Skip to content

Instantly share code, notes, and snippets.

View sungchun12's full-sized avatar
🧃
Juicin' up these open source contributor muscles in full force!

Sung Won Chung sungchun12

🧃
Juicin' up these open source contributor muscles in full force!
View GitHub Profile
@sungchun12
sungchun12 / drop_dbt_cloud_pull_request_schemas.sql
Last active May 17, 2021 19:28
drop dbt Cloud pull request schemas to cleanup your snowflake database organization
--Run this command in your terminal: dbt run-operation drop_dbt_cloud_pull_request_schemas
--Write this as a file in your dbt project directory: macros/drop_dbt_cloud_pull_request_schemas.sql
--Original Source: https://github.com/randypitcherii/hashmap_randy_pitcher_workspace/blob/master/dbt/macros/cleanup/drop_old_relations.sql
{% macro drop_dbt_cloud_pull_request_schemas() %}
{% set cleanup_query %}
-- CTE to query the snowflake information schema to get all the tables and views in scope for cleanup
WITH
@sungchun12
sungchun12 / cloudSettings
Last active July 8, 2019 21:42
Visual Studio Code Settings Sync Gist
{"lastUpload":"2019-07-08T21:42:32.794Z","extensionVersion":"v3.3.1"}