> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradime.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Creating Sources from your Warehouse

> Automatically generate accurate sources.yml files by connecting DinoAI to your data warehouse metadata. Save time and eliminate errors when defining source tables for your dbt™ projects.

export const Arcade = ({src, title}) => <div style={{
  position: 'relative',
  paddingBottom: 'calc(56.2225% + 41px)',
  height: 0,
  width: '100%'
}}>
    <iframe src={src} title={title} frameBorder="0" loading="lazy" allow="clipboard-write" allowFullScreen style={{
  position: 'absolute',
  top: 0,
  left: 0,
  width: '100%',
  height: '100%',
  colorScheme: 'light'
}} />
  </div>;

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.

### Example Prompt

> *I uploaded some new data to my data warehouse. Can you create a sources.yaml file?*

<Info>
  **Optional**: When updating existing sources with new tables, you can add [context](/products/dino-ai/copilot/context/index) by selecting your existing sources.yml file. Context helps DinoAI understand your existing project structure and make more relevant changes.
</Info>

<Frame>
  <img src="https://mintcdn.com/paradime-docs/9ZsuN0wtxDqr0yUA/images/image-2-1-1-1-1-1-1-1-1-1.png?fit=max&auto=format&n=9ZsuN0wtxDqr0yUA&q=85&s=cc062b5b3e9bcd2e90ec4811cdc6a901" alt="" width="835" height="424" data-path="images/image-2-1-1-1-1-1-1-1-1-1.png" />
</Frame>

***

### Step-by-Step Instructions

<Info>
  **Prerequisite: Connect your warehouse** to your [Code IDE environment](/products/settings/connections/development-environment/index)
</Info>

1. **Open DinoAI** by clicking the DinoAI icon (🪄) in the left panel
2. Ensure **Agent Mode** is selected
3. **Optional**\*\*\*:\*\*\* [**Add context**](/products/dino-ai/copilot/context/index) by clicking the "@" symbol and selecting any existing sources.yml files
4. **Enter your prompt** requesting a sources.yml file creation
5. **Review the preview** of the generated YAML file
6. **Accept the changes** to create the file in your project
7. **Verify the file** has been created correctly with all expected sources

<Arcade src="https://demo.arcade.software/YcNcYxttOItDt1B4eMi7?embed&embed_mobile=tab&embed_desktop=inline&show_copy_link=true" title="Creating Sources from your Warehouse" />

***

### How It Works

After you enter your prompt:

1. DinoAI connects to your data warehouse and scans available schemas and tables
2. It retrieves column information including data types
3. If configured, DinoAI applies your [.dinorules](/products/dino-ai/dino-rules) preferences
4. It generates a properly formatted sources.yml file

<Info>
  **Note**: If you're updating existing (not creating) a YAML file, DinoAI preserves existing documentation and adds only the new tables
</Info>

***

### Key Benefits

* **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


## Related topics

- [Creating dbt Sources from Data Warehouse](/guides/paradime-101/getting-started-with-the-paradime-ide/dinoai-accelerating-your-analytics-engineering-workflow/dinoai-agent/creating-dbt-sources-from-data-warehouse.md)
- [Snapshot Source Data Freshness](/products/bolt/creating-schedules/templates/dbt-tm-templates/snapshot-source-data-freshness.md)
- [Creating a Workspace](/guides/paradime-101/getting-started-with-your-paradime-workspace/creating-a-workspace.md)
- [Use Cases](/products/dino-ai/copilot/use-cases/index.md)
- [Build and Test Models with New Source Data](/products/bolt/creating-schedules/templates/dbt-tm-templates/deferred-model-execution.md)