Linen
Join Slack
Hello all, Testing tap-mssql and erroring on load (json or csv). It seems to be reading from datab...
# troubleshooting
c
Hello 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.
tap-mssql error log.txt
b
When you run 
meltano invoke tap-mssql
do you get this same error ?
Out 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-csv
c
meltano run in progress
b
Did the meltano run crashed and burn?
c
still 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
Open in Slack
PreviousNext
Powered by

Meltano

Meltano community

Powered by