CREATE FOREIGN TABLE Statement - Teradata Vantage - Analytics Database

CREATE FOREIGN TABLE riverflow_csv, EXTERNAL SECURITY MyAuthObj (
  Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
  GageHeight2 DOUBLE PRECISION FORMAT '-ZZZ9.99',
  Flow DOUBLE PRECISION FORMAT '-ZZZZ9.99',
  site_no BIGINT,
  datetime VARCHAR(16) CHARACTER SET UNICODE CASESPECIFIC,
  Precipitation DOUBLE PRECISION FORMAT '-ZZZ9.99',
  GageHeight DOUBLE PRECISION FORMAT '-ZZZ9.99'
) USING (
    LOCATION ('/s3/YOUR-BUCKET.s3.amazonaws.com/CSVDATA/')
);