Overview

The doc_attribute_values format contains the list of defined attributes values, their main properties and meta-data.

Many attributes don’t need any attribute_values, only the ones for which additional information are required (e.g.: the category tree, some attribute like color which might have a color code as a value, but can connect this attribute value to additional information, …)

Example

In this example, we provide a simple Category Tree structure.

Here is the example for the first case above (make sure to format it in JSONL before loading to BigQuery: Newline delimited JSON : https://en.wikipedia.org/wiki/JSON_streaming).

{
  "attribute_name": "categories",
  "numerical": true,
  "value_id": "20",
  "value_label": [
    {
      "language": "de",
      "value": "24h-Sortiment"
    }
  ],
  "parent_value_ids": [
    "12"
  ],
  "creation_tm": "2020-10-20 00:00:00",
  "client_id": 1,
  "src_sys_id": 1
}

Properties

Field name	Type	Mode	Description

Field name	Type	Mode	Description
attribute_name	STRING	REQUIRED	the name of the attribute (should match the name of the attribute provided in the doc_product table in either string_attributes, numeric_attributes or localized_numeric_attributes
numerical	BOOLEAN	NULLABLE	are the provided attribute value identifiers numerical? fyi - in this tables, the values are always provided as strings, but not in the doc_products and other tables
value_id	STRING	REQUIRED	the value id to map to it's related value labels (always a string, but must be castable to numeric if numerical = true)
value_label	LOCALIZED	REPEATED	the labels of the value id
parent_value_ids	STRING	REPEATED	the value ids of the parent (only for hierarchical attributes), (always a string, but must be castable to numeric if numerical = true)
products	PRODUCT	REPEATED	connections to products (normally not needed, as should be provided in the doc_product table
stores	STRING	REPEATED	the stores
title	LOCALIZED	REPEATED	the title of the attribute value
short_description	LOCALIZED	REPEATED	the short description of the product group
description	LOCALIZED	REPEATED	the description of the attribute value
images	LIST	REPEATED	the images of the attribute value
link	LOCALIZED	REPEATED	the link of the attribute value
tags	TAG	REPEATED	the tags , e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]
labels	LABEL	REPEATED	the labels of the product line, e.g.: [STRUCT('symbol', 'delivery', '24h', [STRUCT('de', '24-H Versand')])]
pricing	PRICING	NULLABLE	pricing information about the product line, e.g.: STRUCT('discount',[STRUCT('de','Bis:')],[STRUCT('de','-50:')],[STRUCT('de','%')])
visibility	VISIBLITY	REPEATED	the product visibility :VISIBILITY_NOT_VISIBLE = 1; VISIBILITY_IN_CATALOG = 2; VISIBILITY_IN_SEARCH = 3; VISIBILITY_BOTH = 4;
status	STATUS	REPEATED	the product status
periods	PERIOD	REPEATED	information about the activity periods of the attribute value
string_attributes	MAP	REPEATED	additional string (not localized) attributes of the product line (MAP type: STRING)
localized_string_attributes	MAP	REPEATED	additional localized string attributes (MAP type: LOCALIZED in STRING)
numeric_attributes	MAP	REPEATED	additional numeric (not localized) attributes (MAP type: NUMERIC)
localized_numeric_attributes	MAP	REPEATED	additional localized numeric attributes (MAP type: LOCALIZED in NUMERIC)
datetime_attributes	MAP	REPEATED	additional datetime (not localized) attributes (MAP type: DATETIME)
localized_datetime_attributes	MAP	REPEATED	additional localized datetime attributes (MAP type: LOCALIZED inDATETIME)
creation_tm	DATETIME	REQUIRED	technical field
client_id	INTEGER	REQUIRED	technical field
src_sys_id	INTEGER	REQUIRED	technical field

Resources

BigQuery JSON Schema

https://github.com/boxalino/data-integration-doc-schema/blob/master/doc/doc_attribute_value.json

BigQuery DDL

https://github.com/boxalino/data-integration-doc-schema/blob/master/ddl/doc_attribute_value.sql