Hi All
How can I avoid sorting in my dbt core model when loading data into Snowflake? I have a Snowflake cluster defined on two columns. When I run the job, I notice that dbt automatically adds an ORDER BY clause, which reduces Snowflake’s performance. I want to prevent dbt from automatically adding the ORDER BY clause. I have tried the below options, but they are not working.
I have tried the below code in my dbt core model
{{ config( materialized=‘table’, cluster_by=[‘period_name’,‘version’], sort= none ) }}
select * from table
{% if execute.materialized %} {{ query_without_order_by }} ORDER BY {{ sort }} {% else %} {{ query_without_order_by }} {% endif %}