Limiting Data Access Using Views

Use Case

You need to implement row-based filtering to limit the amount of data that users can access from certain tables in your database.

Recommendation

Fivetran syncs all rows from tables from source to destination. Fivetran recommends using views and permissions in your destination to limit the data that users have access to. Views can be built with a WHERE clause to implement row filtering based on the data in the table.

1. Create VIEWS with a WHERE clause to limit the rows that are available in the view
2. GRANT access to the VIEWs to users and groups
3. Revoke access to the raw tables Fivetran syncs where the full set of data is stored

Considerations