sqlflow_public/doc/the column-level lineage.md

Insert into enrollment2.EnrollmentCW
SELECT
       CASE WHEN dstf.LastName + ', ' + dstf.FirstName LIKE '%DEFAULT%' THEN ''
            ELSE dstf.LastName + ', ' + dstf.FirstName
       END AS AdvisorFullName,
       CASE WHEN dstf.StaffEmail = 'Unknown' THEN ''
            ELSE dstf.StaffEmail
       END AS AdvisorEmail 
FROM STU_DW.enrollment1.vwStudentEnrollmentCW fsecw
       LEFT JOIN STU_DW.org.DimStaff dstf ON fsecw.DimStaffIDAdvisor = dstf.DimStaffID
                                      AND dstf.IsCurrentRow = 1									  

1. How to get column-level model from the complete model

2. The export format of the column-level model