Support DBT `modules` in jinja templating - Githubissues

sqlfluff / sqlfluff

A modular SQL linter and auto-formatter with support for multiple dialects and templated code.

https://www.sqlfluff.com

MIT License

7.99k stars 734 forks source link

Support DBT `modules` in jinja templating #6470

Open mroy-seedbox opened 6 days ago

mroy-seedbox commented 6 days ago

Search before asking

[X] I searched the issues and found no similar issues.

Description

DBT exposes a modules variable which can be used to access some python modules: datetime, pytz, re, and itertools.

The first error we run into is Undefined jinja template variable: 'modules'.
Then if we define a template variable: modules = {"datetime": {"date": {}}}, we get this error when we try to use modules.datetime.something(): Unrecoverable failure in Jinja templating: 'dict' object is not callable.

Is there any way to define a template variable as a callable?

Dialect

Any.

Are you willing to work on and submit a PR to address the issue?

[X] Yes I am willing to submit a PR!

Although I do not have the time at the moment.

Code of Conduct

[X] I agree to follow this project's Code of Conduct

mroy-seedbox commented 6 days ago

I think it should be doable for SQLFluff to expose these python modules as well.

But in the meantime, a workaround is to wrap the methods that we need in a macro, and them configure the macro in [sqlfluff:templater:jinja:macros].