Schema version per schema?

[pepijnve]

At the moment schema_version is stored at the snapshot level. The implication is that there is a single schema version for the entire catalog rather than one per schema in the catalog. Is this intentional?

I think there might be value in pushing the schema_version down to the schema table since this allows for more precise version modeling and more fine grained cache invalidation.