|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.|
Enter your hostname. Example:
|Port||Set this value to |
|Database||Set this value to the default database name.|
|External Data Source Name||For read-write connections, you must provide an External Data Source. Otherwise, the connection is read-only. See above for details.|
|Connect String options|
Include any options required for your environment:
|User Name||Username to use to connect to the database.|
|Password||Password associated with the above username.|
|Default Column Data Type Inference|
Configure for SSO
If you have enabled Azure AD SSO integration for the
|D s platform|
For more information on locating data, see Database Browser.