Rex Gibson RexGibson
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
| foo | |
| bar | |
| biz | |
| baff | |
| bang! |
RexGibson
/ looker_log_jsonify.py
Last active
June 15, 2017 15:50
— forked from frank-kutzey/looker_log_jsonify.py
converts looker logs from plain text log to json like format - usefull for importing logs to EBK or ELK
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
| #!/usr/bin/env python | |
| from json import dumps | |
| import sys | |
| while True: | |
| string = sys.stdin.readline() | |
| if not string: | |
| break |
RexGibson
/ gist:a0b5bdcfeaa75789bb62284829d97e29
Created
April 29, 2016 15:29
— forked from mikekaminsky/gist:3daf5f9ab2901ec5149964bbe32e8aa8
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
| CREATE OR REPLACE FUNCTION kaplan_meier(text) | |
| RETURNS TABLE ( | |
| time_period int, | |
| pivot text, | |
| exposed int, | |
| events int, | |
| marginal_probability double precision, | |
| cumulative_probability double precision | |
| ) AS | |
| $PROC$ |
RexGibson
/ custom_table_info.view.lookml
Created
March 10, 2015 08:17
Looker Redshift Management Model
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
| - view: custom_table_colmn_info | |
| derived_table: | |
| sql: | | |
| SELECT | |
| a.schemaname | |
| , b.table_name | |
| , b.ordinal_position | |
| , b.column_name | |
| , REPLACE(b.udt_name, 'bpchar', 'char') data_type | |
| , character_maximum_length data_length |
RexGibson
/ How to install Scala 2.10 homebrew
Last active
August 29, 2015 14:16
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
| # to install the latest stable version: | |
| brew install scala --with-docs | |
| # to install scala-2.10: | |
| brew install https://raw.github.com/gist/4340744/scala.rb --with-docs | |
| # to switch versions (from https://github.com/mxcl/homebrew/wiki/External-Commands): | |
| brew switch scala 2.9.2 | |
| brew switch scala 2.10.0 | |
RexGibson
/ GoogleSpreadsheets.py
Last active
August 29, 2015 14:07
— forked from cspickert/GoogleSpreadsheets.py
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
| #!/usr/bin/python | |
| import re, urllib, urllib2 | |
| class Spreadsheet(object): | |
| def __init__(self, key): | |
| super(Spreadsheet, self).__init__() | |
| self.key = key | |
| class Client(object): |
RexGibson
/ link_numpy_scipy_to_virtual_env.sh
Last active
August 29, 2015 14:01
Link Numpy and Scipy to a virtual env
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
| #!/bin/bash | |
| set -e | |
| if [[ -z $1 ]] | |
| then | |
| echo "must supply virtualenvname" | |
| exit 128 | |
| fi | |
| # This lists the packages to link from the system site packages | |
| PACKAGES_TO_INSTALL=(numpy scipy) |
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
| # remove this comment and save file in ~/.azkabanrc | |
| [DEFAULT] | |
| user = | |
| session_id = | |
| [vagrant] | |
| url = https://localhost:8443 | |
| user = azkaban | |
| session_id = 3b25ac47-a791-4648-8434-bcbc737e4ba5 |
RexGibson
/ gist:4627739
Last active
December 11, 2015 16:28
WEEK and YEARWEEK SQL Functions with dates to understand how different formats display
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 YEARWEEK('2012-1-1', 0) '2012-1-1' | |
| , YEARWEEK('2012-12-30', 0) '2012-12-30' | |
| , YEARWEEK('2012-12-31', 0) '2012-12-31' | |
| , YEARWEEK('2013-1-1', 0) '2013-1-1' | |
| , YEARWEEK('2013-1-5', 0) '2013-1-5' | |
| , YEARWEEK('2013-1-6', 0) '2013-1-6' | |
| , 0 type | |
| UNION | |
| SELECT YEARWEEK('2012-1-1', 1) '2012-1-1' | |
| , YEARWEEK('2012-12-30', 1) '2012-12-30' |