When using the MSSQL ingestion, is there a way to ...
# ingestionc
clever-ocean-10572
08/18/2021, 8:24 PMWhen using the MSSQL ingestion, is there a way to have it ingest all databases or do you need to specify the database?
b
big-carpet-38439
08/18/2021, 9:23 PMWithout any allow deny pattern configured, it should just ingest all tables by default š
c
clever-ocean-10572
08/18/2021, 10:54 PMYeah, it will get all the tables in a database but is it possible to get all the databases from a MSSQL instance?
b
better-orange-49102
08/19/2021, 3:48 AMI think the recipe configuration expects one database per file?
m
mammoth-bear-12532
08/19/2021, 6:12 AM
@clever-ocean-10572 the current recipe configuration expects one database per file
b
big-carpet-38439
08/19/2021, 6:13 AMCompletely misread the question š. looking at the code, it appears that the database parameter is optional...
big-carpet-38439
08/19/2021, 6:13 AM@mammoth-bear-12532 Do you recall what behavior occurs when db not specified
big-carpet-38439
08/19/2021, 6:13 AM?
big-carpet-38439
08/19/2021, 6:14 AMm
mammoth-bear-12532
08/19/2021, 6:24 AM
Will have to play with the mssql sql-alchemy connector to report for sure. At this point, I would say the behavior is .. unspecified š
c
clever-ocean-10572
08/19/2021, 1:33 PMIām testing having multiple database parameters. It seems to run only the ingestion on the last one in the configuration.
c
careful-insurance-60247
08/19/2021, 3:25 PMit would be awesome if we could set a list of DBs we wanted to ingest
b
big-carpet-38439
08/19/2021, 3:41 PMThis is a very reasonable feature request..Do you guuys mind raising it as an issue on the repo or shall i?
c
clever-ocean-10572
08/19/2021, 4:14 PM@big-carpet-38439 I will put in a feature request.
clever-ocean-10572
08/19/2021, 4:20 PM