Overview

This data type contains the list of languages.

Example

In this example, we provide a language 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).

{
  "language": "de",
  "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
language	STRING	REQUIRED	the language code : 'de', 'fr', 'en', 'it', ...
country_code	STRING	REQUIRED	optional, needed only to differentiate two diffrent ways to address the same language (e.g.: 'ch', 'de', ...), if used, the language_code used in other tables must be of the format '[country_code]-[language_code]', like 'ch-de' and 'de-de'
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_language.json

BigQuery DDL

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