SHOW TABLE riverflow_csv;
CREATE MULTISET FOREIGN TABLE riverflow_csv ,FALLBACK , EXTERNAL SECURITY MyAuthObj, MAP = TD_MAP1 ( Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC, GageHeight2 FLOAT FORMAT '-ZZZ9.99', Flow FLOAT FORMAT '-ZZZZ9.99', site_no BIGINT, datetime VARCHAR(16) CHARACTER SET UNICODE CASESPECIFIC, Precipitation FLOAT FORMAT '-ZZZ9.99', GageHeight FLOAT FORMAT '-ZZZ9.99') USING ( LOCATION ('/s3/YOUR-BUCKET.s3.amazonaws.com/CSVDATA/') MANIFEST ('FALSE') PATHPATTERN ('$var1/$site_no/$var3/$var4/$var5') ROWFORMAT ('{"field_delimiter":",","record_delimiter":"\n","character_set":"LATIN"}') STOREDAS ('TEXTFILE') HEADER ('TRUE') STRIP_EXTERIOR_SPACES ('FALSE') STRIP_ENCLOSING_CHAR ('NONE') ) NO PRIMARY INDEX ;