1

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.

Steps

  1. Download the script
  2. From CMC export the tenant and unzip it locally or from Incorta UI just export the schemas you need and unzip it.
  3. Edit the path in the script
  4. Execute the script as - python extract.py
  5. 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.

 

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like1 Follow
  • 1 Likes
  • 2 mths agoLast active
  • 39Views
  • 1 Following

Product Announcement

Incorta 5 is now Generally Available