Use Terraform to interact with the Snowflake emulator


Terraform is an Infrastructure-as-Code (IaC) framework developed by HashiCorp. It enables users to define and provision infrastructure using a high-level configuration language. Terraform uses HashiCorp Configuration Language (HCL) as its configuration syntax.

The Snowflake emulator supports Terraform, allowing you to define and provision Snowflake resources using the same commands and syntax as the Snowflake service. You can use Terraform to create, update, and delete Snowflake resources locally, such as databases, schemas, tables, and stages.

Configuring Terraform

In this guide, you will learn how to configure Terraform to interact with the Snowflake emulator.

Setup Snowflake provider

To use Terraform with the Snowflake emulator, you need to configure the Snowflake provider in your Terraform configuration file. The following example shows how to configure the Snowflake provider:

terraform {
  required_providers {
    snowflake = {
      source  = "Snowflake-Labs/snowflake"
      version = "~> 0.61"

provider "snowflake" {
  account  = "test"
  user     = "test"
  password = "test"
  role     = "test"
  host     = "snowflake.localhost.localstack.cloud"

Create Snowflake resources

You can now use Terraform to create Snowflake resources using the Snowflake provider. The following example shows how to create a Snowflake database using Terraform:

resource "snowflake_database" "example" {
  name                        = "example"
  comment                     = "example database"
  data_retention_time_in_days = 3

Deploy the Terraform configuration

You can now deploy the Terraform configuration using the following command:

$ terraform init
$ terraform apply

The terraform init command initializes the Terraform configuration, and the terraform apply command creates the Snowflake database.