Skip to main content
The SQL Execution Tool allows DinoAI to run SQL queries directly against your connected data warehouse, making it the fastest way to validate assumptions, inspect results, and debug issues without leaving the Paradime IDE. This tool bridges the gap between writing code and verifying it, enabling DinoAI to execute queries and reason over the results — from profiling a dataset to generating dbt tests based on what the data actually contains.
This tool is for query execution. If you only need to explore warehouse metadata such as schemas, tables, or column definitions, use the Warehouse Tools instead.

​
Enabling the SQL Execution Tool

Admin permission required. Only workspace admins can enable this tool.
To enable the SQL Execution Tool:
  1. Navigate to Settings in your Paradime workspace
  2. Open the DinoAI section
  3. Find SQL Execution Tool and toggle it on
Once enabled, the tool will be available to all users in your workspace from the DinoAI Tools Settings panel.

​
Capabilities

The SQL Execution Tool runs SQL statements against your connected data warehouse and returns the results directly to DinoAI. Specifically, it:
  • Runs any SQL statement against your connected data warehouse
  • Auto-limits result sets to a maximum of 1,000 rows

​
Using the SQL Execution Tool

  1. Open DinoAI in the right panel of the Code IDE
  2. Provide the SQL query you want to run, either directly or as part of a broader prompt
  3. Add any additional instructions for how DinoAI should handle or interpret the results
  4. Grant permission when DinoAI asks to execute the query
  5. Review the results and implement DinoAI’s suggested actions

​
Example Use Cases

Profiling a Dataset Prompt
Result: DinoAI writes and executes the necessary queries to produce a data profile of the table, summarizing key statistics per column so you can quickly assess data quality before building models on top of it. Finding Distinct Values and Configuring a Test Prompt
Result: DinoAI queries the column for all unique values, presents the results, and generates the corresponding accepted_values test in your schema.yml based on what it finds in the data. Analyzing Query Results Prompt
Result: DinoAI executes the SQL, interprets the returned data, and highlights anything unusual such as unexpected nulls, outlier values, or distributions that don’t match common assumptions — giving you a starting point for investigation.

​
Working with Other Tools

The SQL Execution Tool works well alongside DinoAI’s other capabilities to support your full development workflow:
  • Combine with the Warehouse Tool to explore table and column metadata before writing and executing a query
  • Combine with the Terminal Tool to run dbt commands and then validate the output by querying the resulting models directly
  • Use alongside Git Lite to commit model changes after validating results look correct through query execution

​
Best Practices

  • Validate early and often — Run queries against your models as you build to catch issues before they reach production
  • Let DinoAI interpret results — Ask DinoAI to summarize or analyze query output rather than just returning raw rows, especially for large or complex result sets
  • Use it to drive test generation — Query for distinct values, null rates, or value ranges and ask DinoAI to turn the findings directly into dbt tests
  • Be mindful of row limits — Results are capped at 1,000 rows. If your query returns exactly 1,000 rows, there may be additional data not shown — add filters or aggregations to work within the limit effectively

Related topics

Tools and FeaturesSnowflake Query Analysis ToolBigQuery Query Analysis ToolCatalog ToolData Warehouse Tools