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.

[Kaniz]

Hi @Sam E​, We haven’t heard from you since the last response from @Debayan Mukherjee​, and I was checking back to see if you have a resolution yet.

If you have any solution, please share it with the community as it can be helpful to others. Otherwise, we will respond with more details and try to help.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve 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.