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
0 answers

How to connect SQL Server with Metabase in local instance

I am using windows 11 and I have installed SQL Server for learning purposes. While logging into the SQL Server I am using Windows Authentication which means I don't have any password for the username. Now, I want to learn Metabase. So I have…
1
vote
1 answer

Using Metabase API behind google oauth

I have a Metabase Docker image running locally that is routed to the URL: https://metabase.example.com I am trying to. do a curl on this to grab a Metabase token to use the Metabase API; however, this URL is hidden behind Google oauth, so I believe…
jipot
  • 304
  • 3
  • 13
  • 34
1
vote
1 answer

Cannot connect to RDS from inside a docker container, I can from the host, and I can from a local docker container

I have an ec2 instance with docker compose installed, running a single container. I have the same setup replicated locally on my machine. using nc -v **host** 5432 results in: From my machine > success From inside a docker container running on my…
1
vote
0 answers

Solved : Connecting to Postgresql from Metabase

I am using Ubuntu 22.04 and Postgresql 14. I have configured Metabase on Docker with Nginx. All are installed on the same machine - localhost. The Metabase page opens at the following address : http://127.0.0.0:3000. When I try to add Postgres…
Sachin
  • 85
  • 9
1
vote
1 answer

How to summarize count of rows by range of two dates in Metabase

I have a Postgress database with the table MyClasses Name id uuid startDate timestamptz endDate timestamptz price numeric And given the next data: id startDate endDate price class1 Aug 1, 2022 Aug 3, 2022 100 class2 Aug…
Yayo Arellano
  • 3,575
  • 23
  • 28
1
vote
1 answer

Connecting Tranco Google BigQuery with Metabase

I am trying to connect third party ranking management system (https://tranco-list.eu/) with metabase. Tranco is giving us an option to see the record on Google BigQuery but when I am trying to connect the Tranco with Metabase then it is asking for…
Himanshu Jain
  • 518
  • 4
  • 20
1
vote
1 answer

Metabase on K8s (GKE) get Readiness probe failed

I try to deploy Matabase on my GKE cluster but I got Readiness probe failed. I build on my local and get localhost:3000/api/health i got status 200 but on k8s it's not works. Dockerfile. I create my own for push and build to my GitLab registry FROM…
1
vote
1 answer

PostgreSQL: with clause returning syntax error at end of input

I'm trying to create a temporary table with the following code: with cte_counts as (select entity_id, entity_name, count(distinct segment_id) as countries from cte_geography where cte_geography.metric_id in (2, 20, 35) group by 1, 2 order by 3…
Joehat
  • 979
  • 1
  • 9
  • 36
1
vote
0 answers

Metabase behind Traefik Getting 404

Issue: I have set up Metabase behind Traefik, running as a Docker container. But it's getting 404 error. I want to access through - dashboard.{{hostname}}. What can be the issue & how can I solve it? my configurations: docker-compose.deploy.yml …
Robin
  • 75
  • 1
  • 5
1
vote
2 answers

How to select cumulative counts by group over time across in postgres

I have cumulative counts for two groups over time in this format: Date Group Cumulative Count 1/1/2020 A 1 1/2/2020 A 3 1/2/2020 B 1 1/3/2020 B 2 And I'd like to reshape this data into this format: Date Group Cumulative…
1
vote
0 answers

Stuck when migrating Metabase from H2 DB to mysql

I am using metabase version v0.41.2 with H2 DB and running it on Windows server. Now I want to migrate from H2 db to mysql. Following is the command used java -jar metabase.jar load-from-h2 /path/to/metabase.db After executing the command, it is…
MemZ
  • 306
  • 4
  • 10
1
vote
1 answer

Extract JSON content in Metabase SQL query

Using: Django==2.2.24, Python=3.6, PostgreSQL is underlying DB Working with Django ORM, I can easily make all sort of queries, but I started using Metabase, and my SQL might be a bit rusty. The problem: I am trying to get a count of the items in a…
camelBack
  • 748
  • 2
  • 11
  • 30
1
vote
0 answers

Facing issue on metabase with mongodb query

I have run the query which is generated by metabase itself: [ { "$group": { "_id": { "openedAt~~~month": { "$let": { "vars": { "parts": { "$dateToParts": { …
Robin
  • 75
  • 1
  • 5
1
vote
0 answers

Metabase : Could not transfer artifact org.clojure:clojure:pom:1.10.3 from/to central

I am building Metabase (branch = release-0.41.0) using Cooperate Jenkins. Could you please guide me on how to use my corporate remote repository instead of this https://repo1.maven.org/maven2/ for downloading dependency & library? Could you please…
Prem Sahu
  • 11
  • 3
1
vote
2 answers

PostgreSQL + metabase connection refused

I am trying to configure postgres to run with springboot and metabase. Each service is running separately alone but when I try to put the 3 together in a docker-compose file, I am getting the following error : Caused by:…
user16806803