Update tables in metabase

Get Help
1

Hi there!

I’m currently working on a project that involves creating KPI’s. That implies using mongodb, ETL tool (Talend for Big Data) and metabase, all in a windows server 2012.

I have various databases in mongodb, i use talend to query information from all of them and upload a json file back to mongodb with the parameters needed.

I want metabase to get that json file(s) and make a dashboard with all my KPI’s.

How can i update the tables in metabase on the spot? The json files don’t ulpoad instantly.
Do i have to restart metabase everytime i upload a json file to mongo?

I use the latest versions on all software and use Chrome to use metabase!

Thanks!

2

One thing to make sure to check is if your Metabase instance is configured with caching

Nope!

3

Thanks for the reply, but for now i don’t have problems with caching.

My problem is that metabase don’t automatically update my tables when i added new files in my mongodb.

Is there anything i can do to update instantly?

4

Ah now I understand better (I hope :blush:) you want new tables and fields to be visible after you make changes to the schema in Mongo

Then look at https://metabase.com/docs/latest/administration-guide/01-managing-databases.html#database-sync-and-analysis …

You can trigger a manual sync there. No need for a Metabase restart.

1 Like
5

Thanks for the reply!

I checked the options available. In the option “Database syncing” is it possible to automatically scan in the minutes i desire? Let’s say, every five minutes :wink:

I saw that in admin panel we have a button to “scan database now”, can i do that option or activate it somehow on the main metabase program? :slight_smile:

6

It looks like you can trigger it from the REST API: https://github.com/metabase/metabase/blob/master/docs/api-documentation.md#post-apidatabase

For how to get started with the API see documentation in this wiki page: