Microsoft Azure SQL Data Warehouse
Version:
2023.1
Last modified: May 17, 2023
| Connection Type | ODBC (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 bigserver.database.windows.net, you would enter user123-admin@bigserver.database.windows.net for the Login ID. |
| Driver Details | The ODBC drivers are contained in the SQL Server Native Client. You can download the Microsoft ODBC Driver 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 |
In-Database Workflow Process
Write Support
- Alteryx recommends that you use the bulk connection. Select Other Databases > SQL Server Bulk when you configure the Output tool database connection.
- Write functionality is limited to creating new tables or replacing tables.
Authentication Type
Only Windows Authentication or SQL Server Authentication is supported, depending on how the SQL Server is configured.