November 2023 Product Update: Workflows, Starting Block, Git Import & Self-Serve Plans

Import from Git/.sql files New

Organizations can now import their query history from git or .sql files into a workspace in runQL. This can be found in the "Manage Workspace" area. This enables an organization to start using those queries right away and benefit from the powerful query auto suggestions. This will also help provide a low friction onboarding experience to enable organizations to get up and running with zero touch from our side (PLG).

• Import SQL files directly into Saved Queries
• Comments are automatically mapped as descriptions
• Helps teams onboard and activate faster

Payments Self-Serve New

Organizations can now self-serve in upgrading to new plan levels within the platform! This sets the stage for us to soon start testing PLG motions.

• Upgrade your plan from inside the app
• No need to contact sales or support

Query Suggestion Bug Update

Squashed a bug with query suggestions.

Default Explore Tab Update

When a person first goes into a workspace we now ensure that they have a default explore tab so they can start typing queries right away.

Manage Workspace Update

Cleaned up the UI for adding users and data connections in a workspace.

Default DB Source Update

Fixed a bug that was not showing the default DB source at the top of the Navigator.

Demo Workspace & Connection Naming Update

The demo workspace created for each organization is now called WorldDB Exploration.

The demo connection is now called WorldDB Demo.

Workflows New

Workflows allow Frontline Data Professionals to chain multiple queries together from the same or different data sources. Results from one query can feed into the next query or subsequent queries. This helps when working with data from different data sources and also allows data teams to split up those gnarly, long queries that previously required CTEs. This makes understanding and managing queries 10x easier.

• Combine multiple queries across data sources
• Results flow from one step to the next
• Helps simplify, modularize, and document analysis logic

Compare with the Previous Version New

A new option is available to compare a version with a previous version in addition to comparing with the latest version.

Auto Rename Tab to AI Saved Query Name New

When saving a query we now automatically change the explore tab name to the generated AI name given to the query.

runSource Support for Workflows Update

runSource updates now support workflows. Your BI tool can consume the output of a workflow!

Explore Tabs & Data Connections Update

Updated the explore tabs in multi-connection workspaces to handle switching tabs and keeping the appropriate data connection defined for each tab.

Email Signup and Password Reset Update

Updated the UI for email signup and password reset confirmation pages and fixed a bug with the email process.

Navigator Improvements Update

The Navigator panel now shows all schemas for all connections defined in a workspace.

Coming up Next

We believe that AI will augment Data Analysts and Data Scientists (Frontline Data Professionals), helping them evolve from data heroes into data superheroes.

This week we’re focused on the "Starting Block" — an integrated starting point for Frontline Data Professionals to ask AI for a query and also get suggestions from saved queries and query history.

AI Query Suggestions New

You can now ask AI to generate a query for you. Of course we give you the option to edit the AI suggestion before you run it. Trust...

runQL Starting Block New

The new starting block at the top of each query window integrates three previously separate functions into one place enabling quick query generation and reuse. In the starting block you get suggestions from saved queries, query history and the ability to ask AI to generate queries, making it easier and faster to kick off every query in your data exploration journey.

• Combines history, AI, and saved query reuse in one spot
• Increases speed and reduces blank-screen time

Show AI-Generated Query Descriptions in Explore Tab New

Previously in order to see the generated description for a saved query you would have to break out of your workflow and go to the saved queries page. We now show the generated description above the query window when you click save.

Parameters UI Update

Added a UI element to make the option to use parameters more obvious.

Save and Version Status Update

You now see the save and version progress state in the respective buttons, along with a confirmation that the save or version completed successfully.

Query Copy Button Update

Fix for the query copy button on the query window.

Query Title Generation Update

An update to ensure that generated query titles are unique.

— The runQL Team