When specifying a SQL DW Read-Write connection, you must can provide an External Data Source Name value as part of the connection definition. The External Data Source enables publishing and support for large-scale data ingestion.
NOTE: This setting is not used for SQL DW Read-Only connections.
The External Data Source enables publishing and support for large-scale data ingestion. If the External Data Source is not provided, the connection is Read-Only and does not scale well:
- The connection is read-only.
- The native ingestion of the
D s platform
- The external data source must be created by the database admin on the default database defined in the SQL DW connection. For more information:
- The External Data Source must point to the same storage location as the base storage layer for the
. For example, if the base storage layer is WASB, the External Datasource must point to the same storage account defined in
D s platform
. If this configuration is incorrect, then publishing and ingestion of data fail.
D s item item configuration
- For more information on privileges required for the authenticating DB user, see https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql.
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|