When mysql datasource is added to dremio, all databases that the mysql user has access to will be listed on dremio. However, if in future we add more databases on mysql and grant access permissions to mysql user that was used to create the existing mysql datasource on dremio, the new databases will not be listed under the existing dremio-mysql connection resource. If the existing datasource is removed and re-added a fresh, the new databases will now be listed. Is this the desired/design behaviour?
How long did you wait before dropping and adding the source? The default discovery time is 1 hour unless you have changed it
Hi @balaji.ramaswamy
Apologies for delayed response and thank you for pointing out the portion of docs I was missing. I didn’t wait for longer that a couple of minutes!