b-per

# this script requires a github personal access token (PAT) with read repos scope

import requests
import os

s = requests.Session()
GITHUB_API_PAT = os.environ['GITHUB_API_PAT']

def get_releases(repo):

b-per

from urllib.request import Request, urlopen
from urllib import parse
import os
import time
import json

#------------------------------------------------------------------------------
# get environment variables
#------------------------------------------------------------------------------
api_base        = os.getenv('DBT_URL', 'https://cloud.getdbt.com/') # default to multitenant url

b-per

This script could be used locally when someone wants to build models in their own schema while deferring to the Prodcution models and not having the Production manifest file stored locally.

It creates a modified manifest.yml file based on a local one, changing the schema name from the local one to the Production one. The target_name argument is the name of the folder where the new manifest will be created. It defaults to target2 but can be updated

Usage: python build_defer_manifest.py [--target_name TARGET_NAME] dev_schema defer_schema

After having generated the manifest, you can do a dbt run -s <my_model> --defer --state target2

Notes:

b-per

#compdef dbt

# OVERVIEW
#   Adds autocompletion to dbt CLI by:
#       1. Finding the root of the repo (identified by dbt_project.yml
#       2. Parsing target/manifest.json file, extracting valid model selectors
#       3. Doing some bash magic to autocomplete selectors for:
#           -m
#           --model[s]
#           --exclude