...
| Connection Type | Description | Notes | ||||
|---|---|---|---|---|---|---|
| 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.
To create, see Connections Page. | This connection requires more permissions. You must also specify an External Datasource Name. See below.
|
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.
...
