Export To S3 And External table

JimmyAndresonJimmyAndreson Community Edition User
edited March 2021 in General Discussion

I export data to s3 with portion :
SELECT s3EXPORT_PARTITION(* USING PARAMETERS url='s3://bucket_name/test1/bystate.date') OVER (PARTITION BY name,date) FROM (SELECT name,TO_CHAR(ts, 'YYYYMMDD') AS date, * FROM T ) foo;
Now I want to create the external table with partition (date & name) base on the data in s3 I export before.
I can do that?
what kind of file the export create?it looks like CSV with '|' delimiter,
in this case, file CSV can be a part of the external table with a partition on name and date?
Thank you all !VidMate


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file