The latest updates from Husprey
June 26, 2023
12.56.4
We've been working hard for the past few months to bring you a highly requested feature: the ability to add variables to your queries. And today, we're thrilled to announce that variables are now available to everyone in beta!
So, what exactly are variables? They're your secret weapon for dynamic query customization. With variables, you can easily replace values in your queries using interactive widgets. To get started, simply open the Execution panel on the left side of your notebook, create a variable, and embed it in your SQL code by typing [.c-code]{{variable_name}}[.c-code] in a query.
We offer variables in four types: [.c-code]boolean[.c-code], [.c-code]number[.c-code], [.c-code]string[.c-code], and [.c-code]lists[.c-code] (with single or multiple selections). The best part? List variables can be populated not only from a static list of values provided by you, but also from the results of a local table!
With this update, we're excited to make our notebooks more powerful than ever for data analysts. We'd love to hear your thoughts on this new feature and learn about your specific use cases!