Unable to Connect to SQLite database file

#1

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:

Screenshot%20from%202019-02-12%2013-17-25

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

Screenshot%20from%202019-02-12%2013-14-31

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?

0 Likes

#2

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.

0 Likes

#3

@UisceBeatha Did you get this figured out? :smile:

0 Likes