21 lines
534 B
Python
21 lines
534 B
Python
from airflow import DAG
|
|
from airflow.providers.postgres.operators.postgres import PostgresOperator
|
|
from datetime import datetime
|
|
|
|
VIEWS = [
|
|
"sells_and_statuses_v",
|
|
]
|
|
|
|
with DAG(
|
|
dag_id="refresh_multiple_matviews",
|
|
start_date=datetime(2024, 1, 1),
|
|
schedule_interval="0 7 * * *",
|
|
catchup=False,
|
|
):
|
|
|
|
for view in VIEWS:
|
|
PostgresOperator(
|
|
task_id=f"refresh_{view.replace('.', '_')}",
|
|
postgres_conn_id="postgres_default",
|
|
sql=f"REFRESH MATERIALIZED VIEW {view};",
|
|
) |