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

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

Export only a specific schema or table

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

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

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


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

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