Step 3: Query Data with READ

To read actual rows, omit the RETURNTYPE clause entirely. NOS will return the data directly.

The example below queries the publicly available Azure Open Datasets NYC Taxi dataset — no Azure account or credentials required:

SELECT
    vendorID,
    tpepPickupDateTime,
    tpepDropoffDateTime,
    passengerCount,
    tripDistance,
    puLocationId,
    doLocationId,
    rateCodeId,
    paymentType,
    fareAmount,
    tipAmount,
    tollsAmount,
    totalAmount
FROM READ_NOS (
    USING
        LOCATION ('/az/azureopendatastorage.blob.core.windows.net/nyctlc/yellow/puYear=2016/puMonth=6/')
        STOREDAS ('PARQUET')
) AS d
SAMPLE 10;

Tip

Partition pruning Scoping the LOCATION path to a specific partition (e.g. puYear=2016/puMonth=6/) significantly reduces the data NOS needs to scan. Always filter by partition columns in the path rather than in the WHERE clause when possible.

For private containers, add the AUTHORIZATION clause:

FROM READ_NOS (
    USING
        LOCATION ('/az/mystorageaccount.blob.core.windows.net/mycontainer/mypath/')
        STOREDAS ('PARQUET')
        AUTHORIZATION (MyAzureAuth)
) AS d

Step 3: Query Data with READ_NOS

Teradata Developer Guides