Error: Connect MSSQL read replica with Redash

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.