Skip to content

dbt-labs/coalesce-workshop-template

Repository files navigation

{{ workshop_name }} Workshop

Welcome to the {{ workshop_name }} workshop of Coalesce {{ coalesce_year }}!

{{ workshop_intro }}

Prerequisites This workshop assumes that you're familiar with dbt and at a minimum know how to:

  • Apply and run out-of-the-box dbt tests
  • Execute dbt commmands
  • Use git functionality
  • Write basic SQL
  • {{ update_prereqs }}

It's a bonus if:

  • You understand languages like Jinja (templating) or Python (scripting)
  • You've written some basic Jinja or Python statements in the past
  • {{ update_bonus_knowledge }}

Live Participant Setup Instructions

If you'll be joining us live at location, you'll be given access to a project for this workshop. You can also bring your own dbt Project!

Verify that you're set up and ready to go once you have access to a project:

  1. Navigate to the dbt Cloud account
  2. Click the cog in the top right corner and go to Profile Settings
  3. Click on User Profile > Credentials in the left sidebar
  4. Click on the project name you want to set credentials for
  5. Click Edit in the bottom right corner of the pane that opens
  6. Configure your development credentials:
    1. Scroll to the Development Credentials section in the pane
    2. Change these configurations:
      configuration value
      schema Set this to dbt_[first_initial][last_name]. Example: dbt_cberger
      target Set this to dev
    3. Click Save
  7. Verify your connection:
    1. Click the Develop tab in the top menu bar
    2. Create a new branch named coalesce_[first_initial][lastname]. Example: coalesce_cberger
    3. Run dbt deps if needed to install dependencies (you'll be informed via the UI)
    4. Try running dbt build from the command bar at the bottom of the UI

{{ additional_information }}

Remote Participant Setup Instructions

Before completing this workshop, there are some prerequisites that you'll need:

  1. A Repository
    Ideally, with the files and folders contained in this workshop. To make a copy, fork this repository.

  2. dbt This workshop is written using dbt Cloud, so a Cloud account is ideal. If using core, you'll need to pay attention to the differences to complete this workshop on your own.

    Ideally, you'll also want to work with the dbt version this project was built with (dbt v{{ version }})

    Resources:

  3. Some Data
    This project is written on top of Snowflake and uses the publicly available TPC-H data set which is be included in a Snowflake trial account.

    A truncated version of the data set has also been included in this project as CSV files if you're using a different data platform - this is located in the resources folder.

    Important: We don't suggest seeding the CSV files. Though they are truncated, there are still a signifcant amount of rows. As a best practice we use seed functionality for small and static datasets where seeds are more performant for this specific purpose.

    If you don't have a data platform set up yet, don't worry. These guides are great for getting you set up: BigQuery

    Snowflake

Verification if using this repository and dbt Cloud

  1. Navigate to your dbt Cloud account
  2. Click the cog in the top right corner and go to Profile Settings
  3. Click on User Profile > Credentials in the left sidebar
  4. Click on the project name you want to set credentials for
  5. Click Edit in the bottom right corner of the pane that opens
  6. Configure your development credentials:
    1. Scroll to the Development Credentials section in the pane
    2. Change these configurations:
      configuration value
      schema Set this to dbt_[first_initial][last_name]. Example: dbt_cberger
      target Set this to dev
    3. Click Save
  7. Verify your connection:
    1. Click the Develop tab in the top menu bar
    2. Create a new branch named coalesce_[first_initial][lastname]. Example: coalesce_cberger
    3. Run dbt deps if needed to install dependencies (you'll be informed via the UI)
    4. Try running dbt build from the command bar at the bottom of the UI

{{ additional_information }}

🎉 If you've made it this far, congratulations! You're ready to go. 🎉

You're ready to start the workshop! There's nothing else to do until the workshop begins.

Additional Helpful Links:

  • Learn more about dbt in the docs
  • Check out Discourse for commonly asked questions and answers
  • Join the dbt community for more help and hang with other data practitioners
  • Find dbt events near you
  • Check out the blog for the latest news on dbt's development and best practices

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published