I am used to having both a “RowInsertedDatetime” and a “RowUpdatedDatetime” column in my fact tables to keep track of the history of a specific row and whether it has been updated since insertion (first load both are current_timestamp()). Is it possible to omit “RowInsertedDatetime” column when running with incremental tables? So the value never changes.
You can define it in the “merge_exclude_columns” config. Docs here: https://docs.getdbt.com/docs/build/incremental-models#strategy-specific-configs
@Owen originally posted this reply in Slack. It might not have transferred perfectly.
@jakob.agelin originally posted this reply in Slack. It might not have transferred perfectly.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.