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?

AndyZ_ASA

Former Employee

Jul 01, 2019

anishXsharma If I didn't understand your question correctly could you also paste a snippet of your ASA query section and sql reference query?