Changelog
mabl helprelease notesfeature requestssystem status
Back to All
improved

BigQuery Export Supports Partitioned Tables

over 4 years ago by Joseph Lust

To help optimize your BigQuery analytics, support for partitioned tables has been added to the mabl BigQuery export feed integration.

Any new tables created by the integration will now feature partitioning by day.
The table partitions are:

  • journey_run on column start_time
  • plan_run on column start_time
  • run_categorization on column created_time

Partitioned tables in BigQuery allow for optimizing your analytic queries, enabling you to constrain the data scanned, and thus the cost of your BigQuery data warehouse. Additionally, by using day partitioned tables, you can now expire data partitions when they are no longer relevant to your analyses.