Write Azure stream analytics output to Azure Tables

Question

I want to write stream analytics output to Azure Tabale. I wrote below query for it:

Select * into azuretable from datasource;

But I cannot see data in table. Any pointers?

Pritam · Accepted Answer · 2016-05-28 22:19:10Z

2

I figured it out. Problem was in the values of partition key and row keys values. These values should be exists in your data model, in my case should be part of input of stream analytics. For example, if we put Row Key = Time and Partition Key = RecordId then Time and RecordId should be valid properties present in input data model.

answered May 28, 2016 at 22:19

Pritam

1,4105 gold badges26 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vignesh Chandramohan Over a year ago

Yes, it should exist. If you would like to skip events that don't have those properties, then you can set output error policy to be true. Events which are bad will be skipped.

Pritam Over a year ago

Just found an article this stuff clearly !! simple-talk.com/cloud/cloud-data/…

Collectives™ on Stack Overflow

Write Azure stream analytics output to Azure Tables

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related