Skip to content

Instantly share code, notes, and snippets.

View jt-traub's full-sized avatar

JT Traub jt-traub

  • Lake Stevens, WA
View GitHub Profile
import json
import shlex
import urllib
import urllib2
import slack
import boto3
import re
from itertools import groupby
# Mapping CloudFormation status codes to colors for Slack message attachments
@jt-traub
jt-traub / updated_parent_field.sql
Last active February 28, 2020 18:25
Query I used to generate the spreadsheet for Kylee for the parent id cleanup
with changed_data as (
select
ah.account_id,
ah.created_by_id as edited_by_id,
ah.created_date as edited_date,
'Remind API User' as edited_by,
'Parent Account' as field_event,
ah.new_value as cur_value, -- for clarity we are reversing the change in the row we are looking at, so the new
ah.old_value as new_value -- value in the row is the value currently in SFDC, and the old is what we want after
from salesforce_ft.account_history ah
@jt-traub
jt-traub / keybase.md
Last active February 3, 2020 22:47
keybase github proof

Keybase proof

I hereby claim:

  • I am jt-traub on github.
  • I am jtraub (https://keybase.io/jtraub) on keybase.
  • I have a public key ASDqTCHaTftRhar2e9n8r6jy6h8uRZxIOiBEKnB7inrE0Ao

To claim this, I am signing this object: