Why Aren't My Selected Metafield Tables Syncing?

Question

I selected metafield tables in my Shopify connection schema, but some of them aren't syncing to my destination. Why are they missing, even though I see relevant data in Shopify?

Environment

Connector: Shopify

Answer

Fivetran does not create separate tables for Shopify metafield resources, such as PRODUCT_METAFIELD and CUSTOMER_METAFIELD. Instead, we sync all selected metafields to the METAFIELD table. The metafield resources shown in the Schema tab let you choose which metafields you want to sync, but they don't create separate tables in your destination.

To query metafields for a specific Shopify object type, filter the METAFIELD table using the owner_resource column. For example, to query product metafields, run:

SELECT * FROM METAFIELD WHERE owner_resource = 'product';