Skip to content
This repository has been archived by the owner on Feb 1, 2022. It is now read-only.

amychen1776/dbt-learn-demo

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

22 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

dbt-learn-demo

ℹ️ This is a demonstration repo used for dbt Learn. Each pull-request relates to one section of the group assignment. The branches for each stage have been left intact.

Getting started

There’s two main ways of working with dbt:

  • Edit files and run projects using the web-based Integrated Development Environment (IDE) in dbt Cloud.
  • Edit files locally using a code editor, and run projects using the Command Line Interface (dbt CLI).

Please follow the setting up instructions for your chosen development method. Either way, you're going to need credentials for Snowflake!

Here are the statements your database admin will need to run:

create user <user>
    password = '<generate_this>'
    default_warehouse = transforming
    default_role = transformer;

Using dbt Cloud

  1. Ask the data team to add you to the dbt Cloud account as a Developer.
  2. Click the hamburger menu, and then Develop.
  3. Enter your Snowflake credentials
  4. Verify that you can run dbt by entering the following in the command line input
dbt run

Using the CLI

  1. Clone this github repo
  2. Install dbt following these instructions
  3. Copy the example profile to your ~/.dbt folder (created when installing dbt):
$ cp ./sample.profiles.yml ~/.dbt/profiles.yml
  1. Populate ~/.dbt/profiles.yml with the credentials your Snowflake credentials
open ~/.dbt
  1. Verify that you can connect to Snowflake
$ dbt debug
  1. Verify that you can run dbt
$ dbt run

Coding conventions

This project follows Fishtown Analytics' coding conventions and git guide.

Understanding the structure of this project

This project follows the structure set out in this article.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published