Package which generates schema.yml and columns.md from Excel Sheet
Project description
dbt_schema_md_generator
This code automatically produces schema.yml and columns.md file with input from xlsx file.
Please follow the Steps below:
- Input the program with your xlsx filename and model_name_to_append
- Each Sheet Name will represent a Table and contains the Column_Name, Column_Description and tests if any.
- Each sheet must contain 'Column_Name' and 'Column_Description' as Headers in them
- If you want to add Test you need to add 'Yes' respectively under the test column.
- Make Sure you have a Table_Descriptions Sheet present in your xlsx file
- Ensure you have entries for all the Tables in Table_Descriptions Sheet
- The Sheet Name must match with the Column_Name given in the Table_Descriptions Sheet
- Please refer to the Sample_File provided for more clarity.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
dbt_accelrator-0.0.1.tar.gz
(3.6 kB
view hashes)
Built Distribution
Close
Hashes for dbt_accelrator-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ce44c9f7e5f7cf51da3b6196f3ffd9f28815ada39077570b9948ae75a64a1278 |
|
MD5 | 701bea03a10bfcad3940802b6775fa82 |
|
BLAKE2b-256 | 10737e249d20e0cd36d9b85615b92e0c6b4a3684692feb400d60fb6ed814381b |