Stack Overflow
Stack Overflow

Questions tagged [metabase]

Metabase is an open source browser based analytics/data visualization tool.

Metabase is an open source browser based analytics/data visualization tool.

Its backend is implemented in Clojure and the frontend is built with React. Since Clojure is a JVM based language it can be deployed cross-platform as a single .jar.

382 questions
1
vote
1 answer

Connect to postgres from docker-compose for metabase and postgres using secrets file for credentials

I have metabase with postgres up and running with this docker-compose file: $ cat docker-compose.yml version: '3.7' services: metabase-secrets: image: metabase/metabase:latest container_name: metabase-secrets hostname:…
Mauro
  • 11
  • 2
1
vote
0 answers

Parameterizing hsql/raw string format

I'm using a product called Metabase and working to get a custom driver working. There's a method I'm overriding that constructs logic getting last X weeks. Below is an example of what I'm trying to accomplish (defmethod sql.qp/date [:db2 :week] …
user3399186
  • 11
  • 1
1
vote
0 answers

metabase / python api - ConnectionRefusedError: [WinError 10061] No connection could be made because the target machine actively refused it

I have data in a database within Metabase than I am looking to extract through their API. https://www.metabase.com/learn/administration/metabase-api As suggested I am using the code below to access it: import requests import pandas as pd response =…
ben121
  • 879
  • 1
  • 11
  • 23
1
vote
1 answer

How to add a card to a Metabase dashboard using Python

I've extracted ordered cards from a Metabase dashboard and would like to copy them into a new empty dashboard through Python. I don't find the Metabase API documentation: Add Card to Dashboard particularly clear: POST /api/dashboard/:id/cards with…
NicolasRx
  • 29
  • 5
1
vote
0 answers

How to allow metabase work with instance IP on Linux

I am relatively new to AWS and metabase. I am trying to setup metabase with AWS EC2 instance. I have been able to spin up the instance and ssh into the server from my local linux machine. I also tried http://localhost:3000/ and was able to access…
Sam Bayo
  • 143
  • 1
  • 11
1
vote
2 answers

How do I select date in native mongodb query?

I want to execute the following code using Metabase and MongoDB database: [{ "$project":{ "incrementId":"$incrementId", "createdAt":"$createdAt" } }, {"$limit":1048576} ] How do I select a specific date? Let's say i want to see…
Marcin Stańczak
  • 55
  • 1
  • 6
1
vote
0 answers

issue in creating a field filter for a case statement column in metabase

i am having an issue in creating a field filter for a column with a case statement in Metabase. My SQL code- SELECT fk_sender_id, (SELECT company_name FROM Stardb.st_users AS u WHERE u.client_id=plogs.transaction_log.fk_sender_id) AS…
Prashant Pandey
  • 11
  • 1
1
vote
0 answers

PostgreSQL - Database in Metabase does not contains any tables

We have setup Metabase, PostgreSQL (RDS) in our AWS environment. We added database in Metabase but do not see any tables inside We also tried with click on sync tables/fields. I am not sure what i need to do here to get tables into Metabase Can…
Manish Joisar
  • 1,256
  • 3
  • 23
  • 47
1
vote
1 answer

How do I query mongodb with aggregration by passing data as a parameter to filter unix time stamp

I'm querying through Metabase which is connected to a Mongodb server. The field which I'm querying is nested and is a Unix timestamp. See below { room_data: { "meta": { "xxx_unrecognized": null, "xxx_sizecache": 0, …
mystical_starseed
  • 27
  • 1
  • 5
1
vote
0 answers

Is it possible to query the output of a BigQuery stored procedure (maybe as a view?) using Metabase BI?

Is it possible to use Metabase to query the output of a BigQuery stored procedure? I have a complex hierarchical relationship query that I am trying to port from postgres -> BigQuery that uses WITH RECURSIVE on PG which does not exist on BigQuery.…
Kieran Benton
  • 8,739
  • 12
  • 53
  • 77
1
vote
0 answers

Metabase chart does not display on dashboard upon filtering, but displays when clicked on

I've created some questions (charts) that display perfectly on their own. When added to the dashboard they also display perfectly. However, upon adding some filters on the dashboard and selecting the appropriate fields in each of the chart, once I…
user12575866
  • 107
  • 1
  • 4
1
vote
0 answers

How to connect Metabase to Google BigQuery

Following this tutorial or this, an oAuth clientId and clientSecret is required from Google in order to connect metabase to BigQuery service. Make sure to choose 'Other' for your application type. Google doesn't have application type "other" in its…
KasparTr
  • 2,328
  • 5
  • 26
  • 55
1
vote
1 answer

How do I select every nth minute row in SQL (postgresql)

Currently I'm working on creating a dashboard for web connected sensor. I'm using Blynk + Metabase + PostgreSQL setup. My current SQL command to display a graph in Metabase is : SELECT ts, extract(hour from ts) as h, extract(minute from ts) as m,…
HollowLord
  • 11
  • 5
1
vote
1 answer

Metabase embed question fails with Assert failed: (integer? card-id)

Trying to embed a question using iframe in my application. I've followed the instructions here: https://www.metabase.com/docs/latest/administration-guide/13-embedding.html Code (PHP): $payload = (object) [ 'resource' => ['question' =>…
Matanya
  • 6,233
  • 9
  • 47
  • 80
1
vote
1 answer

Embedding a Metabase question in an iframe shows headers, legends and controls but not content

I have a problem with embedding questions from a Metabase 0.34.2 server in an iframe. When I embed questions the body of the item I'm embedding is hidden and styled to an absolute position and height too small to be visible. I wonder if anyone has…
Christopher Gentle
  • 195
  • 11
1 2 3
…
25 26