{"repo":"ryanrozich/snowflake-dbml-generator","free":true,"listed":false,"github":"https://github.com/ryanrozich/snowflake-dbml-generator","clone":"git clone https://github.com/ryanrozich/snowflake-dbml-generator.git","description":"Automatically generate DBML files from Snowflake databases for quickly reverse engineer interactive ER diagrams and documentation from your Snowflake DB. Ideal for data engineers and analysts, it supports custom primary key configurations and relationship inference.","language":"Python","stars":18,"topics":["analytics","analytics-engineering","data-catalog","data-engineering","data-governance","data-platform-tooling","data-warehousing","dbdiagram","dbml","er-diagram"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Snowflake DBML Generator The Snowflake DBML Generator is an open-source tool that translates Snowflake database schemas into DBML (Database Markup Language), facilitating easy generation of ER diagrams and comprehensive documentation of database structures. For data engineers, analysts, and ML engineers, it enables you to bootstrap a rich interactive DB diagram directly from Snowflake. Quick Start Examples Using Snowflake's Sample Data Sets, here are demonstrations of generating DBML and visualizing it with dbdiagram.io: 1. Snowflake TPCH SF100 Dataset - ER Diagram on dbdiagram.io - Snowflake Dataset Documentation 2. Snowflake TPCDS SF100TCL Dataset - ER Diagram on dbdiagram.io - Snowflake Dataset Documentation Features - Automatic DBML Generation : Converts Snowflake schema definitions into DBML automatically. - Complex Schema Support : Manages complex relationships, including composite foreign keys. - Interactive Mode : Guides through configuration file generation and database connection setup. - Customizable Visualization : Allows customization of DBML file appearances with configurable color schemes. - SQL Comments Extraction : Extracts SQL table and column comments as DBML notes. - Table Statistics : Includes table statistics like row count and size in bytes in the DBML output. Installation Prerequisites - Python 3.6+ - Snowflake account credentials Install from PyPI Build from Source Usage Command Line Interface Run the generator via the command line. For detailed usage","default_branch":null,"files":null,"tree":[],"storefront":"/r/ryanrozich","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ryanrozich/snowflake-dbml-generator/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}