LogoLogo
  • 👋Welcome to the Rockset-Confluent workshop
  • Preface
    • Workshop Introduction
    • 💟Rockset Pairs with Kafka for Real-Time Analytics
    • ⚒️Build a Real-Time Recommendation & Customer 360 Application
    • 👀Workshop pre-reqs
      • Create a user_activity_v1 schema on Mockaroo
      • Create a user_purchases_v1 schema on Mockaroo
      • Getting Started with Confluent Cloud
      • Create 2 Kafka Topics
      • Create Confluent API keys
      • Send data to Kafka
  • Workshop Part I: Build a real-time recommendation and other analytical queries
    • ✏️Rockset account setup
      • 🔑Get Kafka credentials from your email
      • ➿Rockset integration and collection overview
      • ⛏️Create Rockset Account
    • 🧺Populate Rockset collections with Kafka and S3 data
      • 🪄Create a kafka integration
        • Select the Kafka data source
        • Fill in the integration details
      • 🪄Create collections
        • Create a CustomerClickActivities collection
          • Create SQL transformations on CustomerClickActivities
        • Create a CustomerPurchaseActivities collection
          • Create SQL transformations on CustomerPurchaseActivities
        • Create an Aggregate CustomerPurchaseActivities collection
          • Create SQL transformation on AggregateCustomerPurchaseActivities
        • Create a ProductInformation collection
          • Create SQL transformations on ProductInformation
        • Create a CustomerInformation collection
          • Create SQL transformations on CustomerInformation
    • 🖊️Write analytical queries
      • Write a real-time recommendation query
        • Return the customer's last purchase
        • Return the customer's latest activities after their last purchase
        • Find previous purchases that contain the customer's items
        • Aggregate all the purchases
        • Filter results so it doesn't contain the product of interest
        • Identify the product ID with the product name
        • Create a Query Lambda
        • Wrap up on real-time recommendation query
      • Display all users who created an account
        • Create a Query Lambda
        • Wrap up for displaying all users
      • Return a customer's previous purchase
        • Associate the product IDs with the product names
        • Create a Query Lambda
      • Return the total and average customer spend
        • Create a Query Lambda
    • 🗝️Create an API key
    • 🧘‍♀️Analytical query wrap up
  • Workshop Part II: Build a customer 360 app on Retool
    • Create real-time internal tools with Retool
    • Retool account setup
      • Sign up for a free trial
    • Create resource queries
    • Create a customer 360 app
      • List all the users who made purchases
      • Show specific details of a specific customer
      • Show a customer's purchase
      • Show items recommended
      • Show customer's spend
      • Final touch ups
Powered by GitBook
On this page
  1. Workshop Part I: Build a real-time recommendation and other analytical queries
  2. Rockset account setup

Create Rockset Account

Create a Rockset Account. When you create the account, pick us-west-2 as your region. After you create an account, you’re ready to create your first integration with Kafka!

NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.

PreviousRockset integration and collection overviewNextPopulate Rockset collections with Kafka and S3 data

Last updated 2 years ago

✏️
⛏️