Forums/Official GoodData/Integration with Third Party Services

Amazon S3 Bucket Integration

Ray Light
posted this on October 02, 2009 14:26

People have asked if it is possible to automatically retrieve data stored in an Amazon S3 bucket (such as logs) and load it automatically into Good Data. The answer is a qualified (but loud) Yes! :-)

In order to set this up, Good Data needs full permissions on the files in question. Since Amazon does not allow automatic inheritance of permissions in a specified bucket, we recommend creation of a new S3 account solely for storing the data files. Procedures to set this up are as follows:

  1. Create a new S3 account. This account should only be for storing data files.
  2. Create a bucket in your new S3 account
    • Please use ONLY lowercase letters and NO underscores ("_") in your S3 bucket name
    • Copy your new S3 account's Access Key and Secret Key, along with the bucket name, into a text file (https://aws-portal.amazon.com/gp/aws/developer/account/index.html?ie=UTF8&action=access-key)
    • Put this text file into the bucket you just created in this step, and change the ACLs on the file to give FULL_CONTROL to [Good Data account info] (this is the email address of the Good Data S3 account which we will provide upon request)
    • Also give FULL_CONTROL access to this bucket to both the MAIN account email address (your original S3 account) and to [Good Data account info]
  3. Once this is successfully set up, you can begin putting your data files into this bucket (in CSV or zipped CSV format), and Good Data will periodically retrieve and load the data into your project.

Note: Good Data will automatically load the data contained in this S3 bucket only after pre-arranged agreement. We would need to know what data we are loading (ie, via a sample with appropriate column headers) and also that all files conform to the sample.

For more information, please feel free to contact us at:

Support email: support@gooddata.com
Support phone: (415) 200-0194
Other Inquiries: info@gooddata.com

 

 

Comments

User photo
Ajay Dawar

Ray

This is awesome. What about databases running in the Amazon cloud?

--Ajay D.

July 16, 2010 10:13.
User photo
Ray Light
GoodData

Hi Ajay,

 

We'd be happy to work with you to meet your use case requirements. Please contact info@gooddata.com and we'd be happy to discuss your use case and see what we can do for you.


Thanks,
Ray 

July 19, 2010 01:44.
User photo
Steve Wilhelm

Is there any way to export data from our S3 buckets to GoodData without having to give GoodData full control access to our S3 bucket?

October 12, 2010 16:39.