on 03-31-202209:07 PM - edited on 10-12-202305:19 PM by Tristan
This python script takes an unzipped tenant export file or an 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 it to query the schema metadata.
Download & unzip the zip file. They are two scripts and you can run as per your use case:
extract_schema_tables.py : extracts schema, tables and datasource info
extract_schema_tables_columns.py : extracts schema, tables, columns, datatypes etc and datasource info
From the CMC export the tenant and unzip it locally or from Incorta UI just export the schemas you need and unzip them.
Configure the path in the script for the dir and outputFile variables
Execute the script as -python <script>
This will create a csv file which can be imported into incorta and a dashboard created on top of it to query this data.