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?