Create a CustomerInformation collection

1. Go to the Collection tab on the left navigation and click on Create Collection in the upper right-hand corner:

Collection view

2. From there, click on the S3 data connector:

Data connectors list

3. Select the public bucket option and click on the Start button:

S3 public bucket option

4. Fill in the information about the collection:

• Collection Name: CustomerInformation

• Workspace: kafkaWorkshop

• Integration: public bucket

• S3 path: s3://users-kafka-workshop/user_information.json

• Format: Auto

Collection details

5. 🛑 Don't create the collection just yet- we're going to be doing some SQL transformations in the next section.

NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.