Synapse Connection
SynapseConnection​
info
SynapseConnection
is defined beneath the following ancestor nodes in the YAML structure:
Below are the properties for the SynapseConnection
. Each property links to the specific details section further down in this page.
Property | Default | Type | Required | Description |
---|---|---|---|---|
description | string | No | A brief description of what the model does. | |
metadata | No | Meta information of a resource. In most cases it doesn't affect the system behavior but may be helpful to analyze project resources. | ||
name | string | Yes | The name of the model | |
synapse | Yes | Synapse Connection options. |
Property Details​
Connection​
Data source/sink Connection.
Property | Default | Type | Required | Description |
---|---|---|---|---|
connection | One of:   S3Connection   GcsConnection   AbfsConnection   LocalFileConnection   SnowflakeConnection   BigQueryConnection   MSSQLConnection   MySQLConnection   OracleConnection   PostgresConnection   HttpConnection   DuckDBConnection   SFTPConnection   DatabricksConnection | Yes | Data system Connection. |
SynapseConnectionOptions​
Property | Default | Type | Required | Description |
---|---|---|---|---|
max_query_length | integer | No | Maximum query length to allow. | |
max_concurrent_queries | integer | No | Maximum number of concurrent queries to allow. | |
max_combined_sql_statements | integer | No | Maximum number of combined SQL statements to allow. | |
host | string | Yes | MSSQL server host to connect to. | |
user | string | No | MSSQL Server user to connect as. | |
password | string | No | MSSQL Server user password. | |
schema | dbo | string | No | MSSQL schema to use. |
port | integer | No | MSSQL Server port to connect to. | |
driver | string ("ODBC Driver 18 for SQL Server", "FreeTDS") | Yes | Driver to use for the MSSQL Connection. | |
trust_server_certificate | boolean | No | ||
database | string | Yes | MSSQL Server database to connect to. | |
staging | Yes | External data source to use for staging data for synapse to load from. | ||
create_schema_if_not_exists | boolean | No | Boolean flag indicating whether to create the schema if it does not exist. | |
table_index | string ("heap", "clustered_columnstore") | No | Index type to use for the table. | |
distribution | string ("ROUND_ROBIN", "REPLICATE") | No | Distribution type to use for the table. | |
spark | No | Optional settings to enable Spark-based operations. |
SynapseAnalyticsSparkOptions​
Property | Default | Type | Required | Description |
---|---|---|---|---|
endpoint | string | No | The development endpoint of the Synapse Analytics workspace | |
service_principal | No | Azure service principal to use for authenticating against the Spark Livy API endpoint. | ||
sql_user | string | No | SQL user to use for the Synapse Analytics Connection | |
sql_password | string | No | SQL password to use for the Synapse Analytics Connection | |
sql_server | string | No | SQL server to use for the Synapse Analytics Connection | |
staging | No | The external data source to use for staging data for synapse to load from. |
SynapseExternalDataSource​
Property | Default | Type | Required | Description |
---|---|---|---|---|
name | string | Yes | Unique name of the external data source. | |
abfs | Yes | ABFS Connection to use for the external data source. |
AbfsConnectionOptions​
Azure Blob File System Connection options.
Property | Default | Type | Required | Description |
---|---|---|---|---|
account | string | No | Azure Blob File System account name to connect to. | |
root | string | Yes | abfs[s] URL for the root prefix. | |
shared_key | string | No | Azure Blob File System shared key to use for the ABFS Connection. | |
service_principal | No | Azure Blob File System service principal in JSON to use for the ABFS connection. The JSON should include a key named 'client_id' for the client ID, a key named 'client_secret' for the client secret, and a key named 'tenant_id' for the tenant ID. | ||
enable_default_credential | False | boolean | No | If True, enables use of the default credential for the ABFS connection if no other credentials are provided. |
AbfsServicePrincipal​
Property | Default | Type | Required | Description |
---|---|---|---|---|
client_id | string | Yes | Client ID for the service principal. | |
client_secret | string | Yes | Client secret for the service principal. | |
tenant_id | string | Yes | Tenant ID for the service principal. |
ResourceMetadata​
Meta information of a resource. In most cases, it doesn't affect the system behavior but may be helpful to analyze Project resources.
Property | Default | Type | Required | Description |
---|---|---|---|---|
source | No | The origin or source information for the resource. | ||
source_event_uuid | string | No | UUID of the event that is associated with creation of this resource. |
ResourceLocation​
The origin or source information for the resource.
Property | Default | Type | Required | Description |
---|---|---|---|---|
path | string | Yes | Path within repository files where the resource is defined. | |
first_line_number | integer | No | First line number within path file where the resource is defined. |