I need to drop some columns and uppercase the data in snowflake tables.
For which I need to loop through all the catalogs/ dbs, its respective schemas and then the tables.
I need this to be in python to list of the catalogs schemas and then the tables after which I will be exicuting the SQL query to do the manipulations.
How to proceed with this?
1.List all the catalog names
2.List all the schema names
3.List alll the table names
I have established a connection using python snowflake connector
Your best source for this information is in your SNOWFLAKE.ACCOUNT_USAGE share that Snowflake provides.  You'l need to grant privileges to whatever role you are using to connect with Python.  From there, though, there is are the following views: DATABASES, SCHEMATA, TABLES, and more.
How to retrieve all the catalog names , schema names and the table names in a database like snowflake or any such database?