I am trying to establish connectivity between MSSQL Server read replica with Redash but getting connection error and it requires to set the property ApplicationIntent=ReadOnly.
See the snapshot:
I am not sure how to set this property in Redash. Please advice.