Expand Json filter plugin for Embulk

expand columns having json into multiple columns

Overview

• Plugin type: filter

Configuration

• json_column_name: a column name having json to be expanded (string, required)
• root: root property to start fetching each entries, specify in JsonPath style (string, default: "$.")
• expanded_columns: columns expanded into multiple columns (array of hash, required)
  • name: name of the column. you can define JsonPath style.
  • type: type of the column (see below)
  • format: format of the timestamp if type is timestamp
• keep_expanding_json_column: Not remove the expanding json column from input schema if it's true (false by default)
• stop_on_invalid_record: Stop bulk load transaction if an invalid record is included (false by default)

---

type of the column

name	description
boolean	true or false
long	64-bit signed integers
timestamp	Date and time with nano-seconds precision
double	64-bit floating point numbers
string	Strings

Example

filters:
  - type: expand_json
    json_column_name: json_payload
    root: "$."
    expanded_columns:
      - {name: "phone_numbers", type: string}
      - {name: "app_id", type: long}
      - {name: "point", type: double}
      - {name: "created_at", type: timestamp, format: "%Y-%m-%d"}
      - {name: "profile.anniversary.et", type: string}
      - {name: "profile.anniversary.voluptatem", type: string}
      - {name: "profile.like_words[1]", type: string}
      - {name: "profile.like_words[2]", type: string}
      - {name: "profile.like_words[0]", type: string}

Note

• If the value evaluated by JsonPath is Array or Hash, the value is written as JSON.

Dependencies

• https://github.com/jayway/JsonPath
  • use to evaluate JsonPath
  • Apache License Version 2.0

Build

$ ./gradlew gem  # -t to watch change of files and rebuild continuously

Contributor

• @Civitaspo
• @muga
• @sakama