Hello everyone!

In this post, I’ll walk you through how to extract the description of all the columns and tables using the one desktop plan. Providing detailed descriptions and comments is a fundamental best practice in data management and data standards. This approach significantly enhances the
understanding and usability of data.

The summary of all the tables, attributes and their descriptions can be extracted using the below plan.

1. Open a plan and add Attribute and Catalog Item metadata reader steps.
2. The Attribute meta data reader helps to extract the attribute names, comments, description. Open the meta data reader and provide the column names as below and provide the Parent Id Column name as ‘CatalogItemID’.

3. The Catalog Items meta data reader helps to extract the catalog Item name based on the catalog Item Identifier. Open the meta data reader and provide the column names as below and provide the Id column name as ‘catalogItemID’.

4. Use the Join Step and join the meta data reader steps based on the ‘CatalogItemID’. Use the join Type as ‘INNER’.

5. Create a text file writer and store all the attributes.
6. The complete plan looks like below.

7. Run the plan and see the output file. The excel file contains catalogItemID, CatalogItemName, Comment, Description attributes.

If you have any questions or thoughts, please don’t hesitate to share them in
the comments