Can I omit columns for incremental tables?

[yeykawb]

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.

[a_slack_user]

You can define it in the “merge_exclude_columns” config. Docs here: https://docs.getdbt.com/docs/build/incremental-models#strategy-specific-configs

_{Note: @Owen originally posted this reply in Slack. It might not have transferred perfectly.}

[a_slack_user]

Thanks!

_{Note: @jakob.agelin originally posted this reply in Slack. It might not have transferred perfectly.}