Create a ProductInformation 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: 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.