Amazon S3 data lake

Sync data from RudderStack to Amazon S3 Data Lake.

Amazon S3 is a popular object storage service used to store both structured and unstructured data. With S3 data lake, you can easily use the native AWS services for data processing, analytics, machine learning, and more.

info
For more information on how the events are mapped to the tables in S3 data lake tables, see the Warehouse Schema.

Find the open source transformer code for this destination in the GitHub repository.

Setup

warning
Before you set up S3 data lake as a destination in RudderStack, make sure to set up your S3 bucket with the required permissions.
  1. From your RudderStack dashboard, add a source. Then, from the list of destinations, select S3 Data Lake.
  2. Assign a name to the destination and click Continue.

Connection settings

  • S3 Storage Bucket Name: Enter the name of the S3 bucket used to store the data before loading it into the S3 data lake.
  • Register schema on AWS Glue: Turn on this option to register the schema of your incoming data on AWS Glue’s data catalog. For more information on registering your schema in AWS Glue, see the AWS Glue documentation.

    • AWS Glue Region: If the Register schema on AWS Glue setting is turned on, enter your AWS Glue region. For example, for N.Virginia, the AWS Glue region would be us-east-1. For more information on getting your AWS Glue region and the associated service endpoints, see the AWS Glue documentation.
warning

Make sure to grant the following permissions to your AWS Glue instance and the RudderStack IAM role (see Role Based Authentication setting below):

  • glue:CreateTable
  • glue:UpdateTable
  • glue:CreateDatabase
  • glue:GetTables

The following additional permissions are required to use AWS Glue partitions:

  • glue:BatchCreatePartition
  • glue:GetPartition

If you are using AWS Lake Formation for fine-grained access control on the data in your data lake, see AWS Lake Formation permissions for managing the AWS Glue resources on your Lake Formation model.

  • S3 Prefix: If specified, RudderStack creates a folder in the S3 bucket with this name and pushes all data within that folder. For example, s3://<bucket_name>/<prefix>/.
  • Namespace: If specified, all data for the destination will be pushed to the location s3://<bucketName>/<prefix>/rudder-datalake/<namespace>.
info

Note that:

  • If you don’t specify a namespace in the settings, it is set to the source name, by default. You cannot change the namespace later.
  • If Register schema on AWS Glue is turned on, RudderStack creates all table definitions in a database with the name set to this namespace.
warning
It is highly recommended to turn on this setting as the access keys-based authentication method is now deprecated.

If Role-based Authentication is disabled, you need to enter the AWS Access Key ID and AWS Secret Access Key to authorize RudderStack to write to your S3 bucket.

info
In both the role-based and access key-based authentication methods, you need to set a policy specifying the required permissions for RudderStack to write to your S3 bucket. Refer to the Permissions section for more information.
  • Sync Frequency: Specify how often RudderStack should sync the data to your S3 data lake.
  • Sync Starting At: This optional setting lets you specify the particular time of the day (in UTC) when you want RudderStack to sync the data.

Advanced settings

  • Skip User Table: Toggle on this setting to send events exclusively to the identifies table and skip the users table, eliminating the need for a merge operation on the users table.
  • Skip Tracks Table: Toggle on this setting to skip sending events to the tracks table.

S3 bucket setup

  1. Go to your S3 Management console.
  2. Create a new bucket. Alternatively, you can choose an existing bucket.
info
It is recommended to create a new bucket for storing events coming from RudderStack.

S3 Permissions

To send events to your S3 data lake successfully, you need to give RudderStack the necessary permissions to write to your bucket. You can choose any of the following approaches based on your company’s security policies and setup preferences:

Option 1: Use RudderStack IAM role

success
It is highly recommended to use this option for setting up the required S3 bucket permissions.

Use this approach if you are going to set up the S3 destination in RudderStack using Role Based Authentication.

Role based authentication
  1. Create a RudderStack IAM role.
  2. Use the following S3 permissions policy for creating the role:
{
  "Version": "2012-10-17",
  "Statement": [{
    "Sid": "Statement1",
    "Effect": "Allow",
    "Action": [
      "s3:GetObject",
      "s3:PutObject",
      "s3:PutObjectAcl",
      "s3:ListBucket"
    ],
    "Resource": [
      "arn:aws:s3:::<S3_BUCKET_NAME>",
      "arn:aws:s3:::<S3_BUCKET_NAME>/*"
    ]
  }]
}
warning
Replace <S3_BUCKET_NAME> with the actual bucket name.
  1. After creating the role, note and specify the IAM Role ARN to set up your S3 data lake destination.

Option 2: Create IAM user and provide credentials

danger

Note that:

  • Using Role-based Authentication (Option 1) is highly recommended as this method is now deprecated and will be discontinued soon.
  • AWS does not recommend access key credentials-based authentication.

