@Rachel Cunninghamโ :
If you upgrade your existing tables to Unity Catalog, then any new data that you incrementally load into those tables will also be reflected in Unity Catalog. Unity Catalog provides a metadata layer on top of your data, which means it maintains a logical view of your data and tracks changes to it, rather than being a separate copy of your data.
So, when you upgrade your tables to Unity Catalog, you are essentially migrating the metadata of those tables to Unity Catalog. This means that any changes to those tables, including incremental data loads, will be tracked by Unity Catalog. Unity Catalog maintains a transaction log, which records all changes made to the metadata in the catalog.
Therefore, if you load new data into your tables after upgrading them to Unity Catalog, those changes will be reflected in the metadata of Unity Catalog. However, it's worth noting that any changes to the underlying table structure (e.g. adding or dropping columns) will need to be made in the Hive metastore, and then synced to Unity Catalog using the SYNC METADATA command.
