Create a ProductInformation collection

  1. 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: ProductInformation
  • Workspace: kafkaWorkshop
  • Integration: public bucket
  • S3 path: s3://products-kafka-workshop/product_schema_v1.json
  • Format: Auto
Collction 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.