Before you start retrieving data, there are two important things to consider: the configuration of the query files and the sources from which you will retrieve data.

File Requirements

Queries are stored in files, and here are the necessary specifications and options:

  • Source Files: Must be .sql.

  • Location: All query files should be placed in the queries directory. This includes nesting in any subdirectories under queries.

    ├── my_first_query.sql
    └── product/
        └── active_users.sql
  • Naming: The .sql filename is the one you can use to reference one query in another. See Referencing other queries for more information.

  • Co-Location: .sql query files and .yaml source files must all reside within the queries directory or its subdirectories. See How to Configure Sources for more information.

    └── product/
        ├── active_users.sql
        └── snowflake_product.yaml



The first step is to configure a source. To learn more about how to do this, see How to configure Sources

Source Resolution

It is important understand the source resolution when creating a query. Check Source Resolution