Snowflake + Terraform

• reference
  
• documentation

Dependencies

"sf_tf_user_name" user need sys_admin, security_admin roles on the target Snowflake instance

Steps

• create warehouses(LOADING, TRANSFORMING)
• create databases(ANALYTICS, ANALYTICS_STAGE)
• create roles(LOADER, TRANSFORMER, REPORTER)
• create dbt user
• create schemas
• grant roles

Manual deploy method

• Clone this repo

• Initialize the terraform project

  terraform init
  

• Create the secret.tfvars based on the empty_secret.tfvars file

• plan

    terraform plan -var-file secret.tfvars
  

• apply

    terraform apply -var-file secret.tfvars