Enhance schema compare process

[jp-vanheerden]

Is your feature request related to a problem? Please describe.

• No - enhancement of existing functionality

Describe the solution you'd like

• remove the need to have util_BuildMetadata run in each environment/workspace - should only be run in Dev
• Metadata should only populate CompareMetdata in Dev
• Support for multiple lakehouses
• Generate a .sql file per change statement
• combine the util_BuildMetadata and 'compare' notebooks
• exclude views from create table scripts
• table script needs to include partition information
• the bug below also needs to be resolved (when running the process for a second time):

Describe alternatives you've considered

• N/A

Additional context

• Request based on requirements for Perpetual