🛠 December 2023 Product Updates

Git Import Update

When there are multiple queries per sql file, we now import each of them into a separate saved query. If the imported query also contains a comment then we now import that as a query description. Along with this we updated the documentation for git imports on the Admin/Documentation page.

• Each SQL statement now imports as a separate saved query
• Query comments are pulled in as descriptions
• Updated Git import documentation for clarity

Attach Database to Workspace Update

Added a UI fix to make "attach a database" to a workspace more visible (like it was before we re-organized the UI). Thanks to JC for pointing out that this was missing.

• Improved visibility of “Attach a database” option
• Restores UX parity from previous UI

Manage Workspace Update

Made all the Workspace admin items more visible when clicking on the menu for Manage Workspaces.

• Improved discoverability of admin actions
• Streamlined access from workspace menus

Adding Connections/Database Change Update

When adding a connection (host/port), specifying a particular database is now required. If there are multiple DBs on the same server then each one will require a separate entry. This is to support more granular security and access for organizations.

• Granular access control per database
• Supports security-first org setups

Confirmation on Delete Statement New

When you run a delete statement you will now get a confirmation prompt... because. :-)

• Prevents accidental destructive queries
• Simple safety net for analysts and devs

Virtual Query Service Update

Fixed an issue with approved queries and the virtual query service.

• Ensures correct approved query execution
• Improved stability for external BI tools

Approved Queries New

Teams now have the capability to mark a query version as approved. This approved query will show up as the top query in saved queries. The approved query is the version that gets used for all queries run through the Virtual Query Service.

• Enables trusted version control for queries
• Integrates with the Virtual Query Service

Result Tabs Memory New

We now keep the column sorting preferences, etc. when changing between result set tabs.

• Preserves grid settings across tabs
• Improves multi-tab data comparison workflows

Inviting Users to Org Update

Multiple updates to invite users to orgs in the admin panel and in a workspace. Also a change to lower.

• Simplified user invitation flows
• Improved reliability of magic link invites

Tags Generation Update

Update to the auto generation of tags for database, tables and columns for saved queries.

• Better tagging for improved searchability
• Enables more accurate content organization

Data Types and Charts Update

Update for data types to display correctly in charts.

• Fixes chart display issues
• Improves accuracy in visualizations

Explore Tab from Saved Query Update

On the saved queries page, if you click "use query" and you already had that query open in an explore tab then the focus would not be set to the tab. This has been fixed.

• Explore tab reuse now preserves context
• Reduces duplicate tab clutter

Plan Limits for AI Queries Update

Plan limits are in place for AI query generation based on the subscription plan.

• Ensures compliance with tiered plans
• Supports upcoming PLG rollout

MS SQL Support New

We now support MS SQL Server in both cloud and local installations. This in preparation for onboarding a company that uses MS SQL and MS Azure SQL.

• Supports hybrid MS SQL + Azure SQL setups
• Expands compatibility with enterprise stacks

Query to Prompt Mapping Library New

We now automatically generate and store a non-technical question that the query answers when you save a query. This is for your organization's reuse library to get trusted answers faster for Frontline Data Professionals and eventually the rest of the organization.

• Auto-mapped natural language summaries
• Improves reuse and discoverability

Keyboard Shortcuts New

Alt or Option + T: creates a new explore tab.
Alt or Option + W: closes an explore tab.
Enter: runs the query.

• Boosts productivity with fast navigation
• Keyboard-friendly experience

Explore Tab, Edit Saved Query Description New

You can now edit the AI generated description right from the explore tab. While editing the description is not often needed, this saves you from having to break out of your workflow to edit it on the saved queries page.

• Inline editing speeds up iteration
• Reduces context switching

Global Saved and Global Query History Update

Speed improvements and pagination.

• Improved performance for large orgs
• Easier navigation of historical queries

Clear Suggestions When a Query is Run Update

Clear the starting block suggestions when a query is run so that the focus is on the data results and the query itself.

• Improves clarity in query experience
• Less visual noise

Plan Limits for Workflows Update

Plan limits are in place for workflows based on the subscription plan.

• Support for PLG pricing strategy
• Controls feature access by tier

— The runQL Team