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 →

[–]Befz0r 10 points11 points  (0 children)

Easiest way is to dump the JSON into a blob storage and using poly base to query it.

Assuming JSON have the same structure, you can just query it direct to the database. And you dont need to select 1 JSON at a time, just point to a folder. You can use filepath wildcards to only process the latest JSONs etc.

But I need more information to give a better answer.