Create a CustomerClickActivities collection

  1. 1.
    After you created and saved the integration, click on the button in the upper right-hand corner, Create Collection from Integration:
2. Input the collection details [red boxes]:
  • Collection Name: CustomerClickActivities
  • Workspace: kafkaWorkshop
  • Integration: CustomerActivities
  • Kafka Topic: user_activity
  • Starting offset: earliest
  • Format: JSON
You’ll see the source preview [blue box] on the far right; this is the preview of the Kafka data.
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.