Support automatic table creation on SQL Azure

[quinvit]

It looks like support AzureSQL well if we create log table manually. Could we adjust script to create log table to support AzureSQL too?

https://i.gyazo.com/fdd7e79b7dd210b255d163126b85044d.png

[MV10]

@quinvit Are you saying the IF NOT EXISTS test fails on Azure SQL?

Azure SQL has other differences that conflict with recent changes to this sink. Easy to validate during configuration, but noting these in case this issue leads to some sort of Azure SQL -specific changes:

• a clustered index is required
• XML column data types not supported

[MV10]

It appears the IF NOT EXISTS syntax should work on Azure SQL (I don't have time to try it right now). This Microsoft quickstart tutorial for Azure SQL has you begin by doing exactly that:

https://docs.microsoft.com/en-us/sql/azure-data-studio/quickstart-sql-database?view=sql-server-2017#create-the-tutorial-database

[ckadluba]

Recently I implemented the Managed Identities for Azure authentication in this sink and while testing it on Azure I also tested the table autocreation. It worked without problems. The service principal has to have the necessary permissions on the database though.

Here are the screenshots from my test. The first one shows the sink configuration, the second one shows the database table that was created by the sink.

#222 (comment)

I'm closing this issue as automatic table creation seems to work with Azure as of today with the sink version 5.4.0-dev-00304.