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)
