Configure a Data Destination - S3 and Redshift

Configuring a Data Destination for Amazon S3 and Redshift.

At One Model, we think it's critical that your data goes to where you need it most. If Amazon is your platform of choice, you can use our S3 or Redshift Data Destinations to send data from One Model to your Amazon environment.

Configure an Amazon S3 Data Destination

To configure an Amazon S3 Data Destination in One Model, navigate to Data -> Destinations. Then select Add Data Destination, and select Amazon S3:

 

From there, configure the required settings for your data destination:

Display Name - The name of the Destination as it will appear in One Model

Aws Region - The region that the S3 bucket is in

Bucket Name - The name of the S3 bucket that the files will be uploaded into

Upload File Path - The path in the S3 Bucket that the files will be uploaded to. This can be a value like "/" for the root directory in the bucket, or "/SubDirectoryName/" to navigate to a sub-directory.

AWS Access ID - The Access ID for the Amazon IAM (Identity and Access Management) user that has access to the bucket

AWS Secret Key - The Secret Access Key for the Amazon IAM user.

 

Note: One Model does not support Two-Factor authentication for Amazon S3

 

Configure a Redshift Data Destination

To configure an Redshift Data Destination in One Model, navigate to Data -> Destinations. Then select Add Data Destination, and select Redshift:

From there, configure the required settings for your data destination:

Display Name - The name of the Destination as it will appear in One Model

Redshift Type - Whether the Redshift cluster is Internal (re-loading data into your One Model Redshift Cluster), or External (a Redshift cluster of your choice)

Schema - The Schema in Redshift that the data will be loaded into

Endpoint* - The URI that the Redshift Cluster can be accessed through

Port* - The Port that the Redshift Cluster can be accessed through for that Endpoint

Database* - The Database in the Redshift Cluster that the data will be loaded into

Username* - The Redshift User that has access to load data into that Redshift Cluster

Password* - The Password of that Redshift User

(* refers to fields that are only configurable where Redshift Type is External)

 

For further details on how to configure a Data Destination, refer to our Configure a Data Destination guide.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.