GRAPHQL Data Model
The CData JDBC Driver for Shopify models the Shopify API as relational tables, views, and stored procedures.
To use the GraphQL Data Model, simply set Schema to GraphQL.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Shopify account.
Common tables include:
| Table | Description |
| Shop | Contains general settings and information about the shop. |
| Customers | Lists customers with core profile data, marketing preferences, and tags. |
| Catalogs | Lists product catalogs belonging to the shop for business-to-business (B2B) or channel use. |
| Orders | Lists orders with customer, payment, fulfillment, duty, and tax details. |
| DeliveryProfiles | Lists saved delivery profiles that define shipping logic by product and location. |
| OrderTransactions | Lists payment transactions associated with orders (authorization, capture, refund). |
| Refunds | Represents refunds of items or transactions on an order, with amounts and reasons. |
| RefundLineItems | Lists refund line item records that specify quantities and amounts refunded. |
| Products | Lists products with titles, status, variants, media, and publishing details. |
| ProductVariants | Lists product variants with pricing, inventory tracking, and option values. |
| Collections | Returns manual and automated collections with titles, rules, and publication state. |
| CollectionProducts | Lists products contained within a specified collection. |
| DraftOrders | Lists saved draft orders for manual checkout or invoicing workflows. |
| DraftOrderLineItems | Lists the line items included in a draft order with quantities and prices. |
| Fulfillments | Represents shipments created for orders, including tracking and delivery status. |
| FulfillmentOrders | Lists merchant-managed and third-party fulfillment orders with statuses and assignments. |
| FulfillmentEvents | Lists status events (in transit, delivered) associated with fulfillments. |
| Locations | Lists active inventory locations used for stock, fulfillment, and pickup. |
| InventoryItems | Lists inventory items (SKU-level records) with tracking and cost data. |
| Metafields | Lists metafields attached to one or more resource Ids. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing fulfillment orders, adjusting inventory across locations, and administering store configuration and content.
Using Bulk API
See UseBulkAPI for a more in-depth look at how the driver performs Shopify Bulk Operations.