Hi All,
I am trying to use Azure SQL as metedata storage for druid, as there is no native support, I used community extension ( sqlserver-metadata-storage ). It worked fine initially, but when I enable druid-basic-authentication it tries to alter tables and fails.
As I looked into logs, I found alter table or even select queries are fired with mysql dialect and mssql driver is not able to execute the same.
Does anyone did this setup and able to fix the issue, any recommendation is highly appreciated.
Regards,
Rizwan