SHOW IN XML TABLE riverflow_csv;
*** XML of DDL statement returned.
*** Total elapsed time was 1 second.
---------------------------------------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-16" standalone="no" ?><TeradataDBObjectSet version="1.0" xmlns="http://schemas.teradata.com/dbobject" xmlns:xsi="htt
p://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/dbobject http://schemas.teradata.com/dbobject/DBObject.xsd"><
Table authName="MyAuthObj" authType="GENERAL" baseClass="Table" dbName="NU" fallback="true" foreigntable="true" kind="Multiset" map="TD_MAP1" map_kind=
"contiguous" name="riverflow_csv" objId="2:52890" objVer="1"><ColumnList><Column name="Location" nullable="true" order="1"><DataType><Char casespecif
ic="true" charset="UNICODE" length="2048" uppercase="false" varying="true"/></DataType></Column><Column name="GageHeight2" nullable="true" order="2">
<DataType><Decimal precision="3" scale="2"/></DataType></Column><Column name="Flow" nullable="true" order="3"><DataType><Decimal precision="3" scale=
"2"/></DataType></Column><Column name="site_no" nullable="true" order="4"><DataType><Integer/></DataType></Column><Column format="Y4-MM-DDBHH:MI" nam
e="datetime" nullable="true" order="5"><DataType><TimeStamp fractionalSecondsPrecision="0"/></DataType></Column><Column name="Precipitation" nullable
="true" order="6"><DataType><Decimal precision="3" scale="2"/></DataType></Column><Column name="GageHeight" nullable="true" order="7"><DataType><Deci
mal precision="3" scale="2"/></DataType></Column></ColumnList><UsingClauseList><Clause name="LOCATION" value="/s3/YOUR-BUCKET.s3.amazonaws.com/CSV
DATA"/><Clause name="MANIFEST" value="FALSE"/><Clause name="PATHPATTERN" value="$var1/$site_no/$var3/$var4/$var5"/><Clause name="ROWFORMAT" value="{&
quot;field_delimiter":",","record_delimiter":"\n","character_set":"LATIN"}"/><Clause name="STO
REDAS" value="TEXTFILE"/><Clause name="HEADER" value="TRUE"/><Clause name="STRIP_EXTERIOR_SPACES" value="FALSE"/><Clause name="STRIP_ENCLOSING_CHAR"
value="NONE"/></UsingClauseList><Indexes><NoPrimaryIndex/></Indexes><SQLText><![CDATA[CREATE MULTISET FOREIGN TABLE riverflow_csv ,FALLBACK ,
EXTERNAL SECURITY MyAuthObj ,
MAP = TD_MAP1
(
Location VARCHAR(2048) CHARACTER SET UNICODE CASESPECIFIC,
GageHeight2 DECIMAL(3,2),
Flow DECIMAL(3,2),
site_no INTEGER,
datetime TIMESTAMP(0) FORMAT 'Y4-MM-DDBHH:MI',
Precipitation DECIMAL(3,2),
GageHeight DECIMAL(3,2))
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 ]]></SQLText></Table><Environment><Server dbRelease="17.10.01.01" dbVersion="17.10c.00.198dr196079" hostName="TDLabs"/><User userI
d="00000604" userName="JOE"/><Session charset="ASCII" dateTime="2021-06-09T15:03:48"/></Environment></TeradataDBObjectSet>