topic Re: Previous data is getting wiped off for delta tables in Data Engineering

Previous data is getting wiped off for delta tables

naveen123 — Sat, 24 Dec 2022 06:59:06 GMT

I am using only insert sql query to insert the hist. load but previous data getting deleted.

Tried with python query also but same issue persists.

Reading the data from gcp bucket(parquet file)

writing the data into gcp bucket(delta file)..

the deleted files are present in gcp target location but not able to see while querying in databricks

Ajay-Pandey — Sat, 24 Dec 2022 12:15:49 GMT

@Naveen123 Upadhye could you please send your query or code that you are using?

This helps me debug your problem, there might be chance data is getting overwritten

Aviral-Bhardwaj — Sat, 24 Dec 2022 12:25:05 GMT

This is strange , Please share your code by that we can debug

jose_gonzalez — Tue, 27 Dec 2022 23:04:40 GMT

Share your query and also look for any error messages in the driver logs. This might help to undertand better what is happening.