Schema Info

Schema Name: sfdl_stage_csv.storsmartzoho_storsmart_active_clients

created: 2021-01-12 11:19:46
disabled: False
format: raw
id: 1003
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_csv",
    "table": "storsmartzoho_storsmart_active_clients"
}

type: csv

Schema Versions: 15

Version 906662

created: 2026-04-17 07:00:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-17/1776427238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-17/1776427238
id: 906662
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6415260
updated: 2026-04-17 07:00:54

Version 906445

created: 2026-04-16 07:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-16/1776340841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-16/1776340841
id: 906445
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6414712
updated: 2026-04-16 07:01:08

Version 906231

created: 2026-04-15 07:00:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-15/1776254432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-15/1776254432
id: 906231
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6414224
updated: 2026-04-15 07:00:51

Version 906018

created: 2026-04-14 07:00:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-14/1776168036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-14/1776168036
id: 906018
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6413732
updated: 2026-04-14 07:00:54

Version 905802

created: 2026-04-13 07:00:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-13/1776081631'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-13/1776081631
id: 905802
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6413178
updated: 2026-04-13 07:00:49

Version 905600

created: 2026-04-12 07:00:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-12/1775995228'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-12/1775995228
id: 905600
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6412779
updated: 2026-04-12 07:00:58

Version 905398

created: 2026-04-11 07:00:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-11/1775908830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-11/1775908830
id: 905398
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6412398
updated: 2026-04-11 07:00:53

Version 905185

created: 2026-04-10 07:01:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-10/1775822463'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-10/1775822463
id: 905185
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6411914
updated: 2026-04-10 07:01:26

Version 904972

created: 2026-04-09 07:01:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-09/1775736075'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-09/1775736075
id: 904972
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6411401
updated: 2026-04-09 07:01:39

Version 904756

created: 2026-04-08 07:00:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-08/1775649635'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-08/1775649635
id: 904756
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6410895
updated: 2026-04-08 07:00:54

Version 904543

created: 2026-04-07 07:00:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-07/1775563234'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-07/1775563234
id: 904543
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6410386
updated: 2026-04-07 07:00:59

Version 904328

created: 2026-04-06 07:00:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-06/1775476830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-06/1775476830
id: 904328
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6409842
updated: 2026-04-06 07:00:54

Version 904126

created: 2026-04-05 07:00:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-05/1775390435'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-05/1775390435
id: 904126
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6409449
updated: 2026-04-05 07:01:09

Version 903923

created: 2026-04-04 07:00:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-04/1775304024'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-04/1775304024
id: 903923
processed: 1

raw_data:

{
    "APM Lease Requirement": 53,
    "APM Program": 49,
    "APM Program End": 51,
    "APM Program Start": 50,
    "APM Tech Status": 52,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 54,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6409067
updated: 2026-04-04 07:00:48

Version 903710

created: 2026-04-03 07:00:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-03/1775217635'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
]

hive_path: s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-03/1775217635
id: 903710
processed: 1

raw_data:

{
    "APM Program": 49,
    "APM Program Start": 50,
    "Acct Owner": 43,
    "Address": 24,
    "Admin Fee (%)": 8,
    "Agreement Version": 51,
    "Audit Letters Sent": 39,
    "Audit Letters Sent Date": 40,
    "Auto Protect Enabled": 28,
    "Auto Protect Off": 30,
    "Auto Protect On": 29,
    "Auto Protect Re-enabled": 31,
    "City": 25,
    "Client All Programs": 5,
    "Client Dropped Date": 14,
    "Client Status": 6,
    "Common Variable ID": 17,
    "Company Name": 3,
    "Corp Group Name": 0,
    "Corp Related Notes": 38,
    "Corporate Group Number": 2,
    "Current Success Status": 37,
    "Facility Number": 41,
    "Fenced Facility": 20,
    "First Training 1 Date": 42,
    "Gated Facility": 19,
    "ITV Added": 32,
    "ITV Enabled": 33,
    "Insurance Required per Lease": 48,
    "Link to Company": 22,
    "Non-Reporting Annex?": 7,
    "Primary Contact Email": 23,
    "Reason - No AP Move In": 45,
    "Reason for Termination": 15,
    "SL-SE-EZ Corp Company Code": 34,
    "SL-SE-EZ Loc Fac Code": 35,
    "Sales Director": 44,
    "Sign On Date": 9,
    "Software": 16,
    "Source of Business": 18,
    "State": 26,
    "Success Mgr": 36,
    "Trainer": 47,
    "Training 1 Date": 10,
    "Training 2 Date": 11,
    "Training Schedule Status": 12,
    "Training Status": 13,
    "Used Facility ID": 4,
    "Vested Letter Person": 46,
    "ZCRM Account ID": 21,
    "ZCRM Corp ID Number": 1,
    "ZIP Code": 27
}

