An overview for the BigQuery integration with Secoda
After connecting BigQuery to Secoda, to view the metadata associated with one of your BigQuery tables, visit the catalog page and click on the title of your BigQuery table. That link will bring you to the following page.
The tables associated with the schemas that have been selected in your BigQuery integration will be imported. If a comment is present on the table, that comment will be brought in as a description.
The columns associated with the tables will be imported into Secoda. The column name, type and comment will be brought in. Optionally, clicking the "Run Profiler" button will show a distribution of each BigQuery column.
Table and column lineage is automatically imported into Secoda. The last day of queries are parsed with our lineage parser to build a map of the relationships between columns and tables.
The queries from the last day of query history in BigQuery will be brought in and automatically associated with the tables that they reference.