Knowledge Drop

How can I send data to an S3 bucket via the API?

  • 15 June 2021
  • 1 reply
  • 280 views

Userlevel 3

Last tested: Mar 20, 2018
 

You can send data to an S3 bucket using the Run Scheduled Plan Once endpoint.

You'll need to replace the S3 bucket region, access_key_id, secret_access_key and query_id.

{ 
"scheduled_plan_destination":[
{
"format":"csv",
"apply_formatting":false,
"apply_vis":false,
"address":"s3://bucketname/",
"type":"s3",
"parameters":"{\"region\":\"us-east-1\",\"access_key_id\":\"XXXXXXXX\"}",
"secret_parameters":"{\"secret_access_key\":\"XXXXXXXX\"}"
}
],
"name":"big data s3 upload",
"query_id":<number>,
"run_once":true,
"send_all_results":true
}

 

 

This content is subject to limited support.                

 

 

 

 


1 reply

Does Looker support also including a session token as an optional parameter? This would enable us to use temporary AWS credentials in our API calls.

Reply