...

...

• D s conntype
  type sqldatawarehouse

   is a scalable data warehouse solution available through Microsoft Azure. For more information, see https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-overview-what-is. 

• D s conntype
  type sqldatawarehouse

   connections can interact with data stored as managed tables or external tables. 
•  

Limitations

• Microsoft SQL DW connections

  D s conntype
  type sqldatawarehouse

   connections can use dedicated or serverless SQL pools. 
• For more information, see Microsoft SQL Data Warehouse Connections.

Limitations

• D s conntype
  type sqldatawarehouse

   connections are available only if you have deployed the 

  D s platform

   onto Azure.

• When using the SQL DW read-write connection, the The defined length of a table row cannot exceed 1 MB.

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

Uses

...

of 

D s conntype
type sqldatawarehouse

The

1. Create datasets by reading from SQL DW tables

   D s conntype
   type sqldatawarehouse

    tables.

2. Write to SQL DW tables

   D s conntype
   type sqldatawarehouse

    tables with your job results.

3. Ad-hoc publication of data to SQL DW

   D s conntype
   type sqldatawarehouse

   .

Before You Begin

...

Using 

D s conntype
type sqldatawarehouse

• Enable Access: Integration requires the following:

  • Installation of the 

    D s platform

     on Microsoft Azure.
  • Either ADL or WASB is supported as the base storage layer. For more information, see Set Base Storage Layer.

• Read Access: Your SQL DW administrator

  D s conntype
  type sqldatawarehouse

   administrator must configure read permissions. Your administrator should provide a database for upload to your SQL DW datastore.

• Write Access: You can write and publish jobs results to SQL DW

  D s conntype
  type sqldatawarehouse

  . 

Secure Access

SQL DW These connections require SSL access.

Storing Data

...

in 

D s conntype
type sqldatawarehouse

Your

Reading

...

from 

D s conntype
type sqldatawarehouse

You can create a

For more information, see Database Browser.

Writing

...

to 

D s conntype
type sqldatawarehouse

You can write back data to SQL DW using

• Job results can be written directly to SQL DW as

  D s conntype
  type sqldatawarehouse

   as part of the normal job execution. Create a new publishing action to write to SQL DW

  D s conntype
  type sqldatawarehouse

  . See Run Job Page.

• As needed, you can publish results to SQL DW for previously executed jobs.

  Info
  NOTE: You cannot re-publish results to SQL DW if the original job published to SQL DW. However, if the dataset was transformed but publication to SQL DW failed, you can publish from the Publishing dialog.

  Info
  NOTE: To publish to SQL DW, the source results must be Parquet format.

  See Publishing Dialog

  D s conntype
  type sqldatawarehouse

   for previously executed jobs.

• For more information on how data is converted to SQL DW

  D s conntype
  type sqldatawarehouse

  , see SQL DW Data Type Conversions.

...

• No validation is performed for the connection and any required permissions during job execution. So, you can be permitted to launch your job even if you do not have sufficient connectivity or permissions to access the data. The corresponding publish job fails at runtime. 
• No data validation is performed during writing and publication to SQL DW

  D s conntype
  type sqldatawarehouse

  . Your job fails if the schema for the

  D s item
  dataset dataset

  varies from the target schema.
• Prior to publication, no validation is performed on whether a target is a table or a view, so the job that was launched fails at runtime.