Configure Amazon S3 Outbound Integration

Overview

Staircase AI supports exporting scheduled report data directly to an AWS S3 bucket in CSV format. In addition to email delivery, you can configure an S3 bucket as a destination for your scheduled reports, giving you more flexibility in how you store and access report data. This is particularly useful if your team uses a data lake such as Snowflake or Databricks. You can route Staircase AI customer data directly into your existing data pipeline without any manual extraction.
A key capability of report uploads is the inclusion of a timestamp in the file name, ensuring that new reports do not overwrite existing ones.

Prerequisites

Before configuring the integration in Staircase AI, you need:

• An AWS account with permissions to create S3 buckets and IAM policies.
• An Amazon S3 bucket created and set to private. Note the bucket name, you will need it during configuration.
• Access credentials of an IAM role.

Configure the Amazon S3 Outbound Integration in Staircase AI

To configure the Amazon S3 Outbound integration in Staircase AI:

1. Log in to Staircase.ai
2. Navigate to Settings > Integrations and select the Amazon S3 card. The right pane displays details about the Amazon S3 integration.
3. In the Outbound tab, enter the Bucket name.  This maps the correct bucket to which reports are sent. 
   Note: This step is particularly useful if your team uses a data lake such as Snowflake or Databricks.
   
   
    
4. Click Save to complete the configuration. Once configured, AWS S3 Setting appears as a destination option in your scheduled reports. 
5. (Optional) In the File path field, enter the path within the S3 bucket where you want to export the report. If you do not specify a path, the report is exported to the root level of the bucket. The file path follows this format: [file_path/]{report_name}_{yyyyMMdd_HHmmss}.csv 
   For example: exports/weekly/Customer_Health_20260412_143022.csv