I am working on a project which generates an SQLite database. I plan to build some cloud infrastructure, and store and visualise the data in AWS. The database consists of a single table of <10 columns, and a few thousand rows.
The most popular services for storage and visualisation appear to be S3 and Quicksight respectively. It seems that uploading an SQLite database to S3 would present no problems. However, reading the documentation of Quicksight, it is not clear whether an SQlite database would be an acceptable format.
According to https://docs.aws.amazon.com/quicksight/latest/user/supported-data-sources.html, relational data can be read from an S3 bucket. It further says that data from S3 can be read in the following formats: csv, tsv, elf, clf, xlsx, and json. Can anyone confirm that an SQLite .db file will therefore not be accessible to Quicksight?
Would the best strategy be to change to a MySQL or PostgreSQL database format, as these are acceptable data sources for Quicksight?
