How to Replicate Database Views in the Destination

Use Case

You want to replicate data from a view in your source database in your destination.

Recommendation

Fivetran does not sync views directly from the source database because changes to the data in the underlying tables make it hard to accurately track incremental updates to the view itself. We recommend that you re-create the view in your destination.

To re-create a view in your destination, do the following:

1. Sync all of the underlying tables used in the view in your database connectors.
2. Copy the view definition code from your source database.
3. Create a new dbt transformation. Learn how in our dbt transformation documentation.
4. Paste your view definition code so it is re-created exactly in your destination.

Considerations

Each source database has different mechanisms for extracting the code for the view quickly.

• PostgreSQL: Use the definition column in the pg_views system table