Skip to content

Instantly share code, notes, and snippets.

@davidtamaki
davidtamaki / find_replace_dash_element.py
Created December 11, 2020 16:41
Find/replace SQL text in Looker dashboard element ID
import looker_sdk
from looker_sdk import models, error
########## UPDATE THIS ##########
INI_FILE = "looker.ini"
CONNECTION_NAME = "faa"
dashboard_element_id = '123'
old_string = 'old-string'
new_string = 'new-string'
#################################
@davidtamaki
davidtamaki / analyse_listening.py
Created February 6, 2020 13:32
stats on pocketcasts listening
import requests, json, pandas as pd
USERNAME = 'YOUR_EMAIL@WHATEVER.COM'
PW = 'YOUR_PASSWORD'
formdata = {"email": USERNAME, "password": PW, "scope": "webplayer"}
response = requests.post("https://api.pocketcasts.com/user/login", data=formdata)
response.raise_for_status()
token = response.json().get('token')
@davidtamaki
davidtamaki / download_csvs_from_dashboard.py
Created November 25, 2019 16:39
download CSVs from Looker dashboard with dashboard filters as CLI parameters using Looker Python SDK
import sys
import textwrap
from typing import Optional
import exceptions, urllib
from looker_sdk import client, models
import csv
import json
import pprint as pp
sdk = client.setup("../looker.ini")
@davidtamaki
davidtamaki / flamegraph.js
Last active January 29, 2019 17:37
flamegraph
var vis = {
id: 'flamegraph',
label: 'Flamegraph',
options: {
color: {
type: 'string',
label: 'Custom Color',
display: 'color',
},
diameter: {