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
17
votes
6 answers

Force SSL on App Engine Flexible Environment Custom Runtime

We're running an instance of Metabase on a App Engine Flexible Custom Runtime with a Dockerfile based on openjdk:8. Currently it allows access on http://[metabase-project].appspot.com/ and https://[metabase-project].appspot.com/. I'd like to force…
Morgan Conbere
  • 173
  • 1
  • 6
16
votes
4 answers

Metabase Filters example

I am using metabase integrated with Mysql for reporting purposes. I went through documentation but was unable to find any example explaining how to implement filters in SQL based questions. The only example I found was regarding Date Range and…
Syed Anas
  • 1,459
  • 3
  • 19
  • 38
7
votes
3 answers

Upload a .csv file to metabase

I would like to upload a .csv file to metabase but it doesn't offer the option. What would be the easiest way to get it done? Spin up a DB locally? Or is there a plugin that can be added? Thanks
fro
  • 437
  • 4
  • 16
7
votes
3 answers

Metabase on Google App Engine

I'm trying to set up Metabase on a gcloud engine using Google Cloud SQL (MySQL). I've got it running using this git and this app.yaml: runtime: custom env: flex # Metabase does not support horizontal scaling # …
digital aloe
  • 71
  • 1
  • 4
6
votes
0 answers

Convert String to Int on AWS DocumentDB

I am currently trying to write a metabase question off AWS Document DB and I am running into an issue where I need to convert a string to an integer. Unfortunately, it seems like aws documentdb does not support $toInt and I am not sure how to get…
Kevin Peng
  • 71
  • 2
6
votes
1 answer

Unwind dictionary values in mongodb aggregation framework

I need to create some plots from single documents existing in mongodb. I can only use the mongodb aggregation framework (so for example I cannot just pull the documents into python and work with it there). I am using the query builder of metabase,…
Alex Popa
  • 93
  • 1
  • 6
6
votes
1 answer

Is it possible to get raw data from a Metabase MBQL / SQL query via the REST API?

Is there a Metabase REST API that takes a MBQL/SQL query and returns the raw data? I can perform a MBQL query via the API in a 2-step process by doing the intermediate step of creating a Question via the Metabase web app UI and then querying the…
Grokify
  • 15,092
  • 6
  • 60
  • 81
6
votes
1 answer

Using Metabase with Firebase Realtime Database for data analytics

Is it possible to setup and use Metabase (https://metabase.com/) to directly (or indirectly, maybe via Google BigQuery) connect to Firebase realtime Database to fetch data to analyze? Any advice or tutorial links (if available) will be highly…
Dimitri
  • 2,240
  • 3
  • 21
  • 39
6
votes
2 answers

Connect Metabase to Sql Server

I installed Java on my Windows 10 machine and downloaded Metabase.jar, and ran it. Now I could access metabase at localhost:3000 But I'm unable to setup my SQL Server Database as Data reference. I'm either getting: Couldn't connect to the database.…
Gk_999
  • 508
  • 8
  • 29
6
votes
1 answer

Is there a way to retrieve Metabase Questions Table JSON output via API?

The Metabase (https://metabase.com/) Data Explorer web UI has the ability to create queries they call questions with various filters. The query results can be visualized in a variety of ways including a table and charts. The table results can also…
Grokify
  • 15,092
  • 6
  • 60
  • 81
6
votes
2 answers

IIS: How to get the Metabase path?

i'm trying to get the list of mime types known to an IIS server (which you can see was asked and and answered by me 2 years ago). The copy-pasted answer involves: GetObject("IIS://LocalHost/MimeMap") msdn GetObject("IIS://localhost/mimemap")…
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
5
votes
2 answers

30 day rolling count of distinct IDs

So after looking at what seems to be a common question being asked and not being able to get any solution to work for me, I decided I should ask for myself. I have a data set with two columns: session_start_time, uid I am trying to generate a…
Tobiah Adam
  • 53
  • 4
5
votes
3 answers

How to connect Metabase with Google Sheet?

I have username and password to the metabase our company use heavily. Everyday I have to download CSVs frequently and then export them to google sheets to make report or analysis. Is there any way to connect Metabase to Google Sheet so that the…
Ashraful Islam
  • 53
  • 1
  • 1
  • 5
5
votes
1 answer

Metabase - how to find question id or dashboard id from queryHash

We are using Metabase to query Amazon Redshift DB. In AWS UI queries section I can see Metabase user ID and corresponding queryHash. -- Metabase:: userID: 201 queryType: native queryHash:…
kapil matani
  • 157
  • 1
  • 9
5
votes
2 answers

How to safetly export all IIS settings from one server to another?

I am trying to build a virtual machine that clones one of the servers used in production instances of our webapp so that we can do deployment testing on it. I have gotten all the necessary files over, IIS installed, the database up and running. To…
George Mauer
  • 117,483
  • 131
  • 382
  • 612
1
2 3
…
25 26