Azure SQL Data Warehouse

Authentification and configuration options for 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.

What's next

Snowflake

Authentification, configuration options, and content for Snowflake.

Google BigQuery

Authentification, configuration options, and content for BigQuery.

Amazon Redshift

Authentification, configuration options, and content for Redshift.

Postgres

Authentification and configuration options for Postgres.

Sitemap