Is it possible to create a sqlite database and export it?

same213
New Contributor III

I am trying to create a sqlite database in databricks and add a few tables to it. Ultimately, I want to export this using Azure. Is this possible?

Anonymous
Not applicable

Hi @Sam E​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

Hubert-Dudek
Databricks MVP

What is the reason behind using SQLite? You can use hive metastore.


My blog: https://databrickster.medium.com/

same213
New Contributor III

@Hubert Dudek​  We currently have a process in place that reads in a SQLite file. We recently transitioned to using Databricks. We were hoping to be able to create a SQLite file so we didn't have to alter the current process we have in place.