Running Redshift
Pre-requisites:
Redshift account
S3 bucket
Setting up S3 bucket
We'll need an S3 bucket so that Artie Transfer can load micro-batches of TSVs such that we are able to invoke the remote COPY command
for Redshift.
After the MERGE, we will no longer need the files on S3, so it's generally recommended to set up a Lifecycle rule in S3 to have these files be automatically purged.
Here's an example of what the bucket and lifecycle configuration can look like in Terraform.
Last updated