entity_table
  • 13 Dec 2022
  • 1 Minute to read
  • Contributors
  • Dark
    Light
  • PDF

entity_table

  • Dark
    Light
  • PDF

Article summary

The entity_table object defines the primary data source containing the singular entities of the Data Product. This becomes the table with which all other tables are representedly aligned.

There are two specific attributes, unique_keys and foreign_keys, that separate the entity_table object from data sources both directly joined or connected as other_tables. Otherwise, all available attributes of the parent table class apply.

{
  "table": "~/dir_with_source_data/tttt.csv",
  "table_alias": "tttt",
  "unique_keys": [
    "uuu1",
    "uuu2"
  ],
  "foreign_keys": [
    "fff1",
    "fff2"
  ],
  "parsers": "config/parsers/tttt_parsers.json"
}

unique_keys

usage: required
The unique_keys attribute is an array of strings which represent the column or columns to use from the source data as the primary key. The values within the referenced columns define the singular entity of the Data Product.

foreign_keys

usage: optional
The foreign_keys attribute is an array of strings which represent a column or columns used for joins that are not the entity of the Data Product.


Was this article helpful?

What's Next