How do I write a partitioned parquet file from a big query table?

user_5356907 0
Viewed 463

I have created a parquet file from a big query table like this:

 EXPORT DATA
    OPTIONS(
             uri='gs://path_for_parquet_file/*.parquet',
             format='PARQUET',
             overwrite=false
            )
  AS SELECT * FROM `my_project.my_dataset.my_table`;

I want to know if there is a way to partition the parquet file. My big query table is partitioned by a date column.

Thanks,

gcs partition parquet google-bigquery
1 Answers

could not found answer to this question from official docs. my solution to this is write for loop to filter partiotion and export them

user_24125490
Related