Metabase Provisioning Role

This is an Ansible role for setting up Metabase, a free tool for Business Intelligence and analytics.

For the latest Metabase documentation, click here.

Requirements

You need to have Java OpenJDK version 8 or higher installed. This requirement is not included in meta/main.yml, so you can install it however you prefer.

Defaults

You can see all the default settings here.

Setup

Metabase uses an embedded H2 database by default. For production use, it's better to use your own database. This role uses PostgreSQL by default, but you can choose any database. If you want to use the built-in H2 database, set: use_own_database: false.

Note: This database is only for Metabase's own data and settings, not for the data you want to analyze.

If you choose your own database, make sure to create it before using this role. You can change the following settings:

metabase_db: metabase
metabase_db_type: postgres
metabase_db_host: localhost
metabase_db_port: 5432
metabase_db_user: metabase
metabase_db_pass: changeme

This role will also create the first admin user for Metabase. You can change these settings (or use the defaults for testing):

metabase_admin:
  first_name: Metabase
  last_name: Admin
  email: [email protected]
  password: metabase123

Configuring Datasets

Metabase comes with a sample dataset, but you can add your own databases during the installation. Use this format:

metabase_databases:
  - name: Business Data
    engine: postgres
    dbname: analyze-me
    host: localhost
    port: 5432
    user: postgres
    password: changeme
    ssl: false

Note: You can change these settings later in the app if needed.

Example Playbook

- name: Provision Metabase
  hosts: webservers

  roles:
    - role: libre_ops.metabase

You can also use this role to install Metabase on your local machine, like this:

- name: Install Metabase Locally
  hosts: 127.0.0.1
  connection: local

  roles:
    - role: libre_ops.metabase
      vars: 
        use_own_database: false