Unable to scan Redshift catalog

[alvaromaroto]

It seems there is a bug when you try to scan Redshift catalog. There is an extra where in the Redshift query, so I think there is a issue with the databuilder library (https://github.com/amundsen-io/amundsen/blob/main/databuilder/databuilder/extractor/redshift_metadata_extractor.py#L36). It throws the following exception:

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.SyntaxError) syntax error at or near "WHERE"
LINE 52:             WHERE SCHEMA NOT IN ('information_schema', 'pg_c...

Can you help me?