Hello! I’m trying to figure out if it is possible ...
# best-practices
p
Hello! I’m trying to figure out if it is possible to run
meltano install
without connecting to the system database. My usecase is that I’m trying to install extractors and loaders at docker build time in an environment that doesn’t have network access to the system database and has no real reason to have the db credentials. I then plan to run migrations separately (it seems like I can do that using
meltano upgrade database
, but I haven’t tested that yet). Even running
meltano install extractors loaders
fails if
database_uri
is not reachable. Based on this, it seems like my only option is to not set
database_uri
in the config and use an env variable instead an just have the docker build run migrations against a local sqlite database even though I don’t plan to use that database. Or is there another approach to this?
Also on a related note, this is documented but from what I can tell I can just install
pymysql
(or any other sqlalchemy-compatible db adapter) if I want to use mysql for the system database, right?
m
Pretty sure this is what I'm doing. I tend not to set env vars in my docker file anyway FWIW
j
Heya! Did you manage to solve this? I have exact same use case and problem 😓
p
No, I didn’t. I gave up on trying to set
database_uri
in the config and just use a local sqlite database during install time.