Transform your data with SQL expressions, now generally available

SQL expressions are now generally available. SQL expressions let you query, join, and reshape the results of your existing data source queries using familiar MySQL-like syntax. Instead of chaining multiple transformations to get your data into the right shape, you can write a single SQL statement that filters, aggregates, and combines results from one or more queries. This is especially powerful when you need to:

• Join data across queries and data sources. Combine results from different queries, even from different data sources, into a single table, subject to the input cell limit.
• Aggregate and filter with SQL. Use GROUP BY, WHERE, ORDER BY, common table expressions (CTEs), and a broad set of SQL functions to shape your data.
• Do more with less setup. Replace long chains of transformations with a single, readable query.

To get started, add a new SQL expression in the query editor and reference your other queries by their RefID.

To learn more, refer to the SQL expressions documentation.