​
November 2024 - What’s new?

​
✨✨✨ Our NEW RE-DESIGN ✨✨✨

We’re super excited to give you all the details on what exactly has changed, and why. Scroll below to learn more.

​
First, why did we do this?

Our product needs to save you time, make your day-to-day feel much easier, and basically help you become the best, most productive, version of your data-self.

What is shouldn’t be doing is to be VERY slow, painfully rigid, and feel buggy.

But it definitely was doing that.

This was literally the #1 (yes, #1) feedback we got from our customers and users. And if you’re telling us about it over and over again, it makes it THE most important thing we could be doing right now.

So we decided to put an end to this chaos, and do one simple product amazingly well - meaning easy, simple and beautiful. In our wildest dreams, you should have fun using it.

So, we hope you’ll love this new version (at least as much as we do…) and find your happy place while using it 😇

PS - thanks for all the users out there that hopped on calls with us to brainstorm, validate and share their thoughts with us. It means the world to us.

​
The Change(s)

  • UI: Well…. basically everything :)
  • Perfomance, performance, performance - this was the most important thing for us. Your experience should feel flawless. So no more waiting for a query to be created, no more loading between different pages of the product, no more waiting dozens of seconds to simply delete a folder.
  • Queries are much clearer -
    • We understood what’s important to show in preview mode and what isn’t (which we then added to the query profile).
    • The query profile has no-load and easily appears as it pops-up from the bottom of your screen.
  • Folders are finally much more organized -
    • We switched the folder view to be more like any storage app (Google Drive, Notion etc). That means no more one long page of queries in subfolders in folders. Rather we give each folder the respect it deserves with a page of it’s own.
    • You can easily see which users each folder is shared with.
  • The search experience is easy-to-use -
    • Filters are now out in the open - did you know that that you had the ability to filter your search results based on the query date, person, source and more? Probably not, because it was hidden in some kind of (honestly weird) icon. Filters are now visible to all, and even better - you can understand your search results based on the options in each filter. Try it out and let us know what you think :)
  • Removing the clutter (we’re a plugin.. so anything on the screen needs to be chosen carefully) -
    • No more annoying left side panel - it’s now in a simple side menu
    • The history tab also moved to the side menu
    • Public section became a folder
    • And Vuola - you get much more room to emphasize and see the important stuff (like, let’s say, the folders and queries themselves).
  • Creating a new SQL became a whole lot easier with the very straightforward new ‘+’ button (when you think about it, how wasn’t this an option until now?…)
  • And more like: automatically generating a title (which is new) and a description (which isn’t) is now totally up to your choice, editing a query is in the query profile, bug fixes…

So many changes (and we’re sure that you’ll notice some more while using it), all in the hopes of making this product as simple and easy to use as possible.

​
What Didn’t Change

  • Our commitment to our users and customers
  • Our mission of creating once place for everything SQL
  • Our obsession to make every minute count
  • Our office pet

This is still V1 - so we’d absolutely LOVE to hear any thoughts, concerns or feedback you have.

And here’s a sneak peak to what’s up next:

  • Keyboard shortcuts
  • Onboarding
  • Snippets are everywhere
  • Auto-editing from your IDE
  • Git Integration
  • Permissions
  • ERD in product

So.. stay tuned! 😜

​
Previous Updates:

​
Automatically Import and Organize Your Most Common SQL

​
October 22, 2024

We’ll automatically organize your SQL into folders and give each one a title and description.

Try it out here.

​
Create Your Own SQL Greeting

​
October 3, 2024

For the upcoming holidays, we’ve had a bit fun and created a SQL Greeting Generator.

If you’ve missed it out, read about it in our Linkedin Post.

​
We’ve done it again: same search, just better 😎

​
September 27, 2024

Faster, More Accurate, and More Relevant

We’ve changed the infra behind our search engine, so we now show the most relevant results up top.

We also sort them based on your team’s usage and activities, and all this in half of the time!

​
🔗 Turn any SQL into a visual diagram in a click

​
September 3, 2024

Try our new ERD capability to better understand the connections between your tables and fields.

BTW - we’ve built it with cursor.com. Read more on this LinkedIn post to hear our thoughts on building with AI.

​
🔗 Validate your queries by users’ activities

​
August 15, 2024

Now you can easily understand how active is each SQL, so you can be sure to use the most relevant one.

How? Using our new activities capability, for each saved SQL you can see when it was last seen, last used, last edited, by who, and when.

​
🔗 Sharing queries is now easier than ever

