Hello, Can I have single sqlite db on S3 as a data...
# troubleshooting
c
Hello, Can I have single sqlite db on S3 as a database for production ?
e
Hi @chintan_patel! You could but it's not something that Meltano supports out of the box. You can pull the db from s3, run Meltano, the push the db back to s3. I wanted to give litestream a try a while ago but it's probably overkill for this use case. Also, if you mean to use sqlite as the system database for Meltano then you may wanna take a look at using s3 as a state backend.
c
Thank you! Yes we use S3 to store the state.