Skip to content

Instantly share code, notes, and snippets.

@Paul-Gallagher

Paul-Gallagher/ahub dependency.sql

Created April 30, 2021 18:03
Show Gist options
  • Save Paul-Gallagher/6ca430e0a2e85bb3c34a7780a57a4ab1 to your computer and use it in GitHub Desktop.
Save Paul-Gallagher/6ca430e0a2e85bb3c34a7780a57a4ab1 to your computer and use it in GitHub Desktop.
Download ZIP
test gist
Raw
ahub dependency.sql
-- is dependent on cpn_fare_haul_cd, fare_rule_cd and doc_cpn
SELECT c.task_nm, c.refresh_freq_cd, d.task_id, d.dependent_on_task_id, t.*
FROM ah_task_control c
JOIN ah_dependency_control d
ON c.task_nm LIKE '%FARE_%_BASIC_IND_%'
AND c.task_id = d.task_id
AND d.exp_ts > CURRENT_DATE
JOIN ah_task_control t
ON t.task_id = d.dependent_on_task_id
;
@Paul-Gallagher
Copy link
Author

are these gist thingies actually useful for anything ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment