Bug description
While trying to setup Superset with Amazon Redshift Cluster, I am running into the following error:
2024-04-15 13:31:10,401:ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (psycopg2.errors.FeatureNotSupported) SQL command "CREATE SEQUENCE ab_permission_id_seq START WITH 1" not supported.
How to reproduce the bug
Following the instructions mentioned here: https://superset.apache.org/docs/installation/installing-superset-from-pypi
Using Psycopg2 for database connection(due to SSL certificate errors) https://superset.apache.org/docs/databases/redshift
Setup fails at command: superset fab create-admin
Screenshots/recordings
Superset version
4.0.0
Python version
3.11
Node version
Not applicable
Browser
Not applicable
Additional context
No response
Checklist
- [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
- [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
- [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Comment From: rusackas
Are you still facing this issue? It's been silent for nearly a year, and I fear there's just not enough detail for this to be actionable.
Comment From: rusackas
Closing due to inactivity, but happy to revisit/reopen.