​
July 28, 2024

🔗 Sharing queries is now easier than ever You can now share your SQL directly from DataGrip in one click! (Or more specifically - in one keyboard shortcut) All you need to do is: Mark the query that you want to share and type CTRL+SHIFT+T. Enter the user’s email you’d like to share it with, And… that’s it 😊 We automatically create a shared folder with that query for you, and that person will immediately get an email + Slack letting them know that you’ve shared a query with them.

​
📁 Easy Folders Navigation

​
Latest Update:July 16, 2024

Customized Snippets Size: Now, you can drag your snippet to resize it however you like. Adjust your snippets to fit your needs and keep your workspace organized.

Highlighted Search Text: Easily find what you’re searching for and focus on what matters. This feature is compatible with all types of queries, both saved and automated history, ensuring you never miss a detail. It enables quick and focused visualization of information.

​
📁 Team Management & Shared Folders

​
Latest Update:June 15, 2024

The new feature allows you to create a team from existing members, manage it, and share folders with them, not just individually. It’s now easier to share across your relevant team and manage it efficiently. To share with your own team, go to shared folders, select the members you want to create a team with, and click on “Create as Team”. After naming it, you can see it in the “Add from Team” section.

​
📁 Repo: edit title + description in thumbnail view

​
Latest Update:June 4, 2024

After a few feature requests about this - now you can easily edit each query’s title and description directly from the thumbnail view.

In your repo, just click on a query title and edit the new name.

We love these kinds of quick feature requests that help us make your work on Sherloq as easy as possible, so keep them coming!

  • Please notice that for now this is enabled only on new queries created.

​
📁 Repo: copy, share, snippets from thumbnail view

​
Latest Update:May 29, 2024

Now you can copy, share and save to snippets from thumbnail view.

​
📁 Repo: “created by” for folders | 🗄️ Management: Generate description

​
Latest Update:May 9, 2024

Data Management automatically generates table + field description: Now you can generate a description for each table and field, without going over and updating them manually.

Repository “created by” info per folder: hovering over the folder name reveals information about who created each folder, helping with better accountability and tracking.

Use Case: You’d like to ask someone on your team a question about the SQL saved in a specific folder.

​
📁 Repo: New query list view

​
Latest Update:April 30, 2024

New query list view: After many user requests, it’s finally here!

Introducing a shortened list view for queries, improving navigation and usability.

Use Case: A user navigates through the query titles more easily with the improved list view interface.

​
Latest Update:April 8, 2024

Adding commenting to each table and field component and advanced search functionality to the Data Management platform.

Use Case: Users want to add specific comments describing how to use each field and table in the analysis and SQL.

​
📁 Repo: DataGrip Snippets + Web platform

​
Latest Update:March 13, 2024

DataGrip easy query/snippet from IDE: Improved DataGrip plugin to allow easy creation of queries and snippets directly from the IDE.

Use Case: A user creates and saves queries and snippets from DataGrip without needing to switch to the Sherloq interface.

New (and larger) UI for the repository in the web platform.

Use Case: Users looking to work on more complex queries, or for those that aren’t working on their query editor.

​
⭐ Launch: V1 Metadata Management Platform

​
Latest Update:March 5, 2024

Finally it’s here! Our data management platform.

As directors and team leads, you now get to see one place for all company tables and fields. You can also see how your team are using the different components and manage them - creating one source of truth for metadata documentation.

*Supported only on the enterprise plan.

​
📁 Repo: generate SQL descriptions | 🤖 Botson: query history

​
Latest Update:February 14, 2024

Repository - auto-generated description: Introduced auto-generated descriptions for queries to provide quick summaries.

Use Case: Instead of writing each description manually, now we automatically generate a SQL description for you. That means your teammates can quickly understand the purpose of a query in a glance.

Botson query history: You can now ask Botson about any query that you ever ran in your editor, and even better, you can check out your team’s history as well!

Use Case: A user looks for a query they ran last week with one of their teammates as part of a project they’re working on.

​
🤖 Botson: edit questions | 📁 Repo: dock left / right

​
Latest Update:February 1, 2024

Botson edit questions: Botson now allows users to edit any question asked depending on the given result.

Use Case: After asking a question and seeing Botson’s answers, you can add filters to find the exact answer you’re looking for.

Repository - Dock left / right: Users can dock the repository interface to the left or right side of their screen, depending on the exact IDE they’re working on.

​
📁 Repo: comments per version | 🤖 Botson: Tableau calculated fields

