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

Prepare Event Log Data to Publish into a Data Warehouse

Event log analysis Flow The flow view of this template

Clean and structure transformations from data stored in JSON format

Transformations:
unnest (json parsing), splitpatterns, rename, replace, filtering (delete, keep), aggregation (groupby, count)

This example flow shows you how to parse and clean application log files or events that might be stored in JSON format. The main types of transformations used in this flow are cleansing and structuring transformations.

This flow comes with detailed annotation of each step in the recipe as well as flow level descriptions for all the recipes. Once you understand the logic, you can customize this flow to jumpstart your own development or share it with others in your workspace.

There is a sample dataset that is loaded automatically for you when you use this template. It contains different event attributes all nested under a single JSON object. This is a very common format for many applications and tools, as well as data returned from API calls.

There are several different recipes that structure and cleanse the event data, and a final aggregation example to show how you can track events per user.

Fore more information, please check out this detailed guide in Trifacta’s Help Center.

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