Export Data from Fivetran to Primer via S3
Fivetran Activations can generate recurring CSV snapshots using its Amazon S3 destination.
To maintain one current dataset in Primer, configure the sync with:
Replace as the sync behavior
A fixed filename
CSV format
A comma delimiter
A header row
No PGP encryption
The complete source dataset on every run
Use Replace only
Do not use Update or Create. Fivetran adds timestamps to files generated by incremental Update or Create runs. Because Primer uses each filename as a dataset name, this would create multiple datasets instead of updating one dataset.
Direct integration with Primer’s S3 access points is subject to compatibility validation. Fivetran’s documentation describes standard S3 bucket connections but does not explicitly document S3 access-point aliases.
Fivetran also requires an external ID and role permissions configured by Primer. Contact your Primer representative before creating the destination. Primer will provide the access-point alias, AWS Region, role ARN, upload path, and validated authentication instructions.
For additional information, see:
Last updated