以下是代码示例:
CREATE TABLE dataset.table_name
OPTIONS(
format="JSON",
compression="NONE",
external_name="my_bucket/path/*.json",
ignoreUnknownValues="true"
) AS (
SELECT * FROM project.dataset.table_with_matching_schema
)
上一篇:BigQuery重复列名