Shopify

1
create extension if not exists wrappers with schema extensions;

1
create foreign data wrapper wasm_wrapper
2
  handler wasm_fdw_handler
3
  validator wasm_fdw_validator;

1
-- Save your Shopify Admin API access token in Vault and retrieve the created `key_id`
2
select vault.create_secret(
3
  '<Shopify API token>', -- Shopify API token
4
  'Shopify',
5
  'Shopify API token for Wrappers'
6
);

1
create schema if not exists shopify;

1
-- create all the foreign tables
2
import foreign schema shopify from server shopify_server into shopify;
3
4
-- or, create selected tables only
5
import foreign schema shopify
6
   limit to ("customers", "products")
7
   from server shopify_server into shopify;
8
9
-- or, create all foreign tables except selected tables
10
import foreign schema shopify
11
   except ("customers")
12
   from server shopify_server into shopify;

1
create foreign table shopify.app (
2
  "apiKey" text,
3
  "appStoreAppUrl" text,
4
  "appStoreDeveloperUrl" text,
5
  "availableAccessScopes" jsonb,
6
  banner jsonb,
7
  description text,
8
  "developerName" text,
9
  "developerType" text,
10
  embedded bool,
11
  "failedRequirements" jsonb,
12
  features jsonb,
13
  feedback jsonb,
14
  handle text,
15
  icon jsonb,
16
  id text,
17
  "installUrl" text,
18
  installation jsonb,
19
  "isPostPurchaseAppInUse" bool,
20
  "optionalAccessScopes" jsonb,
21
  "previouslyInstalled" bool,
22
  "pricingDetails" text,
23
  "pricingDetailsSummary" text,
24
  "privacyPolicyUrl" text,
25
  "publicCategory" text,
26
  published bool,
27
  "requestedAccessScopes" jsonb,
28
  screenshots jsonb,
29
  "shopifyDeveloped" bool,
30
  title text,
31
  "uninstallMessage" text,
32
  "webhookApiVersion" text,
33
  attrs jsonb
34
)
35
  server shopify_server
36
  options (
37
    object 'app'
38
  );

1
create foreign table shopify.businessEntities (
2
  address jsonb,
3
  archived bool,
4
  "companyName" text,
5
  "displayName" text,
6
  id text,
7
  "primary" bool,
8
  "shopifyPaymentsAccount" jsonb,
9
  attrs jsonb
10
)
11
  server shopify_server
12
  options (
13
    object 'businessEntities'
14
  );

1
create foreign table shopify.collections (
2
  "availablePublicationsCount" jsonb,
3
  description text,
4
  "descriptionHtml" text,
5
  events jsonb,
6
  feedback jsonb,
7
  handle text,
8
  "hasProduct" bool,
9
  id text,
10
  image jsonb,
11
  "legacyResourceId" bigint,
12
  metafields jsonb,
13
  products jsonb,
14
  "productsCount" jsonb,
15
  "publishedOnCurrentPublication" bool,
16
  "publishedOnPublication" bool,
17
  "resourcePublications" jsonb,
18
  "resourcePublicationsCount" jsonb,
19
  "resourcePublicationsV2" jsonb,
20
  "ruleSet" jsonb,
21
  seo jsonb,
22
  "sortOrder" text,
23
  "templateSuffix" text,
24
  title text,
25
  "unpublishedPublications" jsonb,
26
  "updatedAt" timestamp,
27
  attrs jsonb
28
)
29
  server shopify_server
30
  options (
31
    object 'collections'
32
  );

1
create foreign table shopify.customerPaymentMethod (
2
  customer jsonb,
3
  id text,
4
  instrument text,
5
  "revokedAt" timestamp,
6
  "revokedReason" text,
7
  "subscriptionContracts" jsonb,
8
  attrs jsonb
9
)
10
  server shopify_server
11
  options (
12
    object 'customerPaymentMethod'
13
  );

