topic Re: In Data Explorer, how do you Refresh a table definition? in Data Engineering

In Data Explorer, how do you Refresh a table definition?

Jason_923248 — Tue, 09 May 2023 16:28:50 GMT

In Data Science & Engineering -> Data -> Data Explorer, if I expand the hive_metastore, then expand a schema and choose a table, and then view the "Sample Data", I receive this error:

[DEFAULT_FILE_NOT_FOUND] It is possible the underlying files have been updated. You can explicitly invalidate the cache in Spark by running 'REFRESH TABLE tableName' command in SQL or by recreating the Dataset/DataFrame involved.

In the old UI, I would click the "Refresh" button to clear the error. That button does not seem to exist anymore. Is there a new method to REFRESH a table within the Data Explorer?

Re: In Data Explorer, how do you Refresh a table definition?

padmajaa — Wed, 10 May 2023 12:27:13 GMT

Try refreshing all cached entries that are associated with the table that might help

REFRESH TABLE [db_name.]table_name

Re: In Data Explorer, how do you Refresh a table definition?

Jason_923248 — Wed, 10 May 2023 13:34:10 GMT

Thanks....I have tried that many times, and it does not help. It's like the Sample Data view in Databricks is cached in some way, and there is no longer a mechanism refresh it.