Creating Volatile Foreign Table - Teradata Vantage

EXPLAIN Statement

EXPLAIN CREATE VOLATILE FOREIGN TABLE test_sales,
EXTERNAL SECURITY TDAWSEDBS_AUTH
USING(
LOCATION('/s3/s3.amazonaws.com/bucket/sales/recNYAA.csv')
);

Result:

Explanation
---------------------------------------------------------------------------
  1) First, we create the table header in TD_MAP1.
  2) Finally, we send out an END TRANSACTION step to all AMPs involved
     in processing the request.
  -> No rows are returned to the user as the result of statement 1.
----------------------------------------------------------------------------

CREATE FOREIGN TABLE Statement

CREATE VOLATILE FOREIGN TABLE test_sales,
EXTERNAL SECURITY TDAWSEDBS_AUTH
USING(
LOCATION('/s3/s3.amazonaws.com/bucket/sales/recNYAA.csv')
);