Hi,

WooCommerce has a number of meta data tables that can consume large volumes of MAR unnecessarily.

These are:

- order_metadata
- order_line_item_metadata
- customer_metadata
- product_variation_metadata
- product_metadata

If you exclude the columns from the schema, the system continues to populate their related tables with the basic reference fields (presumably to maintain data integrity).

 The problem is that these tables tend to be used as storage for various (and numerous) plugins so they get very large very quickly.

For example,

- On one database, every order comes with 40 order_metafield records.

- On another unused metadata accounts for around 75% of monthly MAR.

It would be useful to be able to either:

- Remove these tables from the schema. 

- Filter the table by the metafield key.

Business justification:

- Improved business efficiency for Fivetran and client.

- Enhanced competitive offering. There are lots of companies trying to undercut you. No point in charging for stuff that is not used.

Regards,

Phil