After our successful pre-aggregations workshop in August, the Cube community got together again for a hands-on workshop on multitenancy. We want to thank everyone who attended the workshop and also actively participated with your questions and followed the hands-on lab to setup multitenancy in Cube. If you missed the workshop, you can watch the recording on our YouTube channel and download the slides.

We also want to thank everyone who completed the post-event survey and again, I'm heartened that many people were willing to spend the time to share your feedback. Your feedback not only let us know how we did with the multitenancy workshop, but will also help guide our future events. Hopefully you'll receive your thank you gifts soon! 😊

Multitenancy Workshop Recap

About half of the registrants didn't have experience with multitenancy in Cube, so we spent the first part of the workshop discussing key multitenancy concepts (for both front-end and back-end) in Cube and different configuration options for multitenancy. As we did for the pre-aggregations workshop, we then used Cube Cloud as a lab environment for the attendees to get hands-on experience in setting up multitenancy.

We covered the following three scenarios during the lab session:

  1. Filtering queries per tenant using queryRewrite.
  2. In multiple databases, using contextToAppId to tell which tenant is making the current request and scheduledRefreshContexts for building pre-aggregations for all tenants.
  3. Tenant-specific schema and dynamic scheduledRefreshContexts

During the hands-on session, you also got a glimpse of how key Cube features such as pre-aggregations support multitenancy. Although Cube Cloud was used as it provides a convenient environment for the lab, all features discussed during the workshop are available in the open source version of Cube.

If you missed the hands-on lab, you can find the code and our front-end app that were used during the workshop in the multitenancy workshop directory in the Cube.js repo.

Finally, there was a quick review of multitenancy resources that are available for the community including our documentation and the growing recipes. If you have any questions or suggestions for improving our documentation or recipes, please feel free to start a discussion on Slack.

Next: Data Modeling Workshop in January

Based on the community feedback on post-event surveys for the first two workshops, our next workshop topic will be Data Modeling and it will take place on January 19, 2022! The registration for the Data Modeling workshop is now open, so please feel free to sign up for events today. 🚀

As with previous workshops, we have a few optional survey questions in the registration form (including topics you want to see addressed). We encourage you to answer these questions to help ensure that we cover the topics you care about.

We hope to see many of you on January 19!