Improve catalog sync docs to do similar syncs in Glue and Snowflake as BLMS

[sagarlakshmipathy]

Feature Request / Improvement

Right now only BLMS example uses catalog.yaml whereas Glue uses Crawler and Snowflake uses metadata.json path, both work but not the best way to deploy in production.

So show sample ways to sync to Glue and Snowflake catalogs automatically using a catalog.yaml file.

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct