kaarthik108 / snowChat

Chat snowflake - Text to SQL
https://snowchat.streamlit.app/
448 stars 256 forks source link

Best way to generate schema docs from snowflake #8

Closed esanketkulkarni closed 1 year ago

esanketkulkarni commented 1 year ago

Make you're schemas and store them in docs folder that matches you're database.

In above mentioned step, are we expected manually get(copy) the schema definitions of all tables and views from the database or there is an automated or quicker way to download all schemas with a single click from snowflake?

kaarthik108 commented 1 year ago

Hi @esanketkulkarni , I have made another project where this step is automated. The code for it is here for your reference https://github.com/kaarthik108/snowBrain/blob/main/embed/snowflake_ddl_fetcher.py