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?

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.

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

Hi Guys,

Did you figure this out? IM trying to figure out where to put the SQL lite database in the Redash AWS image. Where is the volume mounted? and what is the path i need to put to access the SQlite db file. ny help will be appreciated

Thanks,

Paco