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

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 (

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
  ),

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

rodrigoborgesdeoliveira

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

0xjac

The repository for the assignment is public and Github does not allow the creation of private forks for public repositories.

The correct way of creating a private frok by duplicating the repo is documented here.

For this assignment the commands are:

1. Create a bare clone of the repository. (This is temporary and will be removed so just do it wherever.)

git clone --bare git@github.com:usi-systems/easytrace.git

kaugesaar

var GeoSearch = function() {
  this.baseUrl = 'https://www.google.se/search?';
  this.pws = true;
  this.lang = 'sv';

  var key = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-_';

  var makeHash = function(loc) {
    loc = loc.toLowerCase().replace(/[åä]/g,'a').replace(/[ö]/g,'o');
    return  'w+CAIQICI' + key[loc.length%key.length] + btoa(loc).replace(/\=/g,'').trim();

cx-shay-shimonov

// ==UserScript==
// @name           Google Search Better Privacy
// @description    Delete unnecessary params and add useful params on Google Search.
// @version        0.0.4
// @include        http://*.google.*/search*
// @include        http://*.google.*/imgres*
// @include        https://*.google.*/search*
// @include        https://*.google.*/imgres*
// @exclude        http://play.google.com/*
// @exclude        http://mail.google.com/*

MurtzaM

//This script prevents Marketo form submission if a user enters non-business email (Gmail, Hotmail, Yahoo, etc.)
//It will work on any page with a Marketo form, and runs when the form is ready 
//For further info, please see Marketo form documentation, http://developers.marketo.com/documentation/websites/forms-2-0/
//Prepared by Ian Taylor and Murtza Manzur on 9/9/2014

<script>
(function (){
  // Please include the email domains you would like to block in this list
  var invalidDomains = ["@gmail.","@yahoo.","@hotmail.","@live.","@aol.","@outlook."];

bsweger

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)