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