1
create foreign table shopify.customers (
2
  addresses jsonb,
3
  "addressesV2" jsonb,
4
  "amountSpent" jsonb,
5
  "canDelete" bool,
6
  "companyContactProfiles" jsonb,
7
  "createdAt" timestamp,
8
  "dataSaleOptOut" bool,
9
  "defaultAddress" jsonb,
10
  "defaultEmailAddress" jsonb,
11
  "defaultPhoneNumber" jsonb,
12
  "displayName" text,
13
  events jsonb,
14
  "firstName" text,
15
  id text,
16
  image jsonb,
17
  "lastName" text,
18
  "lastOrder" jsonb,
19
  "legacyResourceId" bigint,
20
  "lifetimeDuration" text,
21
  locale text,
22
  mergeable jsonb,
23
  metafields jsonb,
24
  "multipassIdentifier" text,
25
  note text,
26
  "numberOfOrders" bigint,
27
  orders jsonb,
28
  "paymentMethods" jsonb,
29
  "productSubscriberStatus" text,
30
  state text,
31
  "statistics" jsonb,
32
  "storeCreditAccounts" jsonb,
33
  "subscriptionContracts" jsonb,
34
  tags text,
35
  "taxExempt" bool,
36
  "taxExemptions" text,
37
  "updatedAt" timestamp,
38
  "verifiedEmail" bool,
39
  attrs jsonb
40
)
41
  server shopify_server
42
  options (
43
    object 'customers'
44
  );

1
create foreign table shopify.draftorders (
2
  "acceptAutomaticDiscounts" bool,
3
  "allVariantPricesOverridden" bool,
4
  "allowDiscountCodesInCheckout" bool,
5
  "anyVariantPricesOverridden" bool,
6
  "appliedDiscount" jsonb,
7
  "billingAddress" jsonb,
8
  "billingAddressMatchesShippingAddress" bool,
9
  "completedAt" timestamp,
10
  "createdAt" timestamp,
11
  "currencyCode" text,
12
  "customAttributes" jsonb,
13
  customer jsonb,
14
  "defaultCursor" text,
15
  "discountCodes" jsonb,
16
  email text,
17
  events jsonb,
18
  "hasTimelineComment" bool,
19
  id text,
20
  "invoiceEmailTemplateSubject" text,
21
  "invoiceSentAt" timestamp,
22
  "invoiceUrl" text,
23
  "legacyResourceId" bigint,
24
  "lineItems" jsonb,
25
  "lineItemsSubtotalPrice" jsonb,
26
  "localizedFields" jsonb,
27
  metafields jsonb,
28
  "name" text,
29
  note2 text,
30
  "order" jsonb,
31
  "paymentTerms" jsonb,
32
  phone text,
33
  "platformDiscounts" jsonb,
34
  "poNumber" text,
35
  "presentmentCurrencyCode" text,
36
  "purchasingEntity" text,
37
  ready bool,
38
  "reserveInventoryUntil" timestamp,
39
  "shippingAddress" jsonb,
40
  "shippingLine" jsonb,
41
  status text,
42
  "subtotalPriceSet" jsonb,
43
  tags jsonb,
44
  "taxExempt" bool,
45
  "taxLines" jsonb,
46
  "taxesIncluded" bool,
47
  "totalDiscountsSet" jsonb,
48
  "totalLineItemsPriceSet" jsonb,
49
  "totalPriceSet" jsonb,
50
  "totalQuantityOfLineItems" bigint,
51
  "totalShippingPriceSet" jsonb,
52
  "totalTaxSet" jsonb,
53
  "totalWeight" bigint,
54
  "transformerFingerprint" text,
55
  "updatedAt" timestamp,
56
  "visibleToCustomer" bool,
57
  warnings jsonb,
58
  attrs jsonb
59
)
60
  server shopify_server
61
  options (
62
    object 'draftOrders'
63
  );

1
create foreign table shopify.fulfillment (
2
  "createdAt" timestamp,
3
  "deliveredAt" timestamp,
4
  "displayStatus" text,
5
  "estimatedDeliveryAt" timestamp,
6
  events jsonb,
7
  "fulfillmentLineItems" jsonb,
8
  "fulfillmentOrders" jsonb,
9
  id text,
10
  "inTransitAt" timestamp,
11
  "legacyResourceId" bigint,
12
  "location" jsonb,
13
  "name" text,
14
  "order" jsonb,
15
  "originAddress" jsonb,
16
  "requiresShipping" bool,
17
  service jsonb,
18
  status text,
19
  "totalQuantity" bigint,
20
  "trackingInfo" jsonb,
21
  "updatedAt" timestamp,
22
  attrs jsonb
23
)
24
  server shopify_server
25
  options (
26
    object 'fulfillment'
27
  );

