Connect Shopify to Snowflake with Windsor.ai

shopify

+

snowflake

Store all your Shopify merchant data in Snowflake

About Shopify

Shopify is a commerce platform that allows anyone to set up an online store and sell their products. Merchants can also sell their products in person with Shopify POS. Merchants can sell Physical products, Digital products, Services and consultations, Memberships, Ticketed experiences and Rentals on the Shopify platform.

About Snowflake

Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.

Shopify metrics and dimensions available for streaming into Snowflake

NameTypeDescription
Customer Created at (Timestamp)TIMESTAMPThe date and time (ISO 8601 format) when the customer was created.
Customer CurrencyTEXTThe three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.
Customer Created At (Date)DATEThe date and time (ISO 8601 format) when the customer information was last updated.
Customer E-Mail AddressTEXTThe unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.
Customer First NameTEXTThe customer's first name.
Customer IDNUMERICA unique identifier for the customer.
Customer Last NameTEXTThe customer's last name.
Customer Last Order IDNUMERICThe ID of the customer's last order.
Customer Last Order NameTEXTThe name of the customer's last order. This is directly related to the name field on the Order resource.
Customer Multipass IdentifierNUMERICA unique identifier for the customer that's used with Multipass login.
Customer NoteTEXTA note about the customer.
Customer Orders CountNUMERICThe number of orders associated with this customer.
Customer Phone NumberTEXTThe unique phone number (E.164 format) for this customer.
Customer stateTEXTThe state of the customer's account with a shop (Can be disabled, invited, enabled and declined)
Customer TagsTEXTTags that the shop owner has attached to the customer, formatted as a string of comma-separated values.
Customer Tax ExemptBOOLEANWhether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.
Customer Total SpentNUMERICThe total amount of money that the customer has spent across their order history.
Customer Updated at (Timestamp)TIMESTAMPThe date and time (ISO 8601 format) when the customer information was last updated.
Customer Email VerifiedBOOLEANWhether the customer has verified their email address.
Customer Created at (Timestamp)DATEThe date and time (ISO 8601 format) of the queried object.
Order EmailTEXTThe customers email address.
Order Cancelled AtTIMESTAMPThe date and time ( ISO 8601 format) when the order was canceled.
Order Closed AtTIMESTAMPThe date and time (ISO 8601 format) when the order was closed.
Order Created AtTIMESTAMPThe autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.
Order CurrencyTEXTThe three-letter code (ISO 4217 format) for the shop currency.
Order Current Subtotal PriceNUMERICThe current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total DiscountsNUMERICThe current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total PriceNUMERICThe current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.
Order Current Total TaxNUMERICThe current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.
Order EmailTEXTThe customers email address.
Order Payment StatusTEXTThe status of payments associated with the order. Can only be set when the order is created.
Order IDTEXTThe unique identifier of the order
Order nameTEXTThe name of the order
Order noteTEXTAn optional note that a shop owner can attach to the order.
Order tagsTEXTTags attached to the order
Order Updated AtTIMESTAMPThe date and time (ISO 8601 format) when the order was last modified.

Windsor.ai: Easily connect Shopify to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.