> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/bigcommerce-v2/schema-information.md).

# Schema Information

## Tables/APIs 

The following is the list of tables or APIs associated with the BigCommerce v2 connector:

* [Banners](#banners) 
* [Brands](#brands) 
* [Catalog](#catalog) 
* [Categories](#categories) 
* [Coupons](#coupons) 
* [Orders](#orders) 
* [Pricelists](#pricelists) 
* [Product\_images](#product_images) 
* [Product\_reviews](#product_reviews) 
* [Product\_variants](#product_variants) 
* [Products](#products) 
* [Storecurrency](#storecurrency) 
* [Subscribers](#subscribers)

#### Banners 

Retrieves the list of drafted banners associated with the BigCommerce store. For more information on the API, see [BigCommerce v2- banners.](https://developer.bigcommerce.com/docs/rest-content/marketing/banners) 

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>content</td><td>STRING</td></tr><tr><td>page</td><td>STRING</td></tr><tr><td>item_id</td><td>STRING</td></tr><tr><td>location</td><td>STRING</td></tr><tr><td>date_created</td><td>STRING</td></tr><tr><td>date_type</td><td>STRING</td></tr><tr><td>date_from</td><td>STRING</td></tr><tr><td>date_to</td><td>STRING</td></tr><tr><td>visible</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Brands &#x20;

Allows you to create, modify, and delete individual brands linked with the products in your BigCommerce store. For more information on the API, see [BigCommerce v2- brands.](https://developer.bigcommerce.com/docs/rest-catalog/brands)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_keywords</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Catalog&#x20;

Helps to retrieve details such as MPN, warranty, price, and images for each product. The Catalog encompasses a store's assortment of physical and digital products. For more information on the API, see [BigCommerce v2- catalog.](https://developer.bigcommerce.com/docs/rest-catalog#catalog-endpoints)&#x20;

**Fields**

<table><thead><tr><th width="198">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>cost_price</td><td>NUMERIC</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>sale_price</td><td>NUMERIC</td></tr><tr><td>retail_price</td><td>NUMERIC</td></tr><tr><td>weight</td><td>NUMERIC</td></tr><tr><td>width</td><td>NUMERIC</td></tr><tr><td>height</td><td>NUMERIC</td></tr><tr><td>depth</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>purchasing_disabled</td><td>BOOLEAN</td></tr><tr><td>purchasing_disabled_message</td><td>STRING</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>sku_id</td><td>NUMERIC</td></tr><tr><td>option_values</td><td>RECORD</td></tr><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>map_price</td><td>NUMERIC</td></tr><tr><td>calculated_weight</td><td>NUMERIC</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr></tbody></table>

#### Categories&#x20;

Allows a BigCommerce store owner to create, modify, and delete categories. For more information on the API, see [BigCommerce v2- categories.](https://developer.bigcommerce.com/docs/rest-catalog/categories)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>parent_id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>views</td><td>NUMERIC</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_keywords</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>layout_file</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>is_visible</td><td>BOOLEAN</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>default_product_sort</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Coupons&#x20;

Assists in retrieving data linked to a category or product discounts that can be applied to orders for consumers who input a specific code for a specific BigCommerce store. For more information on the API, see [BigCommerce v2- coupons.](https://developer.bigcommerce.com/docs/rest-content/marketing/coupons)&#x20;

**Fields**

<table><thead><tr><th width="164">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>amount</td><td>STRING</td></tr><tr><td>min_purchase</td><td>STRING</td></tr><tr><td>expires</td><td>STRING</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>code</td><td>STRING</td></tr><tr><td>applies_to</td><td>RECORD</td></tr><tr><td>num_uses</td><td>NUMERIC</td></tr><tr><td>max_uses</td><td>NUMERIC</td></tr><tr><td>max_uses_per_customer</td><td>NUMERIC</td></tr><tr><td>restricted_to</td><td>RECORD</td></tr><tr><td>shipping_methods</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Orders&#x20;

Retrieves the data of creating, updating, and deleting orders along with order shipments and order shipping addresses for a BigCommerce store. For more information on the API, see [BigCommerce v2- orders.](https://developer.bigcommerce.com/docs/rest-management/orders)&#x20;

**Fields**

<table><thead><tr><th width="304">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>customer_id</td><td>NUMERIC</td></tr><tr><td>date_created</td><td>DATETIME</td></tr><tr><td>date_modified</td><td>DATETIME</td></tr><tr><td>date_shipped</td><td>STRING</td></tr><tr><td>status_id</td><td>NUMERIC</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>subtotal_ex_tax</td><td>STRING</td></tr><tr><td>subtotal_inc_tax</td><td>STRING</td></tr><tr><td>subtotal_tax</td><td>STRING</td></tr><tr><td>base_shipping_cost</td><td>STRING</td></tr><tr><td>shipping_cost_ex_tax</td><td>STRING</td></tr><tr><td>shipping_cost_inc_tax</td><td>STRING</td></tr><tr><td>shipping_cost_tax</td><td>STRING</td></tr><tr><td>shipping_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>base_handling_cost</td><td>STRING</td></tr><tr><td>handling_cost_ex_tax</td><td>STRING</td></tr><tr><td>handling_cost_inc_tax</td><td>STRING</td></tr><tr><td>handling_cost_tax</td><td>STRING</td></tr><tr><td>handling_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>base_wrapping_cost</td><td>STRING</td></tr><tr><td>wrapping_cost_ex_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_inc_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_tax</td><td>STRING</td></tr><tr><td>wrapping_cost_tax_class_id</td><td>NUMERIC</td></tr><tr><td>total_ex_tax</td><td>STRING</td></tr><tr><td>total_inc_tax</td><td>STRING</td></tr><tr><td>total_tax</td><td>STRING</td></tr><tr><td>items_total</td><td>NUMERIC</td></tr><tr><td>items_shipped</td><td>NUMERIC</td></tr><tr><td>payment_method</td><td>STRING</td></tr><tr><td>payment_status</td><td>STRING</td></tr><tr><td>refunded_amount</td><td>STRING</td></tr><tr><td>order_is_digital</td><td>BOOLEAN</td></tr><tr><td>store_credit_amount</td><td>STRING</td></tr><tr><td>gift_certificate_amount</td><td>STRING</td></tr><tr><td>ip_address</td><td>STRING</td></tr><tr><td>ip_address_v6</td><td>STRING</td></tr><tr><td>geoip_country</td><td>STRING</td></tr><tr><td>geoip_country_iso2</td><td>STRING</td></tr><tr><td>currency_id</td><td>NUMERIC</td></tr><tr><td>currency_code</td><td>STRING</td></tr><tr><td>currency_exchange_rate</td><td>STRING</td></tr><tr><td>default_currency_id</td><td>NUMERIC</td></tr><tr><td>default_currency_code</td><td>STRING</td></tr><tr><td>staff_notes</td><td>STRING</td></tr><tr><td>customer_message</td><td>STRING</td></tr><tr><td>discount_amount</td><td>STRING</td></tr><tr><td>coupon_discount</td><td>STRING</td></tr><tr><td>shipping_address_count</td><td>NUMERIC</td></tr><tr><td>is_deleted</td><td>BOOLEAN</td></tr><tr><td>ebay_order_id</td><td>STRING</td></tr><tr><td>billing_address</td><td>RECORD</td></tr><tr><td>is_email_opt_in</td><td>BOOLEAN</td></tr><tr><td>order_source</td><td>STRING</td></tr><tr><td>channel_id</td><td>NUMERIC</td></tr><tr><td>products</td><td>RECORD</td></tr><tr><td>shipping_addresses</td><td>RECORD</td></tr><tr><td>coupons</td><td>RECORD</td></tr><tr><td>tax_provider_id</td><td>STRING</td></tr><tr><td>customer_locale</td><td>STRING</td></tr><tr><td>external_order_id</td><td>STRING</td></tr><tr><td>store_default_currency_code</td><td>STRING</td></tr><tr><td>store_default_to_transactional_exchange_rate</td><td>STRING</td></tr><tr><td>custom_status</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Pricelists&#x20;

Retrieves the pricing list details assigned to a BigCommerce store's specific sales channel, customer group, or customer group. For more information on the API, see [BigCommerce v2- pricelists.](https://developer.bigcommerce.com/docs/rest-management/price-lists)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>active</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_images&#x20;

Retrieves all the lists of product images associated with a BigCommerce store. For more information on the API, see [BigCommerce v2- product images.](https://developer.bigcommerce.com/docs/rest-catalog/products/images#get-all-product-images)

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>is_thumbnail</td><td>BOOLEAN</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>image_file</td><td>STRING</td></tr><tr><td>url_zoom</td><td>STRING</td></tr><tr><td>url_standard</td><td>STRING</td></tr><tr><td>url_thumbnail</td><td>STRING</td></tr><tr><td>url_tiny</td><td>STRING</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_reviews&#x20;

Retrieves a list of all the reviews associated with a product for a given BigCommerce store. For more information on the API, see [BigCommerce v2- product reviews.](https://developer.bigcommerce.com/docs/rest-catalog/products/reviews#get-product-reviews)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>rating</td><td>NUMERIC</td></tr><tr><td>text</td><td>STRING</td></tr><tr><td>title</td><td>STRING</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>date_reviewed</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Product\_variants&#x20;

Retrieves arbitrary key-value attributes like variant images and their meta fields associated with a BigCommerce store product. For more information on the API, see [BigCommerce v2- product variants.](https://developer.bigcommerce.com/docs/rest-catalog/product-variants)&#x20;

**Fields**

<table><thead><tr><th width="198">Field Name</th><th width="69">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>product_id</td><td>NUMERIC</td></tr><tr><td>sku</td><td>STRING</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>sale_price</td><td>NUMERIC</td></tr><tr><td>retail_price</td><td>NUMERIC</td></tr><tr><td>map_price</td><td>NUMERIC</td></tr><tr><td>weight</td><td>NUMERIC</td></tr><tr><td>width</td><td>NUMERIC</td></tr><tr><td>height</td><td>NUMERIC</td></tr><tr><td>depth</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>calculated_weight</td><td>NUMERIC</td></tr><tr><td>purchasing_disabled</td><td>BOOLEAN</td></tr><tr><td>purchasing_disabled_message</td><td>STRING</td></tr><tr><td>image_url</td><td>STRING</td></tr><tr><td>cost_price</td><td>NUMERIC</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>option_values</td><td>RECORD</td></tr><tr><td>sku_id</td><td>NUMERIC</td></tr></tbody></table>

#### Products&#x20;

Retrieves the list of product variants, variant options, pricing, reviews, images, and videos for a BigCommerce store product, in addition to complex rules, custom fields, and metafields data. For more information on the API, see [BigCommerce v2- products.](https://developer.bigcommerce.com/docs/rest-catalog/products)&#x20;

**Fields**

<table><thead><tr><th width="230">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>calculated_price</td><td>NUMERIC</td></tr><tr><td>categories</td><td>STRING</td></tr><tr><td>brand_id</td><td>NUMERIC</td></tr><tr><td>option_set_id</td><td>NUMERIC</td></tr><tr><td>option_set_display</td><td>STRING</td></tr><tr><td>inventory_level</td><td>NUMERIC</td></tr><tr><td>inventory_warning_level</td><td>NUMERIC</td></tr><tr><td>inventory_tracking</td><td>STRING</td></tr><tr><td>reviews_rating_sum</td><td>NUMERIC</td></tr><tr><td>reviews_count</td><td>NUMERIC</td></tr><tr><td>total_sold</td><td>NUMERIC</td></tr><tr><td>fixed_cost_shipping_price</td><td>NUMERIC</td></tr><tr><td>is_free_shipping</td><td>BOOLEAN</td></tr><tr><td>is_visible</td><td>BOOLEAN</td></tr><tr><td>is_featured</td><td>BOOLEAN</td></tr><tr><td>related_products</td><td>STRING</td></tr><tr><td>warranty</td><td>STRING</td></tr><tr><td>bin_picking_number</td><td>STRING</td></tr><tr><td>layout_file</td><td>STRING</td></tr><tr><td>upc</td><td>STRING</td></tr><tr><td>mpn</td><td>STRING</td></tr><tr><td>gtin</td><td>STRING</td></tr><tr><td>search_keywords</td><td>STRING</td></tr><tr><td>availability</td><td>STRING</td></tr><tr><td>availability_description</td><td>STRING</td></tr><tr><td>gift_wrapping_options_type</td><td>STRING</td></tr><tr><td>sort_order</td><td>NUMERIC</td></tr><tr><td>condition</td><td>STRING</td></tr><tr><td>is_condition_shown</td><td>BOOLEAN</td></tr><tr><td>order_quantity_minimum</td><td>NUMERIC</td></tr><tr><td>order_quantity_maximum</td><td>NUMERIC</td></tr><tr><td>page_title</td><td>STRING</td></tr><tr><td>meta_description</td><td>STRING</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>view_count</td><td>NUMERIC</td></tr><tr><td>preorder_message</td><td>STRING</td></tr><tr><td>is_preorder_only</td><td>BOOLEAN</td></tr><tr><td>is_price_hidden</td><td>BOOLEAN</td></tr><tr><td>price_hidden_label</td><td>STRING</td></tr><tr><td>custom_url</td><td>RECORD</td></tr><tr><td>base_variant_id</td><td>NUMERIC</td></tr><tr><td>open_graph_type</td><td>STRING</td></tr><tr><td>open_graph_title</td><td>STRING</td></tr><tr><td>open_graph_description</td><td>STRING</td></tr><tr><td>open_graph_use_meta_description</td><td>BOOLEAN</td></tr><tr><td>open_graph_use_product_name</td><td>BOOLEAN</td></tr><tr><td>open_graph_use_image</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Storecurrency&#x20;

Retrieves the data related to the alternate currency display options on the storefront for a BigCommerce store. For more information on the API, see [BigCommerce v2- storecurrency](https://developer.bigcommerce.com/docs/rest-management/currencies).

**Fields**

<table><thead><tr><th width="177">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>id</td><td>NUMERIC</td></tr><tr><td>is_default</td><td>BOOLEAN</td></tr><tr><td>last_updated</td><td>TIMESTAMP</td></tr><tr><td>country_iso2</td><td>STRING</td></tr><tr><td>currency_code</td><td>STRING</td></tr><tr><td>currency_exchange_rate</td><td>STRING</td></tr><tr><td>auto_update</td><td>BOOLEAN</td></tr><tr><td>token_location</td><td>STRING</td></tr><tr><td>token</td><td>STRING</td></tr><tr><td>decimal_token</td><td>STRING</td></tr><tr><td>thousands_token</td><td>STRING</td></tr><tr><td>decimal_places</td><td>NUMERIC</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>enabled</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>default_for_country_codes</td><td>STRING</td></tr><tr><td>is_transactional</td><td>BOOLEAN</td></tr><tr><td>use_default_name</td><td>BOOLEAN</td></tr></tbody></table>

#### Subscribers&#x20;

Retrieves the data related to subscribers for a BigCommerce store. For more information on the API, see [BigCommerce v2- subscribers.](https://developer.bigcommerce.com/docs/rest-management/subscribers)&#x20;

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="83">Data Type</th></tr></thead><tbody><tr><td>email</td><td>STRING</td></tr><tr><td>first_name</td><td>STRING</td></tr><tr><td>last_name</td><td>STRING</td></tr><tr><td>source</td><td>STRING</td></tr><tr><td>order_id</td><td>NUMERIC</td></tr><tr><td>channel_id</td><td>NUMERIC</td></tr><tr><td>id</td><td>NUMERIC</td></tr><tr><td>date_modified</td><td>TIMESTAMP</td></tr><tr><td>date_created</td><td>TIMESTAMP</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr><tr><td>consents</td><td>STRING</td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/bigcommerce-v2/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.