Have a look here: https://docs.dremio.com/sql-reference/sql-commands/datasets.html
In addition, metadata is refreshed automatically based on a selchedule. You can look at the data source configurations screen to see the options there. More info here: https://docs.dremio.com/advanced-administration/metadata-caching.html