1,301 questions
0
votes
0
answers
56
views
install error on Mac OS: 'ios' file not found ... failed building wheel for pandas
I am running into a consistent error with the PyPI install of apache superset 6.0.0. I am following the instructions from https://superset.apache.org/docs/6.0.0/installation/pypi/.
pip install apache-...
0
votes
0
answers
33
views
Dynamic Dimension in Apache Superset possible?
I'm wondering if it is possible to have a "Dynamic" Dimension in Apache Superset? I would like a dropdown or a filter option and the user select which Dimension he wants to see. Currently we ...
0
votes
0
answers
37
views
Can you create a hierarchy in a dimension when using a table?
I'm wondering if there is chance to create a Hierarchy in Apache Superset. Currently we are using Tableau and we can click on a Dimension to drill down:
The hierarchy:
Drill down:
After you click on ...
1
vote
0
answers
58
views
How to inject dynamic PostgreSQL SET parameters (tenant_id) before every Superset query for multi-tenancy?
I am integrating a Superset dashboard into my web application and need multi-tenant behavior where every client sees the same dashboard layout but only the data that belongs to them. My backend ...
0
votes
0
answers
19
views
Getting bad request error while trying to integrate Superset in asp.net website
We have an asp.net website based on 4.5.2 framework. I am trying to integrate the Superset dashboard into one of the .aspx page, but getting following error:
Error: {"errors": [{"...
0
votes
0
answers
38
views
Customize echarts charts using THEME_DEFAULT
I am working with version 6 and I try to standardize echart charts using THEME. I modified config.py and superset_config.py with the code below. I have try many things but I am not able to make this ...
0
votes
0
answers
41
views
How to make an Apache Superset dashboard update when clicking a bar (X-axis value)?
In Apache Superset, I want to make my dashboard interactive like in Power BI.
For example, when I click on a bar (representing a company name on the X-axis), I want the entire dashboard to ...
Best practices
0
votes
1
replies
62
views
Inquiry: Best Practices for Automating Superset Dashboard Deployments via CI/CD
How to automate deployment of Superset dashboards, charts, and datasets to the target environment (UAT/Prod) from Bitbucket using a CI/CD pipeline running on Cloud Build, Bitbucket Pipelines, or ...
0
votes
0
answers
25
views
How to use CollectionControl?
I'm working on a chart plugin for apache superset. To customize the chart I want to add a list of colors that will be used within the chart. Superset has a CollectionControl for this. With the ...
0
votes
1
answer
63
views
Apache superset embedded 401 error for GET Theme
I have an issue with superset embedded sdk. I am trying to embed a dashboard with guest token. We have multiple Themes configured and replaced the default themes. I tried with different guest roles, ...
4
votes
3
answers
378
views
Superset Guest Token
I'm trying to access an Apache Superset dashboard using a guest token, but no matter what configuration I change, Superset always redirects to the login page instead of displaying the embedded ...
0
votes
0
answers
31
views
superset configurations API for adding users dynamical using code
I am using the admin role bust it's more like i'm missing permissions why? and how can we fix this error?
/api/v1/security/users/
Error: FORBIDDEN
Response body
Download
{
"message": &...
0
votes
0
answers
123
views
Using OpenStreetMap on Superset
I am trying to setup Apache-Superset, so that it uses OpenStreetMap instead of MapBox.
I am currently using Superset in their local Python Version (not the Docker one), I have modified the config.py ...
0
votes
0
answers
33
views
Reusing metrics in Apache Superset, like c_metric = a_metric / b_metric
I want to build metrics in Apache Superset based on other metrics. It looks like this is not supported. The data warehouse used is Snowflake. Does anyone here know how to do this without copy and ...
1
vote
1
answer
96
views
Missing Authorization Header when calling /api/v1/security/csrf_token/
When making a request to the Superset endpoint /api/v1/security/csrf_token/, the response returns an error:
{
"msg": "Missing Authorization Header"
}
The issue only happens when ...
0
votes
1
answer
140
views
Unable to Create Tables in Iceberg via Trino with MinIO and Iceberg REST Catalog
I'm setting up a data lake using the following stack, using docker compose.
MinIO + IceBerg Rest + Trino + Superset.
docker-compose.yml
version: "3.9"
services:
# ---------------- MinIO --...
0
votes
0
answers
104
views
Native Filters option not available in superset version 5.0.0
I am using Apache Superset version 5.0.0 and I am the admin.
I dont see any option to add filters to my dashboard. Is there any chance filters are off in superset_config.py?
apache-superset-dashboard
...
1
vote
1
answer
129
views
superset iframe embedding working in firefox
I am embedding Apache Superset’s dashboard builder inside my MERN application using an iframe.
This setup works perfectly in Firefox, but in Google Chrome the iframe fails to load. Instead, I see ...
0
votes
0
answers
129
views
Unable to embed apache superset dashboard, getting 401 UNAUTHORIZED in the /api/v1/dashboard/
I am trying to embed dashboard from my app's instance of superset, I am unable to
view the dashboard on my application,
I am getting 401 unauthorized error, even if i am sending the authorization ...
0
votes
0
answers
113
views
422 Unprocessable Entity ( The request was well-formed but had semantic errors.)
I was trying to access the Superset Api's by using JWT token, but its giving 422 error code with below details, i request to help, am i missing anything here?
Error Details:
422 Unprocessable Entity ( ...
1
vote
1
answer
138
views
Column reference "id" is ambiguous while filtering in a chart
I created a dataset in Superset SQL Lab by joining 2 tables on session_id.
SELECT *
FROM t1.performance as perf
INNER JOIN t1.test_session as session
ON perf.session_id = session.session_id
Now, to ...
0
votes
0
answers
58
views
How to enable feature List group and custom color feature?
I have installed superset 4.0.1 . We are not able to see the feature List Groups and customize color .
0
votes
0
answers
146
views
Enable Jinja templating in superset 4
I have installed superset 4.1.2 in python virtual environment on redhat 8.8. My analytics database is Clickhouse and I want to enable Jinja templating for filtering based on logged in user and dynamic ...
-1
votes
1
answer
189
views
MySQL connection button is missing - Superset 5.0.0
I've just installed Apache Superset v5.0.0, and I'm trying to configure a database connection. However, I only see options for PostgreSQL and SQLite; the MySQL connection button is missing. I've ...
1
vote
0
answers
69
views
Apache Superset PostgreSQL Query: Network address operator <<= Not Supported
I have a new instance of Apache Superset and SQL queries to PostgreSQL databases from SQLLab is working. The exception is SQL which use the <<= 'is contained within or equals' network address ...
0
votes
1
answer
1k
views
How to fix MCP error -32000: Connection closed conecting a new MCP server with Roo code extension in VScode?
I'm trying to connect a new MCP server (Superset MCP) using the RooCode extension in VSCode. The time MCP server works correctly, but when trying to start the superset-mcp one, I get this error:
MCP ...
1
vote
1
answer
907
views
How to build and deploy apache-superset in production
I need to deploy superset in production, but I want to use an specific code with our cusomizations. We want to be able to change superset frontend acording our necessities and deploy those changes in ...
0
votes
0
answers
119
views
Apache Superset SQL query filtering
I'm new to Cube / Superset so bear with me. I've the following cube defined in Cube:
cubes:
- name: items
sql: >
SELECT DISTINCT
...
FROM
...
WHERE
lt.package_org_id = '{{ ...
0
votes
0
answers
52
views
Can't join two tables in Cube.js through Superset
I've the following query i'm trying to get to work in superset SQL LAB:
SELECT
count(lt.id) AS correctcount
FROM
groups g
LEFT JOIN learner_tests lt ON lt....
0
votes
0
answers
31
views
How to template SCHEMA field for a Dataset?
To support sharing my dashboards with other users, I'm using jinja templates to support changing database and schema name in my dataset SQL.
However, I can't see how to template the SCHEMA name field. ...
0
votes
0
answers
59
views
Apache Superset Time Grains
I can't get timegrains to work on charts. I get the following message
Error: Orig exception: Code: 215. DB::Exception: Column
db.wfm_Schedule_Activity.start_time is not under aggregate function
and ...
1
vote
0
answers
52
views
How can I implement multiple oauth providers parameters for multi tenant setup
I am using Superset with SSO enabled using Cognito in a multi tenant environment. Each tenant is using a separate user pool. Is it possible to plug the connection parameters based on the tenant so ...
2
votes
1
answer
384
views
In Apache Superset, how can I apply a dashboard filter on multiple dataset columns using 'OR' operator
I have a dataset that has three different columns containing a city name (with different meanings).
Now I want to have a dashboard filter where I can enter one city name which should then be applied ...
1
vote
0
answers
40
views
How to query across rows without joins in superset using druid as my db?
I have 3 types of entities ( which can have multiple values ): A, B and C.
Now, A is sending requests to B and B sends requests over to C. However, when A acts a sender, B is the recipient and when B ...
1
vote
0
answers
157
views
REST API Endpoint for Downloading Superset Charts in CSV/Excel Format
I'm using Apache Superset (version 4.1.2) and need to download a chart via the REST API in both CSV and Excel formats. Could you please provide the appropriate API endpoint along with the required ...
1
vote
1
answer
326
views
Facing gateway timeout error in apache superset
I am using apache superset to connect to postgresql. I am facing "Gateway Timeout" in Dashboards where few charts come up but few errors out. In fact, when I click on "View Query" ...
0
votes
0
answers
88
views
Read Filter Values in Handlebars Chart in Apache Superset
I have a Handlebar chart in my Dashboard and I was looking to get values of a filter in it. I tried filter_values() and get_filters() function but then I get this error:
Expecting 'ID', 'STRING', '...
1
vote
1
answer
355
views
Build superset image with personalized logo
I'm trying to build a custom Docker image of Apache Superset that displays my own logo. However I can't figure out what is the little mistake I'm making. My project is structured as follows:
...
1
vote
1
answer
144
views
Force Flask-AppBuilder to perform MFA authentication with OAuth2
I'm running an instance of Apache Superset, a Python Flask app that uses Flask-AppBuilder's security module.
I'm using an Azure SSO config similar to that from the docs:
{
"name":...
0
votes
1
answer
140
views
How to visualize a simple non-timeline table as BarChart in Apache Superset with different colors
To make it simple. I have a table with two columns and two rows:
partyname
value
partya
60
partyb
40
And I would like to get a bar-chart (bars vertically) and both bars should be visible in different ...
0
votes
0
answers
33
views
Onclick enablement on Big Number chart
I want to know if onclick is available/possible for big number charts as it is available for table charts.
For eg -> We have 2 tables
Table 1-> Cols-> Subscription ID, Count(subs id)->
5 ...
1
vote
0
answers
509
views
Superset authentication with Azure Entra ID
I've successfully set up my Apache Superset to authenticated users with Azure Entra ID 2-step verification. However, when I log out and try to log in again, I get the 502 bad gateway error and this ...
0
votes
0
answers
50
views
can superset make dashboard access by role
I want to make a dashboard that only access by this role(ex. role) is superset able to do it only see that it have dataset permission but I want it to access the same dataset but difference dashboard /...
0
votes
1
answer
391
views
Set postgres RDS as metadata backup for Superset [closed]
I'm trying to store the metadata of my superset dashboard running on a EC2 in a RDS.
My rds:
resource "aws_db_instance" "default" {
allocated_storage = 10
identifier ...
0
votes
0
answers
107
views
Error connecting Dremio to Superset [SQL: Could not finish writing before closing]
I'm getting this error when I try to connect Dremio to Superset:
ERROR : (builtins.NoneType) None [SQL : Could not finish writing before closing] (Background on this error at: https://sqlalche. me/e/...
1
vote
1
answer
398
views
Running Apache Superset on Azure App Service
Has anyone deployed Apache Superset with Azure App Service before? I have a problem of logging in with a default admin users.
After getting Superset to run on Azure App Service, I was able to get into ...
1
vote
0
answers
105
views
How to localize D3 SI suffixes in Apache Superset number formatting (e.g., k, M, B → тыс., млн, млрд)?
I've been trying to localize default number formatting in Apache Superset charts, specifically the SI suffixes used in formats like .2s.
Out of the box, Superset uses D3 defaults — k, M, B — but I ...
0
votes
1
answer
291
views
Laravel Superset API - Failed to Get CSRF Token (Subject must be a string)
Problem Statement
I am trying to generate a guest token for Apache Superset from my Laravel application using the Superset API. However, I am getting the following error when trying to get the CSRF ...
0
votes
0
answers
66
views
superset export pdf error: error { target: img,
When I try to export a PDF in the GUI, I get the following error message:
error { target: img, isTrusted: true, srcElement: img, currentTarget: img, eventPhase: 2, bubbles: false, cancelable: false, ...
0
votes
0
answers
120
views
Configuring apache superset with postgres with role and schema
I am trying to configure apache superset with PostgreSQL as metadata database. I provided below sqlalchemy URL:
SQLALCHEMY_DATABASE_URI = "postgresql://superset_user:password@db_host:5432/...