Example: Join Remote Tables through Different Foreign Servers - Teradata Fabric

What this query helps you do:

• Retrieve order and customer information from different systems
• Match each order to its corresponding customer
• Analyze data across multiple data sources in a single SQL query

SELECT o.orderkey,
       c.name
FROM hive1.tpch.orders o
JOIN teradata1.tpch.customer c
  ON o.custkey = c.custkey;