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.
Comments
0 comments
Please sign in to leave a comment.