troubleshooting
How to define a SQL table for storing nested JSON data using NATS connector?
I'm using NATS connector to ingest data with a nested JSON structure. How can I define a SQL table to store this nested JSON data? Do I need a schema for this to work?
De
Declan Harrison
Asked on Mar 15, 2024
- You can use the
Struct
type for nested fields when defining the SQL table. - When using RisingWave, you need to choose between providing a schema registry and a SQL defined schema; you can't use both simultaneously.
- RisingWave allows you to select the data that needs to be flattened from the nested structure. More information can be found in the RisingWave documentation.
Mar 15, 2024Edited by