Composing SQL Formatters

👤 This documentation is intended for SQL Users.

SQL Formatters can be chained together, one after another. For example, to convert a timestamp to Pacific Time and then aggregate by date, query:

select [created_at:pst:date] from users.

Combining this with automatic joins allows for quick, powerful queries such as:

select [users.created_at:pst:date], users.platform, sum(price)
from [purchases+users]
group by 1, 2

In Periscope, this displays revenue by user platform:

Our support team is ready to help