# Syntax for refresh metadata

**URL:** <https://community.dremio.com/t/syntax-for-refresh-metadata/9578>\
**Category:** Dremio University\
**Created:** [August 22, 2022, 8:38pm UTC](https://community.dremio.com/t/syntax-for-refresh-metadata/9578 "2022-08-22T20:38:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aki0086](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/aki0086/32/4181_2.png) [@aki0086](https://community.dremio.com/u/aki0086)\
**Post date:** [August 22, 2022, 8:38pm UTC](https://community.dremio.com/t/syntax-for-refresh-metadata/9578/1 "2022-08-22T20:38:43Z")

</div>

Hi all,

I have a question regarding the syntax for refreshing metadata.  
I’m using this command to attempt to refresh the metadata, but i keep getting an error

> ALTER TABLE “INFO-HDFS.b.p.3529.fi.latest” REFRESH METADATA;

> Error:  
> SQL Error: VALIDATION ERROR: Tried to access non-existent source [INFO-HDFS.b.p.3529.fi.latest].

query on the info schema tables…

| TABLE\_CATALOG | TABLE\_SCHEMA | TABLE\_NAME | TABLE\_TYPE |
| --- | --- | --- | --- |
| DREMIO | [INFO-HDFS.b.p.3529.fi](http://INFO-HDFS.b.p.3529.fi) | latest | TABLE |

What am i doing wrong?

version: 20.1.0-202202061055110045-36733c65

---

<div class="post-metadata">

**Author:** ![Benny\_Chow](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/benny_chow/32/5527_2.png) [@Benny\_Chow](https://community.dremio.com/u/Benny_Chow)\
**Post date:** [August 22, 2022, 11:48pm UTC](https://community.dremio.com/t/syntax-for-refresh-metadata/9578/2 "2022-08-22T23:48:39Z")

</div>

When you added the double quotes, the whole string was treated as the source name. I think you just need to double quote INFO-HDFS.

You can also use the SQL Editor and click the “Add to SQL Editor” next to the dataset name to get the fully qualified table name.

---

<div class="post-metadata">

**Author:** ![fetanchaud](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/fetanchaud/32/4192_2.png) [@fetanchaud](https://community.dremio.com/u/fetanchaud)\
**Post date:** [August 23, 2022, 7:57am UTC](https://community.dremio.com/t/syntax-for-refresh-metadata/9578/3 "2022-08-23T07:57:36Z")

</div>

> [@aki0086](#):
>
> “INFO-HDFS.b.p.3529.fi.latest”

Hi @aki0086 , IMHO @Benny_Chow is right, you should try this :

“INFO-HDFS".“b”.“p”.“3529”.fi"."latest”

instead.

Best regards,