Import and export Amazon Redshift data

Export a Redshift table or a console result to CSV, JSON, Excel and more, with a cost note, or copy a table to another connection.

Redshift export has two sources: a table, and a console result.

Exporting a table

Table export uses the Data API. On a direct connection the dialog is disabled and says why. You can export all rows or the first N rows. Exporting everything is a scan that Redshift bills in RPU or cluster time, and the dialog says so. If the catalog has no row count for the table, the export stops at one million rows and tells you, and you can choose a different limit. A preview shows the first rows before the job starts, and the job runs in the job center, where you can cancel it.

Exporting a console result

A finished run can be exported without running the query again. On the Data API, Tablyne rereads the finished statement, so nothing is billed twice. On a direct connection only the first page of the result is kept, so the file holds only that page and the dialog says so. Exporting a console result as SQL is not available, because a result has no source table.

Formats and spreadsheets

The formats are CSV, JSON, JSON Lines, SQL, Markdown and Excel. CSV and Excel files neutralize text that a spreadsheet would run as a formula, while numbers like -1 stay numbers. You can turn that off in the export dialog.

Copying out

A table can be copied to another connection that supports it. Redshift is a source for that copy, not a target.

Importing

Tablyne does not import files into Redshift. Load data with the Redshift tools you already use.