Skip to main content

Coalesce dbt Fusion Engine in platform Quickstart Guide

dbt Fusion engine
dbt platform
Quickstart
Beginner
Menu

    Introduction​

    Get hands-on with the dbt Fusion Engine in a sandbox dbt platform account during Coalesce.

    info

    This Quickstart guide is only intended to be used by in-person Coalesce registered users.

    Continue using this guide to get hands-on keyboard experience, preview the experience in the following video.

    Section 1: Sandbox Sign-up​

    Let's get started with access to a Fusion sandbox!

    The form for accessing your Fusion Sandbox in dbt platform.The form for accessing your Fusion Sandbox in dbt platform.
    1. Go to https://workshops.us1.dbt.com/workshop (Note: In order to access the sign-up page, you may need to log out of any existing dbt Platform account you have or access this URL in Incognito Mode)

    2. Enter your first name, last name, and company email.

    3. From the dropdown, select Mom’s Flower Shop as your workshop.

    4. Enter the passcode provided on the Fusion @ Coalesce website (linked via the QR code in your welcome bag).

    5. Click Complete Registration and note your temporary email and password.

      💡 Accounts remain active for 7 days, but you must use the temporary email / password provided to you after registration to access the account. Store this in a notepad doc or password manager for the week.

    6. Click Login

    Section 2: Developer productivity with Fusion​

    1. In the dbt platform left-hand navigation, click Select a project and choose Mom’s Flower Shop

    2. In the left-hand navigation, click on Studio to open the Fusion-enabled IDE.

    3. An in-app guide will appear for quick resources and videos about Fusion’s new capabilities. Please take a few minutes to review these resources!

    4. From the File Explorer in Studio, open the models/staging/stg_flower_orders.sql file.

    5. Use Preview CTE above the first CTE to preview data for just this CTE (raw_flower_orders) .

      💡 Fusion enables modular previews for faster debugging.

    6. Hover over the asterisk in select * to see column names and data types of available columns.

    💡 Fusion provides live metadata and column insights as you code.💡 Fusion provides live metadata and column insights as you code.
    1. Test Fusion’s live error detection — introduce a typo and click Save. (e.g., change order_id to order_key) to see real-time feedback. Hover over the red squiggly line to see details about the error.
    Fusion can detect your SQL errors in real-time while you code and before you send it to your data platform.Fusion can detect your SQL errors in real-time while you code and before you send it to your data platform.

    Please note: any file edits stay local to your Studio IDE; no feature branches are permitted for this sandbox account.

    Section 3: State-aware orchestration​

    1. From the left navigation, go to Orchestration → Environments → Production.

    2. Navigate to Prod Job (State Aware Orchestration Enabled) at the bottom of the page.

    3. Open Settings to enable State Aware Orchestration. Check Enable Fusion cost optimization features and expand to check State Aware Orchestration. Click Save.

    SAO is easily enabled through the familiar job configurations view.SAO is easily enabled through the familiar job configurations view.
    1. Navigate back to the job page by clicking on the Prod Job (State Aware Orchestration Enabled) in the breadcrumb path above the Run #.
    Navigate back to the job itself through the breadcrumb.Navigate back to the job itself through the breadcrumb.
    1. Click Run now on the Prod Job (State Aware Orchestration Enabled) and click into the run to view logs.
    Choose the run now button to kick off the initial SAO run.Choose the run now button to kick off the initial SAO run.
    1. After completion, open the Lineage tab.

      All models should show Success, since this is the first full run of the project.

    2. Run the job again by clicking Run now again to see the power of State aware orchestration at work!

    3. When the job completes, open the Lineage tab to see Reuse statuses appear on most models. We have new flower orders, so the stg_flower_orders and downstream models are rerun (status: success), while the rest of the models are reused, since there is no new data.

      💡 Fusion automatically skips models without fresh data, saving pipeline execution time and avoiding data platform costs

    4. On the Prod Job (State Aware Orchestration Enabled) page, click on Models underneath the Overview section.

      View the Models built vs. Models reused charts to monitor efficiency gains.

    💡 State aware orchestration ensures only changed data is processed.💡 State aware orchestration ensures only changed data is processed.

    Section 4: Learn More​

    Stop by the dbt Booth in the Discovery Hall to learn more about the Fusion-powered features mentioned in the keynote, witness the magic firsthand at any of our demo pods, and dive deeper into use cases, success stories, and migration details through ongoing lightning talks.

    • Learn more about the dbt Fusion Engine in the docs: About Fusion
    • Continue learning dbt at learn.getdbt.com
    • Learn about Coalesce — the premier analytics engineering conference where data leaders and practitioners reimagine tools and reshape the future of data and AI.

    Was this page helpful?

    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

    0