Creating Sources from your Warehouse
Last updated
Was this helpful?
Last updated
Was this helpful?
Setting up source definitions in dbt™ projects involves querying information schemas, documenting tables and columns, ensuring proper YAML formatting, and keeping sources up-to-date as new tables are added. This manual process can be time-consuming and prone to errors.
DinoAI Agent can automatically generate complete and accurate sources.yml files by directly accessing your data warehouse metadata.
I uploaded some new data to my data warehouse. Can you create a sources.yaml file?
Open DinoAI by clicking the DinoAI icon (🪄) in the left panel
Ensure Agent Mode is selected
Enter your prompt requesting a sources.yml file creation
Review the preview of the generated YAML file
Accept the changes to create the file in your project
Verify the file has been created correctly with all expected sources
After you enter your prompt:
DinoAI connects to your data warehouse and scans available schemas and tables
It retrieves column information including data types
It generates a properly formatted sources.yml file
Time Savings: Reduces a 30+ minute manual task to seconds
Accuracy: Eliminates typos and formatting errors
Maintainability: Makes it easy to keep sources up-to-date as your warehouse evolves
Completeness: Captures all tables and columns without missing anything
Prerequisite: Connect your warehouse to your
Optional: by clicking the "@" symbol and selecting any existing sources.yml files
If configured, DinoAI applies your preferences