Undefined jinja template variable: 'dbt_utils'

Question

How to fix the below issue in sqlfluff linting:

Undefined jinja template variable: 'dbt_utils'. I have included templater = dbt in the .sqlfluff file.

Code being parsed:

config(
schema='business',
unique_key = 'calendar_id'
)
}}
WITH rpt_fact_calendar AS (
     SELECT * FROM {{ ref('stg_calendar') }}
)
SELECT
    {{ dbt_utils.generate_surrogate_key(['listing_id', 'till_date']) }}
AS calendar_id, rpt_fact_calendar.*
FROM 
    rpt_fact_calendar

Which dialect ? BQ or another. can you share the .sqlFluff file ? @derik — Faisal Maqbool, May 10 '23 at 11:28

score 0 · Accepted Answer · answered May 16 '23 at 15:08

0

In my case, I was running sqlfluff command from not the same directory as the .sqlfluff config file. The .sqlfluff config file was outside my dbt project directory. I am closing the question.

answered May 16 '23 at 15:08

Derik Roby

37
4

Undefined jinja template variable: 'dbt_utils'

1 Answers1