This section describes how you interact through the  with your SQL DW data warehouse.

Limitations

Uses of SQL DW

The  can use SQL DW for the following tasks:

  1. Create datasets by reading from SQL DW tables.
  2. Write to SQL DW tables with your job results.

  3. Ad-hoc publication of data to SQL DW.

Before You Begin Using SQL DW

Secure Access

SQL DW connections require SSL access.

Storing Data in SQL DW

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.

Reading from SQL DW

You can create a  from a table stored in SQL DW.

For more information, see Database Browser.

Writing to SQL DW

You can write back data to SQL DW using one of the following methods:

NOTE: Writing and publishing to SQL DW is not supported if Azure AD SSO has been enabled.

Data Validation issues: