Why Can't I Exclude the ORDER_METADATA and PRODUCT_METADATA Tables From My Connector's Schema?

Question

While configuring my connector's schema, I can exclude some columns from the ORDER_METADATA and PRODUCT_METADATA tables. Why can't I exclude the tables entirely?

Environment

Connector: WooCommerce

Answer

The primary and foreign keys associated with the ORDER_METADATA and PRODUCT_METADATA tables are essential for data integrity and connector functionality. As a result, you can exclude non-key columns from your connector's schema, but it's not possible to exclude columns containing primary keys, and you can't exclude either table entirely.