SQL reference data in Azure Stream Analytics

Copper Contributor

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 belong to before using them as a look up data and pass on to Power BI datasets, but it seems SQL reference input does not support TimeSpan. For a work around, as of now I'm casting it to varchar but I believe reference input should support TimeSpan soon.

3 Replies

@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%...

 

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

 

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

@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.