Example: Reference a Remote Table Using a Table Alias - Teradata Fabric

Teradata® Fabric - Installation and User Guide - 3.11

Product
Teradata Fabric
Release Number
3.11
Publication Date
August 2026
Content Type
Administration
Configuration
Installation
User Guide
Publication ID
B035-5991-086K
ft:locale
en-US
ft:lastEdition
2026-11-06
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
ft:sourceId
dita
dita:id
lxg1591800469257

This query:

  • Retrieves Buick records from the remote cardata table
  • Uses the alias p as a shorthand for the table name
SELECT p.*
FROM teradata1.default.cardata p
WHERE p.make = 'Buick';