...

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.

• No data validation is performed during publication SSL connections to SQL DW . Your job fails if the schema for the 

  D s item
  item dataset

   varies from the target schema.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.

• SSL connections to SQL DW are required.

• 
  

Pre-requisites

• If you haven't done so already, you must create and deploy an encryption key file for the

  D s item
  item node

  to be shared by all relational connections. For more information, see Create Encryption Key File.

...

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

...

When specifying a SQL DW Read-Write connection, you must can provide an External Data Source Name value as part of the connection definition. The External Data Source enables publishing and support for large-scale data ingestion. 

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:

• The connection is read-only.
• The native ingestion of the 

  D s platform

   is used.

Requirements:

• 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

...