GitHub user Ozoubia created a discussion: Recommended IRIS connector for Superset 6.x? (TOP / row limit issues with sqlalchemy-iris)
Hi everyone, I'm running Superset with InterSystems IRIS as a data source and I'm planning to move to Superset 6.x. My current setup uses: - `apache/superset:4.0.2` (official image) - `sqlalchemy-iris==0.18.1` ([caretdev/sqlalchemy-iris](https://github.com/caretdev/sqlalchemy-iris)) - `intersystems-irispython==5.4.0` While testing Superset 6.x with the same connector, I ran into problems with queries involving row limits. IRIS uses `SELECT TOP n` rather than `LIMIT`, and some generated queries didn't work. A few questions: 1. Is there a newer or recommended connector/dialect for IRIS that works well with Superset 6.x? 2. Has anyone successfully used IRIS with Superset 6.x, and if so, with which package versions? 3. Are there alternative approaches (e.g. a different driver, JDBC/ODBC bridge, or engine spec settings) that others use for IRIS? Any pointers would be appreciated. Thanks! GitHub link: https://github.com/apache/superset/discussions/44346 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
