Exporting Data

EXPORT TABLE employee
INTO FILE PATH '/export/employee.csv'

EXPORT TABLE employee
INTO FILE PATH '/data/employee.csv'
WITH OPTIONS (DATASINK_NAME = 's3_dsink')

EXPORT TABLE product
INTO FILE PATH '/export/products.csv'

EXPORT TABLE product
INTO FILE PATH '/export/products_par.dat'
FORMAT PARQUET

-- Creates a file with a name like:
--   export/product.csv
EXPORT TABLE product
INTO FILE PATH '/export/product.csv'
WITH OPTIONS (SINGLE_FILE = 'overwrite')

EXPORT TABLE product
INTO FILE PATH '/export/products_exp.csv'
WITH OPTIONS (BATCH SIZE = 20000)