New versions of SQLMesh may be incompatible with the project's stored metadata format. Migrations provide a way to upgrade the project metadata format to operate with the new SQLMesh version.
When issuing a SQLMesh command, SQLMesh will automatically check for incompatibilities between the installed version of SQLMesh and the project's metadata format, prompting what action is required. SQLMesh commands will not execute until the action is complete.
Installed version is newer than metadata format
In this scenario, the project's metadata format needs to be migrated.
Installed version is older than metadata format
Here, the installed version of SQLMesh needs to be upgraded.
How to migrate
The project metadata can be migrated to the latest metadata format using SQLMesh's migrate command.
Migrating project metadata will affect all users of the project. Please consult your SQLMesh administrator before running the migrate command.