Overview

In this Data Type, you can define all the data about the customers.

Example

In this example, we provide a simple attribute definition.

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).

{
  "persona_id": "82474",
  "prefix": "Herr",
  "firstname": "Marco",
  "lastname": "XXX",
  "street": "Amselweg 3",
  "zipcode": "4538",
  "city": "Oberbipp",
  "phone": "079947xxxx",
  "email": "xxx@hotmail.com",
  "countryID": "CH",
  "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
*	CONTACT	REQUIRED	All the properties of the CONTACT defined type are also main parameters of the doc_user type
contacts	CONTACT	REPEATED	default contacts like for billing and shipping
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_user.json

BigQuery DDL

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