website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Asana
Aloha POS
Baremetrics
Beans Route
BILL
Bloom Growth
Bullhorn
Calendly
Ceridian Dayforce
ClinicalTrials.gov
ConnectWise
DBT Cloud
DBT Cloud Log Stream
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Google Play
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
Microsoft Teams
NetSuite (Oracle NetSuite)
NetSuite SuiteAnalytics
Optimum HRIS
QuickBooks Online
Salesforce
Salesloft
Shift4 Payments
Shopify
Square
Square Marketplace
Stripe
Toast
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zendesk Sell
Zoom
Databases
Files & Object Storage
SQL Data Query
SSH Tunnel Setup for Hosted Database Systems
SQL Playground Editor
SQL Transformations
DBT Cloud Transformations
Terraform: Reverse Terraforming
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
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
July 2023
June 2023
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Customer Support
License
Viewpoint
Credit Consumption Breakdown
Docs powered by
Archbee
website logo

DBT Cloud Transformations

4min

DataLakeHouse.io with DBT Cloud works like something magical. Adding a DBT Cloud transformation in DataLakeHouse.io allows you to call an existing job as part of the sync data pipeline. After each synchronization frequency of your source data to the raw landing zone at your target/destination (e.g.: Snowflake) a DBT Cloud job can be run. You can even override some of the DBT Cloud parameters of the job to dynamically control the job steps and other details of the run.

DBT Cloud Jobs on DLH.io
DBT Cloud Jobs on DLH.io


For more information on how to create a transformation, you will perform similar steps to create SQL Transformations but instead of the SQL Transformation Type you will select the DBT Cloud option instead.

Add a DBT Cloud Transformation

  1. Click on Transformation from the header menu
  2. Click on New Transformation or Add a Transformation to show the Transformation creation form.
  3. Update the DBT Json Options field with any override information, use "{}" or leave blank which is the default
  4. Update the Job ID field with the job id from your DBT Cloud instance
  5. 
  6. Click the Save button

For more information on DBT Cloud & DBT Cloud Transformations:

  • Please use our community support and forums on Slack at https://datalakehouse.slack.com



Updated 20 Jun 2023
Did this page help you?
PREVIOUS
SQL Transformations
NEXT
Terraform: Reverse Terraforming
Docs powered by
Archbee
TABLE OF CONTENTS
Add a DBT Cloud Transformation
For more information on DBT Cloud & DBT Cloud Transformations:
Docs powered by
Archbee