Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

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. 

Info

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
     is used.

Requirements:

...

PropertyDescription
Host
Enter your hostname. Example:

 

Code Block
testsql.database.windows.net
PortSet this value to 1433.
DatabaseSet this value to the default database name.
External Data Source NameFor 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 NameUsername to use to connect to the database.
PasswordPassword associated with the above username.
Default Column Data Type Inference

Set to disabled to prevent the

D s platform
from applying its own type inference to each column on import. The default value is enabled.

...