Create a Custom Profile | Teradata Connector | QueryGrid - Creating a Custom Push Profile

Create a Custom Profile | Teradata Connector | QueryGrid - Creating a Custom Push Profile - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product

Teradata QueryGrid

Release Number

2.19

Published

July 2022

Language

English (United States)

Last Update

2022-07-28

dita:mapPath

jpf1654813554544.ditamap

dita:ditavalPath

ft:empty

dita:id

lxg1591800469257

Product Category

Analytical Ecosystem

Base the settings in custom push profiles on workload and the recommendations of your Teradata Customer Support Representative.

This procedure shows how to use the following macros to create custom push profiles.

Copy macro (TD_COPY_PUSHPROFILE).
Overwrite macro (TD_OVERWRITE_PUSHPROFILE).

Hive is used as an example. Use the same steps to create custom push profiles for Teradata and Presto.

Create a custom push profile.

Option	Steps
Copy and Overwrite the push profile	Copy the default push profile and rename it. In the example below, the default push profile HIVE_V1 is copied and renamed Hive_Custom1. EXECUTE TD_COPY_PUSHPROFILE(‘HIVE_V1’, ‘Hive_Custom1’); Update the push profile. The following example uses the overwrite macro to overwrite an entire existing custom push profile (Hive_Custom1) with a new JSON specification. EXECUTE TD_OVERWRITE_PUSHPROFILE('Hive_Custom1', new JSON(‘{"SourceProfile":"Hive_V1", "ColOp":[{"timestamp":false,"varbyte":false,"byte":false, "CompareOp":{"default":true,"GT":false,"LT":false}}], "AggrOp":{"count":false}}’))

Option

Steps

Copy and Overwrite the push profile

Copy the default push profile and rename it.
In the example below, the default push profile HIVE_V1 is copied and renamed Hive_Custom1.
```
EXECUTE TD_COPY_PUSHPROFILE(‘HIVE_V1’, ‘Hive_Custom1’);
```

Update the push profile.

The following example uses the overwrite macro to overwrite an entire existing custom push profile (Hive_Custom1) with a new JSON specification.

EXECUTE TD_OVERWRITE_PUSHPROFILE('Hive_Custom1', new
JSON(‘{"SourceProfile":"Hive_V1",
"ColOp":[{"timestamp":false,"varbyte":false,"byte":false,
"CompareOp":{"default":true,"GT":false,"LT":false}}],
"AggrOp":{"count":false}}’))