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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#requires -version 2.0 | |
[CmdletBinding()] | |
param ( | |
[parameter(Mandatory=$true)] | |
[ValidatePattern('\.rptproj$')] | |
[ValidateScript({ Test-Path -PathType Leaf -Path $_ })] | |
[string] | |
$Path, | |
[parameter( |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This example shows you how to use GitHub Actions to run dbt against BigQuery.
-
Follow the instructions on getdbt.com for installing and initializing a dbt project.
-
Copy this action (dbt.yml) into the workflows directory.
mkdir .github mkdir .github/workflows
cp ~/Downloads/dbt.yml .github/workflows/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"name": "Sparkline Typeface", | |
"visualStyles": { | |
"pivotTable": { | |
"Default": { | |
"values": [ | |
{ | |
"fontFamily": "Sparks Bar" | |
} | |
] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
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:
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
* 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. |