Back

Product

Document flattening

An opt-in table setting flattens nested JSON document fields into destination columns, with an optional maximum depth.

Artie can now flatten nested JSON document fields into destination columns with an opt-in table setting. Configure flattening, including an optional maximum depth, from a table's Advanced settings. Arrays and non-object values retain their original shape.

Why this matters

  • Query nested document data without a separate downstream transformation
  • Control how deeply nested objects are flattened
  • Preserve arrays and other non-object values as-is
Document flattening docs