astro-sdk icon indicating copy to clipboard operation
astro-sdk copied to clipboard

Published 20 hours ago • verified publisher icon astronomer

Cannot connect to SQL Server

Open kollerp opened this issue 2 years ago • 1 comments

Describe the bug We are unable to to connect to a locally hosted SQL Server with connection metadata registered in the Airflow UI. source = aql.Table(name=TABLE_NAME, conn_id=CONNECTION_ID) fails with:

File "src/pymssql/_pymssql.pyx", line 593, in pymssql._pymssql.connect standard_task_runner.py:104} ERROR - Failed to execute job 55 for task export_to_file (connect() got an unexpected keyword argument 'extra'; 508)

Version

  • Astro: 1.7.0
  • pymssql 2.2.10
  • OS: Ubuntu
  • We are running the cloud composer airflow environment locally provided by Google.

kollerp avatar Nov 20 '23 10:11 kollerp

Can you share how your sqlserver connection is being configured in Airflow please?

phanikumv avatar Nov 24 '23 11:11 phanikumv