Snowflake connections require the following elements:
account-name.region
.snowflakecomputing.comYou can both read from and publish to two separate snowflake databases within a single Dataform project. For example, you may have a database called RAW_SOURCE
that contains raw data loaded into Snowflake and a database called ANALYTICS
in which you create data tables you use for analytics and reporting.
You can define a default database in your dataform.json
file.
1{ 2 "warehouse": "snowflake", 3 "defaultSchema": "dataform", 4 "assertionSchema": "dataform_assertions", 5 "defaultDatabase": "ANALYTICS" 6}
You can then override the default database in the config block of your SQLX files.
1config { 2 type: "table", 3 database: "RAW_SOURCE" 4}
You can configure separate databases for development and production in your environment.json
file. The process is described on this page.
If you are using Dataform web and are having trouble connecting to Snowflake, please reach out to us by using the intercom messenger icon at the bottom right of the app.
If you have other questions related to Snowflake, you can join our slack community and ask question on the #Snowflake channel.