I’m wondering if we can refresh metadata for VDS in a similar way as for PDS.
We sometimes change the schema of the PDS but the VDS which “select * from” it didn’t pick up the new schema unless we delete the VDS and recreate it again.
I think the schema for the VDS is stored in somewhere rather than a pointer to the schema of underlying PDS and only when it “thinks” the underlying table changed it will refresh the metadata. Since we didn’t change the table name of the PDS, Dremio still assumes the old schema of the table.
Thank you so much.