Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

JSON transformations

Any advanced examples for explaining transformations on complex nested JSON data files in Matillion ?

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Sanket,

With Matillion ETL for Redshift you can approach this in three main ways:

  1. During data loading – using Matillion’s Nested Data Load Component
  2. During data loading – using the Athena JDBC driver for example as shown in this article on the AWS Big Data Blog
  3. During data transformation (i.e. after loading) – using Matillion’s Calculator Component using Redshift’s JSON functions on a CHAR or VARCHAR column containing JSON

Best regards,
Ian

Post Your Community Answer

To add an answer please login