Sam Chapin sbchapin

Why

Service developers like to INSERT INTO ... VALUES (...).
Snowflake doesn't like to INSERT INTO ... VALUES (...).

Most folks dont know or care about differences in OLTP and OLAP.

So, paste this gist to a service developer to give them options. Even when Snowflake hurts them with nested objects/arrays in the schema, this gets them past those roadbumps, compensating for Snowflake's lackluster documentation.

Turn 20000ms of compile time and 500ms execution time for 500 rows...

ADR-0000: Use Markdown Architectural Decision Records

Context and Problem Statement

We want to record decisions made in this project independent whether decisions concern the architecture or the code.

Which format and structure should these project records follow?

Decision

Trunk-based

Given a main branch used in a trunk-based development strategy, here is how semantic release can fit in:

%%{init: { 
    'logLevel': 'debug',
    'theme': 'default' , 
    'themeVariables': {
        'git0': '#777',

	<#
	.SYNOPSIS
	Displays a Windows Toast notification with a custom title and message.

	.DESCRIPTION
	This script creates and shows a Windows Toast notification using the Windows.UI.Notifications API.
	It allows customization of the notification title, message, and the application ID used for the toast.
	If JSON is piped into the script, the JSON values are preferred over the -Title and -Message parameters.

	.PARAMETER Title

	with

	-- Establish some test cases with expected outputs.
	-- Note that this is the extent of the testing.
	-- No claims are made to complete correctness for the full range of numbers - only for the following tests is it guaranteed.
	test_cases as (
	select
	num,
	description,
	expected_output

	# VSCode: use the Metals BSP plugin to integrate - https://marketplace.visualstudio.com/items?itemName=scalameta.metals
	# IntelliJ: use the built-in support with scalafmt - https://www.jetbrains.com/help/idea/work-with-scala-formatter.html

	# Required:
	version = "3.5.3"
	runner.dialect = scala213

	# Optional:
	style = defaultWithAlign # Align pattern matching statements, variable decls, function defs, adjacent symbols, etc...
	maxColumn = 120 # Monitors of the 20th century rejoice