Step 4: Create a Foreign Table (Optional)

For repeated queries against the same dataset, a foreign table definition avoids repeating the READ_NOS clause every time and makes the data feel like a native Teradata table:

CREATE FOREIGN TABLE nyc_yellow_taxi
    EXTERNAL SECURITY DEFINER TRUSTED MyAzureAuth
USING (
    LOCATION ('/az/azureopendatastorage.blob.core.windows.net/nyctlc/yellow/')
    STOREDAS ('PARQUET')
);

-- Query it like any other table
SELECT *
FROM nyc_yellow_taxi
SAMPLE 10;

Note

Foreign tables are always created as No Primary Index (NoPI) tables. Each query against a foreign table fetches data live from the object store — NOS does not cache results automatically.