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 in your service for an effortless pipeline into and out of 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.
Loading data with the COPY Wizard step-by-step:
- 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.
- Select your file type and size
CSV, Fixed width, JSON or Avro.
- 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.
- 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.
- 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.
- 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.