Add the Dataset to the Main Schema
The final step is consolidating an approved dataset into the schema’s main table in BigQuery — the single, governed table that all clean datasets for that schema accumulate into.
Steps
Review the transformed data
On the Review step, inspect the mapped rows. Confirm the AI’s mapping looks correct against your schema’s fields.
Approve the dataset
Submit the dataset for approval. Depending on the schema’s mandatory approvers, a reviewer moves it from Pending Approval to Approved. (A rejected dataset comes back so you can make changes.)
Merge into the main schema table
On the Export step, choose Merge. The Merge into data source dialog confirms how many rows will be inserted and into which target table.
Confirm
Click Merge. The rows are inserted into the schema’s main BigQuery table and the dataset is marked Completed.
Each approved dataset appends into the same main schema table, so the table grows into a complete, trusted record across all your transformation runs — ready for analytics and reporting.
You’re done
You’ve gone from raw files to governed data in BigQuery. Repeat the dataset flow any time you have new files to bring in, and reuse the same schema so everything lands in one consistent table.