1
create foreign table shopify.fulfillmentorders (
2
  "assignedLocation" jsonb,
3
  "channelId" text,
4
  "createdAt" timestamp,
5
  "deliveryMethod" jsonb,
6
  destination jsonb,
7
  "fulfillAt" timestamp,
8
  "fulfillBy" timestamp,
9
  "fulfillmentHolds" jsonb,
10
  "fulfillmentOrdersForMerge" jsonb,
11
  fulfillments jsonb,
12
  id text,
13
  "internationalDuties" jsonb,
14
  "lineItems" jsonb,
15
  "locationsForMove" jsonb,
16
  "merchantRequests" jsonb,
17
  "order" jsonb,
18
  "orderId" text,
19
  "orderName" text,
20
  "orderProcessedAt" timestamp,
21
  "requestStatus" text,
22
  status text,
23
  "supportedActions" jsonb,
24
  "updatedAt" timestamp,
25
  attrs jsonb
26
)
27
  server shopify_server
28
  options (
29
    object 'fulfillmentOrders'
30
  );

1
create foreign table shopify.inventorylevel (
2
  "canDeactivate" bool,
3
  "createdAt" timestamp,
4
  "deactivationAlert" text,
5
  id text,
6
  item jsonb,
7
  "location" jsonb,
8
  "scheduledChanges" jsonb,
9
  "updatedAt" timestamp,
10
  attrs jsonb
11
)
12
  server shopify_server
13
  options (
14
    object 'inventoryLevel'
15
  );

1
create foreign table shopify.locations (
2
  activatable bool,
3
  address jsonb,
4
  "addressVerified" bool,
5
  "createdAt" timestamp,
6
  deactivatable bool,
7
  "deactivatedAt" text,
8
  deletable bool,
9
  "fulfillmentService" jsonb,
10
  "fulfillsOnlineOrders" bool,
11
  "hasActiveInventory" bool,
12
  "hasUnfulfilledOrders" bool,
13
  id text,
14
  "inventoryLevels" jsonb,
15
  "isActive" bool,
16
  "isFulfillmentService" bool,
17
  "legacyResourceId" bigint,
18
  "localPickupSettingsV2" jsonb,
19
  metafields jsonb,
20
  "name" text,
21
  "shipsInventory" bool,
22
  "suggestedAddresses" jsonb,
23
  "updatedAt" timestamp,
24
  attrs jsonb
25
)
26
  server shopify_server
27
  options (
28
    object 'locations'
29
  );

