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

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';