There is a number of successful companies who aim to provide reverse-ETL as a service:

– Census
– Hightouch
– Grouparoo

However there are multiple ways to do it yourself:

1. Writing your own scripts

– Every script is adding complexity to your pipelines
– Non-scalable: you should write new code for each integration
– Requires Software Engineering skills: not applicable to business users

Could be automated with:

– Python + Airflow DAGs
– Jupyter + cron + any Python libs (pandas, sklearn, …)

2. Using off the shelf integrations

– Enables using built-in integration capabilities from Software you already use
– Could be tweaked easy enough

Examples are:

– Looker Action Hub
– Redshift with its Spectrum, Datashares, Unloading to S3

#reverse_etl