Microsoft Azure Synapse SQL Connector

Back Next

Advanced settings

The following table describes the advanced connection properties:

Property	Description
External Data Source	The data source to create the external table. Ensure that the external data source exists in Microsoft Azure Synapse SQL and you have the permission to access the external data source. When you use the copy command method to load data from the staging location to Microsoft Azure Synapse SQL, you don't need to specify an external data source.
Staging Schema Name	The name of the schema that the Secure Agent uses to create external tables for staging data files. If you do not specify the staging schema name, the Secure Agent considers the configured Azure DW Schema Name.
Blob End-point	Type of Microsoft Azure endpoint. Select one of the following endpoints: core.windows.net. Connects to Azure endpoints. Use this endpoint when you connect to a serverless SQL pool. core.usgovcloudapi.net. Connects to US Government Microsoft Azure Synapse SQL endpoints. core.chinacloudapi.cn. Connects to Microsoft Azure Synapse SQL endpoints in the China region. Default is core.windows.net.
VNet Rule	Enable to connect to a Microsoft Azure Synapse SQL endpoint residing in a virtual network (VNet). This property doesn't apply to a serverless runtime environment.