doc_language

Content: Languages

List of languages

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