#exasol

native-import-in-exasol.sql

IMPORT INTO mytable
FROM LOCAL SECURE CSV
FILE /file.csv
(1, 2 FORMAT = 'YYYY-MM-DD', 3..12)
ENCODING = 'ASCII'
ROW SEPARATOR = 'LF'
SKIP = 1;
COMMIT;


-- file in s3 
IMPORT INTO mytable
FROM CSV
at S3_CONN
file 'testbucket/file.csv'


IMPORT INTO mytable FROM CSV AT 'https://testbucket.s3.amazonaws.com'
USER '<key-ID>' IDENTIFIED BY '<secret-key>' -- user/password
FILE 'testpath/test.csv';