Hi All,
I’m facing an issue in creating new tables with dynamic names in dbt model
In my work we are trying to create tables with suffix of current_timestamp (<table_name>_<current_timestamp>), but when I run this model in minute basis like every minute or some seconds, it’s creating the table with privious execution table name (like table name from cache). How to resolve this
I’m new to dbt, and I am trying from scratch.
this is my sample code
{% set timestamp = modules.datetime.datetime.now().strftime(“%Y%M%D%H%M%S”) %}
{{ config(alias=“sample_” ~ timestamp, materialized=‘table’) }}
Select ‘User’ as name, ‘Manual’ as run_type