Azure Powershell - Test Stream analytics job refererence input

DeeplyGrow 21 Reputation points
2020-09-23T10:03:53.897+00:00

Hi,

I'm trying to test Stream analytics job inputs and outputs from Powershell (it is part of release pipeline). Everything is fine unless I come across an input of type "reference" (eg. SQL database). I'm using command Test-AzStreamAnalyticsInput.

It immediately returns "false" and in Stream Analytics job Activity log I can see error: 

Operation name: Test Stream Analytics Job Input  
Time stamp: xxx  
Event initiated by: xxx  
Error code: BadRequest  
Message: Feature or property 'SQL reference data' is not supported in API version 2016-03-01. Please use API version 2019-06-01.  
  
SQL Database is available as a Reference input source in API version 2019-06-01 and newer. Serialization and compression properties do not apply to this input source.

On the other hand, reference input test from Azure Portal GUI works fine. I did some research but I'm lost where and how to set the API version using Powershell, so I can test all inputs without failure.

Thanks.

Best Regards.

Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
354 questions
Accepted answer
  1. HimanshuSinha-msft 19,476 Reputation points Microsoft Employee
    2020-09-25T18:36:12.38+00:00

    Hello @DeeplyGrow ,

    I just heared back from the the internal team and they did confimred that they are aware of the fact the Test-AzStreamAnalyticsInput does not work with referenced input . At this time they do not have the a time line as to when this will be released .

    I have added the ask on the feedback forum : https://feedback.azure.com/forums/270577-stream-analytics/suggestions/41485447-azure-powershell-test-azstreamanalyticsinput-no

    Thanks
    Himanshu

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. DeeplyGrow 21 Reputation points
    2020-09-28T06:38:38.227+00:00

    Thanks for your response and time.

    Is there any alternative way to test reference input (eg. check if reference resource is existing and is running)?

    Thanks.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.