MSSqlServer + JSON

Hello,

I have a MS SQL Server as DataSource. In the Dashboard, I select a JSON string column from the database (Query):

SELECT
[JSON]
FROM
[dbo].[qry_Statistics]

I choose “Format as Table”.

In the visualisation tab, I choose “Table” and as “Table Transform” I choose “JSON Data”, but columns does not show the columns from the JSON data.

Sample JSON data:
{"_id":“AXEL_Wfl-hGp97q9LQQs”,"_type":“log”,"_index":“logs-2020.03.24”,"@message":“Deployed website”,"@timestamp":1585044088747,“tags”:[“deploy”,“website-01”],“description”:“Torkel deployed website”,“coordinates”:{“latitude”:12,“longitude”:121,“level”:{“depth”:3,“coolnes”:“very”}},“long”:“asdsaa asdas dasdas dasdasdas asdaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa asdasdasdasdasdasdas asd”,“unescaped-content”:“breaking
the
row”}

So my question is: How to use MS-SQL with JSON data column?

Best regards

1 Like