Timeline for Trying to read JSON string using SQL Query and OpenJson
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 21, 2021 at 16:03 | comment | added | AbdulAleem | OK if we know the commonly all number of columns in general in different json strings that we have but not particularly in this json file/string, can we process it at least because we know all the columns used for generating these files. | |
| Jul 16, 2021 at 19:23 | comment | added | ch_g | Technically, yes, it is possible, but will be quite complicated, you will end up writing something like a json parser. The key point here is that you have to know or find out the structure of the source json in order to extract all columns in a flat structure. | |
| Jul 16, 2021 at 7:58 | comment | added | AbdulAleem | Thank you so much, is there anyway to write without mentioning the Column names like Col1 etc, just with generic SQL Statement like * etc or get the column names dynamic way, because the column names are not same or number of columns might change. | |
| Jul 16, 2021 at 1:48 | history | edited | ch_g | CC BY-SA 4.0 |
added 490 characters in body
|
| Jul 16, 2021 at 1:30 | history | answered | ch_g | CC BY-SA 4.0 |