Dynamic Table Name

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

Can anyone help me to sort out this