Sherloq Changelog

πŸ†• Latest Update:

July 16, 2024 | πŸ“

Easy Folders Navigation Type folder names to filter and find relevant folders and sub-folders easily. This feature makes searching easy, saving you time and hassle.

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.

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.Β 

See it on action!

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.

Β 

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

  • 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.

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.

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.

  • 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.

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.

  • 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 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: 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.
  • 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 is it important and what’s it’s purpose.
  • Botson Tableau calculated fields: Added support for calculated fields in Tableau.
  • 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
  • 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 to resize the repository extension for longer queries, viewing different versions or more complex analyses.
  • Extended Repository search including rules, tags, and source.
    • Use Case: Find a query that your teamate 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 orgs metadata names and queries.
  • 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 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!

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

You can think of Watson like ChatGPT for your company’s internal metadata, so you can ask questions like: where should I query from if I’m looking for company revenue?” or “who was the last person the used table “users”?.

In the upcoming weeks we’ll add more capabilities for specific use-cases and support different types of questions, so stay tuned!

  • Supported only on the enterprise plan.
  • 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 πŸ™‚ )
  • 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
  • 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!
  • 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.
  • 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.
  • Shared folders: you can now create folders that are shared only with specific people from your team or company. Just create a new folder and type in that user’s name.
  • Comments per query: You can now easily create comments for each saved query, to add specific notes or feedback.
    • Use case: add the link to a Tableau dashboard.

πŸŽ‰ Introducing Sherloq: Revolutionizing SQL Collaboration! πŸš€

Hey everyone,

We’re beyond excited to introduce Sherloq, the ultimate collaborative repository for SQL users.Β 

After extensive development and testing (thanks to our design partners!), we’re thrilled to finally share Sherloq with you all.Β 

Our mission? To help SQL users focus on what really matters – analyzing data and creating insights, without the chaos of tracking down and managing queries.

🌟 What is Sherloq?

Sherloq is a game-changer for SQL users, designed to eliminate the headaches of disorganized queries and inefficient collaboration. It’s all about bringing order and ease to your SQL work, making your data-driven tasks smoother and more productive.

We’ve all been there:

  • Lost Queries: Struggling to remember where you saved that one critical query.
  • Slack Overload: Constantly asking in Slack channels for updated queries.
  • Endless Search: Scrolling through numerous files to find a specific query.

 🎁 Key Features

πŸ—‚οΈ Create + Share Folders
Organize your queries into specific folders and share them effortlessly with your team. Keep everything structured and easily accessible.

Β πŸ“ Create + Share Queries
Quickly create and share queries with your colleagues. No more digging through endless files or Slack messages – just share directly from Sherloq.

πŸ“œ History + Company Queries
Access a comprehensive history of all queries across your organization. Ensure you’re always using the most up-to-date versions and quickly find past queries.

Β πŸ•’ Version Control
Track changes with version control for your SQL. Collaborate without the fear of overwriting someone else’s work and easily revert to previous versions when needed.

Β 

Why Sherloq?

Sherloq tackles these issues head-on.Β 

It’s organized yet flexible, sits on top of your IDE without requiring any integration, and is perfect for both data experts and beginners.

Β 

We can’t wait to see how Sherloq transforms your SQL workflow. Your feedback, questions, and comments are invaluable to us, and our team is here and eager to hear from you.

Thank you for joining us on this exciting journey!

Happy Querying! πŸŽ‰

The Sherloq Team

Need Integration?

Try Sherloq for free