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

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.

New to Trifacta?

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

SIGN UP FOR FREE TRIAL

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