Configure Hyper-Q for use with Azure Synapse
After installing the Hyper-Q software, you configure each Hyper-Q VM for use with Azure Synapse.
The configuration parameters for Hyper-Q are in the file /opt/datometry/config/dtm.ini
. Modify the following lines to configure Hyper-Q for use with the Azure Synapse environment. For an example of a dtm.ini configuration file, see Example dtm.ini Configuration File.
Important
All string values on the left-hand side of an assignment in dtm.ini must be enclosed in double quotes. For example: "DTM_MDS_USER".
In the
[endpoints]
section, locate the line below and replaceasa_database
with the name of your Azure Synapse instance."endpoint".database = asa_database
In the
[gateways]
section, locate the line below and replaceasa_host
with the hostname of your Azure Synapse instance."gateway".host = asa_host
In the
[metadata_stores]
section, locate the lines below and replaceasa_database
,asa_username
, andasa_user_password
with the name of your Azure Synapse instance, and the username and password to be used to access Metadata Store."mdstore".database = asa_database "mdstore".user = asa_username "mdstore".password = asa_user_password