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 II: Build a customer 360 app on Retool
  2. Create a customer 360 app

List all the users who made purchases

PreviousCreate a customer 360 appNextShow specific details of a specific customer

Last updated 2 years ago

1. Populate the search results table in table1:

Action Item: Click on one of the columns on the Search results table. After you’ve clicked on a column, under Data in the navigation bar on the far right, add this-{{GetAllUsers.data.results}}.

You’ll see the table populated by data from the GetAllUsers query resource:

Populate the search table

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