Amazon S3 or Amazon Simple Storage Service is a service offered by Amazon Web Services that provides object storage through a web service interface.

Kloudio's Amazon S3 integration allows users to easily create reports using file data (only CSV file) from Amazon S3 and run the reports in Google Sheets or Excel.

This article will help you get started with the following:

  1. Create AWS Access ID and Secret Access Key

  2. Create Amazon S3 integration on Kloudio

  3. Create and run your reports

1. Creating AWS Access ID and Secret Access Key

a) Sign in to the AWS Management Console and open the IAM console
b) In the navigation pane, choose 'Users'
c) Choose the name of the user whose access keys you want to create, and then choose the Security credentials tab
d) In the Access keys section, choose Create access key

e) To view the new access key pair, choose 'Show'. You will not have access to the secret access key again after this dialog box closes. Your credentials will look something like this:
Secret access key: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY

2. Create Amazon S3 integration on Kloudio

a) Go to Kloudio Connections and click the button to create a 'New Connection'
b) Click the Setup button under the Amazon S3 icon

c) Enter the Amazon S3 Access key and Secret access key, generated in step a

d) Click 'Next', and the Amazon S3 integration will be created

3. Setup Amazon S3 sync settings

Now it's time to set up your Amazon S3 data sync settings.

This will enable you to sync your Amazon S3 data (CSV file) to the database of your choice. Kloudio will do this on your behalf by invoking AWS APIs based on your configured sync frequency.

Please follow the steps below:

a) Enter Connection name
b) Choose an existing database connection: This is where Kloudio will sync your Amazon S3 data. Once it's synced, it will be available for creating Kloudio reports in builder or SQL mode
c) Choose a schema name where you'd like your data to be synced
d) You can also optionally use Kloudio's data warehouse in case you don't have any data warehouse to sync your data to
e) Add table name, key and bucket name under 'Data Options'

f) Select the Frequency and Interval under 'Sync Schedule'
g) Click 'Save & Sync'

By now the sync should start running. You will get a confirmation once it's completed running.

4. Create Kloudio reports from your Amazon S3 connection

Once the Amazon S3 connection is created and synced, you can create reports.

You can easily create reports using Kloudio's report builder or SQL reports.

Please ensure you select the connection and schema as used in the Amazon S3 connection settings from Step 3.

You can save your report by clicking "Save".

5. Remove Tables from Amazon S3 integration.

In the integration settings page, in the Table options, you can click on 'X' to remove the required table like below.

This will delete the table from the data warehouse.

Feel free to chat with us or drop an email in case you have any questions related to this integration.

Did this answer your question?