Example: Create a View Using a Remote Table - 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

What this query helps you do:

  • Create a reusable view for the remote cardata table
  • Simplify future queries by using cardata_view instead of teradata1.default.cardata
CREATE VIEW cardata_view AS
SELECT *
FROM teradata1.default.cardata;