John Hammink Jammink2

## gist:172b5ffa320ee4a050e22b4ab92f2b9a
td connector:guess accounts.yml -o account_output.yml

## gist:9c7a33acb19510360bb0873c63b9e1ed
td connector:issue account_output.yml --database sfdc --table account --time-column createddate

## bc_desc_from_SF.sql
select billingcity, description from account limit 100

## gist:a2b789503f332d0495f3a754d202eb21
curl --ipv4 -XGET <external_IP_Address_for Elasticsearch_EC2_instance>:9200/_count

## gist:c091c6584bf399e89d8b03eddc132726
curl --ipv4 -XGET <external_EC2_IP>:9200/_search -d '{
    "query": {
        "match_all": {}
    }
}
'

## gist:895029536e2f6fe9eb652542ba6d5d9d
curl -X GET 'http://<external_EC2_IP>:9200/descriptions_by_city'

## Create DB and Table (generic)
td db:create <database_name>
td table:create <database_name> <table_name>

## webhook post
URL:  http://in.treasuredata.com/postback/v3/event/<database_name>/<table_name>
Payload Type:  Json
Wrap Request in Array: No
Unflatten: yes
Headers:
Content-Type: application/json
X-TD-Write-Key:  <your_Treasure_Data_Write_API_Key>

## query_googledocs
td query -d googledocs "select gsx_userid, gsx_lastname, gsx_streetname, gsx_city, gsx_zip from sheet"

## check_query_results_by_job_ID
td job:show <JOB_ID_NUMBER>
	curl --ipv4 -XGET <external_EC2_IP>:9200/_search -d '{
	"query": {
	"match_all": {}
	}
	}
	'
	td db:create <database_name>
	td table:create <database_name> <table_name>
	URL: http://in.treasuredata.com/postback/v3/event/<database_name>/<table_name>
	Payload Type: Json
	Wrap Request in Array: No
	Unflatten: yes
	Headers:
	Content-Type: application/json
	X-TD-Write-Key: <your_Treasure_Data_Write_API_Key>