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

sub-job

EyeSouth · Load-From-NextTech

called by Daily-Processing

sub-job EyeSouth/Load-From-NextTech · db EyeSouth_ProdMirror · updated 2025-09-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

Load-From-NextTech

25 tasks · EyeSouth
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. ImportSqlImportSqldisabled
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechTest
    connection=EyeSouth_ProdMirror-sqlserversql file=sql/load_from_nexttech__importsql.sqltable name=ImportNextTechTestimport mode=Replacedata source type=SqlServer
  2. PracticePlusPracticePlusdisabled
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPTest
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPTestimport mode=Replacedata source type=SqlServerDISABLED
  3. PracticePlus Charge ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPCharge
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPChargeimport mode=Replacedata source type=SqlServer
  4. PracticePlus Adjustment ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPAdjustment
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPAdjustmentimport mode=Replacedata source type=SqlServer
  5. PracticePlus Payment ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPPayment
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPPaymentimport mode=Replacedata source type=SqlServer
  6. PracticePlus Encounter ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPEncounter
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPEncounterimport mode=Replacedata source type=SqlServer
  7. PracticePlus Facility ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPFacility
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPFacilityimport mode=Replacedata source type=SqlServer
  8. PracticePlus Provider ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPProvider
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPProviderimport mode=Replacedata source type=SqlServer
  9. PracticePlus Practice ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPPractice
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPPracticeimport mode=Replacedata source type=SqlServer
  10. PracticePlus InsurancePlan ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPInsurancePlan
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPInsurancePlanimport mode=Replacedata source type=SqlServer
  11. PracticePlus Chargemaster ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPChargemaster
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPChargemasterimport mode=Replacedata source type=SqlServer
  12. PracticePlus Supply Master ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPSupply
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPSupplyimport mode=Replacedata source type=SqlServer
  13. PracticePlus Product Master ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPProduct
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPProductimport mode=Replacedata source type=SqlServer
  14. PracticePlus PatientInsurance ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPPatientInsurance
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPPatientInsuranceimport mode=Replacedata source type=SqlServer
  15. PracticePlus Encounter ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPEncounter
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPEncounterimport mode=Replacedata source type=SqlServer
  16. PracticePlus Patient ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPPatient
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPPatientimport mode=Replacedata source type=SqlServer
  17. PracticePlus Claim ExportImportSql
    Imports data from SQL Server or Snowflake queries into target tables using bulk copy operations with configurable loading modes.
    writes ImportNextTechPPClaim
    connection=EyeSouth_ProdMirror-sqlserver-2table name=ImportNextTechPPClaimimport mode=Replacedata source type=SqlServer
  18. Load SourceNextTechPPChargesqlload_from_nexttech__load_sourcenexttechppcharge.sql
    ✨ Updates the source charge table by replacing existing records with the latest imported charge data and timestamping the changes.
    writes SourceNextTechPPCharge · reads ImportNextTechPPCharge
    ↳ feeds from PracticePlus Charge Export
  19. Load SourceNextTechPPAdjustmentsqlload_from_nexttech__load_sourcenexttechppadjustment.sql
    ✨ Updates the source adjustment table by replacing existing records with the latest imported adjustment data and applying a timestamp.
    writes SourceNextTechPPAdjustment · reads ImportNextTechPPAdjustment
    ↳ feeds from PracticePlus Adjustment Export
  20. Load SourceNextTechPPPaymentsqlload_from_nexttech__load_sourcenexttechpppayment.sql
    ✨ Updates the source payment table by replacing existing records with the latest imported payment data.
    writes SourceNextTechPPPayment · reads ImportNextTechPPPayment
    ↳ feeds from PracticePlus Payment Export
  21. Load SourceNextTechPPEncountersqlload_from_nexttech__load_sourcenexttechppencounter.sql
    ✨ Updates the source encounter table by replacing existing records with the latest imported encounter data.
    writes SourceNextTechPPEncounter · reads ImportNextTechPPEncounter
    ↳ feeds from PracticePlus Encounter Export
  22. Load SourceNextTechPPChargemastersqlload_from_nexttech__load_sourcenexttechppchargemaster.sql
    ✨ Updates the source chargemaster table by replacing existing records with the latest imported service and pricing data.
    writes SourceNextTechPPChargemaster · reads ImportNextTechPPChargemaster
    ↳ feeds from PracticePlus Chargemaster Export
  23. Load SourceNextTechPPSupplysqlload_from_nexttech__load_sourcenexttechppsupply.sql
    ✨ Updates the source supply table by replacing existing records with the latest imported supply data.
    writes SourceNextTechPPSupply · reads ImportNextTechPPSupply
    ↳ feeds from PracticePlus Supply Master Export
  24. Load SourceNextTechPPProductsqlload_from_nexttech__load_sourcenexttechppproduct.sql
    ✨ Updates the source product table by replacing existing records with the latest imported product data.
    writes SourceNextTechPPProduct · reads ImportNextTechPPProduct
    ↳ feeds from PracticePlus Product Master Export
  25. Load SourceNextTechPPPracticesqlload_from_nexttech__load_sourcenexttechpppractice.sql
    ✨ Updates the source practice table by replacing existing records with the latest imported practice location data.
    writes SourceNextTechPPPractice · reads ImportNextTechPPPractice
    ↳ feeds from PracticePlus Practice Export