Pad71 commented on issue #42440:
URL: https://github.com/apache/airflow/issues/42440#issuecomment-2379164318
create or replace view v_sla_definitions as
select
DEF.ID as SLA_ID
, DEF.NAME
, DEF.DESCR
, DEF.SLA_TYPE_ID
, CONA.NAME as CONTEXT_AREA
, CON.NAME as CONTEXT
, TARG.NAME as TARGET
, TARG.SLA_TARGET_TYPE_ID as TARGET_TYPE
, DEF.SLA_PERIOD_ID
, DEF.SLA_START_TYPE_ID
, DEF.SLA_START_TYPE_CUST_PAR
, DEF.SLA_END_TYPE_ID
, DEF.SLA_END_TYPE_CUST_PAR
, DEF.MAX_DURATION
, DEF.SLA_DURATION_UNIT_ID
from SLA_DEFINITION DEF
join SLA_CONTEXT CON on DEF.SLA_CONTEXT_ID = CON.ID
join SLA_CONTEXT_AREA CONA on CON.SLA_CONTEXT_AREA_ID = CONA.ID
join SLA_TARGET TARG on DEF.SLA_TARGET_ID = TARG.ID
order by DEF.ID;
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
