Unable to construct the sql url as the password is having special characters.
while using the sqlalchemy, unable to connect with sql server from databricks:user='user@host.mysql.database.azure.com' password='P@test' host="host.mysql.database.azure.com" database = "db" connect_args={'ssl':{'fake_flag_to_enable_tls': True}} conn...
- 2964 Views
- 1 replies
- 0 kudos
Latest Reply
We can use urllib.parse to handle special characters. Here is an example:import urllib.parse user='user@host.mysql.database.azure.com' password=urllib.parse.quote_plus("P@test") host="host.mysql.database.azure.com" database = "db" connect_args={'...
- 0 kudos