How to output a csv file for schema.table.column details
Developed by: Divya Ramachandran
This python script takes the unzipped tenant export file or a unzipped schema export file and produces a csv file which has all the table column details like datatype etc in a schema. This csv file can then be imported into Incorta and a dashboard created on top of that to query the schema metadata.
- Download the script
- From CMC export the tenant and unzip it locally or from Incorta UI just export the schemas you need and unzip it.
- Edit the path in the script
- Execute the script as - python extract.py
- This will create a columns.csv file which can be imported into incorta and a dashboard created on top of it to query this data.