1,375 questions
-3
votes
0
answers
17
views
can we intergrate whole apache superset system with react.js and node.js? [closed]
I am working on a project where I need to integrate Apache Superset (for data visualization) with a React.js frontend and a Node.js backend. Here’s what I’m trying to achieve:
Frontend: React.js for ...
0
votes
1
answer
51
views
Passing the username through an iframe without passing it in the url in extjs
Currently we have an extjs application where we are calling the /login API through an Iframe by passing the username as /login?username=YWRtaW5AZWZmaXNlci5jbzZTZzMTg= and reading this in the ...
0
votes
0
answers
24
views
Apache Superset Iframe Issue: SESSION_COOKIE_SAMESITE=None Still Defaults to LAX
Questions:
Why is Superset not respecting SESSION_COOKIE_SAMESITE=None?
Do I need to explicitly set this in Dockerfile or environment variables?
Is there any other configuration overriding this ...
0
votes
0
answers
24
views
How to dynamically filter Superset dashboards by logged-in user’s account ID?
We are looking to use Superset to provide customer-specific dashboards. Ideally, when a user logs in via OAuth, Superset would automatically filter the data to only show records associated with their ...
-1
votes
0
answers
16
views
psycopg2 error during Docker Superset upgrade
During upgrading to new 5.0.0rc1 version is not possible due to No module named 'psycopg2'.
Error:
superset | File "/app/.venv/lib/python3.10/site-packages/sqlalchemy/dialects/postgresql/...
- 119
-3
votes
0
answers
34
views
Can't send alerts\reports on Apache Superset using Kubernetes [closed]
I want to monitor my database and trigger alert when a specific sql is executing and returns a result.
In order to do so, I've successfully deploy Apache Superset on gcluod GKE. I've add a superset ...
- 7,701
1
vote
0
answers
11
views
The generated graph (superset) for some countries does not display values for a specific year
[]
The constructed graph for some countries does not display values for a certain year. However, there is data for countries in the database. If you set the filter to, for example, Germany, then the ...
0
votes
0
answers
50
views
Integrate Superset with API using Shillelagh
I am trying to connect my Superset deployment using docker, with JSON APIs. I have tried using it with Shillelagh but i am getting following errors:
Following are the logs:
superset_worker | [...
- 2,620
0
votes
0
answers
49
views
How to connect Apache Superset 4.1.1. to LDAP server?
I am using Apache Superset 4.1.1. docker compose setup and trying to connect Superset to LDAP using ldapjdbc driver. I am using openldap jdbc driver, also used CData’s ldap jdbc driver.
I wrote a ...
0
votes
0
answers
21
views
Extracting the Values selected in the Filter on a column from a different dataset
Can we extract the filter value(s) selected in a dashboard filter (applied on a different dataset's column, which is not present in my current dataset) using Jinja in Superset?
Issue:
I tried using ...
0
votes
1
answer
48
views
Apache Superset - Ordering a Bar Chart in Chronological Order with different years
We have a visual with stacked bars considering the last four months (10/24, 11/24, 12/24, 01/25) but I am unable to order them in chronological order since 01 (the month) is smaller than 10. Therefore ...
0
votes
0
answers
21
views
Is there a way to use excel file in superset located at remote location
I want to create Superset dashboard from excel dataset. This is a live dataset which is updated by a 3rd party on a weekly basis. This file is located on our server.
Is there a easy way to keep ...
- 11
0
votes
0
answers
31
views
Column level security on Superset
Is there column based security on Superset?
I want to hide some of the columns of table from different users without creating different tables or data sources.
- 89
0
votes
1
answer
79
views
Not able to see Custom Chart viz plugin in Apache Superset
I am trying to integrated a custom chart in apache-superset, here are the steps which I followed
git clone https://github.com/apache/superset
cd superset
git checkout tags/4.1.1
Added keycloak code
...
0
votes
0
answers
41
views
looping page after login in apache superset using nginx gunicorn proxy pass
need help in apache superset. I've install apache superset in AWS Amazon Linux. If i run using terminal and open the apache superset using ip and port 8088 , it work's fine. Nothing error.
But if i ...
1
vote
1
answer
53
views
superset - embedded dashboard - Unexpected error - list index out of range
I have a table chart that, under certain conditions, returns zero results. When that happens, I get a message in the chart that read "Unexpected error". If I click the "see more" ...
- 11
0
votes
0
answers
31
views
Apache Superset /api/v1/dataset/ is not working for uploading the new csv file as creating a new dataset
I am new to Apache Superset and I am trying to create a new dataset by directly uploading the CSV file using /api/v1/dataset/. Here is what I am trying to do using Postman.
curl --location 'http:/...
0
votes
0
answers
84
views
How to Retrieve Superset Dashboard Thumbnail Image Using API?
I am trying to get the Thumbnail for a Dashboard in Superset from this API:
/api/v1/dashboard/{pk}/thumbnail/{digest}/
I provide the necessary parameters (pk, digest), I receive the following response:...
0
votes
1
answer
81
views
Possible to export charts from Apache Superset to PDF for any superset version?
Possible to export charts-graph from Apache Superset to PDF for any superset version?
it is possible to export charts from Apache Superset to PDF, but it requires some additional setup or tools since ...
0
votes
0
answers
52
views
Apache Superset ID, Label & Filters
It seems to me that at some point superset was supporting filters with ID and Labels i.e. you would be able to present to the user a text value but behind the scenes user the ID for faster queries.
...
0
votes
1
answer
92
views
Monitoring/Tracking Apache Superset usage
Is there a way to monitor end user usage of Superset? I'd like to be able to be able to view Active users and the frequency of dashboards, charts and datasets used.
I tried looking for documentation ...
- 1
0
votes
0
answers
46
views
apache superset with apache drill data not visible in charts
please can you help me i'm having problems with apache superset that i connect to apache drill. inside the SQL Lab i'm able to view my data but as soon as i switch to chart the column data is replaced ...
0
votes
0
answers
24
views
apache / superset implement the changes in the currently git code
Failed to load 'D:\Data\POC\superset-master\superset-frontend\webpack.config.js' config
[webpack-cli] Error: Can not access zstd! Is it installed?
at Object.<anonymous> (D:\Sandeep Data\...
-1
votes
1
answer
53
views
Can't Find Anything After Logging into Apache Superset?
I am using Docker Desktop to run Apache Superset. I downloaded the repository using the following command:
git clone https://github.com/apache/superset
After cloning, I built and started the Docker ...
- 5,063
0
votes
0
answers
37
views
Error 422 While Fetching Tables in Apache Superset via /api/v1/database/1/tables Endpoint
I am facing an issue in Apache Superset where fetching tables for a schema in an Apache Pinot database results in a 422 Unprocessable Entity error.
Problem Details:
The API endpoint causing the issue:
...
0
votes
0
answers
139
views
How to Create a Cumulative Metric in Apache Superset?
I’m working on a dashboard in Apache Superset and trying to create a cumulative metric for one of my visualizations. Here's the context:
I have a dataset with columns such as date, category, and ...
0
votes
1
answer
68
views
Rolling count distinct in superset
I have a BIG NUMBER WITH TIMETREND chart in Superset which has Time grain = Quarter, create_date on temporal axes, and a metric COUNT_DISTINCT(id).
The dataset is used by many other charts.
I have to ...
- 35
0
votes
0
answers
28
views
Error when trying to execute command in Docker on AWS: "container is not running"
I am trying to create an admin user in a Docker container, but I am facing an issue. After attempting to restart the superset container on AWS, I receive an error stating that the container is not ...
0
votes
0
answers
38
views
Menu export is not available for charts in embedded dashboards Superset
We use embedded (https://www.npmjs.com/package/@superset-ui/embedded-sdk) dashboards in our system. When viewed in the superset admin panel, all menu items for charts are available. But in our system ...
0
votes
0
answers
69
views
In Apache Superset is it possible to edit Echarts by JSON Configuration?
I am using Apache Superset 4.1 and we are adding some charts, We figured that Apache Superset uses Apache EChart Library. So we have Pie Charts etc.
When we go to Apache Echart Library these charts ...
- 30.2k
0
votes
0
answers
120
views
Superset line chart value labels cut off — how to display all digits?
I'm using Apache Superset to display a line chart, and I noticed an issue with the last value labels on the chart. for example, the last label on the y-axis shows as "3,010,93" instead of &...
- 11
0
votes
0
answers
114
views
How to change Apache Superset chart font color?
I have tried to inspect Apache Superset dashboard as described in many websites to choose the target element class and write custom CSS to change font color but seems nothing works.
Some of my custom ...
0
votes
2
answers
147
views
how to apply custom Formats in Metrics in Apache Superset?
I am suing Apache superset. I want to add custom Y Axis Axis Format in number format. I have tried DEFAULT_METRIC_FORMATS and D3_FORMATS in superset config.Custom number format is not showing in Y ...
- 5,063
0
votes
1
answer
163
views
Apache Superset with sqlalchemy-kusto - create dataset - could not load columns
I have installed a new superset (version 4.1.1) with sqlalchemy-kusto==2.0.1. I use kusto sql. I can connect to the Azure Data Explorer. When I want to create a dataset, I got an error:
An Error ...
- 63
0
votes
0
answers
111
views
Create Apache Superset chart using DuckDb and Iceberg table raises "virtual dataset query cannot consist of multiple statements"
Creating chart in Apache Superset using DuckDB and Iceberg table using the following statements:
LOAD iceberg;
SELECT * FROM iceberg_scan('/ake-data/iceberg/ake/my_iceberg_table/metadata/00001-...
0
votes
0
answers
44
views
how to use use custom Y Axis Axis Format in Aapache superset
I am using Apache superset. I need to use custom Y Axis Axis Format number format. I have data like sample data:
I want to show data like 23,860 crore instead of 23860,86,00,000. I have tried below ...
- 5,063
0
votes
1
answer
594
views
'This database does not allow for DDL/DML' error in Apache superset
Running the following query in Apache superset on a Clickhouse DB
select top 2 storage_name
from proxy_space;
leads to error:
DB engine Error This database does not allow for DDL/DML, and the
query ...
- 3,191
1
vote
2
answers
287
views
Superset is missing MySQL after upgrade from 3.0.0 to 4.1.1
I have updated superset from 3.0.0 to 4.1.1 in my docker container.
I am currently using a flask to authenticate to AzureAD so my requirements-local.txt looks like this post upgrade:
psycopg2-binary
...
- 63
0
votes
0
answers
51
views
I need to create a Tree chart view in super set, but i'm not understanding the correct way to set the table to the visual work correctly
I need to create a Tree chart view in super set, but i'm not understanding the correct way to set the table to the visual work correctly
I had create a view in superset to reproduce a metric e had in ...
0
votes
1
answer
59
views
How to combine multiple rows of a column while deduping the values in the column? [duplicate]
How can I get the result specified below?
I tried using the LISTAGG function, but it does not eliminate duplicates.
Is there a way to eliminate duplicates at the database itself instead of fetching ...
- 115
0
votes
0
answers
83
views
Update Apache Superset User - password changed
I am using Superset extended API for User management and I want to edit user by
PUT /api/v1/security/users/{pk}
is most probably changing password as the login doesn't work anymore.
After some ...
- 158
1
vote
0
answers
85
views
AWS Cognito with Apache Superset on Docker: "Error Invalid login. Please try again"
I'm trying to integrate AWS Cognito with Superset.
Superset is running on a Docker.
Prior to implementing Cognito, everything was loading just fine - superset is working.
On my page https://momo.com/...
- 93
0
votes
2
answers
146
views
Apache Superset doesn't logout user on Keycloak logout
I'm experiencing some troubles when user logs out of Keycloak - I also need to log user out of Apache Superset, but it Superset authentication is not deleted. How can I achieve that? Is there any ...
- 61
0
votes
0
answers
48
views
Sort days of the week extracted using TO_CHAR(order_date, 'Day') in PostgreSQL or Superset
I am working on Superset where I have extracted the day of the week from a DATE column (order_date) using the following SQL function:
TO_CHAR(order_date, 'Day') AS day_of_week
This gives me a string ...
- 59
0
votes
0
answers
145
views
Collapsed rows or columns in pivot table by default
When creating a Pivot Table chart in Apache Superset, is it possible to ensure that rows and columns are collapsed by default?
I have one column, two rows, and two metrics defined in my pivot table. ...
- 303
0
votes
1
answer
263
views
Embedding an Apache Superset Dashboards in a different origin website using Talisman (X-Frame-Option error)
I am trying to Embed an Apache Superset Dashboard on another angular app deployed on a different host using an iFrame.
The angular app tries to retrieve the dashboard but i run into an error
X-Frame-...
- 518
1
vote
0
answers
433
views
Apache Superset - Conditional Formatting on a column based on the values of another column?
I am using a Pivot Table v2 in Apache Superset. I have two metric columns: 'Cost' and 'Percentage Diff.' (I'll refer to this as '%').
My goal is: for every row, the background color of the 'Cost' cell ...
0
votes
0
answers
21
views
Date time error on SqlLab (Apache-superset) possible error in date/time operation
Have come across this error and stuck as to why it fails on SqlLab on apache superset
Error:
oracle error: ORA-01805: possible error in date/time operation
Query:
select to_timestamp_tz('20-NOV-2024 ...
- 89
0
votes
0
answers
57
views
HTML entities not rendering in query results
Problem
When running a SQL query that includes an HTML <br> tag, Superset is not rendering the tag as expected. Instead, it's being stripped from the output.
Question
Is there a way to configure ...
0
votes
0
answers
27
views
Apache Superset modal editor not fully shown
When opening the modal editor, there's a scrollbar despite having enough space to display all the content.
Example: there are 20 lines of code here, but I have to scroll to see it all.
For context, ...
- 1,072