Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
 
All Templates

Work with Time Series Data with Flexible Granularity

Time series data parsing from timestamp Flow The flow view of this template

Extract or compute data values at different granularity of times with time series data

Transformations:
datetime functions (unixtimeformat), array and object functions (listif, unnest)

This template shows how you can work with time series data that’s expressed in timestamp format and identify last value at a lower granularity (milliseconds) when rolled up to a higher granularity (seconds).

It makes use of several array functions such as listif and unnest. This technique can be reused to work with any other time series data when you wish to extract or compute values at different granularity levels.

USE IN TRIFACTA USE IN DATAPREP

New user?

Use the buttons above and start your 30-day free trial. If your data is mostly on Google Cloud Platform, please use Dataprep. Otherwise, choose Trifacta.

Learn more about Dataprep