Kloudio's S3 integration allows users to easily create reports from file data.

The following article will help you get started:

Step 1 : Go to Kloudio Data Flows and Click on Add a Flow button to create a New Data Flow.

Step 2 : Select the Required Data Warehouse and Click on Next button.

Note: On selecting Use Kloudio's Data warehouse check box, Kloudio’s Default Data Warehouse gets selected or you can create and select your own Data Warehouse

Step 3 : Select S3 from the Data Sources List.

Step 4: On Selecting the Data Source, Corresponding Popup window gets displayed, Enter the following details:

  • Name of Connection : Enter the unique name for the Connection

  • Schema: Enter the Schema Name

  • Table Name : Enter the Table Name associated with your account

  • S3 Bucket Configuration :

    • Bucket Id : Enter the Bucket Id associated with your account

    • AWS Access Key ID (optional) : Enter AWS Access Key ID associated with your account

    • AWS Secret Access Key (optional) : Enter AWS Secret Access key associated with your account

    • Path Prefix (optional) : Enter the Path Prefix associated with your account

    • Path Pattern (optional) : Enter the Path Pattern associated with your account

  • File Format Configuration :

    • File Type (optional) : Select the File Type (CSV or Parquet)

    • Delimiter (optional) : Enter the Delimiter

    • Quote Character (optional) : Enter the Quote Character

    • Escape Character (optional) : Enter the Escape Character

    • Encoding (optional) : Enter the Encoding Type

  • Frequency : Select the desired Sync Frequency and Click on Continue button.

Step 5 : On Selecting Continue button, List of tables to sync gets displayed.

Select the desired tables to Sync and click on Continue button.

Step 6 : Once all the connection tests are passed, You will be redirected to the Data Flow List Screen, where Sync Job status Success gets displayed on successful sync.

Step 7 : Once the S3 connection is created successfully, you will be able to create Reports using that Data Flows.

To Create a New report, Go to Reports tab and click on New Report.

Once the Report Type window is displayed, click on the Report Builder option.

Step 8 : Finally Select the above created dataflow connection, schema, table, columns and Click on Preview Button to get the Data Preview of the Reports.

Did this answer your question?