You can create a connection to a Microsoft Azure SQL database from the
|D s platform|
- This connection type supports data ingestion into ADLS/WASB. When large volumes of data are read from an Azure SQL database during job execution, the data is stored in a temporary location in ADLS/WASB. After the job has been executed, the data is removed from the datastore. This process is transparent to the user.
- For more information on Azure SQL DBDatabase, see https://azure.microsoft.com/en-us/services/sql-database/.
- For additional details on creating a SQL DB connection, see Enable Relational Connections.
- For details on values to use when creating via API, see Connection Types.
This connection is a SQL Server connection type with special settings for some properties. Please create a an Azure SQL Server connection Database connection and then modify specify the following properties with the listed values:
Enter your hostname. Example:
|Port||Set this value to |
|Connect String options|
Please insert the following as a single string (no line breaks):
<DATABASE_NAME>is the name of the SQL DB database to which you are connecting
(optional) Name of the Azure SQL database to which you are connecting.
|User Name||(for |
|Default Column Data Type Inference|
For more information, see Database Browser.
For more information on how values are converted during input and output with this database, see see SQL Server Data Type Conversions.