pymssql showing in logs when pyodbc is specified

[wesseljt]

config

  - name: tap-mssql--db
    inherit_from: tap-mssql
    variant: buzzcutnorman
    pip_url: git+https://github.com/BuzzCutNorman/tap-mssql.git
    config:
      dialect: mssql
      driver_type: pyodbc
      database: db1
      user: myuser
      port: 1433
      sqlalchemy_url_query:
        driver: ODBC Driver 17 for SQL Server
        trustServerCertificate: yes
        multiSubnetFailover: yes
      sqlalchemy_eng_params:
        fast_executemany: 'true'

inherit from

  - name: tap-mssql
    variant: buzzcutnorman
    pip_url: git+https://github.com/BuzzCutNorman/tap-mssql.git
    config:
      dialect: mssql
      driver_type: pyodbc
      port: 1433
      sqlalchemy_url_query:
        Driver: ODBC Driver 17 for SQL Server
      sqlalchemy_eng_params:
        fast_executemany: 'true'

[wesseljt]

Error message

2023-10-20T17:57:03.736061Z [info     ] pymssql._pymssql.ProgrammingError: (207, b"Invalid column name 'dt_offset_col'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n") cmd_type=elb consumer=False name=tap-mssql--db producer=True stdio=stderr string_id=tap-mssql--db
2023-10-20T17:57:05.771235Z [info     ] time=2023-10-20 13:57:05 name=target_snowflake level=INFO message=Table db."table1" exists cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake
2023-10-20T17:57:07.507385Z [info     ] time=2023-10-20 13:57:07 name=target_snowflake level=INFO message=Table db."table1" exists cmd_type=elb consumer=True name=target-snowflake producer=False stdio=stderr string_id=target-snowflake

[wesseljt]

aside from the specifics of the error -its weird the error has pymssql in it not pyodbc.

[BuzzCutNorman]

Looking at the error message it is referencing a tap-mssql--db. Would you be able to pass along that tap's config as well.

[wesseljt]

should be that first one in the config above

[BuzzCutNorman]

I was able to replicate the issue. It seems once I remove the pip_url and variant items from the tap-mssql--db config inheritance started to work properly again. If those two config options are present and say driver_type is not in the config since it has a default the default is used which would be pymssql. Please try removing pip_url and variant from tap-mssql--db's config and let me know if things working as expected.