schema_attributes:

{
    "APM_Program": "string",
    "APM_Program_Start": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

schema_name_id: 1003
schema_scan_id: 6408580
updated: 2026-04-03 07:00:51

Schema Scans: 15

Last at 2026-04-17 07:00:41

Scan 6415260

duration: 0:00:13.267674

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6415260

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-17/1776427238",
        "key": "raw/storsmart_active_clients/2026-04-17/1776427238/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1724282782176253846,
        "service_name": "load-storsmart_active_clients",
        "span_id": 13263718106935342407,
        "trace_id": 1724282782176253846
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-17 07:00:41
success: True
trace_id: 1724282782176253846

Scan 6414712

duration: 0:00:15.806370

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6414712

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-16/1776340841",
        "key": "raw/storsmart_active_clients/2026-04-16/1776340841/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3394576207007299838,
        "service_name": "load-storsmart_active_clients",
        "span_id": 10454858569122655972,
        "trace_id": 3394576207007299838
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-16 07:00:53
success: True
trace_id: 3394576207007299838

Scan 6414224

duration: 0:00:15.687000

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6414224

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-15/1776254432",
        "key": "raw/storsmart_active_clients/2026-04-15/1776254432/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6011361331107568419,
        "service_name": "load-storsmart_active_clients",
        "span_id": 5469991678492940328,
        "trace_id": 6011361331107568419
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-15 07:00:35
success: True
trace_id: 6011361331107568419

Scan 6413732

duration: 0:00:15.822454

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6413732

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-14/1776168036",
        "key": "raw/storsmart_active_clients/2026-04-14/1776168036/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8232815981056623024,
        "service_name": "load-storsmart_active_clients",
        "span_id": 1385096708022025346,
        "trace_id": 8232815981056623024
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-14 07:00:39
success: True
trace_id: 8232815981056623024

Scan 6413178

duration: 0:00:13.129704

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6413178

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-13/1776081631",
        "key": "raw/storsmart_active_clients/2026-04-13/1776081631/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15553511875814867236,
        "service_name": "load-storsmart_active_clients",
        "span_id": 8296999902202364636,
        "trace_id": 15553511875814867236
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-13 07:00:36
success: True
trace_id: 15553511875814867236

Scan 6412779

duration: 0:00:13.299645

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6412779

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-12/1775995228",
        "key": "raw/storsmart_active_clients/2026-04-12/1775995228/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5293787277323946886,
        "service_name": "load-storsmart_active_clients",
        "span_id": 11587560126668675282,
        "trace_id": 5293787277323946886
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-12 07:00:45
success: True
trace_id: 5293787277323946886

Scan 6412398

duration: 0:00:13.267566

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6412398

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-11/1775908830",
        "key": "raw/storsmart_active_clients/2026-04-11/1775908830/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 18265215685800873464,
        "service_name": "load-storsmart_active_clients",
        "span_id": 5427778192674513021,
        "trace_id": 18265215685800873464
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-11 07:00:40
success: True
trace_id: 18265215685800873464

Scan 6411914

duration: 0:00:13.158677

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6411914

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-10/1775822463",
        "key": "raw/storsmart_active_clients/2026-04-10/1775822463/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3110957283365137780,
        "service_name": "load-storsmart_active_clients",
        "span_id": 3927967787834775710,
        "trace_id": 3110957283365137780
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-10 07:01:13
success: True
trace_id: 3110957283365137780

Scan 6411401

duration: 0:00:13.073418

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6411401

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-09/1775736075",
        "key": "raw/storsmart_active_clients/2026-04-09/1775736075/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4080755104511513410,
        "service_name": "load-storsmart_active_clients",
        "span_id": 17922520869843045536,
        "trace_id": 4080755104511513410
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-09 07:01:26
success: True
trace_id: 4080755104511513410

Scan 6410895

duration: 0:00:15.873241

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6410895

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-08/1775649635",
        "key": "raw/storsmart_active_clients/2026-04-08/1775649635/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8156460778626255700,
        "service_name": "load-storsmart_active_clients",
        "span_id": 4399750027487657415,
        "trace_id": 8156460778626255700
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-08 07:00:38
success: True
trace_id: 8156460778626255700

Scan 6410386

duration: 0:00:13.126349

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6410386

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-07/1775563234",
        "key": "raw/storsmart_active_clients/2026-04-07/1775563234/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9595958695038001202,
        "service_name": "load-storsmart_active_clients",
        "span_id": 13202557265642124773,
        "trace_id": 9595958695038001202
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-07 07:00:45
success: True
trace_id: 9595958695038001202

Scan 6409842

duration: 0:00:15.743818

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6409842

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-06/1775476830",
        "key": "raw/storsmart_active_clients/2026-04-06/1775476830/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10071532794568489200,
        "service_name": "load-storsmart_active_clients",
        "span_id": 6112833949621425506,
        "trace_id": 10071532794568489200
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-06 07:00:38
success: True
trace_id: 10071532794568489200

Scan 6409449

duration: 0:00:15.691240

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6409449

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-05/1775390435",
        "key": "raw/storsmart_active_clients/2026-04-05/1775390435/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4220305481758816345,
        "service_name": "load-storsmart_active_clients",
        "span_id": 7601607782189802686,
        "trace_id": 4220305481758816345
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-05 07:00:53
success: True
trace_id: 4220305481758816345

Scan 6409067

duration: 0:00:13.160555

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6409067

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-04/1775304024",
        "key": "raw/storsmart_active_clients/2026-04-04/1775304024/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11577490629161997750,
        "service_name": "load-storsmart_active_clients",
        "span_id": 6706661649744512938,
        "trace_id": 11577490629161997750
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-04 07:00:34
success: True
trace_id: 11577490629161997750

Scan 6408580

duration: 0:00:13.175969

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6408580

payload:

{
    "datatype_dict": {
        "APM Program": "string",
        "APM Program Start": "string",
        "Acct Owner": "string",
        "Address": "string",
        "Admin Fee (%)": "string",
        "Agreement Version": "string",
        "Audit Letters Sent": "string",
        "Audit Letters Sent Date": "string",
        "Auto Protect Enabled": "string",
        "Auto Protect Off": "string",
        "Auto Protect On": "string",
        "Auto Protect Re-enabled": "string",
        "City": "string",
        "Client All Programs": "string",
        "Client Dropped Date": "string",
        "Client Status": "string",
        "Common Variable ID": "string",
        "Company Name": "string",
        "Corp Group Name": "string",
        "Corp Related Notes": "string",
        "Corporate Group Number": "string",
        "Current Success Status": "string",
        "Facility Number": "string",
        "Fenced Facility": "string",
        "First Training 1 Date": "string",
        "Gated Facility": "string",
        "ITV Added": "string",
        "ITV Enabled": "string",
        "Insurance Required per Lease": "string",
        "Link to Company": "string",
        "Non-Reporting Annex?": "string",
        "Primary Contact Email": "string",
        "Reason - No AP Move In": "string",
        "Reason for Termination": "string",
        "SL-SE-EZ Corp Company Code": "string",
        "SL-SE-EZ Loc Fac Code": "string",
        "Sales Director": "string",
        "Sign On Date": "string",
        "Software": "string",
        "Source of Business": "string",
        "State": "string",
        "Success Mgr": "string",
        "Trainer": "string",
        "Training 1 Date": "string",
        "Training 2 Date": "string",
        "Training Schedule Status": "string",
        "Training Status": "string",
        "Used Facility ID": "string",
        "Vested Letter Person": "string",
        "ZCRM Account ID": "string",
        "ZCRM Corp ID Number": "string",
        "ZIP Code": "string"
    },
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-storsmartzoho-stage",
        "hive_path": "s3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-03/1775217635",
        "key": "raw/storsmart_active_clients/2026-04-03/1775217635/data.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.storsmartzoho_storsmart_active_clients",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15360764980988207379,
        "service_name": "load-storsmart_active_clients",
        "span_id": 2624355585338213592,
        "trace_id": 15360764980988207379
    }
}

