Azure SQL data warehouse connections require the following elements:
SQL Data Warehouse supports table distributions. Manually tuning this parameter can help to optimize query performance.
SQL Data Warehouse distributions can be configured in Dataform using the distribution
option:
1config { 2 type: "table", 3 sqldatawarehouse: { 4 distribution: "REPLICATE" 5 } 6} 7SELECT CURRENT_TIMESTAMP() AS ts
This query compiles to the following statement:
1CREATE TABLE "dataform"."example" 2WITH (distribution = REPLICATE) 3AS SELECT CURRENT_TIMESTAMP() AS ts
If you are using Dataform web and are having trouble connecting to Azure SQL Data Warehouse, please reach out to us by using the intercom messenger at the bottom right.
If you have other questions, you can join our slack community and ask question to get help.