topic Re: Is it possible to create a sqlite database and export it? in Data Engineering

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

same213 — Tue, 18 Oct 2022 15:44:36 GMT

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?

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

Anonymous — Sun, 27 Nov 2022 13:29:45 GMT

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!

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

Hubert-Dudek — Mon, 05 Dec 2022 16:35:37 GMT

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

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

same213 — Tue, 13 Dec 2022 13:04:54 GMT

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

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

Debayan — Tue, 18 Oct 2022 16:10:14 GMT

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-query-from-a-databricks-notebook , https://community.databricks.com/s/question/0D53f00001GHVYICA5/how-to-export-full-result-databricks-azure and https://www.getcensus.com/blog/4-ways-to-export-csv-files-from-databricks.

Please let us know if this answers your question.