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

Teradata® Fabric - Installation and User Guide - 3.11
Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257
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.
  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}}’))