Question
Can Fivetran Sync from Redshift?
Answer
There are two primary options for syncing data from Redshift:
- If it’s a small dataset you can write a Lambda function. We have a blog post about it here.
- For larger datasets, you would need to do an export to S3, then have Fivetran sync the data files from there.
Cause
Our Postgres connector won’t work for Redshift and they won’t be able to get past the setup tests due to the dependencies we check for.