👋Welcome to the Rockset-Confluent workshop
Preface
Workshop Part I: Build a real-time recommendation and other analytical queries
Workshop Part II: Build a customer 360 app on Retool

Powered by GitBook

On this page

Workshop Part I: Build a real-time recommendation and other analytical queries

🧺Populate Rockset collections with Kafka and S3 data

🪄Create collections

Create a CustomerPurchaseActivities collection

PreviousCreate SQL transformations on CustomerClickActivities NextCreate SQL transformations on CustomerPurchaseActivities

Last updated 2 years ago

On the left-side navigation bar, click on the Collections tab.
In the upper right-hand corner, click on the Create Collection button:

3. Click on the Kafka connector:

4. Select the integration we just created, CustomerActivities:

5. Fill in the collection details:

Collection Name: CustomerPurchaseActivities
Workspace: kafkaWorkshop
Integration: CustomerActivities
Kafka Topic: user_purchases
Starting offset: earliest
Format: JSON

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