​
Latest Update:January 23, 2024

Comments per version: You can now add comments on specific query versions to explain changes done between versions.

Use Case: After adding a “where” statement in the SQL, you’d like to explain to future teammates why it is important and what its purpose is.

Botson Tableau calculated fields: Added support for calculated fields in Tableau.

​
🤖 Botson: dashboards

​
Latest Update:January 16, 2024

Botson dashboards: Ask questions on top of your Tableau dashboards.

Use Case: What is the SQL behind the dashboard? Who created it? When was it last updated?

Metadata integrations for enterprise: Tableau, Redshift.

​
📁 Repo: edit version name + change size

​
Latest Update:December 13, 2023

Repository edit name per version: Users can now edit the names of query versions for better organization.

Use Case: Give each version an indicative name depending on what has been changed, by who and when.

Extension change size: Now you can easily resize the repository extension for longer queries, viewing different versions or more complex analyses.

​
📁 Repo: advanced search | 🤖 Botson: GPT-4 secure env.

​
Latest Update:November 1, 2023

Extended Repository search including rules, tags, and source.

Use Case: Find a query that your teammate saved a month ago, tagged by a specific project and includes the word “client” in the query title.

Botson secure GPT-4 environment: Now you have the functionalities of chat GPT-4, right inside of Botson! And even better - this is a secure and private network so you can use your org’s metadata names and queries.

​
📁 Repo: formatting | 🤖 Botson: WHERE filters

​
Latest Update:October 4, 2023

Repository format queries: Introducing query formatting for easier readability.

Botson supports WHERE clause filters: Now you can ask questions on commonly used WHERE clause filters that are used over and over again in your team.

Use Case: “What do I need to include in the WHERE clause when I query from table ‘users’?”

​
🤖 Watson -> Botson: PARTITION | 📁 Repo: formatting

​
Latest Update:September 27, 2023

Watson -> Botson including partitions: We hear you, and we’ve heard Watson isn’t the best name… to say the least. So we’ve rebranded Watson to Botson ( = Watson Sherlock’s assistant + bot) and added support for query partitions.

Use Case: “What is the partition defined on table ‘users’?”

Repository - minimize extension: Users can now minimize the repository extension so that you don’t ever lose your work while using Sherloq!

​
⭐ Launch: Watson Metadata AI Chatbot

​
Latest Update:September 3, 2023

Super excited to share that we’ve finally launched Watson - your AI Metadata chatbot.

​
📁 Repo: DataGrip plugin + “move” query + dark mode

​
Latest Update:August 24, 2023

DataGrip Plugin LIVE! You asked for it and here it comes! We officially launched the DataGrip plugin, allowing you to interact with Sherloq directly from the IDE.

Repository move between folders: Easily move queries between different folders within the repository.

Use Case: A user reorganizes their queries by moving them into more appropriate folders as projects evolve.

Repository dark mode: for those of you who like it darker (or are just using us on DataGrip :) ).

​
📁 Repo: subfolders

​
Latest Update:July 27, 2023

Repository Subfolders: Introducing subfolders to help organize queries more effectively within the repository.

Use Case: A user creates subfolders for different departments within a main project folder, keeping queries organized.

Integrations: BigQuery, Athena.

​
📁 Repo: CMD + S to save your query + Import queries

​
Latest Update:June 29, 2023

Save from editor: We always look for ways to make your lives easier, so we’ve added the ability to save queries to Sherloq directly from the query editor. Just mark your query in the IDE and type CMD + S (or CTRL for those of you on Windows).

Import queries: You can now easily import existing queries into the repository for easier integration. Just go to the settings page in the repo and upload the file. We’d love to hear if there are any other places you’d like to import your queries from!

​
Latest Update:June 1, 2023

Shared link for folders + queries: You can now generate shareable links for folders and individual queries.

Use Case: A user shares a link to a folder of queries with an external consultant for review.

​
📁 Repo: Tags + Snippets

​
Latest Update:May 26, 2023

Tags: You can now add tags to help categorize and find queries quickly. We also added a few different options for colors to make things pretty, so let us know what you think :)

Use Case: A user tags queries related to sales data between different project folders, making it easier for the sales team to find relevant queries.

Snippets: Introducing snippets! Allowing users to save and reuse common query fragments. Just tick the “save to snippets” checkbox in the query page, and then go to your query editor and type @ @.

Use Case: A user saves a commonly used JOIN clause as a snippet to quickly include in multiple queries