Ensure full support for Snowflake

[Matteo Renoldi (mattcristal)]

What is needed to ensure full support for Snowflake? ❄️

Happy to help out!

[Pádraic Slattery (pgoslatara)]

Matteo Renoldi (@mattcristal) The only reason Snowflake is listed as partially supported is the fact that we do not include Snowflake in the list of adapters tested in the CI pipeline. This is to do with the cost of having a Snowflake account rather than anything to do with dbt, Jinja or the macros in this package.

[Matteo Renoldi (mattcristal)]

Thanks for the context!

So basically testing on Snowflake -> consumes credits -> it is expensive.

But what about Databricks or Google Big Query - which are supported - also for those you will need to consume credits when running the CI, right?

[Pádraic Slattery (pgoslatara)]

BigQuery has a generous free tier so we don't encounter any costs when running CI there.
Databricks is something I am lucky to have access to via my employer, the cost for running CI is small enough that it's not an issue.

[shreyadatar (shreyadatar)]

Pádraic Slattery (@pgoslatara) Thanks for the context! Considering that the package is not tested against Snowflake during CI, are there any practical gotchas we should be aware of if we are to start using this package to power our date dimension using dbt-Snowflake?

[Matteo Renoldi (mattcristal)]

Pádraic Slattery (@pgoslatara) Thanks for the context! Considering that the package is not tested against Snowflake during CI, are there any practical gotchas we should be aware of if we are to start using this package to power our date dimension using dbt-Snowflake?

I am personally using this package with Snowflake and everything works for me