I have a colleague trying to setup Meltano on thei...
# troubleshootinga
andrew_stewart
11/10/2021, 6:34 PMI have a colleague trying to setup Meltano on their windows machine and it looks like there is no sqilte installed for Meltano to write to (for the metadatabase). I know next to nothing about windows… is this common? Is there an analog of
brew install sqlite3t
taylor
11/10/2021, 7:15 PM@visch do you have any insight by chance?
v
visch
11/10/2021, 7:21 PM Copy code
PS C:\code\sandbox> meltano init meltanotestwindows
Created meltanotestwindows
Creating project files...
Created meltanotestwindows/meltano.yml
Created meltanotestwindows/README.md
Created meltanotestwindows/requirements.txt
Created meltanotestwindows/.gitignore
Created meltanotestwindows/model\.gitkeep
Created meltanotestwindows/extract\.gitkeep
Created meltanotestwindows/load\.gitkeep
Created meltanotestwindows/transform\.gitkeep
Created meltanotestwindows/analyze\.gitkeep
Created meltanotestwindows/notebook\.gitkeep
Created meltanotestwindows/orchestrate\.gitkeep
Creating system database...
[2021-11-10 14:19:39,320] [8108|MainThread|alembic.runtime.migration] [INFO] Context impl SQLiteImpl.
[2021-11-10 14:19:39,321] [8108|MainThread|alembic.runtime.migration] [INFO] Will assume non-transactional DDL.
Upgrading database to d135f52a6f49
[2021-11-10 14:19:39,332] [8108|MainThread|alembic.runtime.migration] [INFO] Context impl SQLiteImpl.
[2021-11-10 14:19:39,332] [8108|MainThread|alembic.runtime.migration] [INFO] Will assume non-transactional DDL.
[2021-11-10 14:19:39,344] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade -> b4c05e463b53, Create meltano.core base tables
[2021-11-10 14:19:39,351] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade b4c05e463b53 -> 6ef30ab7b8e5, Create meltano.api tables
[2021-11-10 14:19:39,363] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 6ef30ab7b8e5 -> 53e97221d99f, Add run_id to Job
[2021-11-10 14:19:39,370] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 53e97221d99f -> a3e2b0a4937d, add_login_audit_columns
[2021-11-10 14:19:39,375] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade a3e2b0a4937d -> 990c0665f3ce, ensure user.login_count default value
[2021-11-10 14:19:39,378] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 990c0665f3ce -> ceb00d7ff3bd, Create the EmbedToken table
[2021-11-10 14:19:39,382] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade ceb00d7ff3bd -> 23ea52e6d784, add resource type to embed token
[2021-11-10 14:19:39,387] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 23ea52e6d784 -> 87d9638f6ac6, Add Subscription
[2021-11-10 14:19:39,391] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 87d9638f6ac6 -> 367228df6a43, Add 'trigger' to Job
[2021-11-10 14:19:39,394] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade 367228df6a43 -> e4fbabc3fed6, add last activity at column
[2021-11-10 14:19:39,397] [8108|MainThread|alembic.runtime.migration] [INFO] Running upgrade e4fbabc3fed6 -> d135f52a6f49, Add `last_heartbeat_at` column to `job` table.
Project meltanotestwindows has been created.
Next steps:
cd meltanotestwindows
Visit <https://meltano.com/> to learn where to go from here
> Meltano sends anonymous usage data that helps improve the product.
> You can opt-out for new, existing, or all projects.visch
11/10/2021, 7:21 PM Copy code
PS C:\code\sandbox\meltanotestwindows> cd .\.meltano\
PS C:\code\sandbox\meltanotestwindows\.meltano> ls
Directory: C:\code\sandbox\meltanotestwindows\.meltano
Mode LastWriteTime Length Name
---- ------------- ------ ----
d---- 11/10/2021 2:19 PM run
-a--- 11/10/2021 2:19 PM 53 analytics.json
-a--- 11/10/2021 2:19 PM 77824 meltano.db
PS C:\code\sandbox\meltanotestwindows\.meltano>visch
11/10/2021, 7:21 PMLooks good to me!
visch
11/10/2021, 7:22 PMWhere I've had this happen is when I clone someone's meltano repo, I tend to just copy a new meltano.db to the .meltano dir
e
edgar_ramirez_mondragon
11/10/2021, 7:32 PMYou should be able to verify that sqlite is installed (and which version) with
Copy code
python3 -c 'import sqlite3; print(sqlite3.version, sqlite3.sqlite_version)'
2.6.0 3.32.2a
andrew_stewart
11/11/2021, 4:53 AMThanks all, I’ll take this back to them and see if it hellps.
andrew_stewart
11/11/2021, 5:55 PMIs it actually possible to just disable the database?
v
visch
11/11/2021, 6:28 PMI don't think so, but I"m not certain. You can point to a postgres DB instead of using a local DB
Might not be a bad issue to bring up, if you don't care about state I could see an argument for not wanting the DB!
a
andrew_stewart
11/11/2021, 7:28 PMyeah I just can’t figure out why my colleague’s sqlite driver is borked
andrew_stewart
11/11/2021, 7:29 PMWhatever, I’m moving them over to a cloud based VS Code environment 😛