bigquery suggestion. right now we use DBT for basic normalization. which does something like

create or replace table

and creates the entire table at each sync step. Has anybody thought of replacing this with materialized view? it is automatically supported by bigquery (so need to run it each time) and is incremental. so you only pay for new data

Hi, yes we have. Please see this issue for more info