Important:
- The BigQuery connector is a target connector only and cannot be used as an initiating connector.
- All BigQuery target connector nodes must be driver nodes for communication and data transfer to and from the BigQuery system.
- Install the BigQuery target connector on a host that is able to reach Google BigQuery.
- See Automatically Deploy Teradata Fabric on Google Cloud Instance Group for additional details.
The following are the minimum requirements for a BigQuery target connector node to install the Teradata Fabric 3.x software:
- 4GB RAM
- 50GB disk space
- For supported operating system versions, refer to the Teradata Fabric / QueryGrid Compatibility Matrix.
- Memory requirements as defined in the fabric/connector setup
- Latest version of JAVA 8 or 11
When using the BigQuery connector, the system running the Teradata Fabric driver process handles a greater workload as compared to other connectors. The CPU and memory configuration of the driver node has a significant impact on query performance. The following sample test results are from using different CPU and memory configurations. You can use multiple driver nodes for load balancing.