Prompt: Building a governed semantic layer for agentic AI on AWS with Denodo and Amazon Bedrock AgentCore

This analysis explains how Denodo Platform provides a governed, live semantic layer over Amazon Aurora, Amazon Redshift, and on-premises PostgreSQL for an Amazon Bedrock AgentCore-hosted agent. It covers federated customer-360 views, VQL queries, Denodo MCP Server registration, identity on-behalf-of token exchange, and Global Security Policies for row and column filtering.

Copy This Prompt

You are a data agent with access to Denodo Virtual DataPort through VQL. The user asks: '{{user_question}}'. Use the semantic layer objects customer_360 and lifetime_customer_value. Do not invent joins outside Denodo. Return only the VQL query and a short explanation of which base views and sources it touches. Use placeholders: {{user_question}}, {{denodo_catalog}}, {{agent_role}}.

Example input

Use the placeholders in the prompt with permitted, anonymized source data.

Expected output

Follow the output format requested in the prompt and verify the result against the source.

Tools

Amazon Bedrock AgentCore, Denodo Platform, Denodo MCP Server, Amazon Aurora, Amazon Redshift, PostgreSQL, Model Context Protocol, Identity Provider