dosubot[bot] commented on issue #31906: URL: https://github.com/apache/superset/issues/31906#issuecomment-2598543385
<!-- Answer --> I found a similar unsolved discussion titled "Superset insert data to sqlite3 rather than postgresql" which might be related to your issue. You can view it [here](https://github.com/apache/superset/discussions/24463) <sup>[[1]](https://github.com/apache/superset/discussions/24463)</sup>. Additionally, there are two closed issues with no solutions found in the comments, which might not be directly helpful but indicate similar SQLite-related problems <sup>[[2]](https://github.com/apache/superset/issues/25315)</sup><sup>[[3]](https://github.com/apache/superset/issues/24456)</sup>. Regarding your issue, it seems that Superset might be defaulting to SQLite instead of the configured Postgres database. This can happen if the `SQLALCHEMY_DATABASE_URI` is not correctly set in the `superset_config.py` file. Ensure that the connection string is correctly specified for Postgres, like so: ```python SQLALCHEMY_DATABASE_URI = 'postgresql://<UserName>:<DBPassword>@<Database Host>/<Database Name>' ``` If the configuration file is not properly loaded or if the connection string is incorrect or missing, Superset may fall back to its default SQLite configuration. Additionally, if your home directory is NFS mounted, Superset may default to SQLite due to known issues with SQLite on NFS <sup>[[4]](https://github.com/apache/superset/blob/master/docs/docs/configuration/configuring-superset.mdx)</sup><sup>[[5]](https://github.com/apache/superset/blob/master/docs/docs/faq.mdx)</sup>. SQLite has limitations, especially in handling datetime objects, which can lead to errors when executing scheduled reports. This makes SQLite unsuitable for generating images or PDFs in the context of scheduled reports, and PostgreSQL is recommended for such features <sup>[[6]](https://github.com/apache/superset/issues/31625)</sup><sup>[[5]](https://github.com/apache/superset/blob/master/docs/docs/faq.mdx)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/f29982c0-acd6-4f18-9e48-ac14445564db?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
