Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
refresh table in databricks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shambhu Rai
1,411
Reputation points
Hi Expert, How we can refresh the tables in databricks. can i get some example? its shows table level how about multiple table ? REFRESH TABLE tbl1;
Azure Databricks
{count} votes
-
Vinodh247 40,141 Reputation points MVP Volunteer Moderator2024-01-25T05:16:46.1+00:00 To refresh multiple tables in Azure Databricks, you can use the
REFRESH TABLEcommand for each table. This command invalidates the cached entries for Apache Spark cache, which include data and metadata of the given table or view. The invalidated cache is populated lazily when the cached table or the associated query is executed again. Here’s an example syntax:REFRESH TABLE table_name1; REFRESH TABLE table_name2; REFRESH TABLE table_name3;Where
table_name1,table_name2, andtable_name3identify the Delta tables or views to cache. Please note thatREFRESH TABLEis not applicable for refreshing the data in streaming tables and materialized views. You can use theREFRESH (MATERIALIZED VIEW and STREAMING TABLE)command. -
Shambhu Rai 1,411 Reputation points
2024-01-25T05:44:56.9333333+00:00 I am asking about db level
-
Dillon Silzer 60,726 Reputation points Volunteer Moderator2024-01-25T05:48:43.82+00:00 Hi Shambhu, can you please give us some more details on what you mean by "db level"?
-
Shambhu Rai 1,411 Reputation points
2024-01-25T05:53:47.94+00:00 REFRESH TABLE table_name1; REFRESH TABLE table_name2; REFRESH TABLE table_name3; we can not follow this step if they are multiple tables so anythingon database can be check
-
Vinodh247 40,141 Reputation points MVP Volunteer Moderator
2024-01-25T06:31:47.8066667+00:00 will looping through a databricks job will work out for you? using these REFRESH TABLE table_name1,2,3...etc?
-
Vinodh247 40,141 Reputation points MVP Volunteer Moderator
2024-01-26T11:04:34.9266667+00:00 Shambhu Rai:Please confirm if we are still connected on this discussion. Let me know if you need more info or help.
-
Shambhu Rai 1,411 Reputation points
2024-01-30T00:21:19.8033333+00:00 it is not correct suggestion
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 6%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKH%3C/text%3E%3C/svg%3E)
Kyle Hale 10 Reputation points2024-02-07T23:25:44.71+00:00 hey Shambhu, you're not being very helpful in a forum designed to be helpful. Please share some code or examples of what you are trying to accomplish. No one can help you if you don't provide any information.
Sign in to comment
Sign in to answer