Skip to content

Instantly share code, notes, and snippets.

View lgreene27's full-sized avatar

Lesley Greene lgreene27

  • Los Angeles, CA
View GitHub Profile
@lgreene27
lgreene27 / dbt_project.yml
Created December 9, 2021 19:40
Logging jobs
#For the purposes of logging changes, ignore everything except the section at the bottom introduced with comment
name: 'my_new_project'
version: '1.0.0'
config-version: 2
profile: 'default'
source-paths: ["models"]
analysis-paths: ["analysis"]
test-paths: ["tests"]
@lgreene27
lgreene27 / workspace_setup_script.sql
Created November 23, 2021 01:38
workspace_setup_script
// Do a find replace on {{ project_name }} with the name of your project.
// This will be used in naming your resources, for example databases named {{ project_name }}_DEV and {{ project_name }}_PROD
// Also find and replace {{ qa_svc_accnt_password }} and {{ prod_svc_accnt_password }}
// After completing find and replace, read through each section to make sure you want to follow this setup
// If you run all of these commands in Snowflake you will create DEV, QA, and PROD resources,
// including Databases, Warehouses, Roles, and Service Accounts
// Pay special attention to granting privileges on your sources section and make sure you grant the needed privileges to some users!
//=============================================================================
// create data resources