No, you cannot directly access detailed Iceberg metadata (like specific files, manifests, or partition layouts) using BigQuery SQL. Regarding your second question, BigQuery Iceberg tables currently do not support BigQuery's native APPENDS or CHANGES table functions for Change Data Capture (CDC).

As stated in the documentation you provided, only the listed features are supported.