Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Wrangle Summit 2021 On Demand

You can still experience the best people, ideas and technology in data engineering, all in one place

Get All-Access Pass
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

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.

New to Trifacta?

Sign up below to our free 30-day trial to use this template.


Already have an account?

Download template (Trifacta version) and import it on the Flows page.

Is your data on Google Cloud?

  1. Download template (Dataprep version)
  2. Launch Dataprep on Google Cloud
  3. Import it on Flows page

Learn more about Dataprep

How to Import