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

[same213]

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?

[Debayan]

Hi @Sam E​  , please refer to https://learn.microsoft.com/en-us/azure/databricks/scenarios/databricks-connect-to-data-sources , https://community.databricks.com/s/question/0D53f00001HKHmSCAX/exporting-data-from-databricks , https://community.databricks.com/s/question/0D53f00001HKHqPCAX/how-can-i-export-a-result-of-a-sql-qu... , https://community.databricks.com/s/question/0D53f00001GHVYICA5/how-to-export-full-result-databricks-... and https://www.getcensus.com/blog/4-ways-to-export-csv-files-from-databricks.

Please let us know if this answers your question.

[Anonymous]

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]

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

[same213]

@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.