You would like to replicate data from a view in your source database in your destination.
Fivetran does not sync views directly from the source database because of how changes to the data in the underlying tables makes it hard to accurately track incremental updates to the view itself. Our recommendation is for you to re-create the view in your destination:
- Sync all of the underlying tables used in the view in your database connectors
- Copy the view definition code from your source database
- Create a new Fivetran SQL Transformation
- Paste your view definition code so it is re-created exactly the same in your destination
Each source database will have different mechanisms for quickly and easily extracting the code for the view.
Postgres: Use the view_definition column in the pg_views system table