how to extract snowflake tables schema and store-procedures using python script?

Question

I'm intermediate with python and beginner with snowflakes.

Here i'm able to connect snowflakes and fetch table data.

But main problem is to extract tables schema and store-procedures from snowflakes using python script.

thanks in advance.

Answer 1

Use the get_ddl feature of snowflake as shown below to get the table schema

And use SHOW PROCEDURES to get the procedures

You can see the below python package to find out how you can run the above queries through python

https://github.com/Infosys/Snowflake-Python-Development-Framework

look at the execute_snowquery function