Can I create an auto-incrementing ID in dbt?

momomoro September 16, 2019, 7:26pm 1

Is it possible to create an auto number field while creating models?

2 Likes

Topic		Replies	Views
Surrogate key for multiple-source dimension table Archive	2	2931	May 25, 2022
Surrogate keys in dbt: Integers or hashes? In-Depth Discussions devblog	8	6319	February 1, 2024
Database enforcing PRIMARY key on TEMP tables, failing the DBT model Help dbt-core	0	55	January 30, 2025
How to get incremental number by using surrogate key ? Help	3	152	April 17, 2025
Insert only specific columns with DBT Archive	0	2233	August 3, 2022