1
create foreign table shopify.orders (
2
  "additionalFees" jsonb,
3
  agreements jsonb,
4
  alerts jsonb,
5
  app jsonb,
6
  "billingAddress" jsonb,
7
  "billingAddressMatchesShippingAddress" bool,
8
  "canMarkAsPaid" bool,
9
  "canNotifyCustomer" bool,
10
  "cancelReason" text,
11
  cancellation jsonb,
12
  "cancelledAt" timestamp,
13
  capturable bool,
14
  "cartDiscountAmountSet" jsonb,
15
  "channelInformation" jsonb,
16
  "clientIp" text,
17
  closed bool,
18
  "closedAt" timestamp,
19
  "confirmationNumber" text,
20
  confirmed bool,
21
  "createdAt" timestamp,
22
  "currencyCode" text,
23
  "currentCartDiscountAmountSet" jsonb,
24
  "currentShippingPriceSet" jsonb,
25
  "currentSubtotalLineItemsQuantity" bigint,
26
  "currentSubtotalPriceSet" jsonb,
27
  "currentTaxLines" jsonb,
28
  "currentTotalAdditionalFeesSet" jsonb,
29
  "currentTotalDiscountsSet" jsonb,
30
  "currentTotalDutiesSet" jsonb,
31
  "currentTotalPriceSet" jsonb,
32
  "currentTotalTaxSet" jsonb,
33
  "currentTotalWeight" bigint,
34
  "customAttributes" jsonb,
35
  customer jsonb,
36
  "customerAcceptsMarketing" bool,
37
  "customerJourneySummary" jsonb,
38
  "customerLocale" text,
39
  "discountApplications" jsonb,
40
  "discountCode" text,
41
  "discountCodes" jsonb,
42
  "displayAddress" jsonb,
43
  "displayFinancialStatus" text,
44
  "displayFulfillmentStatus" text,
45
  disputes jsonb,
46
  "dutiesIncluded" bool,
47
  edited bool,
48
  email text,
49
  "estimatedTaxes" bool,
50
  events jsonb,
51
  fulfillable bool,
52
  "fulfillmentOrders" jsonb,
53
  fulfillments jsonb,
54
  "fulfillmentsCount" jsonb,
55
  "fullyPaid" bool,
56
  "hasTimelineComment" bool,
57
  id text,
58
  "legacyResourceId" bigint,
59
  "lineItems" jsonb,
60
  "localizedFields" jsonb,
61
  "merchantBusinessEntity" jsonb,
62
  "merchantEditable" bool,
63
  "merchantEditableErrors" jsonb,
64
  "merchantOfRecordApp" jsonb,
65
  metafields jsonb,
66
  "name" text,
67
  "netPaymentSet" jsonb,
68
  "nonFulfillableLineItems" jsonb,
69
  note text,
70
  "number" bigint,
71
  "originalTotalAdditionalFeesSet" jsonb,
72
  "originalTotalDutiesSet" jsonb,
73
  "originalTotalPriceSet" jsonb,
74
  "paymentCollectionDetails" jsonb,
75
  "paymentGatewayNames" text,
76
  "paymentTerms" jsonb,
77
  phone text,
78
  "poNumber" text,
79
  "presentmentCurrencyCode" text,
80
  "processedAt" timestamp,
81
  "publication" jsonb,
82
  "refundDiscrepancySet" jsonb,
83
  refundable bool,
84
  refunds jsonb,
85
  "registeredSourceUrl" text,
86
  "requiresShipping" bool,
87
  restockable bool,
88
  "retailLocation" jsonb,
89
  "returnStatus" text,
90
  "returns" jsonb,
91
  risk jsonb,
92
  "shippingAddress" jsonb,
93
  "shippingLine" jsonb,
94
  "shippingLines" jsonb,
95
  "shopifyProtect" jsonb,
96
  "sourceIdentifier" text,
97
  "sourceName" text,
98
  "staffMember" jsonb,
99
  "statusPageUrl" text,
100
  "subtotalLineItemsQuantity" bigint,
101
  "subtotalPriceSet" jsonb,
102
  "suggestedRefund" jsonb,
103
  tags jsonb,
104
  "taxExempt" bool,
105
  "taxLines" jsonb,
106
  "taxesIncluded" bool,
107
  test bool,
108
  "totalCapturableSet" jsonb,
109
  "totalCashRoundingAdjustment" jsonb,
110
  "totalDiscountsSet" jsonb,
111
  "totalOutstandingSet" jsonb,
112
  "totalPriceSet" jsonb,
113
  "totalReceivedSet" jsonb,
114
  "totalRefundedSet" jsonb,
115
  "totalRefundedShippingSet" jsonb,
116
  "totalShippingPriceSet" jsonb,
117
  "totalTaxSet" jsonb,
118
  "totalTipReceivedSet" jsonb,
119
  "totalWeight" bigint,
120
  transactions jsonb,
121
  "transactionsCount" jsonb,
122
  unpaid bool,
123
  "updatedAt" timestamp,
124
  attrs jsonb
125
)
126
  server shopify_server
127
  options (
128
    object 'orders'
129
  );

