Can I specify cluster keys for Snowflake in DBT within my yaml file?

Question

According to current DBT documentation for Snowflake, you can configure clustering in Snowflake by providing cluster_by into a models' config.

config(
    materialized='table',
    cluster_by=['col_1']
  )

I would rather provide these values in the model's yml file, like so:

models:
  - name: my_model
  cluster_by: ['col_1']

Is this possible to do?

user_46239 · Answer

You should be able to do this using a config resource property in the .yml file.

e.g.

models:
  - name: my_model
    config:
      cluster_by: ['col_1']