Introduction
Collaborative data analysis leveraging real-time insights requires a harmonious convergence of diverse perspectives and expertise.
Together, we’ve connected information engineers, information architects, engineering leaders, machine learning teams, and product managers across diverse projects to deliver on Rockset’s guarantee of fast query execution for modern data. We not only collaborate with clients on analytics projects, but also utilize our own products daily and engage in collaborative efforts across internal teams. To simplify the process of sharing queries and results within a company, we’re introducing a seamless and enjoyable method for collaborating with colleagues at Rockset, starting with a beta feature that makes it easy to share queries and their outputs with anyone.
Public Question Lambdas
Rockset’s named and parameterized Question Lambdas are executable SQL queries that can be accessed through a dedicated REST API endpoint. Customers are allowed to store numerous SQL queries as distinct sources, which can then be utilized within production functions. Lambdas are a valuable addition to your arsenal, enabling you to execute complex queries seamlessly across platforms such as APIs, command lines, Node.js, and Python – making them an extremely effective way to consolidate queries within software applications?
The utility of Question Lambdas has unfolded in intriguing and unforeseen ways. Due to the popularity of using Question Lambdas for collaborative query iteration, we introduced version control to simplify tracking and auditing changes made with these features. To facilitate seamless collaboration among team members, we introduced the “Copy Inside Hyperlink” feature, enabling the effortless sharing and transfer of SQL code within the same group. Right now, we’re simplifying sharing further with the launch of our Public Question Lambda (PQL), designed to make information-sharing seamless.
What Can They Do?
A Public Question Lambda is an endpoint that enables instant dissemination of query results to anyone, directly from their browser, without the need for an API key or membership in a Rockset group. Public lambda functions process dwell data queries and deliver lead results in a structured JSON format. We have successfully printed a publicly available model using one of our established pattern datasets. Test it out!
Save a public question as a custom Question Lambda, then navigate to the Question Lambda tab through the left navigation panel. When you click on the Lambda console, navigate to the question node and select “Make public” from the dropdown menu.
From this point on, you’ll be able to copy a link to the endpoint, where each request will trigger the execution of the query and yield results.
Why did we construct this? Here are some potential uses for Public Question Lambdas that we’ve conceptualized:
Question outcomes are essential metrics that provide insights into the effectiveness of a company’s decision-making processes. By tracking and analyzing these metrics, organizations can gain valuable insights into which questions yield the most productive results, allowing them to refine their inquiry approach over time. Moreover, understanding the efficiency of question outcomes enables companies to allocate resources more effectively, ensuring that efforts are focused on the most promising areas for growth.
Utilization of Rockset capabilities grows consistently across companies within a corporate landscape. Despite this, new groups keen to explore the product’s potential eagerly seek a live demonstration before delving into the Rockset console. Stakeholders seeking to rapidly convey the benefits of utilizing Lambda functions can now leverage Public Question LAMBDA as a swift means of showcasing its capacity for executing SQL JOINs on complex, nested JSON data structures, thereby facilitating a deeper understanding of this technology’s capabilities in a concise manner?
Restricted Third-party entry
One significant benefit of Public Question Lambdas lies in their ability for third-party entities to access specific datasets, thereby enabling users to manipulate the data as they see fit. To date, this blog has focused primarily on visualizing query results within a browser. However, you can also execute a PQL from the command line or within an application. We observe that this concept has significant potential to facilitate effective collaborations between private and public entities (for instance, The Centers for Disease Control and Prevention (CDC) shares insights with the wider analytical community without requiring manual uploads of CSV files or replacing data in Google Sheets.
Limitations
To prevent potential abuse and unintended usage of Public Query Lambdas, we are temporarily restricting access to these features exclusively for authorized Rockset administrators. To ensure optimal performance and prevent excessive resource utilization, we are capping Public Question Lambdas at a rate of five queries per second. Unfortunately, our current implementation does not support parameterized queries.
Transferring Ahead
If public question lambdas are showcased in their current form, we have several enhancements that we’d like to introduce, including support for parameters, granular role-based entry controls, social sharing capabilities, and more? What’s more, we’re considering allowing Public Lambda clients to modify their SQL queries directly?
Our aspiration remains to be astonished once again by the innovative and creative applications our customers devise for this feature. Are Public Question Lambdas a valuable tool for simplifying complex code and making it more readable? What do you think would make this venture even more remarkable and lasting in your eyes? Are you leveraging the power of Public Question Lambdas to streamline collaboration with your teammates? We would be delighted to hear from you. Get in contact at dwyer@rockset.com. Model new to Rockset? Sign up today to receive a complimentary $300 in free trial credit.
