Biglake table partition from external delta table in GCS

[Mariela Baron]

Hello Delta Lake Community,

I'm using this query in BigQuery to conect deltatables in GCS to BigQuery:

CREATE EXTERNAL TABLE `table`

WITH CONNECTION `connection`

OPTIONS (

  format ="DELTA_LAKE",

  uris=['gs://bucket']); 

It works fine, however I can´t partition this created external table with a direct connection to a bucket in GCS.

How to partition this type of external delta tables in Bigquery? Is there any possible way?

Thanks and Regards,

Mariela 

[Micah Kornfield]

Hi Mariela,

For delta lake tables, the partitioning information is automatically inferred from the delta lake partition metadata, you do not need to specify anything.

Thanks,

Micah