running: False
schema_name_id: 1003
start_time: 2026-04-03 07:00:38
success: True
trace_id: 15360764980988207379

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "APM_Lease_Requirement": "string",
    "APM_Program": "string",
    "APM_Program_End": "string",
    "APM_Program_Start": "string",
    "APM_Tech_Status": "string",
    "Acct_Owner": "string",
    "Address": "string",
    "Admin_Fee____": "string",
    "Agreement_Version": "string",
    "Audit_Letters_Sent": "string",
    "Audit_Letters_Sent_Date": "string",
    "Auto_Protect_Enabled": "string",
    "Auto_Protect_Off": "string",
    "Auto_Protect_On": "string",
    "Auto_Protect_Re_enabled": "string",
    "City": "string",
    "Client_All_Programs": "string",
    "Client_Dropped_Date": "string",
    "Client_Status": "string",
    "Common_Variable_ID": "string",
    "Company_Name": "string",
    "Corp_Group_Name": "string",
    "Corp_Related_Notes": "string",
    "Corporate_Group_Number": "string",
    "Current_Success_Status": "string",
    "Facility_Number": "string",
    "Fenced_Facility": "string",
    "First_Training_1_Date": "string",
    "Gated_Facility": "string",
    "ITV_Added": "string",
    "ITV_Enabled": "string",
    "Insurance_Required_per_Lease": "string",
    "Link_to_Company": "string",
    "Non_Reporting_Annex_": "string",
    "Primary_Contact_Email": "string",
    "Reason___No_AP_Move_In": "string",
    "Reason_for_Termination": "string",
    "SL_SE_EZ_Corp_Company_Code": "string",
    "SL_SE_EZ_Loc_Fac_Code": "string",
    "Sales_Director": "string",
    "Sign_On_Date": "string",
    "Software": "string",
    "Source_of_Business": "string",
    "State": "string",
    "Success_Mgr": "string",
    "Trainer": "string",
    "Training_1_Date": "string",
    "Training_2_Date": "string",
    "Training_Schedule_Status": "string",
    "Training_Status": "string",
    "Used_Facility_ID": "string",
    "Vested_Letter_Person": "string",
    "ZCRM_Account_ID": "string",
    "ZCRM_Corp_ID_Number": "string",
    "ZIP_Code": "string"
}

