Page tree

Release 5.0.1




This section describes how to create connections to Microsoft SQL Datawarehouse (DW).

Tip: This connection is now known as Azure Synapse Analytics.


  • Microsoft SQL DW connections are available only if you have deployed the Designer Cloud Powered by Trifacta platform onto Azure.
  • No data validation is performed during publication to SQL DW. Your job fails if the schema for the Alteryx dataset varies from the target schema.

    NOTE: In this release, this connection cannot be created through the CLI or APIs. Please create connections of this type through the application.

  • SSL connections to SQL DW are required.


  • If you haven't done so already, you must create and deploy an encryption key file for the Alteryx node to be shared by all relational connections. For more information, see Create Encryption Key File.

Connection Types

The Designer Cloud Powered by Trifacta platform supports two types of connections to an Azure SQL DW data warehouse:

Connection TypeDescriptionNotes
SQL DW Read-Only

Read-only access to the SQL DW data warehouse. This connection is available on the Import Data page only.

To create, see Import Data Page.

This connection requires fewer permissions on the data warehouse and its databases but is less performant.

SQL DW Read-Write

Read-write access to the SQL DW data warehouse. This connection is available for reading, direct publishing, and ad-hoc publishing.

To create, see Connections Page.

This connection requires more permissions. You must also specify an External Datasource Name. See below.

Azure SQL DW permissions

  • Read-Only connection: The authenticating DB user must have read permissions to any SQL DW databases, schemas and tables to which the user should have access.
  • Read-Write connection: In addition to the above, the authenticating DB user must have the following permissions:


    • The authenticating DB user must also have read access to the external data source.

Azure SQL DW External Data Source Name

When specifying a SQL DW Read-Write connection, you must provide an External Data Source Name value as part of the connection definition.

NOTE: This setting is not used for SQL DW Read-Only connections.

The External Data Source enables publishing and support for large-scale data ingestion. If the External Data Source is not provided, the connection is Read-Only and does not scale well.



To create this connection:

Please create a connection of this type in the appropriate page and modify the following properties with the listed values:

Enter your hostname. Example:
PortSet this value to 1433.
DatabaseSet this value to the default database name.
External Data Source NameFor read-write connections, you must provide an External Data Source. See above for details.
Connect String options

Include any options required for your environment:

User NameUsername to use to connect to the database.
PasswordPassword associated with the above username.
Default Column Data Type Inference

Set to disabled to prevent the Designer Cloud Powered by Trifacta platform from applying its own type inference to each column on import. The default value is enabled.


For more information on locating data, see Database Browser.

For more information, see Using SQL DW.

Data Conversion

For more information on how values are converted during input and output with this database, see SQL DW Data Type Conversions.

This page has no comments.