def create_example_version_pointer(table1_number, table2_number, **properties): version_pointer = create_typed_table( Table('dv', f'example_{table1_number}_{table2_number}_vp', [ Column(f'example{table1_number}_m_key', 'text'), Column(f'example{table2_number}_c_key', 'text'), Column(f'example{table2_number}_c_load_dts', 'numeric'), Column('load_dts', 'numeric'), ], **properties)) version_pointer.check() return version_pointer
def create_example_link_satellite(table1_number, table2_number, **properties): link_satellite = create_typed_table( Table('dv', f'example_{table1_number}_{table2_number}_l_s', [ Column(f'example_{table1_number}_{table2_number}_l_key', 'text'), Column('load_dts', 'numeric'), Column('effective_ts', 'numeric'), Column('rec_src', 'text'), ], **properties)) link_satellite.check() return link_satellite
def create_customer_h(self, **properties): target_table = create_typed_table( Table('db', 'customer_h', [ Column('customer_key', 'text'), Column('ssn', 'text'), Column('load_dts', 'numeric'), Column('rec_src', 'text'), ], **properties)) target_table.check() return target_table
def create_example_hub(table_number="", **properties): hub = create_typed_table( Table('dv', f'example{table_number}_h', [ Column(f'example{table_number}_key', 'text'), Column('example_id1', 'text'), Column('example_id2', 'numeric'), Column('load_dts', 'numeric'), Column('rec_src', 'text'), ], **properties)) hub.check() return hub
def create_example_satellite(self, table_number="", **properties): satellite = create_typed_table( Table('dv', f'example{table_number}_s', [ Column(f'example{table_number}_key', 'text'), Column('load_dts', 'numeric'), Column('attribute1', 'text'), Column('attribute2', 'numeric'), Column('rec_src', 'text'), ], **properties)) satellite.check() return satellite
def create_example_link(self, **properties): link = create_typed_table( Table('dv', 'example_l', [ Column('example_l_key', 'text'), Column('example1_key', 'text'), Column('example2_key', 'text'), Column('load_dts', 'numeric'), Column('rec_src', 'text'), ], **properties)) link.check() return link