astronomer cosmos distributed by

Help
,
1

Hello everyone!
I’m running an incremental model (dbt-core) using Cosmos and Airflow. The distribution key is specified in the model’s config. The table is created without the specified key.
However, when I run the model manually via the terminal, the table is created with the distribution key.

What should be specified in the Cosmos parameters to add distributed key?

{{
config(
materialized=‘incremental’,
unique_key=‘id’,
distributed_by=‘id’,
orientation=‘row’,
appendoptimized=false,
incremental_strategy=‘delete+insert’,
) }}

2

Can you please share the dbt logs from both astronomer and terminal? Are we using same user from astronomer and terminal to run the model?

Note: @Hareesh originally posted this reply in Slack. It might not have transferred perfectly.