Hello all,
Testing tap-mssql and erroring on load...
# troubleshootingc
Chris Jones
04/01/2024, 8:24 PMHello all,
Testing tap-mssql and erroring on load (json or csv). It seems to be reading from database but erroring after that. Config is:
plugins:
extractors:
- name: tap-mssql
variant: buzzcutnorman
pip_url: git+https://github.com/BuzzCutNorman/tap-mssql.git
config:
dialect: mssql
driver_type: pyodbc
host: hostname
port: 1433
database: dbname
user: username
sqlalchemy_url_query:
driver: ODBC Driver 18 for SQL Server
TrustServerCertificate: yes
authentication: ActiveDirectoryIntegrated
start_date: 2024-01-01
select:
- dbo-t_Time.TimeKey
Error log is attached. Any guidance is much appreciated.
b
BuzzCutNorman
04/01/2024, 8:48 PMWhen you run
meltano invoke tap-mssqlBuzzCutNorman
04/01/2024, 9:21 PMOut of curiosity give this a try. Don't worry about the error you will see when you run the pip command.
Copy code
meltano install --clean
.\.meltano\extractors\tap-mssql\venv\Scripts\activate
pip install --upgrade singer-sdk==0.36.1
deactivate
meltano run tap-mssql target-csvc
Chris Jones
04/01/2024, 9:29 PMmeltano run in progress
b
BuzzCutNorman
04/01/2024, 9:38 PMDid the meltano run crashed and burn?
c
Chris Jones
04/01/2024, 9:39 PMstill running. It's a pretty big table. Not sure if the error is possibly related to record count or if I should try to reproduce with a smaller table and maybe save some time
👍 2
4 Views