Hyper-Q Configuration for Azure Synapse
Hyper-Q Configuration provides information about configuring Hyper-Q using the Hyper-Q configuration file.
This guide contains the following sections:
Understanding the Hyper-Q Configuration File Hyper-Q reads its initial configuration from the file /opt/datometry/config/dtm.ini.
The dtm.ini
file is a text-based file that records configuration options as key-value pairs for properties, and sections that organize those properties.
Endpoint Configuration Parameters The [endpoint]
defines the Hyper-Q service endpoint. SQL clients connect to the endpoint to gain access to Hyper-Q. The endpoint consists of the IP address and the port number at which the Hyper-Q service is available.
Gateway Configuration Parameters The [gateway]
defines the connection to the target data warehouse.
Metadata Store Configuration Parameters The Metadata Store (MD Store) is where Hyper-Q persistently stores metadata information. This includes information about the database objects that cannot be natively stored in the target database's schema.
Pool Configuration Parameters The [pool]
section represents a collection of [gateways].
Policies Configuration Parameters The [policies]
section defines rules for connection routing. Incoming connections are routed to a specific pool based on policy matching. A policy matches incoming connections on the target database, user, IP and protocol.
General Configuration Parameters Specifies basic configuration settings for the Hyper-Q deployment.