Change default snapshot meta column names and values

Archive
1

Hi all!

I was wondering, is there any way to change snapshot’s default meta columns names (e.g. dbt_valid_from) to my custom names? I’m also wondering if it is possible to change the default value of dbt_valid_to column from null to specific date (like 2199-01-01)?

Thanks!

2

My assumption would be that you can easily change the default column names by either creating a view that refs the snapshot model or adding in a CTE. I think the view would be the easier option since you could also just convert the default value of null to a specific date as well in this downstream transformation model. However it would add more model files to your project.