Terraform Provider SnowSQL

The snowsql provider allows for custom Terraform CRUD management of Snowflake objects using SnowSQL.

Note: This provider is not a drop in replacement for the robust resources implemented by terraform-provider-snowflake. For example, use the snowflake_warehouse resource if you need to create a virtual warehouse, Use this provider when you require fine grain control of DCL commands or to implement Snowflake objects that are unsupported by the Snowflake provider resources.

Similiar to the terraform-provider-shell; this provider

this is a backdoor into the Terraform runtime. You can do some pretty dangerous things with this and it is up to you to make sure you don't get in trouble. Since this provider is rather different than most other provider, it is recommended that you at least have some familiarity with the internals of Terraform before attempting to use this provider.

Build provider

Run the following command to build the provider

$ go build -o terraform-provider-snowsql

Test sample configuration

First, build and install the provider.

$ make install

Then, navigate to the examples directory.

$ cd examples/resources/exec/basic

Run the following command to initialize the workspace and apply the sample configuration.

$ terraform init && terraform apply

Credits

see CREDITS for more information.