How to format a Dremio table programmatically?

339 Views Asked by At

Our system produces a lot of Delta files that we would like to query in Dremio. The files might be updated with new schema.

Is there any way for us to programmatically clear format of a delta table and then reformat it in Dremio?

1

There are 1 best solutions below

0
On

I believe you can refresh the Delta Lake table metadata using this SQL:

ALTER TABLE <path_of_the_dataset> REFRESH METADATA

See https://docs.dremio.com/software/data-formats/delta-lake/#refreshing-metadata