Teradata Fabric Considerations | Teradata Fabric - Teradata Fabric Usage Notes - 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
Teradata Fabric
Changes and Additions
Welcome to Teradata Fabric
Teradata Fabric Description
Teradata Fabric Components
Teradata Fabric Manager
Teradata Fabric Manager Cluster
Data Center
Data Source
Bridge
Fabric
Connector
Link
Active, Pending, and Previous Teradata Fabric Configurations
Teradata Fabric Security
Teradata Fabric Manager Root Certificate Authority
Teradata Fabric Manager SSL Certificates
Teradata Fabric Manager Service Accounts
Authentication and Registration of Data Source Nodes
IP Addresses and Hostname Verification
Data Transfer
Supported TLS Versions
OS Users
LDAP and Kerberos
General Security Guidelines for Teradata Fabric
Teradata Fabric in the Teradata Public Cloud
Preparing for Software Installation
Preinstall Checks
Prerequisites
Teradata Fabric Manager
Teradata Fabric Manager Sizing
Number of Teradata Fabric Manager Instances
Teradata Fabric Manager Locality and High Availability Guidelines
Teradata Fabric Proxy Considerations
Multiple Teradata Fabric Manager Cluster Considerations
Use Case: Production and Development
Use Case: Full Teradata Cluster and External Ecosystem
Fabric
Network Requirements
Java Requirements
Single or Multiple Bridge Considerations
Teradata Fabric Usage Notes
Port Availability
Confirming the Teradata Fabric Functions
Bridge Node Guidelines
Oracle Connector Driver Node Guidelines
CPU
Memory
Throughput
BigQuery Connector Driver Node Guidelines
Throughput
Arrow Flight SQL Connector Driver Node Guidelines
CPU
Memory
Arrow Flight SQL Server Connector Driver Node Guidelines
Minimum Requirements
Recommended Configuration
Best Read throughput on Standard Hardware
Generic JDBC Connector Driver Node Guidelines
Minimum Requirements
Memory
Teradata Fabric with Elastic Compute
Port Configuration
Elastic Compute Lifecycle
Teradata Fabric Installation Workflow
Teradata Fabric Pre-Installation
Teradata Fabric Manager Installation and Configuration
Teradata Fabric Installation and Configuration Using the Teradata Fabric Portlet
Obtaining a Change Control Number
Downloading Required Packages
Software Packages
Installing and Configuring Software
Installing and Configuring Teradata Fabric Manager
Installing Teradata Fabric Manager
Clustering Deployed Teradata Fabric Manager Instances
Creating a Join Token
Multiple Teradata Fabric Manager Clusters
Use Cases: Multiple Teradata Fabric Manager Clusters
Usage Considerations: Multiple Teradata Fabric Manager Clusters
Import System
Set Primary Cluster
Default publicAddress, bindAddress, and clusterAddress Overview
Modifying the publicAddress, bindAddress, and clusterAddress
Adding Aliases for Other Servers
Setting Up Teradata Fabric in the Viewpoint Administration Portlets
Installing a Teradata Fabric Root Certificate
Adding Teradata Fabric
Adding the Teradata Fabric Portlet to the Viewpoint Portal
Changing a Service Account Password
Updating the Teradata Fabric Manager Password in the Monitored Systems Portlet
Configuring Teradata Fabric in the Teradata Fabric Portlet
Uploading Connector Software
Uploading Generic JDBC Connector Software
Uploading Fabric Software
Uploading Node Software
Adding a Data Center
Adding a Data Source System
Import a Data Source System
Add Nodes to a System
Adding Nodes Automatically
Adding Nodes Manually
Automatic Deployment of Teradata Fabric on Scalable Clusters
Automatically Deploy Teradata Fabric on Hortonworks HDP
Upgrading or Downgrading Teradata Fabric Deployment Scripts on HDP
Automatically Deploy Teradata Fabric on Cloudera CDH/CDP
Upgrading or Downgrading Teradata Fabric Deployment Scripts on CDH/CDP
Automatically Deploy Teradata Fabric on Azure HDInsight
Upgrading or Downgrading Teradata Fabric Deployment Scripts on HDInsight
Automatically Deploy Teradata Fabric on Amazon EMR
Upgrading or Downgrading Teradata Fabric Deployment Scripts on EMR
Automatically Deploy Teradata Fabric on Google Cloud Dataproc
Upgrading or Downgrading Teradata Fabric Deployment Scripts on Dataproc
Automatically Deploy Teradata Fabric on Google Cloud Instance Group
Upgrading or Downgrading Teradata Fabric Deployment Scripts on Google Cloud Instance Group
Automatically Deploy Teradata Fabric on Azure Virtual Machine Scale Set
Upgrading or Downgrading Teradata Fabric Deployment Scripts on Azure VMSS
Automatically Deploy Teradata Fabric on AWS Auto Scaling Group
Upgrading or Downgrading Teradata Fabric Deployment Scripts on AWS ASG
Configuring Virtual IP Addresses
Adding a Dedicated Bridge System
Adding a Bridge System Using Data Source Nodes
Configuring Teradata Fabric for a Teradata FICON Node
Adding a Fabric
Adding a Network
Add No Ingress to a Network
When to Use No Ingress
Where to Put No Ingress in the Link Setup
When to Use a Load Balancer Network Type
Adding a Communication Policy
Configuring and Using Links
About Connectors and Links
Adding a Target Connector
Configuring the Target Connector
Configuring the Teradata Target Connector and Data Source
Teradata Target Connector Security Guidelines
Configuring the Hive Target Connector and Data Source
Configuring the Primary Group for Hive Users
Configuring the Hive Class Path (CDH Only)
Configuring the Hive Connector for Use with a Custom Hadoop Library Path or Custom JAR Path
Hadoop JAR Files
Configuring the Hive Connector for Use with LLAP
Enabling the Operation Log
Hive Target Connector Security Guidelines
Hive Target Connector Privileges
Verifying Permission to Run kinit (Hive)
Updating Hive Classpath after Upgrading the Hive Connector
Configuring the Spark SQL Target Connector and Data Source
Configuring a Group for Spark Connector Users for Logging Purposes
Creating an HDFS Directory for the Spark SQL Connector
Configuring the Spark SQL Target Connector User
Spark SQL Target Connector Security Guidelines
Verifying Permission to Run kinit (Spark SQL)
Restarting the Spark Thrift Server after Upgrading the Spark Connector
Configuring the Oracle Target Connector and Data Source
Oracle Target Connector Security Guidelines
Oracle Target Connector Privileges
Configuring the BigQuery Target Connector and Data Source
BigQuery Target Connector Security Guidelines
Configuring the Arrow Flight SQL Target Connector and Data Source
Arrow Flight SQL Connector Security Guidelines
Configuring the Arrow Flight SQL Connector — SERVER Execution Type
Arrow Flight SQL Metadata Commands
Query Data from Teradata
Write Data to Teradata
Arrow Flight SQL Connector Security Guidelines Using SERVER Execution Type
Arrow Flight Authentication Methods
Basic Authentication
JWT Authentication
TLS
Versioning Support and Upgrade Process
Fabric Upgrade Only
Fabric and Connector Upgrade
Connector Upgrade Only
Arrow Flight SQL Connector — SERVER Execution Type Port Change
Transaction Support
Limitations and Usage Considerations: Arrow Flight SQL Connector Using SERVER Execution Type
Configuring the Generic JDBC Target Connector
Generic JDBC Connector Security Guidelines
Running a Connector Diagnostic Check
Adding an Initiator Connector
Adding a Link
Running a Link Diagnostic Check
Running a Link Bandwidth Test
Using Links
Using a Teradata-to-TargetConnector Link
Completing the Teradata Initiator Connector Installation on Teradata System Nodes (Viewpoint 16.20 and later)
Required Teradata Initiator Connector Privileges
Teradata Initiator Connector Security and User Sessions
Authorization Objects
Configuring a Foreign Server and Granting Privileges for Teradata-to-TargetConnector Links
User and Role Mapping
Adding a User Mapping
User Mapping Usage Notes
Setting Up User Mapping (Oracle Only)
Adding a Role Mapping
Role Mapping Usage Notes
Setting Up Role Mapping
Validating a Teradata-to-TargetConnector Link
SQL Syntax for the Teradata Initiator Connector
Target Pushdown Conditions
Remote Table Optimization (RTO)
RTO Process
Default Push Profiles
Push Profile Attributes
Push Profile Defaults
Push Profile Macros
Custom Push Profiles
Creating a Custom Push Profile
Kerberos Single Sign-On
SQL Command Reference for the Teradata Initiator Connector
ALTER FOREIGN SERVER
Syntax Elements (ALTER FOREIGN SERVER)
Modify Options
Drop Options
Required Privileges (ALTER FOREIGN SERVER SQL)
BEGIN LOGGING
COMMENT (Comment Placing Form)
Syntax Element
CREATE AUTHORIZATION and REPLACE AUTHORIZATION
Syntax Elements (CREATE/REPLACE AUTHORIZATION)
Usage Notes (CREATE/REPLACE AUTHORIZATION)
Examples of Creating and Replacing the Authorization
CREATE FOREIGN SERVER
Syntax Elements (CREATE/ALTER FOREIGN SERVER)
USING
DO IMPORT WITH
DO EXPORT WITH
Required Privileges (CREATE FOREIGN SERVER)
Usage Notes (CREATE FOREIGN SERVER)
Examples: Using CREATE FOREIGN SERVER
DROP FOREIGN SERVER
Syntax Elements
server_name (DROP FOREIGN SERVER)
Example: Using DROP FOREIGN SERVER
END LOGGING
Syntax Elements
ON operation
EXPLAIN
GRANT and REVOKE
HELP FOREIGN
Syntax Elements (HELP FOREIGN)
Examples of Using HELP FOREIGN
Required Privileges (HELP FOREIGN)
INSERT Syntax and the Teradata Connector
SELECT Syntax and the Teradata Connector
SHOW FOREIGN SERVER
Syntax Elements
TD_SERVER_DB.
server_name (SHOW FOREIGN SERVER)
Required Privileges (SHOW FOREIGN SERVER)
Example of Using SHOW FOREIGN SERVER
Overriding Session Properties
Teradata Fabric Stored Procedures, Functions, and Table Operators
ExecuteForeignSQL
Table Operators and Function
Known Limitations (Teradata-to-TargetConnector)
Alternative Syntax for Referencing Remote Objects through a Foreign Server
Foreign Server Prefix Syntax
Foreign Server Prefix Syntax Elements
Foreign Server Prefix Syntax Usage Notes
Examples: How to Use Foreign Server Prefix Syntax
Example: Generate an execution plan
Example: Select Rows from a Remote Table
Example: Reference a Remote Table Using a Table Alias
Example: Join a Local Table with a Remote Table.
Example: Join Remote Tables through Different Foreign Servers
Example: Create a View Using a Remote Table
Using a Hive-to-Teradata Link
Configuring a Non-Native Table for Hive-to-Teradata
Setting Up User Mapping
Validating a Hive-to-Teradata Link
SQL Syntax for the Hive Initiator Connector
SQL Command Reference for the Hive Initiator Connector
DESCRIBE Syntax for the Hive Initiator Connector
EXPLAIN Syntax for the Hive Initiator Connector
INSERT Syntax for the Hive Initiator Connector
SELECT Syntax for the Hive Initiator Connector
SHOW Syntax for the Hive Initiator Connector
Overriding Session Properties (Hive)
Known Limitations (Hive-to-Teradata)
Using a Spark SQL-to-Teradata Link
Starting Scala REPL
Configuring a Foreign Server for Spark SQL-to-Teradata
Setting Up User Mapping
Validating a Spark SQL-to-Teradata Connector Link
Syntax for the Spark SQL Initiator Connector
Foreign Server Library API Reference for the Spark SQL Initiator Connector
Constructor
Creating a New Foreign Server Object
Restoring an Existing Foreign Server Object
Static Methods
dropForeignServer
getDatasetFromSql
showForeignServers
sql
EXPLAIN Syntax for the Spark SQL Initiator Connector
INSERT Syntax for the Spark SQL Initiator Connector
SELECT Syntax for the Spark SQL Initiator Connector
Instance Methods
create
describe
drop
show
showColumns
showSchemas
showTables
Overriding Session Properties (Spark SQL)
Known Limitations (Spark-to-Teradata)
Additional References
Data Dictionary Views for Teradata Fabric
Query Concurrency on Teradata
Tuning Query Concurrency on Teradata
Using APIs to Monitor Queries Between Teradata and a Foreign Server
Connector and Link Properties
Teradata Connector and Link Properties
Hive Connector and Link Properties
Spark SQL Connector and Link Properties
Oracle Connector and Link Properties
BigQuery Connector and Link Properties
Arrow Flight SQL Connector and Link Properties
Generic JDBC Connector and Link Properties
Data Type Mapping for Teradata Fabric Connectors
Teradata Data Type Mapping
Hive Data Type Mapping
Spark SQL Data Type Mapping
Oracle Data Type Mapping
BigQuery Data Type Mapping
Arrow to Global Type Mapping
Arrow Flight SQL Connector — SERVER Execution Type Data Type Mapping
Arrow Type to JDBC Mapping
Global Type to Arrow Type Mapping
Generic JDBC Data Type Mapping
Temporary Table Cleanup
Time Zone Behavior
Managing Teradata Fabric
Modifying an Existing Teradata Fabric Configuration
Working with Active, Pending, or Previous Versions
Replacing Active Network Versions with Pending or Previous Versions
Replacing Active Communication Policies Versions with Pending or Previous Versions
Replacing Active Fabrics, Connectors, and Links Versions with Pending or Previous Versions
Editing a Fabric
Editing a Connector
Editing a Link
Editing a Data Center
Editing a System
Editing a Network
Editing a Communication Policy
Editing a User Mapping
Teradata Fabric Monitoring, Logging, and Error Handling
Using the Fabric Overview
Viewing a Fabric Overview
Viewing Component Details
Component Details
Viewing Components with the Navigation Panel
Using the Issues View
Viewing Issues History
Using the Issues Details View
Deleting Multiple Issues
Monitoring User Queries Between Local and Remote Servers
Logging and Error Handling
Using the Teradata Fabric Portlet to View Issues
Teradata Fabric Portlet Logging Settings
Understanding the Logging Connector Property
Audit Log
Example: Audit Log
Troubleshooting
Solutions for Job Problems
About Administrative Tasks
Teradata Fabric Manager Settings and Account Management
Managers
Managers Tab
Editing Manager Settings
Service Accounts Tab
Adding a Service Account
Resetting a Service Account Password
Settings Tab
Restarting a Fabric
Enabling Automatic Node Deletion
Deleting Multiple Nodes
Resetting Teradata Fabric Manager to Default Settings
Removing Teradata Fabric Manager from a Cluster
Backup and Restore
Backup
Restore
Run a Post-Backup Script
Migrating Teradata Fabric Manager to a New Server
Understanding of Merging Teradata Fabric Manager Clusters
Merging Teradata Fabric Manager Clusters
Separating Teradata Fabric Manager Clusters
Teradata Fabric Manager RESTful APIs
Installing/Uninstalling a Custom Server Certificate
Certificate Authority Rotation
Upgrading Software
Upgrading Teradata Fabric
About Teradata Fabric Upgrade
Upgrading Teradata Fabric Manager
Upgrading Teradata Fabric Node Software
Upgrading Teradata Fabric Connectors and Fabrics
Removing Old Software Versions from Teradata Fabric Manager
Teradata Fabric Portlet Metrics
Communication Policies Metrics
Connector Diagnostic Check Metrics
Connector Software Metrics
Connectors Metrics
Data Centers Metrics
Fabric Software Metrics
Fabrics Metrics
Issues History Metrics
Issues Metrics
Link Bandwidth Test Metrics
Links Metrics
Managers Metrics
Networks Metrics
Node Details Metrics
Node Installation Status Metrics
Node Software Metrics
Node Status Metrics
Roles Metrics
Service Account Metrics
System Metrics
System Nodes Metrics
User and Role Mappings Metrics
Users Metrics
Teradata Fabric Portlet Table and Row Actions
Table Actions
Row Actions
How to Read Syntax
Additional Information
Supported Releases
Teradata Links
Related Documentation
For Teradata Fabric versions 2.06 and later, /var/opt/teradata/tdqg/tmp must be mounted with exec privileges.
The Access Control Lists (ACL) package is a required dependency for tdqg-node software installation. Debian OS systems may also require the ACL package.