title: Application Insights and Azure Stream Analytics Query export the whole custom dimensions as string
body: <p>I have setup a continuous export from Application Insights into Blog. With a data stream I'm able to get out the JSON files into SQL DB. So far so good.
  Also with help from Phani Rahul Sivalenka I'm able to query the individual properties of custom dimensions as described here: <a href="https://stackoverflow.com/questions/31193274/application-insights-and-azure-stream-analytics-query-a-custom-json-property/43660424#43660424">Application Insights and Azure Stream Analytics Query a custom JSON property</a></p>
  
  <p>My custom dimensions looks like this when exporting manually into CSV file:
  <code>"{""OperatingSystemVersion"":""10.0.18362.418"",""OperatingSystem"":""WINDOWS"",""RuntimePlatform"":""UWP"",""Manufacturer"":""LENOVO"",""ScreenHeight"":""696"",""IsSimulator"":""False"",""ScreenWidth"":""1366"",""Language"":""it"",""IsTablet"":""False"",""Model"":""LENOVO_BI_IDEAPAD4Q_BU_idea_FM_""}"</code></p>
  
  <p>Additionally to the single columns I like to have the whole custom dimensions as a string in a SQL Table column (varchar(max)).
  In the "Test results" of my Data Stream Output Query I see the column as formated above - but when really exporting / wrinting into SQL DB all my tests ended having only the value "Array" or "Record" as value in my SQL Table column.</p>
  
  <p>What do I have to do in the Data Stream Query to get the whole custom dimensions value as a string and I'm able to write this into SQL Table as a whole string?</p>