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

QueryGrid™ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.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.
  1. Create a custom push profile.
    Option Steps
    Copy and Overwrite the push profile
    1. Copy the default push profile and rename it.
      In the following example, the default push profile HIVE_V1 is copied and renamed Hive_Custom1.
      EXECUTE TD_COPY_PUSHPROFILE(‘HIVE_V1’, ‘Hive_Custom1’);
    2. 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}}’))