created: 2026-04-17 07:00:42

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-17/1776427238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2021-01-12 11:19:46",
        "disabled": false,
        "format": "raw",
        "id": 1003,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "storsmartzoho_storsmart_active_clients"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "APM_Lease_Requirement": "string",
            "APM_Program": "string",
            "APM_Program_End": "string",
            "APM_Program_Start": "string",
            "APM_Tech_Status": "string",
            "Acct_Owner": "string",
            "Address": "string",
            "Admin_Fee____": "string",
            "Agreement_Version": "string",
            "Audit_Letters_Sent": "string",
            "Audit_Letters_Sent_Date": "string",
            "Auto_Protect_Enabled": "string",
            "Auto_Protect_Off": "string",
            "Auto_Protect_On": "string",
            "Auto_Protect_Re_enabled": "string",
            "City": "string",
            "Client_All_Programs": "string",
            "Client_Dropped_Date": "string",
            "Client_Status": "string",
            "Common_Variable_ID": "string",
            "Company_Name": "string",
            "Corp_Group_Name": "string",
            "Corp_Related_Notes": "string",
            "Corporate_Group_Number": "string",
            "Current_Success_Status": "string",
            "Facility_Number": "string",
            "Fenced_Facility": "string",
            "First_Training_1_Date": "string",
            "Gated_Facility": "string",
            "ITV_Added": "string",
            "ITV_Enabled": "string",
            "Insurance_Required_per_Lease": "string",
            "Link_to_Company": "string",
            "Non_Reporting_Annex_": "string",
            "Primary_Contact_Email": "string",
            "Reason___No_AP_Move_In": "string",
            "Reason_for_Termination": "string",
            "SL_SE_EZ_Corp_Company_Code": "string",
            "SL_SE_EZ_Loc_Fac_Code": "string",
            "Sales_Director": "string",
            "Sign_On_Date": "string",
            "Software": "string",
            "Source_of_Business": "string",
            "State": "string",
            "Success_Mgr": "string",
            "Trainer": "string",
            "Training_1_Date": "string",
            "Training_2_Date": "string",
            "Training_Schedule_Status": "string",
            "Training_Status": "string",
            "Used_Facility_ID": "string",
            "Vested_Letter_Person": "string",
            "ZCRM_Account_ID": "string",
            "ZCRM_Corp_ID_Number": "string",
            "ZIP_Code": "string"
        },
        "created": "2026-04-17 07:00:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.storsmartzoho_storsmart_active_clients`\n(\n `Corp_Group_Name`  string , `ZCRM_Corp_ID_Number`  string , `Corporate_Group_Number`  string , `Company_Name`  string , `Used_Facility_ID`  string , `Client_All_Programs`  string , `Client_Status`  string , `Non_Reporting_Annex_`  string , `Admin_Fee____`  string , `Sign_On_Date`  string , `Training_1_Date`  string , `Training_2_Date`  string , `Training_Schedule_Status`  string , `Training_Status`  string , `Client_Dropped_Date`  string , `Reason_for_Termination`  string , `Software`  string , `Common_Variable_ID`  string , `Source_of_Business`  string , `Gated_Facility`  string , `Fenced_Facility`  string , `ZCRM_Account_ID`  string , `Link_to_Company`  string , `Primary_Contact_Email`  string , `Address`  string , `City`  string , `State`  string , `ZIP_Code`  string , `Auto_Protect_Enabled`  string , `Auto_Protect_On`  string , `Auto_Protect_Off`  string , `Auto_Protect_Re_enabled`  string , `ITV_Added`  string , `ITV_Enabled`  string , `SL_SE_EZ_Corp_Company_Code`  string , `SL_SE_EZ_Loc_Fac_Code`  string , `Success_Mgr`  string , `Current_Success_Status`  string , `Corp_Related_Notes`  string , `Audit_Letters_Sent`  string , `Audit_Letters_Sent_Date`  string , `Facility_Number`  string , `First_Training_1_Date`  string , `Acct_Owner`  string , `Sales_Director`  string , `Reason___No_AP_Move_In`  string , `Vested_Letter_Person`  string , `Trainer`  string , `Insurance_Required_per_Lease`  string , `APM_Program`  string , `APM_Program_Start`  string , `APM_Program_End`  string , `APM_Tech_Status`  string , `APM_Lease_Requirement`  string , `Agreement_Version`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-storsmartzoho-stage/raw/storsmart_active_clients/2026-04-17/1776427238'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.storsmartzoho_storsmart_active_clients`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.storsmartzoho_storsmart_active_clients"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}