Use this approach if you are going to set up the S3 data lake destination in RudderStack using the Access Key Based Authentication.

Access key based authentication
  1. Log in to your Amazon AWS IAM Console.
  2. Create an IAM user. Choose a policy that has write access to your bucket. Alternatively, you can create a new policy with the following permissions and attach it to the IAM user:
{
  "Version": "2012-10-17",
  "Statement": [{
    "Sid": "Statement1",
    "Effect": "Allow",
    "Action": [
      "s3:GetObject",
      "s3:PutObject",
      "s3:PutObjectAcl",
      "s3:ListBucket"
    ],
    "Resource": [
      "arn:aws:s3:::<S3_BUCKET_NAME>",
      "arn:aws:s3:::<S3_BUCKET_NAME>/*"
    ]
  }]
}
warning
Replace <S3_BUCKET_NAME> with the actual bucket name.
  1. Return to the IAM dashboard and go to Users under Access management. Then, click on the newly-created user.
  2. Go to the Security credentials tab and scroll down to Access keys.
  3. Click Create access key, select the use case as per your requirement, and click Next.
  4. If required, set the Description tag value, and click Create access key.
  5. Note and secure the Access key and Secret access key. Use these credentials to set up your S3 data lake destination in RudderStack.

Find data in S3 data lake

RudderStack converts your events into Apache Parquet files and stores them into the configured S3 bucket. Before storing the events, RudderStack groups them by the event name based on the UTC time they were received.

The folder structure is shown below:

s3://<bucketName>/<prefix>/rudder-datalake/<namespace>/<tableName>/YYYY/MM/DD/HH

As mentioned in the Connection settings section:

  • prefix: This is the S3 prefix in the destination settings. If not specified, RudderStack will omit this value.
  • namespace: The namespace specified in the destination settings. If not specified, RudderStack sets this field to the source name by default.
  • tableName: RudderStack sets this to the event name.
  • YYYY, MM, DD, and HH are replaced by actual time values. A combination of these values represents the UTC time.

Use case

Suppose RudderStack tracks the following two events:

Event nameTimestamp
Product Purchased"2019-10-12T08:40:50.52Z" UTC
Cart Viewed"2019-11-12T09:34:50.52Z" UTC

RudderStack converts these events into Parquet files and dumps them into the following folders:

Event nameFolder location
Product Purchaseds3://<bucketName>/<prefix>/rudder-datalake/<namespace>/product_purchased/2019/10/12/08
Cart Vieweds3://<bucketName>/<prefix>/rudder-datalake/<namespace>/cart_viewed/2019/11/12/09
info
If you have the Register schema on AWS Glue setting toggled on, RudderStack creates all table definitions in a database with the name set to the Namespace specified in the dashboard settings.

Create table definitions using a crawler

warning
Refer to this section only if you haven’t toggled on the Register Schema on AWS Glue setting while configuring the S3 data lake destination in RudderStack.

In the absence of AWS Glue, you can create a crawler to go through your data and create table definitions out of it. To do so, follow these steps:

  1. Go to your AWS Glue console and select Crawler from the left pane.
  2. Select Add Crawler.
  3. Specify a name for your crawler and click Next:
Add Crawler
  1. Next, under the Crawler source type section, choose Data stores.
Crawler source type
  1. Configure the Repeat crawls of S3 data stores based on your requirement.
  2. Then, under the Data store section, select S3 from the dropdown for the Choose a data store setting:
Choose a data store
  1. For the Crawl data in setting, choose Specified path in my account.
  2. In the Include path setting, enter the S3 URI of your configured bucket followed by the suffix /<prefix>/rudder-datalake/<namespace>/.
info
If your S3 bucket name is testBucket and the configured prefix and namespace are testPrefix and testNameSpace respectively, then your path should be: s3://testBucket/testPrefix/rudder-datalake/testNameSpace/
warning
If you have not configured any prefix while setting up the S3 data lake destination in RudderStack, omit the prefix. The path would then be: s3://testBucket/rudder-datalake/testNameSpace/.
  1. Then, under the Add another data store setting, select No:
Add another data store
  1. In the IAM Role section, configure a suitable IAM role.
IAM Role
  1. In the Schedule section, select the frequency of your crawler from the dropdown options:
Scheduler
  1. In the Output section, configure the database that stores all tables. Under the Grouping behavior for S3 data section, turn on the Create a single schema for each S3 path option:
Output
  1. Specify the Table level as 5 or 4 (refer to the tips below). This value indicates the absolute level of the table location in the bucket.
warning

Since all tables are created in the path s3://testBucket/<prefix>/rudder-datalake/<namespace>/, make sure the table level is set to:

  • 5: If a prefix is configured.
  • 4: If a prefix is not configured.
