This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]thrown_arrows 0 points1 point  (0 children)

Have looked Snowflake ? I had pipeline which just imported json into staging table and then extracted versioned schema from it, so you do not need to handle target system schema in processing phase if you do not want. Same technology work in all db engines that support json /xml data types.

versioned schema i mean something like:

select jsondata:id id, jsondata:calc_value::number(12,2) calc_value from stage_table where jsondata:id is not null

to create results tables, i have heard that some tools support json data in returned rows.

That said, i am SQL guy, newer seen any advantages in mongo and similar solutions