rodrigoborgesdeoliveira

• Akan:
  • Nyankómàgó
  • Mǎnu
  • Meńsã́
  • Nsĩã́
  • Dúkũ
  • Ɔkwán
  • Nyamékyε
  • Obím̀pέ

mattmc3

layout	author	title	revision	version	description
default	mattmc3	Modern SQL Style Guide	2019-01-17	1.0.1	A guide to writing clean, clear, and consistent SQL.

Modern SQL Style Guide

sanealytics

-- calculate td/idf
create or replace view scratch.v_elt_calculate_tf_idf
as
with
  params as (
    select 3 as MIN_TOK, 
    5 as MAX_RNK,
    CURRENT_DATETIME() as added_ts,
    100 as MIN_TF
  ),

krisjan-oldekamp

-- Author: Krisjan Oldekamp
-- https://stacktonic.com/article/create-a-user-mapping-table-based-on-the-google-analytics-4-big-query-dataset

declare lookback_window int64 default 90; -- how many days to lookback into the dataset to search for ids (compared to today)

-- udf: deduplicate array of struct 
create temp function dedup(arr any type) as ((
    select 
        array_agg(t)
    from (

palewire

How to deploy a Prefect agent to Google Kubernetes Engine

This post contains code and commands you can use to deploy Prefect agents to Google Cloud’s Google Kubernetes Engine. The agents stand ready to execute workflows triggered by Prefect projects. One agent can run tasks from multiple projects.

The example here demonstrates how to create a single agent with minimal customization. It is configured with a Dockerfile, which installs necessary dependencies, and a k8s.cfg file, which connects the system to a Prefect account.

Agents are deployed via the gcloud command-line utility and its kubectl extension. Proper permissions within a project on Google Cloud are required.

Getting started