Data Lake Config Proposal using EAV pattern

client_module_insert.json

insert API request: 

[
{
  "entity" : "ssp_ratecard",
  "attribute" : "calendar_period_id",
  "bigint_value" : 34567,
  "text_value" : null,
  "double_value" : null,
  "boolean_value" : null
}
]

insert API response:
[
{
  "entity" : "ssp_ratecard",
  "attribute" : "calendar_period_id",
  "identity" : "f1b62db0-a775-11e7-976d-7f5b19983056",
  "bigint_value" : 34567,
  "text_value" : null,
  "double_value" : null,
  "boolean_value" : null,
  "parent_identity" : null,
  "updated_date" : "2017-10-02 13:31:06+0000"
}
]

data_lake_config.cql

  create table IF NOT EXISTS data_lake.lake_config 
  ( entity text,
  	attribute text,
  	identity timeuuid,
  	bigint_value bigint,
  	text_value text,
  	double_value double,
  	boolean_value boolean,
  	parent_identity timeuuid,
  	updated_date timestamp,
  	PRIMARY KEY (entity, attribute, identity) 
  );	
  
  
 insert into data_lake.lake_config ( entity, attribute,identity, bigint_value, updated_date) values ( 'ssp_ratecard', 'division_id',now(), 12345, toTimestamp(now())); 
 
 insert into data_lake.lake_config  (entity, attribute,identity, bigint_value, updated_date, parent_identity) values ('ssp_ratecard', 'ratecard_id', now(),23456, toTimestamp(now()), 85d6ab65-a775-11e7-976d-7f5b19983056);
 

 insert into data_lake.lake_config  (entity, attribute,identity, bigint_value, updated_date, parent_identity) values ('ssp_ratecard', 'calendar_period_id', now(),34567, toTimestamp(now()), c9db63ab-a775-11e7-a337-df2ec9ca83ae);

 insert into data_lake.lake_config  (entity, attribute,identity, bigint_value, updated_date, parent_identity) values ('ssp_ratecard', 'rating_stream_code', now(),45678, toTimestamp(now()), f1b62db0-a775-11e7-976d-7f5b19983056);
 
 select * from data_lake.lake_config;