Unable to Connect to SQLite database file


I’m recently launched a Redash AWS AMI instance (us-east-1 region). I’m trying to connect to a SQlite database that I saved to the same instance. I created a folder and opened the permissions to 777. Under database path, I enter the folder/filename as shown:


After saving and clicking test connection, I get the error message “Connection Test Failed: unable to open database file”.


Alternatively, I tried saving to an S3 bucket and entering the http path. Same error message.

How do I connect to a Sqlite database file?


Redash runs in a Docker container and does not have access to the host’s filesystem. You can\ share the database file with the Redash Docker containers using a Docker VOLUME. You will need to update the Docker Compose settings for this.