We are using Fivetran to sync our production data with BigQuery. However, when data is deleted in production, it still shows up in our Looker explores; there’s a field called _fivetran_deleted and rather than removing deleted records, the records are simply marked ‘true’ in this field to indicate that they’re deleted.
We have asked them if there’s a way they can just set it to remove deleted fields, but it sounds like the answer from them is that we need to filter them out manually.
Is there a simple way to do this in our base views? We don’t want ANY records in Looker that are marked as deleted, and I’m afraid this is going to be extremely cumbersome.
Best answer by DawidView original