Thankyou so much for the thorough explanation Sir. I've been going back and forth between stack overflows, documentation and your video, but I keep facing the same problem over and over. It seems even when I added a new role just like you showed here, superset keep forcing me to login to view the dashboard. Is there any way to tackle this "force login" problem?
Thank you for your support. feel there is some permission like on menu or anything that is missing and that menu option is visible hence after clicking on menu or that specific ui its asking you to login as it sees that permission is missing.
Very nice and useful. If you increase database connections to around 30 or so, Superset will get over that problem because it uses around 20-25 connections for its own purposes. I'm working on a project where Prompts are used to transform to SQL to extract data from a database and then create charts and dashboards programmatically via superset API and then embed this visualization in my NextJS screens. Do you think it is a good idea? Any tweaks you can suggest to improve efficiency and latency by taking a different route through this workflow ? Great work. You have significantly reduced work for each viewer having to go through documentation laboriously and instead pick up knowhow from your videos and implement successfully. Thank you very much.
Thank you so much for your support and kind words these really motivate me to work more on the topic and create something useful. The usecase you told is really amazing and after reading it i was literally in shock understanding how far we can use superset. In terms of optimization as per my understanding when we checked superset it calls roles api multiple times to verify and when i discussed this with experts they claimed this can definitely be avoided to optimize the performance when you embed.
@shantanukhod thanks for the video.I dont want to build the new html file to call the .In apache superset ui like text(Markdown format) accepts some tags so like that can I enable the tag in text .I want to call the map service in superset dashboard ui.is it possible ??
@@ShantanuKhond no!, I mean i don't want to take the map present in apache superset .I want to call the map service outside the superset but i want to put the url() in the superset ui (dashboard).is there any possible to do that like any html tags or any other logic to call the map services in superset ui(dashboards).Thanks for advance.
Hmm got it. For that most probably you will have to create custom plugin. I was able to achieve a basic hello world plugin. One of my clients has same requirements i am also trying to build one.
See I want to navigate from one dashboard to another via url . When navigating, I want to apply filter also on 2nd dashboard. Eg from dashboard 1, if I select patient_id =4 then it should navigate to dashboard 2 with patient_id=4 preapplied on all the charts of dashboard2. I have used CONCAT(url) in CalculatedColumn, and ablw to navigate, but prefilter is not getting applied.
Did you create url like specified format? Please check this post stackoverflow.com/questions/63950646/url-filter-parameters-in-apache-superset-dashboards
You can use standalone=true in url like host_or_IP:8088/superset/dashboard?standalone=true or id you want to permanently hide in dashboard then use this css .top { display : none; }
Hi, We have a web as well as a mobile application for our users where we wish to embed superset dashboards. We are able to embed the dashboard successfully through . However, the dashboard either shrinks or the charts come one below the other when viewed on mobile. Is their a way to show the dashboard in portrait/zoomed out view as default so that the look is same as the desktop one. Any suggestions please?
Hello, As of now this feature is not added. What you can do is create another dashboard with one chart in a row and then try embedding it. Basically if mobile then embed this else old one.
I want to integrate Superset dashboard with ODOO 16 (Open source). Is there any way to integrate. Do you have any documentations or manual? Or can you lend me the process steps whether how to integrate.
@@ShantanuKhond not as per user control now I have one filter event_name and I want my dashboard to filtered with event_name == Rutvij , and dashboard will be filtered and it will open in
Very informative video, I followed all the steps but it is showing "localhost refused to connect" what to do now? In superset_config.py file I have only this line -> PUBLIC_ROLE_LIKE = "Gamma" I am running superset on my local machine by this command "docker compose -f docker-compose-image-tag.yml up" Am I missing something ?
I am using AUTH_TYPE =AUTH_DB. I have added this in the superset config.py AUTH_USER_REGISTRATION = True and AUTH_USER_REGISTRATION_ROLE = "Public". But its not working am getting a 500 error after clicking the button.
The problem is even the user registration form web page does not even appear after you click on the "Register" button. Please do make a video showing how users can self-register on superset.
I guess you have cors issue. Are you trying to embed with other way? If yes then you need to configure cors. For that documentation is ready on our yt-assets github i am recording video probably today or tomorrow.
@@ShantanuKhond Yes Brother I have tried other ways. Worked on guest token API (Superset API documentation). Finally when I try the widget error occured.Need to allow all domains options ? I have live superset server (role: admin,gamma) So i cant to load the on other domains. In the sense how to enable all domains on live superset dashboard.
Can you send me detailed log? You should be able to get it from superset server by stopping service and running the sh file manually. If it is not possible to write here mail me on contact@shantanukhond.me.
sir ive installed superset using ubuntu but i had earlier installed it using docker also and while installing it through ubuntu i filled the same credentials of the superset i installed through docker but it is not running in ubuntu now what should i do it says During handling of the above exception, another exception occurred:
Please check first exception there must be more than one. And we want first exception that actually caused this. You can share error log with me on contact@shantanukhond.me .
Very helpful! Thank you sir!
Glad I could help! Most welcome 😊
great videos, I am waiting for you videos about SSO in Superset
Thank you for your support! Yes i explored it i have planned
Thankyou so much for the thorough explanation Sir.
I've been going back and forth between stack overflows, documentation and your video, but I keep facing the same problem over and over.
It seems even when I added a new role just like you showed here, superset keep forcing me to login to view the dashboard. Is there any way to tackle this "force login" problem?
Thank you for your support. feel there is some permission like on menu or anything that is missing and that menu option is visible hence after clicking on menu or that specific ui its asking you to login as it sees that permission is missing.
Very nice and useful. If you increase database connections to around 30 or so, Superset will get over that problem because it uses around 20-25 connections for its own purposes.
I'm working on a project where Prompts are used to transform to SQL to extract data from a database and then create charts and dashboards programmatically via superset API and then embed this visualization in my NextJS screens.
Do you think it is a good idea? Any tweaks you can suggest to improve efficiency and latency by taking a different route through this workflow ?
Great work. You have significantly reduced work for each viewer having to go through documentation laboriously and instead pick up knowhow from your videos and implement successfully.
Thank you very much.
Thank you so much for your support and kind words these really motivate me to work more on the topic and create something useful.
The usecase you told is really amazing and after reading it i was literally in shock understanding how far we can use superset.
In terms of optimization as per my understanding when we checked superset it calls roles api multiple times to verify and when i discussed this with experts they claimed this can definitely be avoided to optimize the performance when you embed.
me salvaste bro Gracias.
Most welcome 🙂
hello you are doing great work
Thank you 😊
@shantanukhod thanks for the video.I dont want to build the new html file to call the .In apache superset ui like text(Markdown format) accepts some tags so like that can I enable the tag in text .I want to call the map service in superset dashboard ui.is it possible ??
Never tried will have to try this. Just map right. Can we just create a dashboard as map and use it will it work?
@@ShantanuKhond no!, I mean i don't want to take the map present in apache superset .I want to call the map service outside the superset but i want to put the url() in the superset ui (dashboard).is there any possible to do that like any html tags or any other logic to call the map services in superset ui(dashboards).Thanks for advance.
Hmm got it. For that most probably you will have to create custom plugin. I was able to achieve a basic hello world plugin. One of my clients has same requirements i am also trying to build one.
See I want to navigate from one dashboard to another via url . When navigating, I want to apply filter also on 2nd dashboard.
Eg from dashboard 1, if I select patient_id =4 then it should navigate to dashboard 2 with patient_id=4 preapplied on all the charts of dashboard2.
I have used CONCAT(url) in CalculatedColumn, and ablw to navigate, but prefilter is not getting applied.
Did you create url like specified format? Please check this post stackoverflow.com/questions/63950646/url-filter-parameters-in-apache-superset-dashboards
Hi bro, im trying to access to "list roles" but there is an internal server error 500
Help i cant enter full screen the dashboard you have any idea sir?
You can use standalone=true in url like
host_or_IP:8088/superset/dashboard?standalone=true
or id you want to permanently hide in dashboard then use this css
.top { display : none; }
Thanks alot is there a way to remove the edit feature
You should be able to do it by removing permission granted to public role.
Hi, We have a web as well as a mobile application for our users where we wish to embed superset dashboards. We are able to embed the dashboard successfully through . However, the dashboard either shrinks or the charts come one below the other when viewed on mobile. Is their a way to show the dashboard in portrait/zoomed out view as default so that the look is same as the desktop one. Any suggestions please?
Hello, As of now this feature is not added. What you can do is create another dashboard with one chart in a row and then try embedding it. Basically if mobile then embed this else old one.
I want to integrate Superset dashboard with ODOO 16 (Open source). Is there any way to integrate. Do you have any documentations or manual? Or can you lend me the process steps whether how to integrate.
Yes I got couple of request for odoo i will explore and create document or video if i find something.
Please tutorial migration superset to another host
Sure will do.
Make make Tutorial on : how to create drill down on superset apache
Noted will do thanks
I want to open dashboard with already applied custom filters which will open in , how to configure that using super set embedded sdk ?
Do you want user control to change those? You can put rls values those will filter by default.
@@ShantanuKhond not as per user control now
I have one filter event_name and I want my dashboard to filtered with event_name == Rutvij , and dashboard will be filtered and it will open in
Sorry i did not receive notification for this. Basically you will have to embed and while embedding you will have to put rls rules in it.
Very informative video, I followed all the steps but it is showing "localhost refused to connect" what to do now?
In superset_config.py file I have only this line -> PUBLIC_ROLE_LIKE = "Gamma"
I am running superset on my local machine by this command "docker compose -f docker-compose-image-tag.yml up"
Am I missing something ?
Are you able to connect Superset Normally?
@@ShantanuKhond yes it is working fine without but accessing same link from it showing "localhost refused to connect".
@@ShariqShareef-hj8hc try setting TALISMAN=False in your config file
@@blankrelax433 after doing this still get this error
@@huskysharmai forgot to mention you also need to set HTTP_HEADERS = {‘X-Frame-Options’:’ALLOWALL’}
Hi, can you help me with how to integrate apache superset with odoo.
I can help but i have not used odoo.
@@ShantanuKhond If possible, can we connect once.
Sure please ping me on contact@shantanukhond.me
@@ShantanuKhond Please check.
my cd/app/superset is not working system cannot find specified path is coming i downloaded superset through docker. what can i do?
Just give me this weekend I am recording docker video.
Hello can you guide me how to run superset on https ?
Yes as i said earlier using nginx reverse proxy
What about having having a user registration form where users who sign up are given the "public" role
Sign-up? Then it will be with sso where users are given default roles like that??
I am using AUTH_TYPE =AUTH_DB. I have added this in the superset config.py AUTH_USER_REGISTRATION = True and AUTH_USER_REGISTRATION_ROLE = "Public". But its not working am getting a 500 error after clicking the button.
Oh ok. I believe superset sends email to verify user. Have you configured mail settings In config file?
The problem is even the user registration form web page does not even appear after you click on the "Register" button. Please do make a video showing how users can self-register on superset.
Oh ok I will ad in list
Hi I have one error. When loading in my react app.
Error:
X-Frame-Options headers with conflicting values ('SAMEORGIN,Allow') throwing.
I guess you have cors issue. Are you trying to embed with other way? If yes then you need to configure cors. For that documentation is ready on our yt-assets github i am recording video probably today or tomorrow.
@@ShantanuKhond Yes Brother I have tried other ways. Worked on guest token API (Superset API documentation). Finally when I try the widget error occured.Need to allow all domains options ?
I have live superset server (role: admin,gamma)
So i cant to load the on other domains.
In the sense how to enable all domains on live superset dashboard.
No only allow from where request is coming for example if react app is running in local then localhost:3000
I got something like sandbox error while clicking on download csv in my react app.
Can you send me detailed log? You should be able to get it from superset server by stopping service and running the sh file manually. If it is not possible to write here mail me on contact@shantanukhond.me.
Since it is hosted on the production server, do i need to make changes in the config file ?
sir ive installed superset using ubuntu but i had earlier installed it using docker also and while installing it through ubuntu i filled the same credentials of the superset i installed through docker but it is not running in ubuntu now what should i do it says During handling of the above exception, another exception occurred:
Please check first exception there must be more than one. And we want first exception that actually caused this. You can share error log with me on contact@shantanukhond.me .
@@ShantanuKhond sir please make a video ok how to embed dadhboard in docker desktop
Hello can you guide me how to run superset on https ?
Yes as i said earlier using nginx reverse proxy