Welcome to Pulumi Registry, your window into the cloud. Read the announcement.

Snowflake

v0.3.1 published on Thursday, Nov 18, 2021 by Pulumi

The Pulumi Snowflake provider uses the Snowflake SDK to manage and provision resources.

Installation

The Snowflake provider is available as a package in all Pulumi languages:

Authentication against Snowflake

The Snowflake provider support multiple ways to authenticate:

  • Password
  • OAuth Access Token
  • OAuth Refresh Token
  • Browser Auth
  • Private Key

Configuring Credentials

Pulumi relies on the Snowflake SDK to authenticate requests from your computer to Snowflake. Your credentials are never sent to pulumi.com. The Pulumi Snowflake Provider needs to be configured with Snowflake credentials before it can be used to create resources.

Once the credetials are obtained, there are two ways to communicate your authorization tokens to Pulumi:

  1. Set the environment variables SNOWFLAKE_ACCOUNT, SNOWFLAKE_REGION and SNOWFLAKE_USERNAME with the correct combination of authentication variables:

    $ export SNOWFLAKE_ACCOUNT=XXXXXXXXXXXXXX
    $ export SNOWFLAKE_REGION=YYYYYYYYYYYYYY
    $ export SNOWFLAKE_USERNAME=ZZZZZZZZZZZZZZ
    
  2. Set them using configuration, if you prefer that they be stored alongside your Pulumi stack for easy multi-user access:

    $ pulumi config set snowflake:account XXXXXXXXXXXXXX
    $ pulumi config set snowflake:region YYYYYYYYYYYYYY
    $ pulumi config set snowflake:username ZZZZZZZZZZZZZZ
    

Remember to pass --secret when setting any secret keys so that they are properly encrypted. The complete list of configuration parameters is in the Snowflake Resource provider README.