Exporting to Amazon Redshift

To start, navigate to the project you wish to create the export in. Once there, select the 'Exports' tab in the top bar.

From here, press the "New Export" button. Enter a name for the source and select the type " Amazon Redshift", then press continue in the bottom right of the popup.

You will then be redirected to the export configuration page. Which consists of four different sections that must be completed.

The first section is where you select the source or query that you would like to export.

In the second section, you must select the columns you would like to export, and map them by setting an alias.

After selecting the columns, you have the option to apply filters to further limit the date that will be exported.

In the third section, you will decide what connection and account that the Export should connect to. 

In the final section, you must input the name of the table you wish to export to. If the table does not exist, then one will be created.

If 'Use Wild Cards' is selected, the name of the table will include a timestamp on every export. This allows multiple tables to be stored instead of overwriting the same table every time the export is run.

Once the configuration is complete, save the Export and it will be ready to run.

Additional Information can be found within the official Amazon Redshift Documentation

Still need help? Contact Us Contact Us