To create an Import from S3:
- Open the "Copy from S3 to Redshift - Advanced" Template. This can also be found under “CODE” and “More Script Templates…” in the top navigation bar.
- Click the “New Custom Script” button.
- If you have yet to add the S3 credential to Civis, click on the "Add Credential" link below the "Credential" field (see instructions below).
- Fill out the template and click "Run Now" in the top-right corner of the page.
Notes
- Example S3 file path:
- s3://brandable-groupbucket-fbe73dg/home/jsmith/Brandable_Consumer_list.csv
- If you do not see this option in your Scripts index, contact support@civisanalytics.com
- This script utilizes the Redshift COPY command, for full documentation see COPY
- Importing can be scheduled and included in a workflow.
Adding an S3 Credential
To add your S3 credential to Platform go to New Credential and fill out the fields and click "Save"
- Name: what you would like this credential to be named
- Credential Type: Amazon Web Services S3
- Username: AWS Access Key
- Password: AWS Secret Key
Comments
0 comments
Please sign in to leave a comment.