Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Connection TypeDescriptionNotes
SQL DW Read-Only

Read-only access to the SQL DW data warehouse. This connection is available on the Import Data page only.

To create, see Import Data Page.

This connection requires fewer permissions on the data warehouse and its databases but is less performant.

SQL DW Read-Write

Read-write access to the SQL DW data warehouse. This connection is available for reading, direct publishing, and ad-hoc publishing.

Info

NOTE: Under Azure SSO, write operations are not supported through SQL DW connections.

To create, see Connections Page.

This connection requires more permissions. You must also specify an External Datasource Name. See below.

Tip

Tip: Spark-based jobs that read or write through your SQL DW connection leverage PolyBase for faster performance.


Azure SQL DW permissions

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

...