Example Hyper-Q Configuration File for Azure Synapse
You specify configuration parameters for Hyper-Q using the dtm.ini file, which is located in the directory /opt/datometry/config. The following is an example of the dtm.ini filed used to configure Hyper-Q for Azure Synapse.
The following parameters are specific to Azure Synapse.
Parameter | Description |
|---|---|
| Name of the Azure Synapse instance. |
| Hostname of Azure Synapse instance. |
| User ID for Metadata Store access. |
| Password for the Metadata Store user. |
version = "3.3.34" [endpoints] "endpoint".port = 1025 "endpoint".database = "asa_database" "endpoint".app_protocol = odbc "endpoint".type = teradata "endpoint".version = "140000" "endpoint".is_case_sensitive = false [gateways] "gateway".name = "gateway_msadw" "gateway".is_odbc_gateway = true "gateway".connection_string = "Driver=ODBC Driver 17 for SQL Server;Server=__HOST__;Port=__PORT__;Database=__DATABASE__;Uid=__USER__;Pwd=__PASSWORD__" "gateway".host = "asa_hostname" "gateway".port = 1433 "gateway".tls = prefer "gateway".ipv = 4 "gateway".type = msadw "gateway".version = "100000" "gateway".bulk_load_utility = bcp "gateway".bulk_load_chunk_size = 100MB "gateway".bulk_load_max_errors = 2000000000 "gateway".bulk_load_detect_encoding = false "gateway".locale = "en_US.iso88591" "gateway".locale = "en_US.CP1252" [metadata_stores] "mdstore".name = "MDSTORE" "mdstore".gateway = "gateway_msadw" "mdstore".user = "asa_username" "mdstore".password = "asa_user_password" "mdstore".database = "asa_database" "mdstore".mdstore_schema = "__DTM_MDSTORE" "mdstore".mdstore_table = "MDSTORE_TBL" "mdstore".mdstore_worktable = "MDSTORE_WRKTBL" [pools] "defpool".gateway = ["gateway_msadw"] "defpool".name = "pool_msadw" "defpool".backlog = 10 "defpool".capacity = 100 "defpool".active = 30 "defpool".tx_sync = shared [policies] "defpolicy".protocol = all "defpolicy".database = all "defpolicy".user = all "defpolicy".ip = "0.0.0.0" "defpolicy".ip_prefix = 0 "defpolicy".pool = "pool_msadw" "defpolicy".auth_method = passthru