[Feature]: Add DBT Project support

[bcs-administrator]

Company Name

Building Controls and Solutions

Use Cases or Problem Statement

We want to make use of DBT Projects and Workspaces in Snowflake and want to have all of the objects managed through Terraform and CI/CD deployments to make compliance reporting and management of these projects and their resource dependencies manageable by code.

Category

category:resource

Object type(s)

No response

Proposal

Please add support for DBT Project configuration details via terraform to Snowflake including dependent resources like git repository configurations, ssh keys, workspaces, etc.

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @bcs-administrator. Thanks for reaching out to us.

Do you happen to know if there is SQL support for creating the dbt project, workspace, etc.? The current provider is based on SQL capabilities. If something is not available through SQL, then we won't be able to support it with the current provider architecture.

[bcs-administrator]

Yes, actually.

DBT Projects - https://docs.snowflake.com/sql-reference/sql/create-dbt-project
Git Repos - https://community.snowflake.com/s/article/Setting-up-Git-integration-with-various-Git-providers

[sfc-gh-jmichalak]

Thanks for the response. I added this to our features list; we'll discuss it internally. We're open to contributions. Please read our Contributing guide if you're interested.

For the git repositories, we recently added a new preview git_repository resource. Unfortunately, api_integration resource does not support git repositories yet.