Microsoft Azure SQL Data Warehouse

Last modified: September 26, 2019
Connection Type

ODBC (32- and 64-bit)

Driver Configuration Requirements

For client version 10.0, you must append the server name to the Login ID within the Microsoft SQL Server DSN Configuration window. For example:

If a Login ID is user123-admin and the server name is, you would enter for the Login ID.

Driver Details

The ODBC drivers are contained in the SQL Server Native Client. 
32-bit can be downloaded here.
64-bit can be downloaded here.

Bulk write support is available for standard and in-database workflows.

In-Database processing requires 64-bit database drivers.

Type of Support

Read & Write, In-Database

Validated On

ODBC Driver 11, 13, 13.1

Alteryx tools used to connect

Standard workflow processing

 In-Database workflow processing

Blue icon with database being plugged in.

Connect In-DB Tool

Blue icon with a stream-like object flowing into a database.

Data Stream In Tool


Write Support

    • Alteryx recommends using the bulk connection. Select Other Databases > SQL Server Bulk when configuring the Output tool database connection.
    • Write functionality is limited to creating new tables or replacing tables.
    Was This Helpful?

    Need something else? Visit the Alteryx Community or contact support.