Skip to main content
Skip table of contents

EXPORT

The EXPORT command exports the data of a table or partition, along with the metadata, into a specified output location. This output location can then be moved over to a different instance of Indexima and imported directly from there with the IMPORT command.

It can also be serve as a backup of your warehouse.

Syntax

Export all of your warehouse

SQL
EXPORT ALL
 TO '<export_target_path>'
 [ [ ONLY_METADATA ] FORMAT CSV|PARQUET SEPARATOR '<separator>' ]

Export only a specific schema or table

SQL
EXPORT SCHEMA|TABLE <name>
 TO '<export_target_path>'
 [ [ ONLY_METADATA ] FORMAT CSV|PARQUET SEPARATOR '<separator>' ]

Parameters

<name>

The name of the table or schema your want to export. It is case sensitive and cannot contain spaces.

<export_target_path>

The absolute path that indicates where you want to write the export file. The path must be between single quotes.

ONLY_METADATA

ONLY_METADATA will create an export of the metadata generated by your warehouse/schema/table. Be aware that it does not contain actual data.

Format

Format allows you to customize your export format.

The two usable formats are CSV and PARQUET.

Default value: CSV

Separator

This option allows you to customize the column separator in your export file. The character that will define the column separator in the export file must be between single quotes.

Default value: ','

Examples

Export the table 'my_table' into the /tmp/indexima_export in the Indexima Master Node.

The export file will be a CSV file with a semi-colon separator.

Export table

SQL
EXPORT TABLE my_table TO '/tmp/indexima_export' FORMAT CSV SEPARATOR ';'


Export your entire warehouse into the my_bucket/data/indexima_export S3 Object .

The export file will be a CSV file with a coma separator.

Export All

SQL
EXPORT ALL TO 's3://my_bucket/indexima_export'




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.