topic Re: Couple of Delta Lake questions in Data Engineering

Couple of Delta Lake questions

jayallenmn — Tue, 26 Jul 2022 15:41:27 GMT

Hey guys,

We're considering Delta Lake as the storage for our project and have a couple questions. The first one is what's the pricing for Delta Lake - can't seem to find a page that says x amount costs y.

The second question is more technical - if we want to use the python library to access our Delta Lake data instead of spark, do we have to convert the Delta Lake to a Pandas dataframe? This blog seems to say so https://databricks.com/blog/2020/12/22/natively-query-your-delta-lake-with-scala-java-and-python.html. Our concern is our Delta Lake will be many GBs of data and it won't fit in a single Pandas dataframe.

Jay

Re: Couple of Delta Lake questions

-werners- — Wed, 27 Jul 2022 11:03:02 GMT

delta lake itself is free. It is a file format. But you will have to pay for storage and compute of course.

If you want to use Databricks with delta lake, it will not be free unless you use the community edition.

Depending on what you are planning to do, the cost can be very low to very high.

You can use delta lake without databricks btw.

About your 2nd question: pandas is indeed an option. And your concern is exactly why distributed data processing frameworks like Spark were created.

If you want to avoid using Spark, you might wanna look into Dask or Ray.

Re: Couple of Delta Lake questions

jayallenmn — Wed, 27 Jul 2022 17:27:08 GMT

Thanks @Werner Stinckens - would you recommend processing delta lake data with databricks/spark?

Re: Couple of Delta Lake questions

-werners- — Thu, 28 Jul 2022 11:01:26 GMT

totally!

Re: Couple of Delta Lake questions

jose_gonzalez — Fri, 29 Jul 2022 23:36:23 GMT

Hi @Jay Allen,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.