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

Knowledge Drop

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.                

Comments
jeff_c
New Member

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.

Version history
Last update:
‎06-14-2021 06:16 PM
Updated by: