Amazon Simple Storage Service (Amazon S3) provides developers and IT teams with secure, durable, and highly-scalable cloud storage. This article will give you an overview of the Amazon S3 integration.
WHAT TO EXPECT
Here are some things that you can expect with the Amazon S3 integration.
- Connecting: Choosing a Bucket. When you are connecting to Amazon S3, the auth page has an optional field where you can specify the bucket. The bucket is the folder where the file is hosted. It is not required, but may be helpful.
- One sheet per dataset. For Excel-based files, you can select 1 sheet at a time. So if you have an Excel doc with multiple sheets, you need to create a dataset for each sheet.
- Uniquely Named Headers. If there isn’t a unique column header in your chart, we can’t add the data to your dataset.
- Make sure your sheets are formatted correctly. Find some helpful tips on spreadsheet formatting in Grow here.
- File Size Limits. Most files must be smaller than 15 MB in order to successfully pull them into Grow. Under some extenuating circumstances, our support teams can make exceptions for Box files up to 50 MB. You can learn more here.
- Supported File Formats: XLS, XLSX, XLSM, and CSV. If you're looking to use JSON or XML files, Grow can pull those in, but we suggest converting to a CSV first.
Amazon S3 is an integration similar to FTP/SFTP in that it has no set endpoints. Instead, when you connect to Amazon S3, you will be able to pull in the folders and reports you have saved there. Any time your files in Amazon S3 are updated, Grow will automatically update the metrics built on them.
Questions about Amazon S3? Chat in on the site and we’ll be happy to help.