Semantic Layer Sync with Metabase

This page details the support for Metabase in Semantic Layer Sync.

Semantic Layer Sync works with managed and self-hosted Metabase instances.

Configuration

To create a new sync, choose Metabase:

Data model is synchronized via Metabase API which uses a user name and a password for authentication. You can use your own user name and password or create a new service account. You can copy a url at any page of your Metabase workspace.

Example confguration for Metabase:


from cube import config
 
@config('semantic_layer_sync')
def semantic_layer_sync(ctx: dict) -> list[dict]:
  return [
    {
      'type': 'metabase',
      'name': 'Metabase Sync',
      'config': {
        'user': 'mail@example.com',
        'password': '4dceae-606a03-93ae6dc7',
        'url': 'example.metabaseapp.com',
        'database': 'Cube Cloud: production-deployment'
      }
    }
  ]


module.exports = {
  semanticLayerSync: ({ securityContext }) => {
    return [
      {
        type: "metabase",
        name: "Metabase Sync",
        config: {
          user: "mail@example.com",
          password: "4dceae-606a03-93ae6dc7",
          url: "example.metabaseapp.com",
          database: "Cube Cloud: production-deployment"
        }
      }
    ]
  }
}

When a sync is run, Metabase will send an email with a new login notification. You can ignore such emails, configure Metabase to skip sending them, or use a service account with a different email address:

Was this page useful?