Shopify Schema Tables

Shopify stores data in structures which do not follow the rules of data typing and structure that apply to traditional relational tables and columns. Because traditional ODBC and JDBC toolsets might not support these data structures, the data needs to be mapped to a relational form. To achieve this, the Simba Shopify ODBC Connector uses schema tables to map the Shopify data to formats that are compatible with ODBC and JDBC.

The schema tables are listed alphabetically by table name. For each table, the following information is provided:

  • The name of the table.
  • Whether the table is a virtual table, and if so, the table that it is contained in.
  • Whether the table contains any virtual tables, and if so, which ones.
  • Any of the columns in the table that are foldable, that is, whether operations on those columns can be delegated to the server instead of the client.
  • A list of all of the columns in the table, with information about the SQL type and whether the column is nullable, updatable, or returnable by ODBC-escaped DML statements.
    • Important:

    Important:

    The connector currently does not support write-back for JDBC connections. Columns that are described as updatable cannot be updated when you connect to Shopify through a JDBC application.