I want to change the default value of max_num_global_tables. I followed this document https://docs.mongodb.com/bi-connector/master/reference/system-variables#setting-system-variables. And as mentioned I installed MySQL client, connected to bi connector, and used set global max_num_global_tables=10000; and then I connected MySQL again. Now I checked show variables; and it’s showing the updated value for max_num_global_tables. Now I restarted the bi connector inorder to re-map the DBS but then the value went back to the default value. So how can I change it in bi connector itself? (because the default value is 4000, its not mapping all the dbs and collection we have in mongo)
I have posted a question in stackoverflow for the same with more info: tableau api - MongoDB Bi connector not able to update max_num_global_tables system variable - Stack Overflow