Configuring Destinations for Data Studio Exports

  • Updated

Data Studio can deliver your generated export in a few ways:

  • Downloadable file (default)
  • SFTP
  • Cloud Storage, available with these services:

Data Studio Overview 01.png

SFTP or Cloud Storage destinations must be configured to be available options for exporting your report from Data Studio. Go to Reports > Data Studio > Destinations (left menu) & use the following information when configuring:

  • HTTPS is required for all connection types.
  • If you are using SFTP to receive Data Studio reports, you must allow this IP range to receive data:
    207.189.124.0/24
    207.189.125.0/24
    54.200.92.142
    54.93.34.201
    54.194.14.170
    35.183.73.63
  • If you export to a subfolder in Dropbox, prepend the subfolder name(s) with a forward slash (/). Example: /aotest
  • If adding Microsoft OneDrive as a destination, you can only connect a personal account. Business accounts are not currently supported.

Amazon S3

To link an Amazon S3 bucket, you need your Secret Key, your Access Key, and the name of your bucket. To get these Keys you will need to create an IAM user within AWS. See the AWS documentation:

Here is an example of the policy that should be attached to the user to allow Data Studio to export to Amazon S3:

{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "s3export",
"Action": [
"s3:PutObject",
"s3:GetObject",
"s3:AbortMultipartUpload",
"s3:GetBucketLocation",
"s3:DeleteObject"
],
"Effect": "Allow",
"Resource": [
"arn:aws:s3:::AWSBUCKETNAME/*",
"arn:aws:s3:::AWSBUCKETNAME"
]
}
]
}

Was this article helpful?

Have more questions? Submit a request