cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

When does delta lake actually compute a table?

zeta_load
New Contributor II

Maybe I'm completely wrong, but from my understanding delta lake only calculates a table at certain points, for instance when you display your data. Before that point, operations are only written to the log file and are not executed (meaning no changes are made to your data). If that assumption is correct, how can I force an actual computation?

Please correct me here if I missunderstood anything!

1 ACCEPTED SOLUTION

Accepted Solutions

Lakshay
Esteemed Contributor
Esteemed Contributor

Hi @Lukas Goldschmied​ , The operations are calculated when you execute them on the delta table. So, to elaborate when you do an insert operation, a new data file in parquet format is created with new records and the operation metrics are captured in delta log in JSON format. Now, when you run the select command on this table, it will use the information in the delta log to collect the records from the data files and display them

View solution in original post

2 REPLIES 2

Lakshay
Esteemed Contributor
Esteemed Contributor

Hi @Lukas Goldschmied​ , The operations are calculated when you execute them on the delta table. So, to elaborate when you do an insert operation, a new data file in parquet format is created with new records and the operation metrics are captured in delta log in JSON format. Now, when you run the select command on this table, it will use the information in the delta log to collect the records from the data files and display them

Anonymous
Not applicable

Hi @Lukas Goldschmied​ 

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!

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.