Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "jtmId":0,
- "name":"DLX",
- "source":{
- "srcId":0,
- "name":"Vertica at Staging",
- "extractor":"File:DLX",
- "driver":"com.vertica.jdbc.Driver",
- "url":"C:\Temp\results.txt",
- "username":"test",
- "password":"test"
- },
- "destination":{
- "destId":0,
- "name":"My S3 bucket",
- "url":"https://net_thumbtack_tapad.s3.amazonaws.com/",
- "username":"",
- "password":"",
- "accessKey":"AKIAJBGTAIDUK7C6BIQA",
- "secretKey":"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",
- },
- "schedule":{
- "schedule":"0 0 12 ? * MON *"
- },
- "processingData":{
- "fileNameTemplate":"tapad-${fireTime?time}-${desc}.txt",
- "fileType":"TSV"
- "extractor":"File:DLX",
- "extractionSQL":"\nselect\n device_id,\n campaign_id,\n date,\n creative_id,\n campaign_id,\n device_id,\n inventory_type,\n platform_id,\n sum(impressions) as impressions,\n sum(clicks) as clicks\nfrom (\nselect\n device_id as shared_id,\n campaign_id,\n date(created_at) as date,\n creative_id,\n campaign_id as segment_id,\n case when action_id = 'impression' then 1 else 0 end as impressions,\n case when action_id = 'click' then 1 else 0 end as clicks,\n device_id,\n 1 as inventory_type,\n platform_id\nfrom taps\nwhere campaign_id = ${campaign_id} and date(created_at) = date('${fireTime?date}')\n) tt\ngroup by 1, 2, 3, 4, 5, 6, 7, 8 order by date desc;\n ",
- "additionalData":"{campaign_id=\"1537\",date=\"2013-10-10\"}",
- "template":{
- "header":"campaign_id\tdate\tdevice_id\tcreative_id\tinventory_type\tplatform_id\timpressions\tclicks",
- "footer":"---footer---",
- "row":"${campaign_id}\t${date}\t${device_id}\t${creative_id}\t${inventory_type}\t${platform_id}\t${impressions}\t${clicks}"
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement