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
0
votes
1 answer

Share metabase dashboards with team members

I am new to Metabase. And I have Metabase dashboards that I want to let team members be able to see. The Metabase is running on a remote server, and I want the team members to access it from there personal PCs. how can I let them access it? I tried…
0
votes
0 answers

Metabase: Lost everything on ElasticBeanstalk

I was using Metabase on ElasticBeanstalk and everything was fine. Today I realized that the website was off. I saw that the ec2 instance was with the SEVERE status.Tried to reboot the machine. I don’t know if it was rebooted, but after a while it…
Renan Geraldo
  • 605
  • 1
  • 6
  • 17
0
votes
1 answer

Error embedding Metabase dashboard with locked parameters

I am creating a dashboard on Metabase to embed it into an application. This dashboard has two questions, one of which was created using the Metabase query builder (AOV) and the other was created using SQL (GMV). When I set the brand_id parameter on…
Felipe
  • 6,312
  • 11
  • 52
  • 70
0
votes
2 answers

Is possible to read an Azure Databricks table from Azure Data Factory?

I have a table into an Azure Databricks Cluster, i would like to replicate this data into an Azure SQL Database, to let another users analyze this data from Metabase. Is it possible to acess databricks tables through Azure Data factory?
LeandroHumb
  • 843
  • 8
  • 23
0
votes
1 answer

how to display dashboard at homepage in metabase?

I am new to the metabase. If anyone help me out that how to display dashboard at homepage while working on metabase.I tried but failed and search it on the google but did'nt find it anywhere.
0
votes
1 answer

Javascript CSP Block

I am new to metabase. I have downloaded the metabase source code and hosted it in the Ubuntu 16.04 LTS server.When I am starting the Metabase server with the "lein ring server" command, I get "java.awt.HeadlessException". I have read some where in…
SGSC
  • 1
  • 1
0
votes
1 answer

SQL: How To Query my customers who made a purchase after 6 months of registering with us?

I have a table that I can pull up that shows daily if a customer made a purchase or not and the values are 0 or 1 for the day with the list of customers. Table = Customers_daily, column = made_purchase = 1 or 0 Select date_utc, count(distinct…
Gus
  • 343
  • 3
  • 10
0
votes
1 answer

Add filter only if the variable is given with values in Metabase

In Metabase, one can add variables with {{variable}} in queries, such as: select * from dashboard_demographic_view where clinic_id = {{clinic}} , where dashboard_demographic_view is a view created in advance. In the query above, rows where…
ytu
  • 1,822
  • 3
  • 19
  • 42
0
votes
0 answers

How I can connect multiple Postgres Database in a single SQL query?

This is Metabase Related Question. I know how to cross join in PostgreSQL. I have multiple staging databases to store raw data in postgreSQL. All databases are in same host. Now I want to join multiple databases for analysis in Metabase. I saw…
Md Sirajus Salayhin
  • 4,974
  • 5
  • 37
  • 46
0
votes
1 answer

Ambiguous column names while querying mySQL using Metabase

I'm Getting com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'pid' in on clause is ambiguous I have two tables having columns with the same name (pid). Is there a way to make metabase use tablename.columnname…
Sanket Berde
  • 6,555
  • 4
  • 35
  • 39
0
votes
0 answers

Big Query Timeout in Metabase

Hey guys I have trouble on querying BQ. I have query that could be executed using BQ UI but always or rather often timeout in Metabase. Do you have any idea how to optimize BQ querying performance in Metabase? Thanks.
ans4175
  • 432
  • 1
  • 9
  • 23
0
votes
0 answers

SQL - Generate counts for "mismatched" records

I am now trying to use Metabase v0.29 to develop a question. Suppose I have three tables and would like to produce an output table shown below. Table 1 - Job/Student ID (job_student_ids) Job ID Student ID J101 S101 J101 S102 J102 …
Magnus C
  • 1
  • 1
0
votes
1 answer

IIS Metabase GetObject call returning error 424 object required error

We have an ASP Classic website running on Windows Server 2003 and IIS6 which is throwing intermittent runtime error 424 object required. We've tracked this down to the line which initialises the object reference to the metabase as shown below…
craig1410
  • 201
  • 2
  • 14
0
votes
1 answer

Extract ? number of JSON array objects into rows

So I am trying to pivot some large Json arrays into a row by row format (postgres db). So imagine {“searchResults”:[{“id”:“89705”,“score”:42,“title”:“Foo.”,“properties”:{… Currently the most results we have in an array is about 300~ id's and…
0
votes
1 answer

SQL Union grouped by formatted strings

I'm trying to sum up 2 columns from 2 different tables, grouped and sorted by a formatted string. The schema gist is this: Table A: * Created At * Amount Charged Table B: * Created At * Cash Amount Note they share a column name called "created…
Miles
  • 1,615
  • 4
  • 17
  • 42