1
create foreign table shopify.products  (
2
  "availablePublicationsCount" jsonb,
3
  "bundleComponents" jsonb,
4
  category jsonb,
5
  collections jsonb,
6
  "combinedListing" jsonb,
7
  "combinedListingRole" text,
8
  "compareAtPriceRange" jsonb,
9
  "createdAt" timestamp,
10
  "defaultCursor" text,
11
  description text,
12
  "descriptionHtml" text,
13
  events jsonb,
14
  "featuredMedia" jsonb,
15
  feedback jsonb,
16
  "giftCardTemplateSuffix" text,
17
  handle text,
18
  "hasOnlyDefaultVariant" bool,
19
  "hasOutOfStockVariants" bool,
20
  "hasVariantsThatRequiresComponents" bool,
21
  id text,
22
  "inCollection" bool,
23
  "isGiftCard" bool,
24
  "legacyResourceId" bigint,
25
  media jsonb,
26
  "mediaCount" jsonb,
27
  metafields jsonb,
28
  "onlineStorePreviewUrl" text,
29
  "onlineStoreUrl" text,
30
  "options" jsonb,
31
  "priceRangeV2" jsonb,
32
  "productComponents" jsonb,
33
  "productComponentsCount" jsonb,
34
  "productParents" jsonb,
35
  "productType" text,
36
  "publishedAt" timestamp,
37
  "publishedInContext" bool,
38
  "publishedOnCurrentPublication" bool,
39
  "publishedOnPublication" bool,
40
  "requiresSellingPlan" bool,
41
  "resourcePublicationOnCurrentPublication" jsonb,
42
  "resourcePublications" jsonb,
43
  "resourcePublicationsCount" jsonb,
44
  "resourcePublicationsV2" jsonb,
45
  "sellingPlanGroups" jsonb,
46
  "sellingPlanGroupsCount" jsonb,
47
  seo jsonb,
48
  status text,
49
  tags jsonb,
50
  "templateSuffix" text,
51
  title text,
52
  "totalInventory" bigint,
53
  "tracksInventory" bool,
54
  "unpublishedPublications" jsonb,
55
  "updatedAt" timestamp,
56
  variants jsonb,
57
  "variantsCount" jsonb,
58
  vendor text,
59
  attrs jsonb
60
)
61
  server shopify_server
62
  options (
63
    object 'products'
64
  );

1
create foreign table shopify.productvariants (
2
  "availableForSale" bool,
3
  barcode text,
4
  "compareAtPrice" text,
5
  "createdAt" timestamp,
6
  "defaultCursor" text,
7
  "deliveryProfile" jsonb,
8
  "displayName" text,
9
  events jsonb,
10
  id text,
11
  image jsonb,
12
  "inventoryItem" jsonb,
13
  "inventoryPolicy" text,
14
  "inventoryQuantity" bigint,
15
  "legacyResourceId" bigint,
16
  media jsonb,
17
  metafields jsonb,
18
  "position" bigint,
19
  price numeric,
20
  product jsonb,
21
  "productParents" jsonb,
22
  "productVariantComponents" jsonb,
23
  "requiresComponents" bool,
24
  "selectedOptions" jsonb,
25
  "sellableOnlineQuantity" bigint,
26
  "sellingPlanGroups" jsonb,
27
  "sellingPlanGroupsCount" jsonb,
28
  "showUnitPrice" bool,
29
  sku text,
30
  taxable bool,
31
  title text,
32
  "unitPrice" jsonb,
33
  "unitPriceMeasurement" jsonb,
34
  "updatedAt" timestamp,
35
  attrs jsonb
36
)
37
  server shopify_server
38
  options (
39
    object 'productVariants'
40
  );

1
create foreign table shopify.refund (
2
  "createdAt" timestamp,
3
  duties jsonb,
4
  id text,
5
  "legacyResourceId" bigint,
6
  note text,
7
  "order" jsonb,
8
  "orderAdjustments" jsonb,
9
  "refundLineItems" jsonb,
10
  "refundShippingLines" jsonb,
11
  "return" jsonb,
12
  "staffMember" jsonb,
13
  "totalRefundedSet" jsonb,
14
  transactions jsonb,
15
  "updatedAt" timestamp,
16
  attrs jsonb
17
)
18
  server shopify_server
19
  options (
20
    object 'refund'
21
  );

1
create foreign table shopify.return (
2
  "closedAt" timestamp,
3
  "createdAt" timestamp,
4
  decline jsonb,
5
  "exchangeLineItems" jsonb,
6
  id text,
7
  "name" text,
8
  "order" jsonb,
9
  refunds jsonb,
10
  "requestApprovedAt" timestamp,
11
  "returnLineItems" jsonb,
12
  "returnShippingFees" jsonb,
13
  "reverseFulfillmentOrders" jsonb,
14
  status text,
15
  "totalQuantity" bigint,
16
  attrs jsonb
17
)
18
  server shopify_server
19
  options (
20
    object 'return'
21
  );

