The Warehouse Tool enables DinoAI to directly access your data warehouse metadata, making it uniquely powerful for analytics engineering tasks. Unlike general AI tools, DinoAI can reference your actual tables, columns, and relationships.
Capabilities
DinoAI's Warehouse Tool can:
Discover available databases, schemas, and tables in your data warehouse
Access column names, data types, and descriptions
Identify primary and foreign key relationships
Generate accurate source definitions and references
Suggest appropriate join conditions between tables
Supported Data Warehouses
Snowflake
BigQuery
Redshift
Trino
Databricks
... Additional warehouses coming soon!
Real-World Example: Creating a sources.yml file
Open DinoAI in the left panel of the IDE and enter a prompt like: Create a sources.yml from the data in my data warehouse
DinoAI connects to your warehouse and scans the metadata
Review/accept DinoAI's permission request(s)
Example Use Cases
Creating Comprehensive Source Definitions
Prompt: "Create a sources.yml file for all tables in the marketing schema"
Result: Complete sources.yml with accurate table structures, column names, and data types
Building Models with Precise References
Prompt: "Create a staging model for the customers table with appropriate column renaming"
Result: A staging model that correctly references all columns with standardized naming
Mapping Complex Relationships
Prompt: "Create a dimensional model that combines order, customer, and product data"
Result: Properly structured model with correct join conditions based on your actual schema
Last updated
Was this helpful?