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)