It's Just SQL!

Tailpipe leverages DuckDB to provide a SQL interface to the tables built from the log data you've collected.

Basic SQL

Like most popular databases, DuckDB supports standard SQL syntax. If you know SQL, you already know how to query your logs!

You can query all the columns in a table:

But you may want to limit the number of rows when tables are large:

You can filter rows where columns only have a specific value:

or a range of values:

or match a pattern:

You can filter on multiple columns, joined by and or or:

You can sort your results:

You can sort on multiple columns, ascending or descending:

You can group and use standard aggregate functions. You can count results:

or find min and max:

You can exclude duplicate rows:

or exclude all but one matching row: