Datometry Documentation

app_protocol

String

Database property used to identify the network protocol of the clients connecting to Hyper-Q.

Teradata and ODBC are synonyms that identify the SQL clients as Teradata clients. There is no default value. Use the value dtm_pgv3 for Datometry ODBC and JDBC drivers (PolyTools).

century_break

Integer

Specifies which two-digit years are to be interpreted as 20th-century years and which two-digit years are interpreted as 21st-century years. The values can range from 0 to 100. The default is 0.

In this example, strings such as '00/01/01' and '24/01/01' are interpreted as years 2000 and 2024, respectively. A string inserted as '25/01/01' is interpreted as the year 1925. The choice of 25 specifies that the database will use a cushion of up to 25 years to handle input dates for the 21st century, and does not have historic input data prior to the year 1925.

"endpoint1".century_break = 25

compatibility_timezone

String or Integer

The compatibility_timezone parameter lets you specify a time zone which Azure Synapse uses for specific time functions. The functions return time in that time zone, even on backend systems that only support UTC (such as Azure Synapse). This is in contrast to the timezone setting (described later in this section), which ensures time values are converted and returned in the local time, including persisted values.

The time functions affected by compatibility_timezone are: AT LOCAL, CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, DATE, TIME, and NOW(). 

When using compatibility_timezone, functions that return the current time, such as CURRENT_TIME and CURRENT_TIMESTAMP, return time in the time zone specified using compatibility_timezone.

For a mapping of Teradata to Azure Synapse time zone strings, see Teradata to Azure Synapse Time Zone Strings.

database

String

Specifies the database to use with the [policies] parameter.

is_case_sensitive

Boolean

Identifies the case sensitivity of the backend system catalogs. The default is true. Hyper-Q uses this value to properly emulate Teradata system catalog lookups.

If the backend database is an Azure Synapse Analytics (ASA), then the default is false because the standard configuration for ASA is for case insensitive comparisons. Otherwise the default value is true as most other backend databases default to case sensitive comparisons.

memory_quota

Integer

Specifies when the result device begins writing converted results to disk. A low value will increase the result conversion time because more results will return to disk before being sent to client.

You specify the value in megabytes. For example "endpoint".memory_quota = 10MB

port

Integer

Specifies that the endpoint accept connections on the specified port number. In the above example, Hyper-Q is accepting connections to endpoint at port number 1025.

spill_dir

String

Specifies the directory where Hyper-Q creates a file to store large result sets.

timezone

String or Integer

Specifies the local time zone. Hyper-Q adjusts time values to the time zone you specify, and automatically adjusts for daylight saving time when specifying a time zone by name. This allows existing clients to continue to operate in local time on backend systems that only support UTC.

You can specify the time zone value as either an integer or string. For example:

"endpoint".timezone = "America Pacific"
"endpoint".timezone = "-04:00"

Additionally, you can specify a time zone using the set time zone command. This overrides the time zone configuration specified using "endpoint".timezone. For example:

set time zone '-10';
set time zone 'America Eastern';
set time zone '03:00';

For a mapping of Teradata to Azure Synapse time zone strings, see Teradata to Azure Synapse Time Zone Strings.

type

String

Specifies the native database. For example:

"endpoint".type = Teradata

version

Integer

Specifies the Teradata version that Hyper-Q is emulating. "140000" specifies 14.x and "170000" specifies 17.x Teradata distributions.

"endpoint".version = "170000"