Questions tagged [apache-superset]

Superset is an open source business intelligence web application that allows data exploration

Superset is an open-source business intelligence web application that allows data exploration, as well as the creation and sharing of data visualizations and dashboards.

For non-code questions, ask on the Apache Superset Slack community. The link changes often due to Slack's usage limits so can't be included here but is updated on the main README page on Github.

Resources:

  1. Official site
  2. Github
1173 questions
3
votes
1 answer

Apache superset: cannot read metadata from Athena

I am trying to access Athena from superset, the connection is successful and could see all the schema and tables in SQL editior(Enabled expose this db in SQL lab). On SQL editor while loading the metadata it returns following error: ERROR OCCURRED…
Ashutosh
  • 347
  • 4
  • 11
3
votes
1 answer

Connecting a MySQL database to Apache Superset

I am trying to connect a MySQL database to Apache Superset but the following error is reported: sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (1045, "Access denied for user 'supersetuser'@'localhost' (using password:…
Giorgos Myrianthous
  • 36,235
  • 20
  • 134
  • 156
3
votes
2 answers

Superset for Clickhouse in docker with SQLAlchemy

I'm trying to setup Apache Superset for Clickhouse. My understanding so far is that I need to install SQLAlchemy for Clickhouse https://github.com/xzkostyan/clickhouse-sqlalchemy I'm in Ubuntu 16.04 LTS, and using the Docker vanilla version of…
Stephane
  • 161
  • 2
  • 14
3
votes
1 answer

Superset : Where to force an autologin

I am using superset 0.20.4 If I want to add a token to my URL to autologin to a specific user superset/dashboard/3?standalone=true&token=123456789 Where in the codes should I add a check on the token to login and force a user login action? something…
3
votes
1 answer

How to link MongoDB and Superset BI and import real time data ?

I have a mongodb on a server 122.xxx.xxx.xxx. The mongodb version is 3.4.1. I was asked to pool the real-time data from MongoDB to the superset BI to create various dashboards. I have tried the following way: Use a Foreign Data Wrapper mongodb +…
Jessica Chen
  • 31
  • 1
  • 2
3
votes
1 answer

Can't load plugin: sqlalchemy.dialects:jdbc.hive

I'm trying to build an application with superset, I've installed superset, Hive on my Hadoop cluster and I'm trying to connect to my Hive data base with super set but every time, I try to do so I receive this error: ERROR: {"error": "Connection…
fadhloun anis
  • 525
  • 1
  • 6
  • 13
3
votes
1 answer

Why doesn't Superset refresh when I add a new column to a connected table in MySQL?

I can smoothly connect my MySQL database to Superset and create a table, slice and dashboard, but when I add a new column in the table in MySQL, the table I created in Superset would not change or refresh the schema. In order to solve the problem, I…
chilun
  • 292
  • 6
  • 19
3
votes
1 answer

How to Add a Search Filter to Superset dashboard ("Directed Force Layout" visualization type)

I am wondering if there is a way to add a custom search filter to a Superset dashboard. I am building a "Directed Force Layout" visualization from 25K rows and I hope to implement a search filter which limits the graphing to the specific rows…
kee
  • 10,969
  • 24
  • 107
  • 168
2
votes
1 answer

Problem with superset dashboard embedding in web app

plz help !!! I'm following this tutorial https://www.tetranyde.com/blog/embedding-superset trying to embed superset dashboard in react Js app. I think my code is fine but the dashboard is not rendered in the front.. Here is the error :Front I'm…
rwwa2014
  • 21
  • 2
2
votes
0 answers

Apache Superset, Ubuntu, from scratch - superset-frontend directory does not created

Trying to install Apache Superset "from Scratch" according to official instructions: "https://superset.apache.org/docs/installation/installing-superset-from-scratch/" on Ubuntu 22.04 OS: Оn first step, "OS Dependencies", Python3.10 was…
2
votes
1 answer

How to change superset configuration config.py for production non-dev

I'm sorry for this trivial question... I have read the manual and have searched the internet for an answer. I'm able to change the contents of the superset/config.py file using the "docker-compose up" that uses the docker-compose.yml file which is…
user2723476
  • 95
  • 1
  • 1
  • 8
2
votes
1 answer

Unable to login Google SSO in superset

I have installed superset in docker and tried to implement Google SSO in superset. I tried to follow the official docs "Custom OAuth2 Configuration" from https://superset.apache.org/docs/installation/configuring-superset/ . I changed my…
AB21
  • 353
  • 1
  • 4
  • 15
2
votes
0 answers

Superset Parameters from dashboard to backend query

We have a scenario which is perfectly working fine in metabase but now we have to implement same logic and design in Apache Superset. We have to give a user ability to pass parameters to backend query in Superset which is pretty much simple in…
Owais Ajaz
  • 244
  • 5
  • 20
2
votes
1 answer

Apache superset db upgrade command failing with sqlalchemy.exc.OperationalError

I am trying to install Apache superset on Centos7 machine with python3.8. On executing superset db upgrade command it throws below error. INFO [alembic.runtime.migration] Running upgrade 06e1e70058c7 -> a39867932713,…
Mahebub A Sayyed
  • 325
  • 5
  • 14
2
votes
1 answer

Increase row limit of Apache Superset

I tried increasing the row limit of Apache Superset from 50000 to 500000 in the config.py file. But even after changing the limit, I was limited to see only 100000 rows using the table chart in Apache Superset. Is there any way to increase the row…