jgillies

jgillies / Double_toggle_light.yaml

Created August 24, 2025 00:59

	blueprint:
	name: Double-toggle light → 100% brightness
	description: >
	When a selected light is toggled twice within a short window, set that same
	light to 100% brightness.
	domain: automation
	input:
	target_lights:
	name: Lights to watch
	description: One or more light entities that you physically toggle.

jgillies / double_toggle_to_full.yaml

Created August 23, 2025 00:21

	blueprint:
	name: Double-toggle light → 100% brightness
	description: >
	When a selected light is toggled twice within a short window, set that same
	light to 100% brightness.
	domain: automation
	input:
	target_lights:
	name: Lights to watch
	description: One or more light entities that you physically toggle.

jgillies / custom_source_macro.sql

Created August 9, 2022 19:44

	{#
	This overrides the default source() macro to include the option
	for using BigQuery's time travel functionality. This allows for
	for full refreshes in dev to query a source table at an earlier
	point-in-time, so that subsequent incremental runs can be tested
	in a more realistic manner.
	#}

	{% macro source(source_name, table_name) %}

jgillies / yaml.snippets

Created November 20, 2018 15:38

Vim UltiSnips snippets file for dbt docs

	snippet cols "Creates dbt column documentation" b
	- name: $1
	description: $2
	${3:tests:}
	endsnippet

jgillies / dbt.snippets

Last active February 15, 2019 17:17

Vim UltiSnips snippets file for dbt

	" adapted from https://github.com/fishtown-analytics/atom-dbt/blob/master/snippets/atom-jinja2.cson

	snippet config "dbt config block" b
	\{\{
	config(
	materialized = "$1",
	sort = "$2",
	dist = "$3"
	)
	\}\}