Create a CustomerPurchaseActivities collection

1. On the left-side navigation bar, click on the Collections tab.

2. In the upper right-hand corner, click on the Create Collection button:

Collection preview

3. Click on the Kafka connector:

Click on kafka connector

4. Select the integration we just created, CustomerActivities:

Pick integration

5. Fill in the collection details:

• Collection Name: CustomerPurchaseActivities

• Workspace: kafkaWorkshop

• Integration: CustomerActivities

• Kafka Topic: user_purchases

• Starting offset: earliest

• Format: JSON

Collection preview

🛑 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.