Azure SQL Data Warehouse

Authentification

Azure SQL data warehouse connections require the following elements:

• Server
• Port
• Username
• Password
• Database name

Configuration options

Setting table distribution

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:

1
2
3
4
5
6
7
config {
  type: "table",
  sqldatawarehouse: {
    distribution: "REPLICATE"
  }
}
SELECT CURRENT_TIMESTAMP() AS ts

This query compiles to the following statement:

1
2
3
CREATE TABLE "dataform"."example"
WITH (distribution = REPLICATE)
AS SELECT CURRENT_TIMESTAMP() AS ts

Getting help

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.

Join dataform-users on slack

Sitemap