Yes, that is correct. Yufei
On Tue, Feb 24, 2026 at 6:12 PM Anand Kumar Sankaran < [email protected]> wrote: > Hi Yufei > > Does this mean that if I were on Version 2 of the schema and want to > upgrade to Version 4, is it enough that I run the schema for Version 4 and > it would guarantee that I get all the tables in Version 3 as well? > > - > Anand > > *From: *Yufei Gu <[email protected]> > *Date: *Tuesday, February 24, 2026 at 5:16 PM > *To: *[email protected] <[email protected]> > *Cc: *Anand Kumar Sankaran <[email protected]> > *Subject: *Re: Tables in both version 3 and version 4 of schema > > This Message Is From an External Sender > This message came from outside your organization. > Report Suspicious > <https://us-phishalarm-ewt.proofpoint.com/EWT/v1/Iz9xO38YGHZK!YhNDZABkHi1B678BXuVq0MkxnuGCe3EZnQEK6rpdPByK-T2UxSw0gX9ZvqGkVuPYHPgpXKKNZv4W08fNXWYSeDuB1T6vdC0ZTIDDum3_JBjfZ1vByCYMYSilUse3GjwU$> > > Hi Anand, > > Yes, that is correct. The schema versioning is largely additive, and the > community aims to preserve backward compatibility whenever possible. In > practice, this means we typically add new tables or indexes rather than > remove existing ones. Removing structures can introduce breaking changes, > so we try to avoid that. However, backward compatibility is not strictly > guaranteed. Even seemingly minor changes, such as adding a new column, may > require data backfilling or migration steps depending on the deployment. So > seeing those tables present in both versions is expected and by design. > > Yufei > > > On Tue, Feb 24, 2026 at 1:17 PM Anand Kumar Sankaran via dev < > [email protected]> wrote: > > Hi all > > My understanding of the schema versioning is that the schema version is > additive. > > i.e, the tables in version 4 build on top of the tables in version 3. > > I see the following tables are repeated in both version 3 and version 4. > > Is that by design? > > | version | Stores the JDBC schema version | > | entities | All entities with their properties and metadata | > | grant_records | Grant records for entities (authorization) | > | principal_authentication_data | Authentication data for clients | > | policy_mapping_record | Policy mappings for targets | > | events | Event log table | > > - > Anand > >
