Extracting Lineage from Redshift Database

Hi,
I have been trying to extract lineage information from Redshift to Collibra using lineaage harvester. I was able to install it but when I tried to run the full sync, the SQL query stops running after a certain point and the harvester Is stuck. I assume it might be the permissions.
So I wanted to know,

• What kind of permission are needed to be given to the database and to the user in order for the harvester to run.
• If say, certain permissions can’t be given due to security reasons, what could be the workaround.
• Can a custom query be written as a workaround and if it can what would the contents of it be.

Thanks