type_changes issue

Question

Hello Team,

I have written the code to get the latest version of the change data field.

max_version = spark.sql("DESCRIBE HISTORY <tableName>").collect()[0][0]

delta_df = spark.sql(f"SELECT * FROM table_changes('<tableName>',{max_version}) order by _commit_timestamp")

display(delta_df)

I need to get only 1st row from the below mentioned screenshot:

It is executing perfectly.But with "Query Result No Data"

Please advise

Regards

Rohit

Answer 1

Hi @Rohit Kulkarni ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

As per my understanding, you are trying to fetch only the first row out of the the data

If your code is executing without errors but returning "Query Result No Data", it is likely that the query is not returning any rows of data.

In this case, you can modify your code to select only the first row from the DataFrame using the limit() function instead of display(delta_df), use display(delta_df.limit(1))

This will return only the first row of data from the delta_df DataFrame. If there are no rows of data, it will return an empty DataFrame.

---

Hope it helps. Kindly accept the answer if it helps. Thanks