Product Updates

Introducing low-code: the power of SQL, without writing any

No items found.
Taylor Brownlow
May 1, 2024
May 21, 2024
8 min read
Share this post

After several months of development, we’re excited to announce Count’s new low-code functionality, which gives you the power of SQL joins, calculations, and table creation without a single SELECT statement.

The Count canvas gives data teams unprecedented power to break down complex pieces of analysis, and rapidly explore different approaches, in a non-linear, collaborative canvas.

With today’s release, the experience of exploring data in Count is available to those outside the data team, creating a space where data and business teams can use data to solve the business's biggest problems…together.

Use low-code cells to create new tables from scratch or off an existing analysis. Join your data sources together with a few clicks, and create custom columns and filters with powerful calculations.

Plus, low-code joins and calculations are available on all visual cells, making it faster than ever to dive into results, and explore new trains of thought, for analysts and non-analysts alike.

Low-code cells

Cells are the building blocks of Count. Since you can chain cells together, you can quickly build out complex analysis that still makes sense.

However, up until yesterday to build a cell you needed to be able to write SQL or Python.

Now, with low-code cells, the cell-building experience is open to coders and non-coders alike.

This means when a stakeholder wants to explore an analysis further - maybe by filtering the results, further aggregating the table, or even joining that table to another database table, cell, or CSV file - they can do that without writing a single line of code.

Responsive Video Loop
Creating a low code cell in Count.

Learn more about low code cells here.

No black boxes

We believe data should always be transparent to everyone for it to be trusted. This means you won’t find any black boxes in Count, including in our low-code functionality.

Any low-code cell can be turned into a SQL cell so you can see exactly what code is being generated from that cell.

Responsive Video Loop
Converting a low code cell to a SQL cell.

Calculations for custom columns and filters

We knew that low-code functionality wasn’t just for building tables though. Even the most SQL-savvy users know the feeling when you’re building a visual and don’t just want to plot revenue vs. costs, but to create a new column on the fly for profit (revenue - costs).

These kinds of transformations had to be done in SQL or Python, but now with calculations, you can create columns, visual axes, and filters using arbitrarily complex expressions.

Responsive Video Loop
Low code calculations.

These expressions use a DuckDB-like syntax that works on all databases.

To see some examples of the types of expressions you can build, check out the docs here.

No-code joining with confidence

Being able to join two or more tables together is a significant step in someone’s ability to confidently analyze data. With Count’s no-code joining, that ability is now available to everyone, without having to train the organization on the difference between a LEFT and INNER join.

You can join tables to any visual or low-code cell, and specify the conditions of that join. Count will generate suggested joins for you to speed up the process and help everyone query data with confidence.

Responsive Video Loop
Low code joins.

Learn more about no-code joining here.

How to get started

The canvas is designed to bring data and business teams together to collaboratively solve the biggest challenges.

Whether that means diving into a canvas together to figure out why retention has suddenly dropped, or adopting a more agile approach to building company-wide metric trees, the choice is yours. Our customers are already taking full advantage of this new low-code flexibility to do things like:

  • create custom templates with documentation and helpful info for business users to explore popular views and tables with all the context they need
  • create sandboxes from the company metric tree where people can explore results
  • hold more live sessions in the canvas with analysts and stakeholders

Data teams can’t solve the biggest problems alone. Low code is our way of making sure data isn’t just something you look at once a day in a dashboard but is part of how the entire company operates.