question

DeeplyGrow-1834 avatar image
DeeplyGrow-1834 asked ·

Azure Powershell - Test Stream analytics job refererence input

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
1 comment
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @DeeplyGrow-1834 ,

Thanks for the ask and for using the forum .
I do not see a way to pass the API version to the cmdlet , i am reaching out to the internal to get help on this .

Thanks
Himanshu

1 Vote 1 · ·
HimanshuSinha-MSFT avatar image
HimanshuSinha-MSFT answered ·

Hello @DeeplyGrow-1834 ,

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

Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DeeplyGrow-1834 avatar image
DeeplyGrow-1834 answered ·

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.

1 comment Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DeeplyGrow-1834,

Thanks for your response. Unfortunately there is no alternate with Azure Powershell. Azure Stream Analytics product team has recently released an update to the preview version of SDK in various languages that should have support for SQL reference inputs which you could try.

But, I would highly encourage you to please up-vote and comment on the above feature request suggestion shared by Himanshu, which would help to increase the priority of the feature implementation.

Hope this helps.

Thank you


1 Vote 1 · ·