Table: shopify_customers

This table shows data for Shopify Customers.

The primary key for this table is id. It supports incremental syncs based on the updated_at column.

Columns

NameType
_cq_source_nameutf8
_cq_sync_timetimestamp[us, tz=UTC]
_cq_iduuid
_cq_parent_iduuid
id (PK)int64
updated_at (Incremental Key)timestamp[us, tz=UTC]
emailutf8
accepts_marketingbool
created_attimestamp[us, tz=UTC]
first_nameutf8
last_nameutf8
orders_countint64
stateutf8
total_spentutf8
last_order_idint64
verified_emailbool
tax_exemptbool
tagsutf8
last_order_nameutf8
currencyutf8
addressesjson
accepts_marketing_updated_attimestamp[us, tz=UTC]
marketing_opt_in_levelutf8
tax_exemptionsjson
email_marketing_consentjson
admin_graphql_api_idutf8
default_addressjson