Bug description

  1. i use office image version 4.1.2
  2. git clone and docker compose -f docker-compose-image-tag.yml up -d.
  3. i have added requiment-lcoal.txt about starrocks, starrocks==1.0.6, and SQLAlchemy<2.0
  4. starrocks://root:@10.0.152.201:9030/default_catalog.test_database

Image

pls help

Screenshots/recordings

No response

Superset version

4.1.2

Python version

3.10

Node version

16

Browser

Chrome

Additional context

No response

Checklist

  • [ ] I have searched Superset docs and Slack and didn't find a solution to my problem.
  • [ ] I have searched the GitHub issue tracker and didn't find a similar bug report.
  • [ ] 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: dosubot[bot]

Hello @SuperEdison! I'm here to help you with bugs, answer your questions, and assist you in becoming a contributor. While you wait for a human maintainer, feel free to ask me anything!

Superset is unable to load tables after installing the StarRocks driver due to a SQLAlchemy version conflict. Superset requires sqlalchemy==1.4.54, while the latest StarRocks adapter requires SQLAlchemy v2. To resolve this issue, you should use starrocks==1.0.6 instead of the latest version when installing the StarRocks database driver. This older version is compatible with SQLAlchemy 1.4.54 required by Apache Superset 4.1.1, avoiding the version conflict [1].

To continue talking to Dosu, mention @dosu.

Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other

Comment From: rusackas

Looking at their docs here, it seems like you're on the right track. Do you need to add a password?

Comment From: SuperEdison

Looking at their docs here, it seems like you're on the right track. Do you need to add a password?

No password and I can show tables; to get all tables but superset can not load out

URI and starrcocks the both I have tried but it's not working

31803 this issue has tried but didn't succeed

Comment From: SuperEdison

Hello @SuperEdison! I'm here to help you with bugs, answer your questions, and assist you in becoming a contributor. While you wait for a human maintainer, feel free to ask me anything!

Superset is unable to load tables after installing the StarRocks driver due to a SQLAlchemy version conflict. Superset requires sqlalchemy==1.4.54, while the latest StarRocks adapter requires SQLAlchemy v2. To resolve this issue, you should use starrocks==1.0.6 instead of the latest version when installing the StarRocks database driver. This older version is compatible with SQLAlchemy 1.4.54 required by Apache Superset 4.1.1, avoiding the version conflict [1].

To continue talking to Dosu, mention @dosu.

Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other

I have tried to use starricks==1.0.6 but doesn't work