use pymssql replace pyodbc to connect mssql in aws glue #878
Description
Describe the bug
when i use datadiff in aws glue python shell,i can not connect mssql because pyodbc need odbc driver: ODBC Driver 18 for SQL Server ,
but aws glue do not support odbc driver,i hope datadiff can use pymssql to connect mssql .
since pymssql is easier for users to install, can it be turned into a configuration port option?
Make sure to include the following (minus sensitive information):
my scripts:
'''
from data_diff import connect_to_table, diff_tables, disable_tracking
mssql_table1 = connect_to_table(mssql, "table", "id") # mssql is a Connection string
redshift_table2 = connect_to_table(redshift, "table", "id")# redshift is a Connection string
for different_row in diff_tables(mssql_table1, redshift_table2):
plus_or_minus, columns = different_row
print(plus_or_minus, columns)
'''
Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 18 for SQL Server' : file not found (0) (SQLDriverConnect)")
Describe the environment
python 3.9
glue 3.0
datadiff v0.11.1