John Hammink Jammink2
This file contains hidden or 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 gsx_userid, gsx_lastname, gsx_streetname, gsx_city, gsx_zip from sheet |
Jammink2
/ TD CLI Query from textfile
Created
April 18, 2016 20:49
This file contains hidden or 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
| td query -d googledocs -q query.txt |
Jammink2
/ gist:6bbaa21b2ab69ba2886901c3d80e0d38
Created
April 30, 2016 00:46
This file contains hidden or 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 TD_TIME_FORMAT(time, 'yyyy-MM-dd HH:mm:ss', 'JST') AS DATE, * FROM adjust_table WHERE td_time_range(time, '2016-04-29', '2016-04-30','JST') |
Jammink2
/ zendesk_seed.yml
Created
May 6, 2016 22:28
This file contains hidden or 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
| in: | |
| type: zendesk | |
| login_url: https://<YOUR_DOMAIN_NAME>.zendesk.com | |
| auth_method: token # Your Zendesk auth method | |
| username: <YOUR_EMAIL_ADDRESS> # Your Zendesk Login Email Address | |
| token: <YOUR_API_TOKEN> # Your Zendesk API Token | |
| target: tickets # Zendesk Object to import | |
| out: | |
| mode: append |
Jammink2
/ create DB (Zendesk) and 'guess' the data format for the incoming data.
Created
May 6, 2016 22:46
This file contains hidden or 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
| td database:create zendesk && td connector:guess zendesk_seed.yml -o zendesk_ticket.yml |
Jammink2
/ zendesk_ticket.yml
Created
May 6, 2016 23:08
This file contains hidden or 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
| --- | |
| in: | |
| type: zendesk | |
| login_url: https://<YOUR_DOMAIN_NAME>.zendesk.com | |
| auth_method: token | |
| username: <YOUR_EMAIL_ADDRESS> | |
| token: <YOUR_API_TOKEN> | |
| target: tickets | |
| start_time: "2010-04-01 00:00:00+0000" | |
| incremental: true |
Jammink2
/ preview and ingest initial Zendesk ticket
Created
May 6, 2016 23:20
This file contains hidden or 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
| td connector:preview zendesk_ticket.yml && td connector:issue zendesk_ticket.yml --database zendesk --table tickets --time-column updated_at --auto-create-table |
Jammink2
/ gist:4a228e796a096049d99eed415e62a3ab
Created
May 6, 2016 23:45
Schedule Loading Data into Zendesk
This file contains hidden or 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
| td connector:create daily_zendesk_tickets_import "0 1 * * *" zendesk tickets zendesk_ticket.yml -t 'Asia/Tokyo' |
Jammink2
/ salesforce_seed.yml
Created
May 7, 2016 00:03
This file contains hidden or 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
| in: | |
| type: sfdc | |
| username: "USERNAME" # your username | |
| password: "PASSWORD" # your password | |
| security_token: "SECURITY_TOKEN" # your Security Token | |
| client_id: "CLIENT_ID" # your app's consumer key | |
| client_secret: "CLIENT_SECRET" # your app's consumer secret | |
| login_url: https://login.salesforce.com/ # test.salesforce.com for sandbox | |
| incremental: false # 'full dump', see Scheduled execution below | |
| target: Account # Salesforce Object you want to import |
Jammink2
/ support_analytics.sql
Created
May 7, 2016 00:41
This file contains hidden or 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
| WITH sfdc AS ( | |
| -- Get whole Salesforce Information (This table is replaced every data) | |
| SELECT | |
| backendid__c as account_id, | |
| subscription_status__c as subscription, | |
| estimated_mrr__c as mrr, | |
| region__c as region | |
| FROM sfdc.raw_account | |
| WHERE backendid__c is not null | |
| ), |