Describe the bug
Can't connect to my sql server from databricks.
To Reproduce
Install sqlalchemy and sqlalchemy-jdbcapi
Build your connection string as per below (to a MS SQL Server):
jdbcUrl = f"jdbcapi+jdbc:sqlserver://{jdbcHostname}:{jdbcPort};database={jdbcDatabase};user={username};password={password};loginTimeout=30;"
Execute engine = create_engine(jdbcUrl)
Error: Could not parse SQLAlchemy URL from string:...
Expected behavior
Engine should be created
Setup information
OS: Azure Databricks
Browser Chrome
Version Databricks Runtime 11.3 LTS
Additional context
Let me know if you need more details. Is there anything wrongwith my connection string? What environment variables do I need to specify? (I have already specified the JDBC_DRIVER_PATH)
Describe the bug Can't connect to my sql server from databricks.
To Reproduce
jdbcUrl = f"jdbcapi+jdbc:sqlserver://{jdbcHostname}:{jdbcPort};database={jdbcDatabase};user={username};password={password};loginTimeout=30;"engine = create_engine(jdbcUrl)Could not parse SQLAlchemy URL from string:...Expected behavior Engine should be created
Setup information
Additional context Let me know if you need more details. Is there anything wrongwith my connection string? What environment variables do I need to specify? (I have already specified the JDBC_DRIVER_PATH)