Loading data from Amazon S3

Confirm that the table is already created in the database where you want to load data.

Confirm that you are connected to the target database in the tree-view panel of query editor v2 before continuing. You can create a connection using the context menu (right-click) to the cluster or workgroup where the data will be loaded.

Choose Load data.

For Data source, choose Load from S3 bucket.

In S3 URIs, choose Browse S3 to look for the Amazon S3 bucket that contains the data to load.

If the specified Amazon S3 bucket isn't in the same Amazon Web Services Region as the target table, then choose the S3 file location for the Amazon Web Services Region where the data is located.

Choose This file is a manifest file if the Amazon S3 file is actually a manifest containing multiple Amazon S3 bucket URIs.

Choose the File format for the file to be uploaded. The supported data formats are CSV, JSON, DELIMITER, FIXEDWIDTH, SHAPEFILE, AVRO, PARQUET, and ORC. Depending on the specified file format, you can choose the respective File options. You can also select Data is encrypted if the data is encrypted and enter the Amazon Resource Name (ARN) of the KMS key used to encrypt the data.

If you choose CSV or DELIMITER, you can also choose the Delimiter character and whether to Ignore header rows if the specified number of rows are actually column names and not data to load.

Choose a compression method to compress your file. The default is no compression.

(Optional) The Advanced settings support various Data conversion parameters and Load operations. Enter this information as needed for your file.

For more information about data conversion and data load parameters, see Data conversion parameters and Data load operations in the Amazon Redshift Database Developer Guide.

Choose Next.

Choose Load existing table.

Confirm or choose the location of the Target table including Cluster or workgroup, Database, Schema, and Table name where the data is loaded.

Choose an IAM role that has the required permissions to load data from Amazon S3.

(Optional) Choose column names to enter them in Column mapping to map columns in the order of the input data file.

Choose Load data to start the data load.

When the load completes, the query editor displays with the generated COPY command that was used to load your data. The Result of the COPY is shown. If successful, you can now use SQL to select data from the loaded table. When there is an error, query the system view STL_LOAD_ERRORS to get more details. For information about COPY command errors, see STL_LOAD_ERRORS in the Amazon Redshift Database Developer Guide.

Confirm that you are connected to the target database in the tree-view panel of query editor v2 before continuing. You can create a connection using the context menu (right-click) to the cluster or workgroup where the data will be loaded.

Choose Load data.

For Data source, choose Load from S3 bucket.

In S3 URIs, choose Browse S3 to look for the Amazon S3 bucket that contains the data to load.

If the specified Amazon S3 bucket isn't in the same Amazon Web Services Region as the target table, then choose the S3 file location for the Amazon Web Services Region where the data is located.

Choose This file is a manifest file if the Amazon S3 file is actually a manifest containing multiple Amazon S3 bucket URIs.

Choose the File format for the file to be uploaded. The supported data formats are CSV, JSON, DELIMITER, FIXEDWIDTH, SHAPEFILE, AVRO, PARQUET, and ORC. Depending on the specified file format, you can choose the respective File options. You can also select Data is encrypted if the data is encrypted and enter the Amazon Resource Name (ARN) of the KMS key used to encrypt the data.

If you choose CSV or DELIMITER, you can also choose the Delimiter character and whether to Ignore header rows if the specified number of rows are actually column names and not data to load.

Choose a compression method to compress your file. The default is no compression.

(Optional) The Advanced settings support various Data conversion parameters and Load operations. Enter this information as needed for your file.

For more information about data conversion and data load parameters, see Data conversion parameters and Data load operations in the Amazon Redshift Database Developer Guide.

Choose Next.

Choose Load new table.

The table columns are inferred from the input data. You can modify the definition of the table schema by adding columns and table details. To revert to the query editor v2 inferred table schema, choose Restore to defaults.

Confirm or choose the location of the Target table including Cluster or workgroup, Database, and Schema where the data is loaded. Enter a Table name to be created.

Choose an IAM role that has the required permissions to load data from Amazon S3.

Choose Create table to create the table using the definition shown.

A review summary of the table definition is displayed. The table is created in the database. To later delete the table, run a DROP TABLE SQL command. For more information, see DROP TABLE in the Amazon Redshift Database Developer Guide.

Choose Load data to start the data load.

When the load completes, the query editor displays with the generated COPY command that was used to load your data. The Result of the COPY is shown. If successful, you can now use SQL to select data from the loaded table. When there is an error, query the system view STL_LOAD_ERRORS to get more details. For information about COPY command errors, see STL_LOAD_ERRORS in the Amazon Redshift Database Developer Guide.