Jeremy Yeo jeremyyeo

dbt Python models cliff notes

Sample dummy models for testing. Golden rule is that python models have to always return a dataframe.

Snowflake

# sf_table.py
import pandas as pd
def model(dbt, session):

Oh my zsh.

Install ZSH.

sudo apt install zsh-autosuggestions zsh-syntax-highlighting zsh

Install Oh my ZSH.

Backup/archive a repo

Clone the repo

git clone --mirror https://github.com/vuejs/vue

cd into the cloned repo
Create a bundle file in the parent directory

git bundle create ../vuejs_vue.bundle --all

Whether you're trying to give back to the open source community or collaborating on your own projects, knowing how to properly fork and generate pull requests is essential. Unfortunately, it's quite easy to make mistakes or not know what you should do when you're initially learning the process. I know that I certainly had considerable initial trouble with it, and I found a lot of the information on GitHub and around the internet to be rather piecemeal and incomplete - part of the process described here, another there, common hangups in a different place, and so on.

In an attempt to coallate this information for myself and others, this short tutorial is what I've found to be fairly standard procedure for creating a fork, doing your work, issuing a pull request, and merging that pull request back into the original project.

Creating a Fork

Just head over to the GitHub page and click the "Fork" button. It's just that simple. Once you've done that, you can use your favorite git client to clone your repo or j

	{% macro trange_join(left_model, left_fields, left_primary_key, right_models) %}
	{#
	This macro allows the user to join two or more snapshot models together on a common
	key, with the result being a unique record for each distinct time range. For example,

	Given left_model:
	\| {{ join_key }} \| left_field \| dbt_valid_from \| dbt_valid_to \|
	\| - \| - \| - \| - \|
	\| k1 \| L1 \| 2020-01-01 \| 2020-01-05 \|
	\| k1 \| L2 \| 2020-01-05 \| 2999-12-31 \|