def test_materialized_from_obj_validate_needs_knowledge_date( db_engine_with_events_table): from_obj = FromObj( from_obj= "(select entity_id from events where event_date < '2016-01-01') from_obj", name="myquery", knowledge_date_column='event_date') db_engine_with_events_table.execute(from_obj.create_materialized_table_sql) with pytest.raises(ValueError): from_obj.validate(db_engine_with_events_table)
def test_materialized_from_obj_validate_success(db_engine_with_events_table): from_obj = FromObj(from_obj="events where event_date < '2016-01-01'", name="myquery", knowledge_date_column='event_date') db_engine_with_events_table.execute(from_obj.create_materialized_table_sql) from_obj.validate(db_engine_with_events_table)