Forum Discussion

Copper Contributor

Jun 25, 2019

SQL reference data in Azure Stream Analytics

I have a column with Time as Data type in my SQL Server table which is being used as a reference data in Azure Stream Analytics. What I'm doing is cast the values in the same data type which they bel...

AndyZ_ASA

Former Employee

Jul 01, 2019

anishXsharma Please take a look at the current supported types in ASA:

https://docs.microsoft.com/en-us/stream-analytics-query/data-types-azure-stream-analytics?toc=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fstream-analytics%2FTOC.json&bc=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fbread%2Ftoc.json

Could 'DateTime' be used as an alternative in your case?

anishXsharma

Copper Contributor

Jul 02, 2019

AndyZ_ASA I think the best solution should be to support TimeSpan data type in Azure Stream Analytics, so that the Power BI reports can be created without altering or converting the field to the desired output.

As of now rather than converting it to a DateTime, I have converted it to a nvarchar(max). The fields are dynamic so I don't want any individual manipulations to happen.