Hi,
I was wondering if it is possible to adjust the deletion criteria of the raw_table created upon Incremental | Append method in Bigquery. Currently we have data only from >= 2023-01-31 in all raw tables. The connection is Postgres → Bigquery but it can be observed in the other connections as well.
Our goal is to keep as much as raw data as we can without deleting it. Please advise if this is possible.
Thank you!