Karikaaalan
Karikaaalan

Reputation: 179

Snowflake terraform for queries

I wanted to execute few queries for the Snowflake with terraform like. use role admin; alter account set saml_identity_provider = '{ "certificate": "test", "ssoUrl": "https://abccorp.okta.com/app/<okta_snowflake_app_id>/sso/saml", "type" : "OKTA" }';

I want to execute queries like this.Is there any terraform templates that is available,

Upvotes: 1

Views: 1117

Answers (1)

Robert Long
Robert Long

Reputation: 7067

There is a terraform provider plugin for managing Snowflake accounts. Coverage is focused on the parts of Snowflake that are related to access control. Example use cases include:

  • Set up storage in your cloud provider and add it to Snowflake as an external stage
  • Add storage and connect it to Snowpipe
  • Create a service user and push the key into the secrets manager of your choice, or rotate keys

Terraforming Snowflake

Upvotes: 0

Related Questions