website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Toast
Asana
Aloha POS
BILL
Bloom Growth
Bullhorn
Ceridian Dayforce
ConnectWise
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
Oracle EBS
Oracle PeopleSoft
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zoom
Databases
Files & Object Storage
SSH Tunnel Setup for Hosted Database Systems
Databases FAQ
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Historical Re-sync
Analytics
Access Analytics
Snowflake Usage Analytics
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehouse Clouds
Snowflake
Open Source DW Models
Alerts & Notifications
Slack Notifications
Untitled doc
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
License
Viewpoint
Docs powered by archbee 

Terraform: Reverse Terraforming

6min

We have developed the world's first reverse Terraform for your Snowflake Cloud Data Warehouse and will continue to add additional abilities that enable you to take your existing Cloud DW footprint and align it with your existing Terraform investments.

DLH.io Terraform Files
Reverse Terraform Filesa

DLH.io Reverse Terraform
Snowflake Terraforming




Our customers tell us the main use case for this feature is when they have completed a proof-of-value (POV) for Snowflake and as the solution starts moving into the next phase of development, when considering leveraging existing of future use of Infrastructure-as-a-Service (IaaS) and Terraform is the IaaS of choice, conducting a blueprint extraction from the PoV is a tremendous time-saver.

How does it work?

In DLH.io there is an option to articulate the currently deployed Snowflake Cloud Data Warehouse as a set Terraform scripts (.ts files) and state. This is perhaps a snapshot but the most important thing is that it is a complete Terraform configuration for Snowflake that can be now used to deploy the same structure of objects to another Snowflake account.

DLH.io Reverse Terraform of Snowflake service will:

  • Communicate with your Snowflake account
  • Extract all core objects you select and convert them into Terraform syntax and files

Once the files are extracted you can see the format of the files. You may need to unzip the deployed files for larger accounts that are reversed terraformed.

DLH.io Reverse Terraform
Reverse Terraform


Once you've completed the process and downloaded your DLH.io Reverse Terraform Snowflake TF files:

  • Navigate to your Terraform repository folder in your terminal where your Terraform project exists and you have just copied the output files from DLH.io Terraform Reverse Snowflake
  • Initialize your the terraform setup by running,
Shell
|
terraform init 

  • Run the terraform import commands by copy pasting them into the terminal or run them as a shell script file
  • The above step will generate a tfstate file
  • Run terraform plan . if all the resources are correctly imported this will indicate that there are no changes between the existing snowflake infrastructure and the terraform state (tfstate file). If this step indicates changes then that means that there is a difference between the resources imported and the snowflake existing production infrastructure. Any changes will have to be managed on a case by case basis.
  • After the tfstate file is in sync with the snowflake production state, any changes made in terraform will involve the below steps -
    • Make the change in .tf state file of the resource.
    • Run terraform plan to confirm the change
    • Run terraform apply to compliment the change in Snowflake



Updated 17 May 2023
Did this page help you?
Yes
No
PREVIOUS
SQL Transformations
NEXT
DBT Cloud Transformations
Docs powered by archbee 
TABLE OF CONTENTS
How does it work?