I have figured out how to get list of custom tables in Sisense by connecting to MongoDB server and prismWebDB database. But then I run into some issues and would like to get guidance from the Community:
- I get list of custom tables from DatasetTables table but I’m not sure how to identify what custom tables come from which cube? Is there an accurate identifier of some sort that I can use? There’s a table named Elasticube, joins with datasets table on oid = elasticube but I’m not sure if this will give accurate table location.
- I get list of dashboards from Dashboards table and filter on datasource_title to get dashboard names from a specific Sisense cube. Are there any columns from this table or other tables I can use to get list of dashboards and custom table(s) that are used in each dashboard? If so, how is Dashboard table and the other table connected on what inner join?
Thank you for the suggestion.
