Terraform vs Pulumi vs CloudFormation as IaC for Snowflake on AWS

• cloudformation-snowflake-resource-providers

  1 4 6.6 TypeScript

  SnowFlake CFN Registry resource

  

AWS CloudFormation

• schemachange

  9 457 6.7 Python

  A Database Change Management tool for Snowflake

  

We have tried Terraform and others like Snowchange and in the end, we use Snowchange: - Terraform for Snowflake has a very tricky thing is that the table is replaced whenever Terraform detects a change. This is OK for AWS resources but it is bad for data thing like Snowflake - you don't want any change, unless you specifically want to. - We then have to use the second one, Snowchange. This one idea is simple: it marks the SQL files with versions, such as V0.1.1. Snowchange will only run the files if and only if the files are bigger than the biggest recorded in a table in Snowflake (which is done by itself). For example, if the largest version is V0.1.1, and some user accidentally changes the file of V0.1.0, since it is smaller than 0.1.1, the changes are not deployed. Users have to manually the file name to 0.1.2 for it to run.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project