Legacy Pipeline Atlas worker-1snapshot 2026-07-15

sub-job

StrideCare · RevFind-Source-LoadAthenaData-33143

called by RevFind-Daily-Processing-Accounts-33143

sub-job StrideCare/RevFind-Source-LoadAthenaData-33143 · db StrideCare_ProdMirror · updated 2026-04-17

task tree

What the sub-job runs

Tasks in order, each with what it does — typed stepsfrom the MDClarity task docs (click to open the reference), sub-jobsyou can expand inline (▶) to reveal their own tasks, and SQL steps summarized by Gemini (✨). Every step shows the tables it writes/reads and which earlier step it feeds from(sqlglot lineage).

sub-job

RevFind-Source-LoadAthenaData-33143

28 tasks · StrideCare
sub-job / Flow action SQL / native step▶ expand a sub-job inline · ↗ open it as its own page · a typed step opens its doc
  1. Merge SourceClaimMergeSql
    writes SourceClaim_33143 · reads CLAIM
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceClaim_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  2. Merge SourceClinicalEncounterMergeSql
    writes SourceClinicalEncounter_33143 · reads CLINICALENCOUNTER
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceClinicalEncounter_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  3. Merge SourceAppointmentMergeSql
    writes SourceAppointment_33143 · reads APPOINTMENTCLAIM
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceAppointment_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  4. Merge SourceTransactionMergeSql
    writes SourceTransaction_33143 · reads CLAIMTRANSACTION
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceTransaction_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  5. Merge SourceTransactionChargeMergeSqldisabled
    writes SourceTransactionCharge_33143 · reads SOURCETRANSACTION_33143
    merge data source type=ThisDatabasetable name=SourceTransactionCharge_33143merge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  6. Merge SourceTransationPaymentMergeSqldisabled
    writes SourceTransactionPayment_33143 · reads SOURCETRANSACTION_33143
    merge data source type=ThisDatabasetable name=SourceTransactionPayment_33143merge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  7. Merge SourceTransactionAdjustmentMergeSqldisabled
    writes SourceTransactionAdjustment_33143 · reads SOURCETRANSACTION_33143
    merge data source type=ThisDatabasetable name=SourceTransactionAdjustment_33143merge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  8. Merge SourceTransactionTransferMergeSqldisabled
    writes SourceTransactionTransfer_33143 · reads SOURCETRANSACTION_33143
    merge data source type=ThisDatabasetable name=SourceTransactionTransfer_33143merge mode=InsertUpdatebulk copy timeout seconds=300bulk copy use table lock
  9. Merge SourceERABatchMergeSql
    writes SourceERABatch_33143 · reads ERABATCH
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceERABatch_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  10. Merge SourceERARecordMergeSql
    writes SourceERARecord_33143 · reads ERARECORD
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceERARecord_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  11. Merge SourceERADetailMergeSql
    writes SourceERADetail_33143 · reads ERADETAILERARECORD
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceERADetail_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  12. Merge SourceERAKickMergeSql
    writes SourceERAKick_33143 · reads ERAKICK
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceERAKick_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  13. Merge SourceClaimNoteMergeSqldisabled
    writes SourceClaimNote_33143 · reads CLAIMNOTE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceClaimNote_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  14. Merge SourceDenialClaimNoteMergeSqldisabled
    writes SourceDenialClaimNote_33143 · reads DENIALCLAIMNOTE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceDenialClaimNote_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  15. Merge SourcePatientMergeSql
    writes SourcePatient_33143 · reads CLAIMPATIENT
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourcePatient_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  16. Merge SourcePayerMergeSql
    writes SourcePayer_33143 · reads INSURANCEPACKAGEPAYER
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourcePayer_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  17. Merge SourcePatientInsuranceMergeSql
    writes SourcePatientInsurance_33143 · reads CLAIMPATIENTINSURANCE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourcePatientInsurance_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  18. Merge SourceProviderMergeSql
    writes SourceProvider_33143 · reads PROVIDER
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceProvider_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  19. Merge SourceDepartmentMergeSql
    writes SourceDepartment_33143 · reads DEPARTMENT
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceDepartment_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  20. Merge SourceAppointmentTypeMergeSql
    writes SourceAppointmentType_33143 · reads APPOINTMENTTYPE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceAppointmentType_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  21. Merge SourceFeeScheduleProcedureMergeSql
    writes SourceFeeScheduleProcedure_33143 · reads FEESCHEDULEPROCEDURE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceFeeScheduleProcedure_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  22. Merge SourceProcedureCodeMergeSql
    writes SourceProcedureCode_33143 · reads PROCEDURECODE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceProcedureCode_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  23. Merge SourceFeeScheduleMergeSql
    writes SourceFeeSchedule_33143 · reads FEESCHEDULE
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceFeeSchedule_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  24. Merge SourceProcedureCodeModifierMergeSql
    writes SourceProcedureCodeModifier_33143 · reads PROCEDURECODEMODIFIER
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceProcedureCodeModifier_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  25. Merge SourceFeeScheduleDepartmentMergeSql
    writes SourceFeeScheduleDepartment_33143 · reads FEESCHEDULEDEPARTMENT
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceFeeScheduleDepartment_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  26. Merge FEESCHEDALLOWABLECATEGORYMergeSql
    writes SourceFeeSchedAllowableCategory_33143 · reads FEESCHEDALLOWABLECATEGORY
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceFeeSchedAllowableCategory_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  27. Merge SourceTimesheetEntryTransactionMergeSql
    writes SourceTimesheetEntryTransaction_33143 · reads TIMESHEETENTRYTIMESHEETENTRYTRANSACTION
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceTimesheetEntryTransaction_33143merge mode=InsertUpdatebulk copy timeout seconds=300
  28. Merge SourceCustomDemographicsMergeSql
    writes SourceCustomDemographics_33143 · reads CUSTOMDEMOGRAPHICS
    merge data source type=Snowflakeconnection string={AthenaConnectionString}table name=SourceCustomDemographics_33143merge mode=InsertUpdatebulk copy timeout seconds=300