Does Stream Analytics support output to SQL Server memory optimized table?

Question

In the book "Mastering Azure Analytics: Architecting in the Cloud" by Zoiner Tejada I found a paragraph stating that memory optimized tables are not yet supported as output by Stream Analytics.

Source to Book Link

As books are not very good in catching up with those dynamic cloud offerings my question is: does this restriction still apply?

Answer 1

You can use memory optimized table from Azure SQL Database as ASA ouput.

Thanks,

JS - Azure Stream Analytics team.

Answer 2

I agree, you can use in-memory tables as outputs for ASA. The only problem is that you may experience primary key or unique contraint violations errors due to the guarantee of at least once delivery (https://msdn.microsoft.com/azure/stream-analytics/reference/event-delivery-guarantees-azure-stream-analytics).