Skip to main content

Datometry Documentation

Hyper-Q Configuration for Google BigQuery

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.