Find out if Database is used in questions

Get Help
1

Hi
I need help understanding how to properly remove data source.
I have Metabase set up by other engineer with AWS Elastic Beanstalk. Apparently, it's using internal database as there's no other specified

22
222760×126 5.83 KB

And there are few databases connected. One of them I want to delete because the the information in it is already outdated. But don't know if it's used in any question (so I could change/update it).

Is there a way to find out if particular database is used in any question?

2

Hi @vikwl
You would have to find the ID used in Metabase (Admin > Databases), and then you would look in the application database table report_card.database_id to find all questions matching the database ID.

3

Thanks
How can access application database if my Metabase is running in docker and there seem to be no RDS connected?

4

@vikwl Post "Diagnostic Info" from Admin > Troubleshooting.

5 
"metabase-info": {
    "databases": [
      "mysql"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "9.6.20"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-09-15",
      "tag": "v0.36.6",
      "branch": "release-0.36.x",
      "hash": "cb258fb"
    },
    "settings": {
      "report-timezone": null
    }
  }
6

@vikwl I can see that you're using a Postgres 9.6.20 as the application database - where that is, I cannot tell you, so ask your engineer that setup Metabase.
Also, it's a fairly old version of Metabase. Latest release is 0.39.2