This section describes how you interact through the with your SQL DW data warehouse.
No data validation is performed during publication to SQL DW. Your job fails if the schema for the varies from the target schema.
NOTE: In this release, this connection cannot be created through the CLI or APIs. Please create connections of this type through the application.
When using the SQL DW read-write connection, the defined length of a table row cannot exceed 1 MB.
The can use SQL DW for the following tasks:
Write to SQL DW tables with your job results.
Ad-hoc publication of data to SQL DW.
Enable SQL DW Access: SQL DW integration requires the following:
Read Access: Your SQL DW 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.
SQL DW connections require SSL access.
Your SQL DW administrator should provide database access for storing datasets. Users should know where shared data is located and where personal data can be saved without interfering with or confusing other users.
NOTE: The does not modify source data in SQL DW. Datasets sourced from SQL DW are read without modification from their source locations.
You can create a from a table stored in SQL DW.
For more information, see Database Browser.
You can write back data to SQL DW using one of the following methods:
As needed, you can export results to SQL DW for previously executed jobs.
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 Export Results window.
NOTE: To publish from the Export Results window, the source results must be Parquet format.
Data Validation issues: