In this book, we introduce how to easily manage the configuration of Snowflake, known as a SaaS-based data cloud and data warehouse, using Terraform, a tool for Infrastructure as Code (IaC). While systematically organizing practical configurations that can be used in real services, we cover safe resource update methods using GitHub Actions. Additionally, we present methods for managing tables using Golang-migrate.

# Contents:

- Terraform × Snowflake
- GitHub Actions
- Golang migrate

Please note: The content is based on the software versions available at the time of writing. When readers attempt to utilize the content, the software may have been updated, so please exercise caution.

Building Modern Data Platforms: A Guide to Snowflake and Terraform

Introduction

What is Snowflake?

What is Terraform?

Installing Terraform and Basic Operations

About Terraform-Provider-Snowflake

[Basics] Initial Setup

[Basics] CI/CD for Snowflake Resources using GitHub Actions

[Basics] Running Terraform Plan via GitHub Actions

[Basics] Running Terraform Apply using Workflow Dispatch

[Basics] Creating Users and Roles

[Basics] Creating Databases and Schemas

[Basics] Creating Warehouses

[Advanced] Designing the Upcoming Data Infrastructure

[Advanced] Creating Databases

[Advanced] Creating Schemas

[Advanced] Table Management using Golang-migrate

Concluding Remarks

terraform

data

snowflake

nagahama