I am doing a simple select statement to pull data from a table with one of the column having a pretty long json entry. When I run this query in VScode, that particular column return and empty cell ("[]"). However, I do know that there is data in this column because when I run it in Databricks (using Databricks UI), it returns the data as intended. My data is currently hosted in Databricks and I use VScode and SQLTools to connect to Databricks. I looked over the SQLTools setting and there doesn't seem anything to address this. Could it be a bug?
I am doing a simple select statement to pull data from a table with one of the column having a pretty long json entry. When I run this query in VScode, that particular column return and empty cell ("[]"). However, I do know that there is data in this column because when I run it in Databricks (using Databricks UI), it returns the data as intended. My data is currently hosted in Databricks and I use VScode and SQLTools to connect to Databricks. I looked over the SQLTools setting and there doesn't seem anything to address this. Could it be a bug?