🚀 October 2023 Product Update: Virtual Query Service, Charts, Navigator, and More

Redesigned Explorer (now called Navigator) New

You can now:

• Drag to resize the Navigator panel to any size that you prefer
• Accommodates long-named data sources, tables, and fields — ready for LLM prompt integrations
• View field attributes beside the field name without hovering
• Fixed multiple bugs with schema refreshes

LLM Data Source - Hugging Face New

You now have the option to add Hugging Face inference endpoints as a data source for testing:

• Question Answering
• Sentence Similarity
• Text Classification
• Zero Shot Classification

Quick Query Action New

You can now click the arrow icon beside any table for a quick SELECT * FROM tableName LIMIT 10 query. If you already have a query open, it will open a new Explore tab.

PostgreSQL DB Support New

PostgreSQL is now a supported database.

QueryLogs & Version History Paging New

In Explore Tabs, you now have paging for both queries and version history.

Charts in Data Result Sets New

You can now create and download charts right from your data set results! You can create column, bar, pie, line, scatter, area, histogram, or combination charts.

Smart Status Bar New

We now help you quickly sum, count, average, and get min/max for any fields you select. This is part of the new Smart Status Bar at the bottom of data set results which also shows the total number of results for your query.

Grouping & Pivot Tables New

No need to download to Sheets or MS Excel. Did you know you can group and pivot right inside runQL?

LLM Prompts Update

Fixed an issue with loading saved LLM Prompts and “save as new” for LLM Prompts.

Plan Limits & Onboarding Update

Cleaned up subscription-level plan limits, onboarding, and sign-in experiences.

Global Query History Update

Fixed an issue for some organizations with displaying Global Query History.

More Charts for Workbooks New

For the orgs that have access to our Workbooks (alpha release) you now have Line, Bar, Area, and Histogram chart options. A workbook chart uses a saved query as its source. If you change the saved query, all charts that use it automatically update.

Basic Explorer Role New

This is an update to add a Basic Explorer role. The Basic Explorer can run existing queries and view results (in workspaces they are invited to) but cannot create, edit, or add others to a workspace. Important for wider rollout plans.

Allowing Pro Explorers to Invite Collaborators New

Pro Explorers (non-admins) can now invite collaborators to a workspace and to the organization.

Permissions Fix for "My Workspace" Update

A permissions fix when a new person is invited to an organization affecting "My Workspace."

runSource Virtual Query Service New

We are super excited to announce the new runSource Virtual Query Service! It was all hands on deck for this feature as we were down to the protocol level to make this work. You know how when you move, you can have the post office automatically forward mail sent to your old address to your new address without having to update your address for everyone? You can now get that same functionality with your SQL queries.

• Have one source of truth for your queries reused across external BI tools like Metabase, PowerBI, etc.
• Shield your external services from underlying query and database changes
• Secure and log access while hiding real database credentials

To make use of this feature click the runSource link below any saved query and it will generate the Virtual Query for your external tool. Documentation can be found in My Account/Documentation.

Explore Page Updates Update

Based on feedback we moved the Explore, Saved, and History links on the Explore page to make more space for the query editor and data results.

Query Editor Updates Update

We are seeing a 34% saved query reuse rate! We optimized the query editor layout to make it even easier to access query suggestions, search, and the Saved Query dropdown.

— The runQL Team