DB Table Selector node currently does not have an option to select the Database. This becomes problematic when connecting the a Data Vault with multiple Databases.
Any chance that the option to specify a Database can be added to the
DB Table Selector node?
thanks for bringing up this question. I have created a feature request for this.
May I ask to what database you try to connect to? Maybe I can propose a workaround until we have added this functionality.
We are using Snowflake.
Thanks for creating the FR. Is there a way I can subscribe to the updates from the FR?
you are welcome. Unfortunately you can not subscribe to our internal bug tracking system. But I have added this forum request to it so we will update this thread once it is supported and you should get an email if this happens.
with the latest release (4.4.0) the DB extension supports working with multiple databases if this is supported by the database e.g. SQL Server. To use it you have to enable it manually via the Support multiple databases option in the Advanced tab of the DB Connector node or any dedicated connector node e.g. Microsoft SQL Server Connector: