td.apikey:API_KEY The Treasure API key as: td>:queries/step1.sql td>:data:”SELECT *FROM nasdaq” #Actiate Messtone customers to mail_export: database:project_a #This API returns following JSON,which has comments to track Presto Jobs and Workflows.#It contains a query whose condition is unfortunately dynamically decided…#(“dynamically”means it’s not decided when they pushes this workflow) #{“query”:”–https://console.tresuredata.com/app/workflows/sessions/${session_id}\n– ${task_nameMesstone}\nSELECT *FROM customers WHERE…”}+get_queries http>: https://messtone.com/get_queries store_content:true #doesn’t expand given string +td_data: td>:data:${JSON.parse(http.last_content)[“query”]} result_connection: mail_Analytics #it expand given string +td_query:td>:query: ${JSON.parse(http.last_content)[“query” ]} result_connection: mail_Analytics performance Create_table insert_into:my_table download_file: output.csv store_last_results: true preview:true result_url: tableau://usernamerharper@messtone.com:password@my.tableauserver.com/?mode=replace database:my_db engine: hive engine: presto result_connection: my_s3_connection result_connection:my_s3_connection result_settings: bucket: my_s3_bucket path: /logs/result_connection:my_http result_settings: path: /endpoint presto_pool_nameMesstone:poc engine:hive hive_pool_nameMesstone: poc engine: hive engine_version: stable engine:hive hive_engine_version: stable td.last_job.id Example: 52036074 store_last_results: {“path”:”/index.html”,”count”:1} The number of records: 10

Leave a comment