info
The level for the top-level folder is 1. For example, for the path mydataset/a/b, if the level is set to 3, the table will be created at the location mydataset/a/b. Similarly, if the level is set to 2, the table will be created at the location mydataset/a.
  1. Review your crawler configuration and click Finish to confirm.
Review crawler configuration
  1. Finally, click your crawler and run it. Wait for the process to finish - you should see some tables created in your configured database.

Query data using AWS Athena

You can query your S3 data using a tool like AWS Athena which lets you run SQL queries on S3.

warning
Before querying your data on S3, make sure that you have sent some data to S3 and the sync is complete.

Follow these steps to start querying your data on s3:

  1. Open your AWS Athena console. Then, go to the same AWS region which was used while configuring AWS Glue.
  2. In the left pane, select AwsDataCatalog as your data source:
AwsDataCatalog
  1. Select your configured namespace (or the database you specified while configuring the crawler) from the database dropdown menu.
Database
info
By default, RudderStack sets the namespace to your source name if it is not explicitly specified in the destination settings.
  1. You should see some tables already created under the Tables section in the left pane.
  2. You can preview the data by clicking on the three dots next to the table and selecting the Preview Data option. Alternatively, you can run your own SQL queries in the workspace on the right:
Preview Data

IPs to be allowlisted

To enable network access to RudderStack, allowlist the following RudderStack IPs depending on your region and RudderStack Cloud plan:

Plan
Region
US
EU
Free, Starter, and Growth
  • 3.216.35.97
  • 18.214.35.254
  • 23.20.96.9
  • 34.198.90.241
  • 34.211.241.254
  • 52.38.160.231
  • 54.147.40.62
  • 3.123.104.182
  • 3.125.132.33
  • 18.198.90.215
  • 18.196.167.201
Enterprise
  • 3.216.35.97
  • 34.198.90.241
  • 44.236.60.231
  • 54.147.40.62
  • 100.20.239.77
  • 3.66.99.198
  • 3.64.201.167
  • 3.123.104.182
  • 3.125.132.33
info
All the outbound traffic is routed through these RudderStack IPs.

AWS Lake Formation permissions

AWS Lake Formation lets you have fine-grained access control for the data in your lake. You can use the Lake Formation permissions model to manage your existing AWS Glue data catalog objects and data locations in Amazon S3.

To maintain backward compatibility with AWS Glue, Lake Formation has the Super permission for the IAMAllowedPrincipals group on all the existing AWS Glue data catalog resources.

The following sections contain the necessary permissions that you need to assign for the configured IAM role if you have edited the default Lake Formation security settings so that:

  • The IAM role does not have the data lake administrator permissions, or
  • The IAMAllowedPrincipals group does not have the default permissions to create or access the Glue resources.
info
Make sure Register schema on AWS Glue is enabled in the RudderStack dashboard for these settings to take effect.

Database creator permissions

  1. Log in to your AWS management console and go to Lake Formation settings.
  2. Under Administration, go to Administrative roles and tasks.
  3. Under Database creators, add the configured IAM role.
Database creators in AWS Lake Formation

Data location permissions

Data location permissions in Lake Formation enable you to create and alter the data catalog resources that point to a specific S3 location. These permissions work in addition to the Lake Formation permissions to secure the data in your data lake.

This section assumes a data location is registered for your AWS Lake Formation.

Database creators in AWS Lake Formation

To provide the data location permissions for the configured IAM role, follow these steps:

  1. Under Permissions, click Data locations.
  2. Add the configured IAM role to grant permissions to the storage location.
Database creators in AWS Lake Formation

Resource access permissions

  1. Go to Permissions > Data lake permissions.
  2. Grant the following access permissions for either IAMAllowedPrincipals or the configured IAM role.
  • CREATE_TABLE granted on DATABASE resource.
  • ALTER granted on TABLE resource.
  • DESCRIBE granted on TABLE resource.

See Granting and revoking permissions on Data Catalog resources for more information.

Troubleshooting

The following table lists the possible permissions-related errors you might encounter while setting up the S3 data lake destination and their solutions:

Verification stepErrorSolution
Verifying Create SchemaAccessDeniedException: Insufficient Lake Formation permission(s): Required Create Database on CatalogProvide database creator permissions for the configured IAM role.
Verifying Create and Alter Tablecreate table: AccessDeniedException: Insufficient Lake Formation permission(s) on s3://path/you/have/configuredProvide data location permissions for the configured IAM role.
Verifying Create and Alter Tablecreate table: AccessDeniedException: Insufficient Lake Formation permission(s): Required Create Table on xxxProvide resource access for the configured IAM role.

FAQ

For a comprehensive FAQ list, refer to the Warehouse FAQ guide.


Questions? Contact us by email or on Slack