Looking for BQ compatible metadata table corresponding to Netezza metadata

[ManigandanS]

Hi Folks,

We are in the process of migrating our customer from Netezza to BigQuery. In this phase, we are refactoring their existing shell script which has NZ SQL to BQ compatible SQL commands. In one of the script, there were using NZ metadata table and we are finding to replace the same with BQ compatible metadata table or any customer table that we can generate based on BQ metadata tables.

Below is the query which is querying the netezza metadata table,

   SELECT case when conseq > 1 then ',' else '' end || ' ' || attname

      FROM _v_relation_keydata

     WHERE relation = 'dba_raw_tblrefill'

       AND constraintname = 'dba_raw_tblrefill_etlpk'

       AND contype = 'u'

     ORDER BY conseq;

Can anyone help us on finding the bq metadata table for "_v_relation_keydata" or construct one from the available metadata table.?

Thanks,
S.Manigandan