I am trying to deploy all objects which are in snowflake. I had made bit success with tables, views but not able to create sequence with dbt.
I am looking for viable solution to complete my version control for snowflake with dbt.
DBT Team,
Can you please help here ?
Hi, dbt might not be the right tool for you if you want to “version control” an entire Snowflake database. dbt is specifically about building data models for analytics, so is primarily focused on creating tables and views. It doesn’t cover sequences, or many other Snowflake objects like stages, integrations, tasks, users etc.
That said, you can potentially create your own custom materialization that generates a sequence: https://docs.getdbt.com/docs/guides/creating-new-materializations/