Transfer data into Iceberg managed table

You can use the BigQuery Data Transfer Service to transfer data from external sources, such as Amazon Simple Storage Service (Amazon S3), Azure Blob Storage, or Cloud Storage into Iceberg managed table.

Data sources supported

You can specify Iceberg managed table as the destination table type when you set up your transfer configuration for these data sources:

Limitations

Transfers to Iceberg managed table are subject to the following limitations:

  • Append-only: Data is only appended to the destination table. Overwriting, updating, or deleting existing data is not supported.
  • Partitioning limitations: Partitioning is supported on the destination Iceberg managed table, but some limitations apply. For more information, see Partitioning limitations.
  • No backfills: Transfers do not support backfills.

Pricing

For information on BigQuery Data Transfer Service pricing, see the Pricing page.

After data is transferred to Iceberg managed table, standard storage and query pricing applies.