SQLiteDialect_pysqlite cannot be used as a data source for security reasons
I've a error in the middle of using superset database. I've gotten add new database from my local storage, but I've got a error as follow in screenshot.
How can I solve this?
Support for SQLite database connections was retired via configuration some versions ago due to security reasons (basically, it's not a proper DB to support multi-web servers).
That said, if your superset set up is simple and the SQLite DB isn't going to support heavy workload, you can turn support on by changing the config file (I haven't checked if it's still possible for the latest versions, I've done it for some versions ago, check the official superset documentation to see if this method is still valid).
Edit the config.py file and change PREVENT_UNSAFE_DB_CONNECTIONS = False.
- How to write custom javascript in superset which is installed in docker?
- Is it possible to install Apache superset on a ECS container
- Getting loader image instead of chart and doesn't contain complete data
- How to create handlebars in Superset and avoid error call to Function() blocked by CSP?
- Superset Add user with REST API
- Rbac superset enable role on dashboard
- Import dashboard in Apache Superset through REST API
- Default Login for Docker Image of Superset?
- Pinotdb error (pinotdb.exceptions.DatabaseError) {'errorCode': 150... when trying to initialize apache-pinot db from apache-superset
- superset keycloak integration on https
- Apache superset failing docker compose up install method
- PL/SQL to Superset/Trino - convert hexadecimal funcion
- create a dataset in sqllab query editor with parameters in Apache Superset
- Trying to start Apache Superset, and get "services.superset-node.env_file.0 must be a string"
- Superset on Kubernetes with Helm not using custom values file
- Using Superset helm chart with pre-existing postgres database
- How to get Superset Token?? (for use Rest api)
- Problem with positioning of charts in superset dashboard
- Superset enable jinja
- How to Apply a URL Filter in a Superset Dashboard
- Error while running "docker compose pull" in Apache Superset
- Can a Superset dataset use multiple data sources?
- connect superset to postgresql in a docker container - The port is closed
- How add a new map to chart "country_map" Apache Superset
- No data about SELECT queries in Superset in ClickHouse table system.processes
- Creating a Superset user programmatically
- Add dynamic categories to pie chart in Apache Superset?
- Take average from a delimited string in a single expression
- How to skip the Superset signin page
- Get proper usernames to populate on Superset with Azure SSO instead of ID string