[firestore-bigquery-export] Partition Expiration Setting

[sabinayakc]

How to set partition expiration to the table created by this extension?

• I had created a table using this extension with default partition set to MONTH and by TIMESTAMP. However, I would like to delete old partitions after a certain time period.
• I know that by default Big Query moves the inactive partitions to long term storage.

Is this a feature we need to add to the extension? Currently I can't edit the Partition settings via the Big Query UI.

Thank you for your help.

[dackers86]

hi @sabinayakc

This looks to be another parameter we could add to the configuration options.

Adding to our project board for consideration.

Source: https://github.com/googleapis/nodejs-bigquery/blob/main/samples/createTablePartitioned.js