1
create foreign table shopify.shop (
2
  "accountOwner" jsonb,
3
  alerts jsonb,
4
  "allProductCategoriesList" jsonb,
5
  "availableChannelApps" jsonb,
6
  "billingAddress" jsonb,
7
  "channelDefinitionsForInstalledChannels" jsonb,
8
  "checkoutApiSupported" bool,
9
  "contactEmail" text,
10
  "countriesInShippingZones" jsonb,
11
  "createdAt" timestamp,
12
  "currencyCode" text,
13
  "currencyFormats" jsonb,
14
  "currencySettings" jsonb,
15
  "customerAccounts" text,
16
  "customerAccountsV2" jsonb,
17
  "customerTags" jsonb,
18
  description text,
19
  "draftOrderTags" jsonb,
20
  email text,
21
  "enabledPresentmentCurrencies" text,
22
  entitlements jsonb,
23
  features jsonb,
24
  "fulfillmentServices" jsonb,
25
  "ianaTimezone" text,
26
  id text,
27
  "marketingSmsConsentEnabledAtCheckout" bool,
28
  "merchantApprovalSignals" jsonb,
29
  metafields jsonb,
30
  "myshopifyDomain" text,
31
  "name" text,
32
  "navigationSettings" jsonb,
33
  "orderNumberFormatPrefix" text,
34
  "orderNumberFormatSuffix" text,
35
  "orderTags" jsonb,
36
  "paymentSettings" jsonb,
37
  plan jsonb,
38
  "primaryDomain" jsonb,
39
  "resourceLimits" jsonb,
40
  "richTextEditorUrl" text,
41
  "searchFilters" jsonb,
42
  "setupRequired" bool,
43
  "shipsToCountries" json,
44
  "shopOwnerName" text,
45
  "shopPolicies" jsonb,
46
  "storefrontAccessTokens" jsonb,
47
  "taxShipping" bool,
48
  "taxesIncluded" bool,
49
  "timezoneAbbreviation" text,
50
  "timezoneOffset" text,
51
  "timezoneOffsetMinutes" bigint,
52
  "transactionalSmsDisabled" bool,
53
  "unitSystem" text,
54
  "updatedAt" timestamp,
55
  url text,
56
  "weightUnit" text,
57
  attrs jsonb
58
)
59
  server shopify_server
60
  options (
61
    object 'shop'
62
  );

1
create foreign table shopify.storeCreditAccount (
2
  balance jsonb,
3
  id text,
4
  "owner" jsonb,
5
  transactions jsonb,
6
  attrs jsonb
7
)
8
  server shopify_server
9
  options (
10
    object 'storeCreditAccount'
11
  );

1
create foreign table shopify.customers (
2
  addresses jsonb,
3
  "addressesV2" jsonb,
4
  "amountSpent" jsonb,
5
  "canDelete" bool,
6
  "companyContactProfiles" jsonb,
7
  "createdAt" timestamp,
8
  "dataSaleOptOut" bool,
9
  "defaultAddress" jsonb,
10
  "defaultEmailAddress" jsonb,
11
  "defaultPhoneNumber" jsonb,
12
  "displayName" text,
13
  events jsonb,
14
  "firstName" text,
15
  id text,
16
  image jsonb,
17
  "lastName" text,
18
  "lastOrder" jsonb,
19
  "legacyResourceId" bigint,
20
  "lifetimeDuration" text,
21
  locale text,
22
  mergeable jsonb,
23
  metafields jsonb,
24
  "multipassIdentifier" text,
25
  note text,
26
  "numberOfOrders" bigint,
27
  orders jsonb,
28
  "paymentMethods" jsonb,
29
  "productSubscriberStatus" text,
30
  state text,
31
  "statistics" jsonb,
32
  "storeCreditAccounts" jsonb,
33
  "subscriptionContracts" jsonb,
34
  tags text,
35
  "taxExempt" bool,
36
  "taxExemptions" text,
37
  "updatedAt" timestamp,
38
  "verifiedEmail" bool,
39
  attrs jsonb
40
)
41
  server shopify_server
42
  options (
43
    object 'customers'
44
  );
45
46
-- query all customers
47
-- Note: limit the number of target columns in the query, otherwise it may
48
-- exceed single query max cost limit imposed by Shopify API
49
select
50
  id,
51
  "displayName",
52
  "addressesV2",
53
  "updatedAt"
54
from
55
  shopify.customers;

1
select
2
  id,
3
  "displayName",
4
  "addressesV2",
5
  "updatedAt"
6
from
7
  shopify.customers
8
where
9
  id = 'gid://shopify/Customer/9236781315159';