How can I mport metadata json file and transformations from DBT to Collibra?

Question

Hello Everyone,

Is anyone has a step by step setup to import metadata json from DBT to Collibra? I was reading some info here: dbt to Collibra Integration - Collibra Marketplace but it’s difficult for me to set this up. anyone can help please? BTW I have built a dbt plateform based on eks and airflow

integrationdev_rohit · Answer

Hi Gauthier,

This will be custom development that you need to carry in below high level steps :

Read the json file from a location in loop.
Extract the metadata from json file and convert it into one csv file for all the json files .
Once your csv file is ready import it into collibra using import api’s.

Regards,

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard