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_accelerator-0.0.1.tar.gz
(4.0 kB
view hashes)
Built Distribution
Close
Hashes for dbt_accelerator-0.0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 85cbba318d86b1e76ea3cbb3b4ceff5ccd9d8447b5da9ef9aed871572209b42a |
|
MD5 | e0e38ad1db4051e722ee4ffda3e25d3e |
|
BLAKE2b-256 | e30c246cb0a6d1894bd5e10f91d2cfeef1e44e18da7296227139ae945e4f02fc |