Introducing The Highly Requested JSON Flattener Transformer Integration

Announcements
1

We have released the new JSON Flattener Transformer Integration, enabling you to convert nested JSON data into individual columns for easier querying and analysis. This integration is particularly useful for handling complex JSON structures in your destination tables, improving query performance and simplifying data storage.

How It Works:

• Automatically flattens JSON fields, adding columns for each JSON key.
• Original JSON fields remain intact.
• Supports official Go plugins that expose JSON schema information.

Getting Started:

  1. Use the JSON Flattener transformer in your CloudQuery spec with your chosen source (e.g., AWS) and destination (e.g., PostgreSQL).
  2. Add jsonflattener to your transformer spec configuration.

For more setup details and configuration examples, visit the JSON Flattener Integration annoucement post. Feedback and questions are welcome!

3 Likes