sayle-doit

/*
 *  This query will run across an entire organization looking at tables across every project
 *  and shows how they will compare on compressed and uncompressed storage.
 *
 *  Region Notes:
 *  This query will only read from a single region or multi-region at a time. It's
 *  currently not possible to read this data from across all
 *  
 *  By default this reads from the US multi-region, so this might need to be changed if
 *  your data lives elsewhere.

slopp

Dagster Hot Takes

Less On-Call Pages: Retries and Alerts

https://youtu.be/A6WtkMwe4VQ

Getting an on-call page is the worst. Unfortunately most task-based orchestrators page teams frequently, whenever jobs fail. With Dagster you can reduce this alert fatigue by using retry strategies and only getting notified when SLAs are violated.

Resources:

• Star Us: https://github.com/dagster-io/dagster

adityawarmanfw

SELECT event_timestamp,
       user_pseudo_id, 
       (SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'ga_session_id') AS ga_session_id,
       (SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'page_title') AS page_title,
       (ARRAY(SELECT AS STRUCT * FROM UNNEST(event_params) WHERE key NOT IN ('ga_session_id', 'page_title'))) AS rest_of_event_params
  FROM `bigquery-public-data.ga4_obfuscated_sample_ecommerce.events_20210131`
 WHERE event_name = 'page_view'
 LIMIT 1

Hugoberry

{
    "name": "Sparkline Typeface",
    "visualStyles": {
        "pivotTable": {
            "Default": {
                "values": [
                    {   
                        "fontFamily": "Sparks Bar"
                    }
                ]

troyharvey

Using GitHub Actions to run dbt

This example shows you how to use GitHub Actions to run dbt against BigQuery.

1. Follow the instructions on getdbt.com for installing and initializing a dbt project.

2. Copy this action (dbt.yml) into the workflows directory.

    mkdir .github
    mkdir .github/workflows
   

cp ~/Downloads/dbt.yml .github/workflows/

SQLvariant

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

voltek62

library(httr)
library(jsonlite)

# https://dataseolabs.com
# Doc : https://www.similarweb.com/corp/developer/
# Create your key here : https://pro.similarweb.com/#/account/api-management
# You can have freely 3 Months of Web Traffic Data 

# conf
myList <- c("cuisineaz.com","marmiton.org","odelices.com","allrecipes.fr")

jstangroome

#requires -version 2.0
[CmdletBinding()]
param (
    [parameter(Mandatory=$true)]
    [ValidatePattern('\.rptproj$')]
    [ValidateScript({ Test-Path -PathType Leaf -Path $_ })]
    [string]
    $Path,
    
    [parameter(