In BigQuery which metadata table(Information_Schema) is having Table Name, Columns and “Column Comments”?
We have Informatica connected to GCP Big Query, in Informatica “Target Mapping” we have choose option to create a backend table and load the data, it’s successful but the target table is not updated with Table Column’s Comments and we didn’t find an option to get the column comments using informatica tool. The source system 100+ tables having 200 to 400 columns, each column has column comments, but informatica tool it doesn’t have a feature to get as source table columns comments (this column comments feature is not available).
Looking for a possibility way to update the Metadata GCP table for all the Tables Column’s comments but not altering table with column comments.
Please let me know is there a Information_Schema’s table which has the tables, columns and column comments.
thanks, PM