...

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

Limitations

• Microsoft SQL DW connections are available only if you have deployed the

  D s platform

  onto Azure.

• SSL connections to SQL DW are required.

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

  
  

...

• 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:

  Code Block
  CREATE TABLE** ALTER ANY SCHEMA ALTER ANY EXTERNAL DATA SOURCE ALTER ANY EXTERNAL FILE FORMAT

   

  
  

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

...

• The external data source must be created by the database admin on the default database defined in the SQL DW connection. For  For more information: , see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql#d-create-external-data-source-to-reference-azure-blob-storage https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql#g-create-external-data-source-to-reference-azure-data-lake-storesql?view=azure-sqldw-latest&tabs=dedicated.
• The External Data Source must point to the same storage location as the base storage layer for the

  D s platform

  . For example, if the base storage layer is WASB, the External Datasource must point to the same storage account defined in

  D s item
  item configuration

  . If this configuration is incorrect, then publishing and ingestion of data fail.
• For more information on privileges required for the authenticating DB user, see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql.

...

testsql.database.windows.net

...