dataproduct_query
Execute SQL queries on data product output ports to retrieve business data while enforcing governance policies and access controls, with support for Snowflake and Databricks.
Instructions
Execute an SQL query on a data product's output port. This tool connects to the underlying data platform (Snowflake, Databricks) and executes the provided SQL query. You must have access to the output port to execute queries.
If the data contract specifies terms of use (such as usage, or limitations), you may only execute this tool when the query is in line with these terms.
Args: data_product_id: The ID of the data product. output_port_id: The ID of the output port to query. purpose: The business purpose for executing this query. Use a high-level description of why you need this data. If there is a data contract, the purpose must be in line with the terms specified in the data contract. query: The SQL query to execute. Try to use fully qualified table names when appropriate.
Returns: Dict containing query results with row count and data (limited to 100 rows).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | ||
| purpose | Yes | ||
| output_port_id | Yes | ||
| data_product_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |