Module for Metabase with Google Authentication login.

Download repo as zip file, extract all files into the folder of your codes or site-packages (recommended).

pip install -r requirements.txt

Edit config.py with your login email and password.

Then get session cookie by

MetabaseAuth.get_cookie(domain)

If 2-step verification is enabled you need to grant access using your phone. The session cookie will be stored in token.txt and can be reused until expiration.

Example: get the results for question ID 12345, convert into a DataFrame and export to csv

import MetabaseAuth

domain = 'metabase.xxxxx.xx'
cookie = MetabaseAuth.get_cookie(domain)

df = MetabaseAuth.query(domain, cookie, 12345, export=True)

For questions with filters, first we need to obtain the format of the question's parameters request. Get the params as a list by

params = MetabaseAuth.get_params(domain, cookie, question_id)

This will open the browser and navigate to the question page. To get the params, put some values into the filters and click run on Metabase.

Example: query a filtered question with ID 12345

params = MetabaseAuth.get_params(domain, cookie, question_id)

df = MetabaseAuth.query(domain, cookie, 12345, params=params)

Once params has been obtained, we can either convert it to a string and modify directly, or treat it as a list of dictionary for more complex automation.

Example of a returned params:

# creation_datetime is a Field Fiter with value '2020-12-01~2020-12-31'
# order_id is a normal filter with value '111'
[{'type': 'date/range',
  'target': ['dimension', ['template-tag', 'creation_datetime']],
  'value': '2020-12-01~2020-12-31'},
 {'type': 'category',
  'target': ['variable', ['template-tag', 'order_id']],
  'value': '111'}]

We can convert params to a parsable string, modify the values and pass it to another query call.

params_str = MetabaseAuth.params_formatting(params)

Load saved cookie by

cookie = MetabaseAuth.load_cookie()

If cookie has expired you will be prompted to run get_cookie().

Running get_params(question_id) will save the params for that question in params.txt . Load saved params by

params = MetabaseAuth.load_params(question_id)