Hello team, is it possible to ingest multiple MYSQ...
# ingestion
n
Hello team, is it possible to ingest multiple MYSQL databases in one yaml file ? 🙂
b
the ingestion code only accepts one database at a time when it runs
n
Okay, thanks 🙂
b
@nice-planet-17111 Are you interested in ingesting multiple instances of mysql? (E.g. mysql 1 hosted at location 1, mysql 2 hosted at location 2) or multiple schemas within a single MySQL instance? The second should be supported in a single YAML file
n
@big-carpet-38439 I was intending to ingest multiple instances of mysql. I'm thinking of using multiple yaml files. Thank you for the reply anyway 🙂
@big-carpet-38439 Hello, i'm interested in ingestion multiple database again 😢 Can you elaborate the way you mentioned? i already tried ingesting database list, but it got me `str type expected (type=type_error.str)`error.
b
Hi hi ! So currently we only support 1 instance per file!
So each MySQL instance will require separate recipe :(
n
@big-carpet-38439 I was confused, 🙂 what i meant by database, is schema. So the hierarchy is like this : instance -> schema > table
So what i want exactly is, i want to ingest multiple schemas in the same instances in 1 file.