Loading and unloading data

Importing and exporting data is crucial when working with data warehouses, especially with Amazon Redshift. While performance is critical, a simple and scalable process is essential.

Here at DataRow, we know how critical for you to get your loads and unloads operating smoothly. So, COPY and UNLOAD Wizards are at your service, creating an effortless pipeline to and from your Amazon Redshift.

In this post, we’ll cover how easy is to load and unload data using DataRow’s COPY and UNLOAD Wizards.

The COPY Wizard: Loading data into Amazon Redshift

Prepare your COPY command in just six steps with DataRow’s COPY Wizard. Run it right away, or save the preferences to run it later.

copy command wizard page on datarow

Loading data with the COPY Wizard step-by-step:

  1. Select your data source

    Amazon Simple Storage Service (Amazon S3) bucket, an Amazon EMR cluster, or a remote host that is accessed using a Secure Shell (SSH) connection.

  2. Select your file type and size

    CSV, Fixed width, JSON or Avro.

  3. Provide the authorization

    Referencing an IAM role that is attached to your cluster or by providing the access key ID and secret access key for an IAM user.

  4. Specify a conversion

    If you need to specify a conversion that is different from the default behavior, or if the default conversion results in errors, you can manage data conversions by specifying the parameters listed by AWS.

  5. Choose Data Load Operations

    Manage the default behavior of the load operation for troubleshooting or to reduce load times by specifying the parameters listed by AWS.

  6. Run the query

    Run the query immediately, or save the preferences for another time.

The UNLOAD Wizard: Unloading data out Amazon Redshift

Easily get data out of Amazon Redshift with UNLOAD Wizard to one or more text files on Amazon S3. Prepare your UNLOAD process in just two steps:

1- Enter your UNLOAD configurations including target bucket, data source region and other unload options.

2- Select the authorization type and save your configuration. You can give authorization via IAM Role, IAM User, Session Token or credentials.

Ready to use DataRow? Get started with a free trial for your business.