Schema Info

Schema Name: sfdl_stage_postgres.keplernormies_payment_line_fact

created: 2020-11-13 17:24:11
disabled: False
format: raw
id: 992
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_postgres",
    "table": "keplernormies_payment_line_fact"
}

type: postgres

Schema Versions: 3

Version 505226

created: 2023-02-27 09:16:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
    "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_payment_line_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_payment_line_fact`\n(\n `65532513`  string , `fms`  string , `a432c78b_ea84_4229_87f9_af6af7bbbd2f`  string , `0e927783_97b5_4723_8ffc_794ea13a08c3`  string , `Payment`  string , `12_00`  string , `0_00`  string , `414145183`  string , `Xercor_Insurance_Services_LLC____3_000_00`  string , `004163509532`  string , `____5422`  string , `mastercard`  string , `55853868`  string , `1748166`  string , `148`  string , `491529`  string , `20220805`  string , `20220801`  string , `20220831`  string , `42`  string , `1659661716018`  string , `f`  string , `81`  string , `tenant_portal`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-27/1677510951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_payment_line_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-27/1677510951
id: 505226
processed: 1

raw_data:

{
    "": 27,
    "****5422": 13,
    "0.00": 7,
    "004163509532": 10,
    "0e927783-97b5-4723-8ffc-794ea13a08c3": 3,
    "12.00": 6,
    "148": 17,
    "1659661716018": 24,
    "1748166": 16,
    "20220801": 21,
    "20220805": 19,
    "20220831": 22,
    "414145183": 8,
    "42": 23,
    "491529": 18,
    "55853868": 15,
    "65532513": 0,
    "81": 28,
    "Payment": 5,
    "Xercor Insurance Services LLC - $3,000.00": 9,
    "a432c78b-ea84-4229-87f9-af6af7bbbd2f": 2,
    "f": 26,
    "fms": 1,
    "mastercard": 14,
    "tenant_portal": 29
}

schema_attributes:

{
    "001654440721": "string",
    "001654445851": "string",
    "001654485791": "string",
    "001654552871": "string",
    "001654881131": "string",
    "001716408051": "string",
    "001717018861": "string",
    "001717019101": "string",
    "001717020101": "string",
    "001717027991": "string",
    "001717028321": "string",
    "001717028621": "string",
    "001717028951": "string",
    "001717029951": "string",
    "001717030121": "string",
    "001717931471": "string",
    "001719441591": "string",
    "001719442041": "string",
    "001828888541": "string",
    "004003fe_f420_474b_b039_88b1179483bd": "string",
    "004007410212": "string",
    "004163509532": "string",
    "004163571792": "string",
    "004163592632": "string",
    "004163595492": "string",
    "004163595502": "string",
    "004163597762": "string",
    "004163599042": "string",
    "004163601052": "string",
    "004163602012": "string",
    "004163637352": "string",
    "004163640222": "string",
    "004163643972": "string",
    "004163649652": "string",
    "004163651182": "string",
    "004230918642": "string",
    "004230918722": "string",
    "004231484582": "string",
    "056d753c_29c3_4d6d_9351_a547c3ebeb8a": "string",
    "068aef80_ecff_4f3b_ba04_cac574cefb45": "string",
    "0_00": "string",
    "0bd61b94_4592_4242_b4ae_4b7ce3e7ad0d": "string",
    "0c3c17dd_2165_4142_8676_b0f98d71f526": "string",
    "0ca501f6_0746_46e5_b21c_f3300bd1c0f5": "string",
    "0d605c30_d7ce_47a2_8a96_56e5f6ab161b": "string",
    "0e927783_97b5_4723_8ffc_794ea13a08c3": "string",
    "0f775bc1_553c_4b6c_8cc1_148c8330002b": "string",
    "1": "string",
    "1006475": "string",
    "100_00": "string",
    "101858": "string",
    "101_00": "string",
    "1042150": "string",
    "104800017": "string",
    "1048165": "string",
    "1067654": "string",
    "107069871": "string",
    "1077411": "string",
    "108128": "string",
    "1084121": "string",
    "108605138": "string",
    "109": "string",
    "109_00": "string",
    "10_00": "string",
    "111_00": "string",
    "11264797": "string",
    "11488266": "string",
    "11494996": "string",
    "11497535": "string",
    "117709438": "string",
    "120_00": "string",
    "122_00": "string",
    "12403212": "string",
    "1251453": "string",
    "1275015": "string",
    "1287160": "string",
    "12_00": "string",
    "130_00": "string",
    "132033245": "string",
    "132120233": "string",
    "1326968": "string",
    "1327815": "string",
    "1334745": "string",
    "1347": "string",
    "1349": "string",
    "134_11": "string",
    "136_00": "string",
    "137619738": "string",
    "13_00": "string",
    "13_75": "string",
    "13a37b9a_f9ce_4750_adf3_beb35f980b3e": "string",
    "140_00": "string",
    "142071183": "string",
    "142991251": "string",
    "143877356": "string",
    "14622412": "string",
    "148": "string",
    "1483872": "string",
    "149847097": "string",
    "14de90b3_9e04_41ea_a16d_91b598e1ddf4": "string",
    "154_00": "string",
    "157098258": "string",
    "15992": "string",
    "15df2ef8_2f36_472f_87d8_1c09d2205e58": "string",
    "1612986": "string",
    "1644941754376": "string",
    "1644942294425": "string",
    "1644942296294": "string",
    "1644942590060": "string",
    "1644943882602": "string",
    "1644944635680": "string",
    "1644949095218": "string",
    "1646866742342": "string",
    "1646867576709": "string",
    "1646902240501": "string",
    "1646902245657": "string",
    "1646902254384": "string",
    "1646902330266": "string",
    "1646902336273": "string",
    "1646902339783": "string",
    "1646902351346": "string",
    "1646902355859": "string",
    "1646902646837": "string",
    "1646931775141": "string",
    "1646941196356": "string",
    "1646950327207": "string",
    "1646976996510": "string",
    "1646977027614": "string",
    "1650862520786": "string",
    "1654367486470": "string",
    "1659661716018": "string",
    "1659670718894": "string",
    "1659672566982": "string",
    "1659672846208": "string",
    "1659672850761": "string",
    "1659673011290": "string",
    "1659673023589": "string",
    "1659673088981": "string",
    "1659673124771": "string",
    "1659674095577": "string",
    "1659676685461": "string",
    "1659676877405": "string",
    "1659677064699": "string",
    "1659677113773": "string",
    "1659677268392": "string",
    "165_00": "string",
    "1662026727860": "string",
    "1662026728617": "string",
    "1662037460423": "string",
    "1691115": "string",
    "1707427": "string",
    "172872275": "string",
    "173054450": "string",
    "173678986": "string",
    "173_37": "string",
    "1748166": "string",
    "17_63": "string",
    "1802": "string",
    "180210687": "string",
    "180211087": "string",
    "1856640": "string",
    "1868": "string",
    "18_00": "string",
    "1918334": "string",
    "1993062": "string",
    "1dd13f76_0e49_466f_b786_63dcdf118780": "string",
    "1f0f3420_4b33_4a9c_b89a_af1822e0daf8": "string",
    "1f46842b_bcdd_40ff_8e14_bf72cc7220c5": "string",
    "20220106": "string",
    "20220206": "string",
    "20220212": "string",
    "20220215": "string",
    "20220301": "string",
    "20220305": "string",
    "20220306": "string",
    "20220309": "string",
    "20220310": "string",
    "20220311": "string",
    "20220314": "string",
    "20220331": "string",
    "20220409": "string",
    "20220410": "string",
    "20220425": "string",
    "20220524": "string",
    "20220601": "string",
    "20220604": "string",
    "20220630": "string",
    "20220801": "string",
    "20220803": "string",
    "20220805": "string",
    "20220831": "string",
    "20220901": "string",
    "20220904": "string",
    "20220930": "string",
    "20_00": "string",
    "221_00": "string",
    "22964": "string",
    "22_00": "string",
    "23b6859e_9932_441b_9152_104e69930dbb": "string",
    "2406946": "string",
    "2410413": "string",
    "2410875": "string",
    "25562": "string",
    "2627850": "string",
    "26543f30_47d6_46c8_8034_fa6edc3fe8a5": "string",
    "26784": "string",
    "275_00": "string",
    "27809c8f_09c9_4321_a7c4_965b21120781": "string",
    "2792": "string",
    "27a7a986_e888_4b62_a346_2d026f819b44": "string",
    "2854616": "string",
    "288ad3d6_50d4_4806_84f4_5fa818773a1b": "string",
    "28e42a52_e7df_45e4_bf66_da9d5d1fcd92": "string",
    "2957": "string",
    "2_70": "string",
    "3000448": "string",
    "303643c6_293a_4245_a7ca_254e95d64f8f": "string",
    "3069243": "string",
    "3091745": "string",
    "3255918": "string",
    "344088214": "string",
    "344088697": "string",
    "344089150": "string",
    "344092072": "string",
    "344096334": "string",
    "344099821": "string",
    "344119443": "string",
    "3494423": "string",
    "352691155": "string",
    "352693349": "string",
    "352825130": "string",
    "352825271": "string",
    "352825323": "string",
    "352826040": "string",
    "352826095": "string",
    "352826130": "string",
    "352826189": "string",
    "352826192": "string",
    "352826262": "string",
    "352907986": "string",
    "352976605": "string",
    "353014559": "string",
    "353080508": "string",
    "353083195": "string",
    "3617": "string",
    "368467669": "string",
    "385185499": "string",
    "389ee133_2a79_4db9_a9ce_a7d92f9c749c": "string",
    "38cefb5f_3c57_4a07_8cc8_507ade312fa0": "string",
    "39": "string",
    "39c9e62c_c841_439d_b031_ee3b8fccf0d6": "string",
    "3edb50a5_0c4f_4ffe_8f49_c8fec4762c4e": "string",
    "3f840aaa_a30f_4f01_8d06_626245b6a79d": "string",
    "40": "string",
    "414145183": "string",
    "414157664": "string",
    "414160195": "string",
    "414165407": "string",
    "414165474": "string",
    "414168173": "string",
    "414169586": "string",
    "414169773": "string",
    "414171083": "string",
    "414172064": "string",
    "414224579": "string",
    "414229736": "string",
    "414235351": "string",
    "414245662": "string",
    "414248894": "string",
    "42": "string",
    "424264": "string",
    "424726333": "string",
    "424726374": "string",
    "424827451": "string",
    "42a16adb_cbe1_460c_a8c2_47ab74cf1715": "string",
    "42bd94ce_e405_4251_9509_a43c7b11aee6": "string",
    "436285": "string",
    "436660": "string",
    "437170": "string",
    "439744": "string",
    "4406159": "string",
    "441446": "string",
    "4430577": "string",
    "445313": "string",
    "447732": "string",
    "448889": "string",
    "449241": "string",
    "44f0e53e_cf3d_4539_948c_5242a89c38a0": "string",
    "45": "string",
    "452552": "string",
    "456303": "string",
    "456544": "string",
    "456884": "string",
    "463622": "string",
    "465": "string",
    "465631": "string",
    "466418": "string",
    "47": "string",
    "473632ec_9a22_4834_8981_b4a154c84ef9": "string",
    "4739": "string",
    "491529": "string",
    "49e2e083_cd10_4128_913c_551bec853268": "string",
    "4_80": "string",
    "4bffb987_3732_4adb_bf69_c27a4dfc5e8b": "string",
    "4c7e09a9_5d66_40c1_860a_7b139cfc7214": "string",
    "4d5ed596_26d1_4952_ae24_90e8d813b016": "string",
    "4f7d8b51_cc79_423c_a440_ca155e5e687c": "string",
    "5104360": "string",
    "513315": "string",
    "51830": "string",
    "526014": "string",
    "5280884": "string",
    "5366797": "string",
    "53904271": "string",
    "53904377": "string",
    "53904441": "string",
    "53904990": "string",
    "53905840": "string",
    "53906564": "string",
    "53910872": "string",
    "5452674": "string",
    "54d11946_f228_43e8_ba75_2e2b95acb4b5": "string",
    "55": "string",
    "55586346": "string",
    "55586739": "string",
    "55601894": "string",
    "55601925": "string",
    "55602045": "string",
    "55602992": "string",
    "55603068": "string",
    "55603086": "string",
    "55603126": "string",
    "55603177": "string",
    "55603266": "string",
    "55615296": "string",
    "55627788": "string",
    "55638627": "string",
    "55651626": "string",
    "55651750": "string",
    "55853868": "string",
    "55_00": "string",
    "560651": "string",
    "5632390": "string",
    "56a47379_2b43_416c_a48b_6d0f4b90ba18": "string",
    "5704278": "string",
    "578704be_3a5f_4e05_96f4_476aa7132331": "string",
    "58038624": "string",
    "582": "string",
    "586": "string",
    "5874517": "string",
    "592212": "string",
    "593a6c64_3471_43d8_9e3d_56320d91b0f9": "string",
    "595520": "string",
    "595944": "string",
    "599600": "string",
    "5b0355f8_a5c6_4a47_a463_f2a03f9411e6": "string",
    "5b2da068_b9ac_4dba_bc21_5b9bcc423e29": "string",
    "604": "string",
    "608": "string",
    "61": "string",
    "612": "string",
    "61254868": "string",
    "6148e1ee_70b1_45e4_af26_5f41b49a5ce1": "string",
    "61_00": "string",
    "6275536": "string",
    "63": "string",
    "6390916": "string",
    "63_96": "string",
    "644781": "string",
    "65532513": "string",
    "65536784": "string",
    "65537143": "string",
    "65537496": "string",
    "65537639": "string",
    "65538070": "string",
    "65538357": "string",
    "65538390": "string",
    "65539117": "string",
    "65539235": "string",
    "65545678": "string",
    "65546376": "string",
    "65547156": "string",
    "65548094": "string",
    "65548375": "string",
    "6725009": "string",
    "67300974": "string",
    "67300993": "string",
    "67322226": "string",
    "6752732": "string",
    "6763135": "string",
    "6768941": "string",
    "68424": "string",
    "68_00": "string",
    "6ef7da9d_2cc2_4da2_8fc6_e4779fa21479": "string",
    "6f3fa75d_93c7_4137_8ae0_ed0d576bc2fe": "string",
    "7075623": "string",
    "7087650": "string",
    "7150a05a_56f6_41e0_91e6_4e3d7b980b96": "string",
    "715131": "string",
    "71628409": "string",
    "7241913": "string",
    "73247": "string",
    "7333660": "string",
    "7360235": "string",
    "736917": "string",
    "7386740": "string",
    "73981283": "string",
    "742d3feb_e02b_4c0f_a078_1c0c9116ce9e": "string",
    "745003": "string",
    "7541435": "string",
    "75_00": "string",
    "76_00": "string",
    "771": "string",
    "773d2453_f5fa_4aad_8532_ddf424a71ed7": "string",
    "7794913": "string",
    "783744": "string",
    "785af5e0_79a9_4cc4_90e4_b78249f6fa6c": "string",
    "786085": "string",
    "78692": "string",
    "78776310": "string",
    "7b8fb7b8_430f_442b_a284_d00a93411dce": "string",
    "7e1086e3_8e2f_4635_aaeb_35d7249adae8": "string",
    "80": "string",
    "80_00": "string",
    "81": "string",
    "81672020": "string",
    "818": "string",
    "8184092": "string",
    "82": "string",
    "8202220": "string",
    "837": "string",
    "84": "string",
    "844d4410_6fb9_48c3_b450_dc40f7a2b408": "string",
    "8475271": "string",
    "849": "string",
    "854": "string",
    "86": "string",
    "863": "string",
    "8737397": "string",
    "8737490": "string",
    "8d7680df_4283_4885_99f6_4e9168360b8f": "string",
    "906485": "string",
    "90836": "string",
    "909b1673_fa2b_4de4_9acf_b8b56c4960f5": "string",
    "927777ad_8cee_40f1_ae6e_f0ae2fa97e12": "string",
    "939337": "string",
    "9427ba1e_15f3_4c6c_920d_0ebf13da070a": "string",
    "947": "string",
    "951b6b66_4d0e_48a2_96e6_15a7ab9ab173": "string",
    "959929": "string",
    "95_00": "string",
    "9634fc2c_b421_4f43_9df8_d6691e86dd75": "string",
    "965422": "string",
    "96786251": "string",
    "97014316": "string",
    "97723333": "string",
    "981412": "string",
    "9_00": "string",
    "9_54": "string",
    "9_75": "string",
    "9f30b4c9_ead1_423c_8930_cfadaae54764": "string",
    "BOXES___SMALL": "string",
    "BOX_E___WARDROBE": "string",
    "Bader_Company____2_000_00": "string",
    "Bader_Program____2_000_00": "string",
    "Bader_Program____3_000_00": "string",
    "CPUCG5KYZO": "string",
    "California_Fee_Schedule": "string",
    "Credit_Card_Processing_Fee": "string",
    "DNX7VDCFSB": "string",
    "Late_Fee": "string",
    "Payment": "string",
    "Protection_Plan____2_000_00": "string",
    "Protection_Plan____2_500_00": "string",
    "Rent_Unit_00368___12x50x9": "string",
    "Rent_Unit_1092___10x10x8": "string",
    "Rent_Unit_1311___10x10x10": "string",
    "Rent_Unit_2160___5x10": "string",
    "Rent_Unit_229___10x10x0": "string",
    "Rent_Unit_231___10x10x8": "string",
    "Rent_Unit_3099___7_5x10": "string",
    "Rent_Unit_336___10x10x10": "string",
    "Rent_Unit_432___10x30x8": "string",
    "Rent_Unit_520___10x20x0": "string",
    "Rent_Unit_766___10x10x8": "string",
    "Rent_Unit_78___10x10x0": "string",
    "Rent_Unit_87___10x10": "string",
    "Rent_Unit_C195___5x8x8": "string",
    "Rent_Unit_C_12___10x15x8_5": "string",
    "Rent_Unit_D128___10x10x8": "string",
    "Rent_Unit_D1___5x10x10": "string",
    "Rent_Unit_D26___10x20x0": "string",
    "Rent_Unit_D2___10x20x0": "string",
    "Rent_Unit_G020___10x20x0": "string",
    "Rent_Unit_H451___10x10x0": "string",
    "Rent_Unit_H_27___10x15x8": "string",
    "Rent_Unit_IN_17_102___1x17x0": "string",
    "Rent_Unit_K047___10x10x0": "string",
    "Rent_Unit_OUT_21_102___1x21x0": "string",
    "SBOA_Tenant_Insurance____2_000_00": "string",
    "Xercor_Insurance_Services_LLC____3_000_00": "string",
    "____0057": "string",
    "____0579": "string",
    "____0665": "string",
    "____1005": "string",
    "____1007": "string",
    "____1063": "string",
    "____1181": "string",
    "____2297": "string",
    "____2696": "string",
    "____2756": "string",
    "____3029": "string",
    "____3151": "string",
    "____3603": "string",
    "____4013": "string",
    "____4778": "string",
    "____4843": "string",
    "____5422": "string",
    "____5483": "string",
    "____5817": "string",
    "____5979": "string",
    "____6090": "string",
    "____6114": "string",
    "____6499": "string",
    "____6584": "string",
    "____6833": "string",
    "____7108": "string",
    "____7700": "string",
    "____8014": "string",
    "____8212": "string",
    "____8318": "string",
    "____8403": "string",
    "____8546": "string",
    "____8760": "string",
    "____8851": "string",
    "____9053": "string",
    "a10564ab_6af8_47f8_9517_111cb2445525": "string",
    "a432c78b_ea84_4229_87f9_af6af7bbbd2f": "string",
    "a53db356_b328_435c_b17f_fc39e967bc8c": "string",
    "a566b1ed_253f_4844_ba81_55c5c2c99b5a": "string",
    "account_dim_id": "int",
    "acd28a24_d77b_45e2_911d_aef7c14b9dd9": "string",
    "ach": "string",
    "ae2af6e6_4a12_477d_ac4c_57a0f8a31e5c": "string",
    "american_express": "string",
    "amount": "decimal",
    "b34cc648_ef53_40f9_8756_31ce067aa9b7": "string",
    "bb48d444_e987_43c8_8d87_4ccd1af7f14d": "string",
    "be79e414_4ca2_4317_a58c_60fd6850ab2f": "string",
    "bf054065_80b3_41d0_9672_efbc23d87c8e": "string",
    "c7a02d09_a9e1_4d43_92aa_5119739f0c9e": "string",
    "card_on_file": "string",
    "cash": "string",
    "cbc1a65b_3484_4ab8_8364_5582cf68168a": "string",
    "charge_number": "string",
    "check_number": "string",
    "company_dim_id": "int",
    "d0913adf_6ec0_4a74_a11f_689c9b1e9d63": "string",
    "d68eabbf_f789_4b63_ad21_25aa20a226ea": "string",
    "date_dim_id": "int",
    "de056143_f1e9_4bba_b872_a0af34fb0ed7": "string",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "df89f01d_f95f_424f_9c8a_9832e0881287": "string",
    "discount": "decimal",
    "due_on_date_dim_id": "int",
    "e5ae3b82_b25e_4de3_b4e4_c676a6fb4401": "string",
    "e7ec37dd_61b1_49b2_9554_fe70c8c67b7a": "string",
    "e818d1b5_e4f0_4e4d_b332_8ae19f1022f7": "string",
    "e914bb3c_c58b_4098_a80b_489e1eb3ae62": "string",
    "eb8cbcb2_36f6_40d3_9902_485dc57c78a8": "string",
    "ec582b62_3c35_4ea8_a0a5_34bbeb381660": "string",
    "ef2314bd_7cde_4eac_8a95_3ebaaca4eb94": "string",
    "f": "string",
    "f076e615_d86c_4fdb_be88_3d94a55c8f57": "string",
    "f1545202_e924_4c8a_8e31_6b2c473571f8": "string",
    "f4982057_d497_4fe0_acb5_a0c9600c7889": "string",
    "fa103eee_c643_4196_9447_4fe88ce51f74": "string",
    "facility_dim_id": "int",
    "fms": "string",
    "in_store": "string",
    "is_reversal": "string",
    "line_description": "string",
    "mastercard": "string",
    "money_order_number": "string",
    "parent_payment_uuid": "string",
    "payer_account_dim_id": "int",
    "payment_kind": "string",
    "payment_line_fact_id": "bigint",
    "payment_source": "string",
    "payment_uuid": "string",
    "phone": "string",
    "provider": "string",
    "provider_id": "string",
    "receipt_number": "string",
    "received_epoch": "bigint",
    "service_end_date_dim_id": "int",
    "service_start_date_dim_id": "int",
    "tenant_dim_id": "int",
    "tenant_portal": "string",
    "transaction_id": "string",
    "transaction_type": "string",
    "unit_dim_id": "int",
    "visa": "string"
}

schema_name_id: 992
schema_scan_id: 4662286
updated: 2023-02-27 09:16:49

Version 504637

created: 2023-02-26 01:23:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
    "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_payment_line_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_payment_line_fact`\n(\n `65536784`  string , `fms`  string , `28e42a52_e7df_45e4_bf66_da9d5d1fcd92`  string , `9634fc2c_b421_4f43_9df8_d6691e86dd75`  string , `Payment`  string , `75_00`  string , `0_00`  string , `414157664`  string , `Rent_Unit_231___10x10x8`  string , `004163571792`  string , `____4013`  string , `visa`  string , `81672020`  string , `3255918`  string , `863`  string , `783744`  string , `20220805`  string , `20220801`  string , `20220831`  string , `55`  string , `1659670718894`  string , `f`  string , `82`  string , `tenant_portal`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-26/1677396166'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_payment_line_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-26/1677396166
id: 504637
processed: 1

raw_data:

{
    "": 27,
    "****4013": 13,
    "0.00": 7,
    "004163571792": 10,
    "1659670718894": 24,
    "20220801": 21,
    "20220805": 19,
    "20220831": 22,
    "28e42a52-e7df-45e4-bf66-da9d5d1fcd92": 2,
    "3255918": 16,
    "414157664": 8,
    "55": 23,
    "65536784": 0,
    "75.00": 6,
    "783744": 18,
    "81672020": 15,
    "82": 28,
    "863": 17,
    "9634fc2c-b421-4f43-9df8-d6691e86dd75": 3,
    "Payment": 5,
    "Rent Unit 231 - 10x10x8": 9,
    "f": 26,
    "fms": 1,
    "tenant_portal": 29,
    "visa": 14
}

schema_attributes:

{
    "001654440721": "string",
    "001654445851": "string",
    "001654485791": "string",
    "001654552871": "string",
    "001654881131": "string",
    "001716408051": "string",
    "001717018861": "string",
    "001717019101": "string",
    "001717020101": "string",
    "001717027991": "string",
    "001717028321": "string",
    "001717028621": "string",
    "001717028951": "string",
    "001717029951": "string",
    "001717030121": "string",
    "001717931471": "string",
    "001719441591": "string",
    "001719442041": "string",
    "001828888541": "string",
    "004003fe_f420_474b_b039_88b1179483bd": "string",
    "004007410212": "string",
    "004163571792": "string",
    "004163592632": "string",
    "004163595492": "string",
    "004163595502": "string",
    "004163597762": "string",
    "004163599042": "string",
    "004163601052": "string",
    "004163602012": "string",
    "004163637352": "string",
    "004163640222": "string",
    "004163643972": "string",
    "004163649652": "string",
    "004163651182": "string",
    "004230918642": "string",
    "004230918722": "string",
    "004231484582": "string",
    "056d753c_29c3_4d6d_9351_a547c3ebeb8a": "string",
    "068aef80_ecff_4f3b_ba04_cac574cefb45": "string",
    "0_00": "string",
    "0bd61b94_4592_4242_b4ae_4b7ce3e7ad0d": "string",
    "0c3c17dd_2165_4142_8676_b0f98d71f526": "string",
    "0ca501f6_0746_46e5_b21c_f3300bd1c0f5": "string",
    "0d605c30_d7ce_47a2_8a96_56e5f6ab161b": "string",
    "0f775bc1_553c_4b6c_8cc1_148c8330002b": "string",
    "1": "string",
    "1006475": "string",
    "100_00": "string",
    "101858": "string",
    "101_00": "string",
    "1042150": "string",
    "104800017": "string",
    "1048165": "string",
    "1067654": "string",
    "107069871": "string",
    "1077411": "string",
    "108128": "string",
    "1084121": "string",
    "108605138": "string",
    "109": "string",
    "109_00": "string",
    "10_00": "string",
    "111_00": "string",
    "11264797": "string",
    "11488266": "string",
    "11494996": "string",
    "11497535": "string",
    "117709438": "string",
    "120_00": "string",
    "122_00": "string",
    "12403212": "string",
    "1251453": "string",
    "1275015": "string",
    "1287160": "string",
    "12_00": "string",
    "130_00": "string",
    "132033245": "string",
    "132120233": "string",
    "1326968": "string",
    "1327815": "string",
    "1334745": "string",
    "1347": "string",
    "1349": "string",
    "134_11": "string",
    "136_00": "string",
    "137619738": "string",
    "13_00": "string",
    "13_75": "string",
    "13a37b9a_f9ce_4750_adf3_beb35f980b3e": "string",
    "140_00": "string",
    "142071183": "string",
    "142991251": "string",
    "143877356": "string",
    "14622412": "string",
    "148": "string",
    "1483872": "string",
    "149847097": "string",
    "14de90b3_9e04_41ea_a16d_91b598e1ddf4": "string",
    "154_00": "string",
    "157098258": "string",
    "15992": "string",
    "15df2ef8_2f36_472f_87d8_1c09d2205e58": "string",
    "1612986": "string",
    "1644941754376": "string",
    "1644942294425": "string",
    "1644942296294": "string",
    "1644942590060": "string",
    "1644943882602": "string",
    "1644944635680": "string",
    "1644949095218": "string",
    "1646866742342": "string",
    "1646867576709": "string",
    "1646902240501": "string",
    "1646902245657": "string",
    "1646902254384": "string",
    "1646902330266": "string",
    "1646902336273": "string",
    "1646902339783": "string",
    "1646902351346": "string",
    "1646902355859": "string",
    "1646902646837": "string",
    "1646931775141": "string",
    "1646941196356": "string",
    "1646950327207": "string",
    "1646976996510": "string",
    "1646977027614": "string",
    "1650862520786": "string",
    "1654367486470": "string",
    "1659670718894": "string",
    "1659672566982": "string",
    "1659672846208": "string",
    "1659672850761": "string",
    "1659673011290": "string",
    "1659673023589": "string",
    "1659673088981": "string",
    "1659673124771": "string",
    "1659674095577": "string",
    "1659676685461": "string",
    "1659676877405": "string",
    "1659677064699": "string",
    "1659677113773": "string",
    "1659677268392": "string",
    "165_00": "string",
    "1662026727860": "string",
    "1662026728617": "string",
    "1662037460423": "string",
    "1691115": "string",
    "1707427": "string",
    "172872275": "string",
    "173054450": "string",
    "173678986": "string",
    "173_37": "string",
    "17_63": "string",
    "1802": "string",
    "180210687": "string",
    "180211087": "string",
    "1856640": "string",
    "1868": "string",
    "18_00": "string",
    "1918334": "string",
    "1993062": "string",
    "1dd13f76_0e49_466f_b786_63dcdf118780": "string",
    "1f0f3420_4b33_4a9c_b89a_af1822e0daf8": "string",
    "1f46842b_bcdd_40ff_8e14_bf72cc7220c5": "string",
    "20220106": "string",
    "20220206": "string",
    "20220212": "string",
    "20220215": "string",
    "20220301": "string",
    "20220305": "string",
    "20220306": "string",
    "20220309": "string",
    "20220310": "string",
    "20220311": "string",
    "20220314": "string",
    "20220331": "string",
    "20220409": "string",
    "20220410": "string",
    "20220425": "string",
    "20220524": "string",
    "20220601": "string",
    "20220604": "string",
    "20220630": "string",
    "20220801": "string",
    "20220803": "string",
    "20220805": "string",
    "20220831": "string",
    "20220901": "string",
    "20220904": "string",
    "20220930": "string",
    "20_00": "string",
    "221_00": "string",
    "22964": "string",
    "22_00": "string",
    "23b6859e_9932_441b_9152_104e69930dbb": "string",
    "2406946": "string",
    "2410413": "string",
    "2410875": "string",
    "25562": "string",
    "2627850": "string",
    "26543f30_47d6_46c8_8034_fa6edc3fe8a5": "string",
    "26784": "string",
    "275_00": "string",
    "27809c8f_09c9_4321_a7c4_965b21120781": "string",
    "2792": "string",
    "27a7a986_e888_4b62_a346_2d026f819b44": "string",
    "2854616": "string",
    "288ad3d6_50d4_4806_84f4_5fa818773a1b": "string",
    "28e42a52_e7df_45e4_bf66_da9d5d1fcd92": "string",
    "2957": "string",
    "2_70": "string",
    "3000448": "string",
    "303643c6_293a_4245_a7ca_254e95d64f8f": "string",
    "3069243": "string",
    "3091745": "string",
    "3255918": "string",
    "344088214": "string",
    "344088697": "string",
    "344089150": "string",
    "344092072": "string",
    "344096334": "string",
    "344099821": "string",
    "344119443": "string",
    "3494423": "string",
    "352691155": "string",
    "352693349": "string",
    "352825130": "string",
    "352825271": "string",
    "352825323": "string",
    "352826040": "string",
    "352826095": "string",
    "352826130": "string",
    "352826189": "string",
    "352826192": "string",
    "352826262": "string",
    "352907986": "string",
    "352976605": "string",
    "353014559": "string",
    "353080508": "string",
    "353083195": "string",
    "3617": "string",
    "368467669": "string",
    "385185499": "string",
    "389ee133_2a79_4db9_a9ce_a7d92f9c749c": "string",
    "38cefb5f_3c57_4a07_8cc8_507ade312fa0": "string",
    "39": "string",
    "39c9e62c_c841_439d_b031_ee3b8fccf0d6": "string",
    "3edb50a5_0c4f_4ffe_8f49_c8fec4762c4e": "string",
    "3f840aaa_a30f_4f01_8d06_626245b6a79d": "string",
    "40": "string",
    "414157664": "string",
    "414160195": "string",
    "414165407": "string",
    "414165474": "string",
    "414168173": "string",
    "414169586": "string",
    "414169773": "string",
    "414171083": "string",
    "414172064": "string",
    "414224579": "string",
    "414229736": "string",
    "414235351": "string",
    "414245662": "string",
    "414248894": "string",
    "42": "string",
    "424264": "string",
    "424726333": "string",
    "424726374": "string",
    "424827451": "string",
    "42a16adb_cbe1_460c_a8c2_47ab74cf1715": "string",
    "42bd94ce_e405_4251_9509_a43c7b11aee6": "string",
    "436285": "string",
    "436660": "string",
    "437170": "string",
    "439744": "string",
    "4406159": "string",
    "441446": "string",
    "4430577": "string",
    "445313": "string",
    "447732": "string",
    "448889": "string",
    "449241": "string",
    "44f0e53e_cf3d_4539_948c_5242a89c38a0": "string",
    "45": "string",
    "452552": "string",
    "456303": "string",
    "456544": "string",
    "456884": "string",
    "463622": "string",
    "465": "string",
    "465631": "string",
    "466418": "string",
    "47": "string",
    "473632ec_9a22_4834_8981_b4a154c84ef9": "string",
    "4739": "string",
    "49e2e083_cd10_4128_913c_551bec853268": "string",
    "4_80": "string",
    "4bffb987_3732_4adb_bf69_c27a4dfc5e8b": "string",
    "4c7e09a9_5d66_40c1_860a_7b139cfc7214": "string",
    "4d5ed596_26d1_4952_ae24_90e8d813b016": "string",
    "4f7d8b51_cc79_423c_a440_ca155e5e687c": "string",
    "5104360": "string",
    "513315": "string",
    "51830": "string",
    "526014": "string",
    "5280884": "string",
    "5366797": "string",
    "53904271": "string",
    "53904377": "string",
    "53904441": "string",
    "53904990": "string",
    "53905840": "string",
    "53906564": "string",
    "53910872": "string",
    "5452674": "string",
    "54d11946_f228_43e8_ba75_2e2b95acb4b5": "string",
    "55": "string",
    "55586346": "string",
    "55586739": "string",
    "55601894": "string",
    "55601925": "string",
    "55602045": "string",
    "55602992": "string",
    "55603068": "string",
    "55603086": "string",
    "55603126": "string",
    "55603177": "string",
    "55603266": "string",
    "55615296": "string",
    "55627788": "string",
    "55638627": "string",
    "55651626": "string",
    "55651750": "string",
    "55_00": "string",
    "560651": "string",
    "5632390": "string",
    "56a47379_2b43_416c_a48b_6d0f4b90ba18": "string",
    "5704278": "string",
    "578704be_3a5f_4e05_96f4_476aa7132331": "string",
    "58038624": "string",
    "582": "string",
    "586": "string",
    "5874517": "string",
    "592212": "string",
    "593a6c64_3471_43d8_9e3d_56320d91b0f9": "string",
    "595520": "string",
    "595944": "string",
    "599600": "string",
    "5b0355f8_a5c6_4a47_a463_f2a03f9411e6": "string",
    "5b2da068_b9ac_4dba_bc21_5b9bcc423e29": "string",
    "604": "string",
    "608": "string",
    "61": "string",
    "612": "string",
    "61254868": "string",
    "6148e1ee_70b1_45e4_af26_5f41b49a5ce1": "string",
    "61_00": "string",
    "6275536": "string",
    "63": "string",
    "6390916": "string",
    "63_96": "string",
    "644781": "string",
    "65536784": "string",
    "65537143": "string",
    "65537496": "string",
    "65537639": "string",
    "65538070": "string",
    "65538357": "string",
    "65538390": "string",
    "65539117": "string",
    "65539235": "string",
    "65545678": "string",
    "65546376": "string",
    "65547156": "string",
    "65548094": "string",
    "65548375": "string",
    "6725009": "string",
    "67300974": "string",
    "67300993": "string",
    "67322226": "string",
    "6752732": "string",
    "6763135": "string",
    "6768941": "string",
    "68424": "string",
    "68_00": "string",
    "6ef7da9d_2cc2_4da2_8fc6_e4779fa21479": "string",
    "6f3fa75d_93c7_4137_8ae0_ed0d576bc2fe": "string",
    "7075623": "string",
    "7087650": "string",
    "7150a05a_56f6_41e0_91e6_4e3d7b980b96": "string",
    "715131": "string",
    "71628409": "string",
    "7241913": "string",
    "73247": "string",
    "7333660": "string",
    "7360235": "string",
    "736917": "string",
    "7386740": "string",
    "73981283": "string",
    "742d3feb_e02b_4c0f_a078_1c0c9116ce9e": "string",
    "745003": "string",
    "7541435": "string",
    "75_00": "string",
    "76_00": "string",
    "771": "string",
    "773d2453_f5fa_4aad_8532_ddf424a71ed7": "string",
    "7794913": "string",
    "783744": "string",
    "785af5e0_79a9_4cc4_90e4_b78249f6fa6c": "string",
    "786085": "string",
    "78692": "string",
    "78776310": "string",
    "7b8fb7b8_430f_442b_a284_d00a93411dce": "string",
    "7e1086e3_8e2f_4635_aaeb_35d7249adae8": "string",
    "80": "string",
    "80_00": "string",
    "81": "string",
    "81672020": "string",
    "818": "string",
    "8184092": "string",
    "82": "string",
    "8202220": "string",
    "837": "string",
    "84": "string",
    "844d4410_6fb9_48c3_b450_dc40f7a2b408": "string",
    "8475271": "string",
    "849": "string",
    "854": "string",
    "86": "string",
    "863": "string",
    "8737397": "string",
    "8737490": "string",
    "8d7680df_4283_4885_99f6_4e9168360b8f": "string",
    "906485": "string",
    "90836": "string",
    "909b1673_fa2b_4de4_9acf_b8b56c4960f5": "string",
    "927777ad_8cee_40f1_ae6e_f0ae2fa97e12": "string",
    "939337": "string",
    "9427ba1e_15f3_4c6c_920d_0ebf13da070a": "string",
    "947": "string",
    "951b6b66_4d0e_48a2_96e6_15a7ab9ab173": "string",
    "959929": "string",
    "95_00": "string",
    "9634fc2c_b421_4f43_9df8_d6691e86dd75": "string",
    "965422": "string",
    "96786251": "string",
    "97014316": "string",
    "97723333": "string",
    "981412": "string",
    "9_00": "string",
    "9_54": "string",
    "9_75": "string",
    "9f30b4c9_ead1_423c_8930_cfadaae54764": "string",
    "BOXES___SMALL": "string",
    "BOX_E___WARDROBE": "string",
    "Bader_Company____2_000_00": "string",
    "Bader_Program____2_000_00": "string",
    "Bader_Program____3_000_00": "string",
    "CPUCG5KYZO": "string",
    "California_Fee_Schedule": "string",
    "Credit_Card_Processing_Fee": "string",
    "DNX7VDCFSB": "string",
    "Late_Fee": "string",
    "Payment": "string",
    "Protection_Plan____2_000_00": "string",
    "Protection_Plan____2_500_00": "string",
    "Rent_Unit_00368___12x50x9": "string",
    "Rent_Unit_1092___10x10x8": "string",
    "Rent_Unit_1311___10x10x10": "string",
    "Rent_Unit_2160___5x10": "string",
    "Rent_Unit_229___10x10x0": "string",
    "Rent_Unit_231___10x10x8": "string",
    "Rent_Unit_3099___7_5x10": "string",
    "Rent_Unit_336___10x10x10": "string",
    "Rent_Unit_432___10x30x8": "string",
    "Rent_Unit_520___10x20x0": "string",
    "Rent_Unit_766___10x10x8": "string",
    "Rent_Unit_78___10x10x0": "string",
    "Rent_Unit_87___10x10": "string",
    "Rent_Unit_C195___5x8x8": "string",
    "Rent_Unit_C_12___10x15x8_5": "string",
    "Rent_Unit_D128___10x10x8": "string",
    "Rent_Unit_D1___5x10x10": "string",
    "Rent_Unit_D26___10x20x0": "string",
    "Rent_Unit_D2___10x20x0": "string",
    "Rent_Unit_G020___10x20x0": "string",
    "Rent_Unit_H451___10x10x0": "string",
    "Rent_Unit_H_27___10x15x8": "string",
    "Rent_Unit_IN_17_102___1x17x0": "string",
    "Rent_Unit_K047___10x10x0": "string",
    "Rent_Unit_OUT_21_102___1x21x0": "string",
    "SBOA_Tenant_Insurance____2_000_00": "string",
    "Xercor_Insurance_Services_LLC____3_000_00": "string",
    "____0057": "string",
    "____0579": "string",
    "____0665": "string",
    "____1005": "string",
    "____1007": "string",
    "____1063": "string",
    "____1181": "string",
    "____2297": "string",
    "____2696": "string",
    "____2756": "string",
    "____3029": "string",
    "____3151": "string",
    "____3603": "string",
    "____4013": "string",
    "____4778": "string",
    "____4843": "string",
    "____5483": "string",
    "____5817": "string",
    "____5979": "string",
    "____6090": "string",
    "____6114": "string",
    "____6499": "string",
    "____6584": "string",
    "____6833": "string",
    "____7108": "string",
    "____7700": "string",
    "____8014": "string",
    "____8212": "string",
    "____8318": "string",
    "____8403": "string",
    "____8546": "string",
    "____8760": "string",
    "____8851": "string",
    "____9053": "string",
    "a10564ab_6af8_47f8_9517_111cb2445525": "string",
    "a53db356_b328_435c_b17f_fc39e967bc8c": "string",
    "a566b1ed_253f_4844_ba81_55c5c2c99b5a": "string",
    "account_dim_id": "int",
    "acd28a24_d77b_45e2_911d_aef7c14b9dd9": "string",
    "ach": "string",
    "ae2af6e6_4a12_477d_ac4c_57a0f8a31e5c": "string",
    "american_express": "string",
    "amount": "decimal",
    "b34cc648_ef53_40f9_8756_31ce067aa9b7": "string",
    "bb48d444_e987_43c8_8d87_4ccd1af7f14d": "string",
    "be79e414_4ca2_4317_a58c_60fd6850ab2f": "string",
    "bf054065_80b3_41d0_9672_efbc23d87c8e": "string",
    "c7a02d09_a9e1_4d43_92aa_5119739f0c9e": "string",
    "card_on_file": "string",
    "cash": "string",
    "cbc1a65b_3484_4ab8_8364_5582cf68168a": "string",
    "charge_number": "string",
    "check_number": "string",
    "company_dim_id": "int",
    "d0913adf_6ec0_4a74_a11f_689c9b1e9d63": "string",
    "d68eabbf_f789_4b63_ad21_25aa20a226ea": "string",
    "date_dim_id": "int",
    "de056143_f1e9_4bba_b872_a0af34fb0ed7": "string",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "df89f01d_f95f_424f_9c8a_9832e0881287": "string",
    "discount": "decimal",
    "due_on_date_dim_id": "int",
    "e5ae3b82_b25e_4de3_b4e4_c676a6fb4401": "string",
    "e7ec37dd_61b1_49b2_9554_fe70c8c67b7a": "string",
    "e818d1b5_e4f0_4e4d_b332_8ae19f1022f7": "string",
    "e914bb3c_c58b_4098_a80b_489e1eb3ae62": "string",
    "eb8cbcb2_36f6_40d3_9902_485dc57c78a8": "string",
    "ec582b62_3c35_4ea8_a0a5_34bbeb381660": "string",
    "ef2314bd_7cde_4eac_8a95_3ebaaca4eb94": "string",
    "f": "string",
    "f076e615_d86c_4fdb_be88_3d94a55c8f57": "string",
    "f1545202_e924_4c8a_8e31_6b2c473571f8": "string",
    "f4982057_d497_4fe0_acb5_a0c9600c7889": "string",
    "fa103eee_c643_4196_9447_4fe88ce51f74": "string",
    "facility_dim_id": "int",
    "fms": "string",
    "in_store": "string",
    "is_reversal": "string",
    "line_description": "string",
    "mastercard": "string",
    "money_order_number": "string",
    "parent_payment_uuid": "string",
    "payer_account_dim_id": "int",
    "payment_kind": "string",
    "payment_line_fact_id": "bigint",
    "payment_source": "string",
    "payment_uuid": "string",
    "phone": "string",
    "provider": "string",
    "provider_id": "string",
    "receipt_number": "string",
    "received_epoch": "bigint",
    "service_end_date_dim_id": "int",
    "service_start_date_dim_id": "int",
    "tenant_dim_id": "int",
    "tenant_portal": "string",
    "transaction_id": "string",
    "transaction_type": "string",
    "unit_dim_id": "int",
    "visa": "string"
}

schema_name_id: 992
schema_scan_id: 4659043
updated: 2023-02-26 01:24:01

Version 504218

created: 2023-02-25 01:18:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
    "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_payment_line_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_payment_line_fact`\n(\n `65537143`  string , `fms`  string , `be79e414_4ca2_4317_a58c_60fd6850ab2f`  string , `ec582b62_3c35_4ea8_a0a5_34bbeb381660`  string , `Payment`  string , `12_00`  string , `0_00`  string , `414160195`  string , `Protection_Plan____2_000_00`  string , `004163592632`  string , `____8212`  string , `mastercard`  string , `173678986`  string , `8475271`  string , `101858`  string , `2410875`  string , `20220805`  string , `20220801`  string , `20220831`  string , `42`  string , `1659672566982`  string , `f`  string , `81`  string , `card_on_file`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-25/1677309430'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_payment_line_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-25/1677309430
id: 504218
processed: 1

raw_data:

{
    "": 27,
    "****8212": 13,
    "0.00": 7,
    "004163592632": 10,
    "101858": 17,
    "12.00": 6,
    "1659672566982": 24,
    "173678986": 15,
    "20220801": 21,
    "20220805": 19,
    "20220831": 22,
    "2410875": 18,
    "414160195": 8,
    "42": 23,
    "65537143": 0,
    "81": 28,
    "8475271": 16,
    "Payment": 5,
    "Protection Plan - $2,000.00": 9,
    "be79e414-4ca2-4317-a58c-60fd6850ab2f": 2,
    "card_on_file": 29,
    "ec582b62-3c35-4ea8-a0a5-34bbeb381660": 3,
    "f": 26,
    "fms": 1,
    "mastercard": 14
}

schema_attributes:

{
    "001654440721": "string",
    "001654445851": "string",
    "001654485791": "string",
    "001654552871": "string",
    "001654881131": "string",
    "001716408051": "string",
    "001717018861": "string",
    "001717019101": "string",
    "001717020101": "string",
    "001717027991": "string",
    "001717028321": "string",
    "001717028621": "string",
    "001717028951": "string",
    "001717029951": "string",
    "001717030121": "string",
    "001717931471": "string",
    "001719441591": "string",
    "001719442041": "string",
    "001828888541": "string",
    "004003fe_f420_474b_b039_88b1179483bd": "string",
    "004007410212": "string",
    "004163592632": "string",
    "004163595492": "string",
    "004163595502": "string",
    "004163597762": "string",
    "004163599042": "string",
    "004163601052": "string",
    "004163602012": "string",
    "004163637352": "string",
    "004163640222": "string",
    "004163643972": "string",
    "004163649652": "string",
    "004163651182": "string",
    "004230918642": "string",
    "004230918722": "string",
    "004231484582": "string",
    "056d753c_29c3_4d6d_9351_a547c3ebeb8a": "string",
    "068aef80_ecff_4f3b_ba04_cac574cefb45": "string",
    "0_00": "string",
    "0bd61b94_4592_4242_b4ae_4b7ce3e7ad0d": "string",
    "0c3c17dd_2165_4142_8676_b0f98d71f526": "string",
    "0ca501f6_0746_46e5_b21c_f3300bd1c0f5": "string",
    "0d605c30_d7ce_47a2_8a96_56e5f6ab161b": "string",
    "0f775bc1_553c_4b6c_8cc1_148c8330002b": "string",
    "1": "string",
    "1006475": "string",
    "100_00": "string",
    "101858": "string",
    "101_00": "string",
    "1042150": "string",
    "104800017": "string",
    "1048165": "string",
    "1067654": "string",
    "107069871": "string",
    "1077411": "string",
    "108128": "string",
    "1084121": "string",
    "108605138": "string",
    "109": "string",
    "109_00": "string",
    "10_00": "string",
    "111_00": "string",
    "11264797": "string",
    "11488266": "string",
    "11494996": "string",
    "11497535": "string",
    "117709438": "string",
    "120_00": "string",
    "122_00": "string",
    "12403212": "string",
    "1251453": "string",
    "1275015": "string",
    "1287160": "string",
    "12_00": "string",
    "130_00": "string",
    "132033245": "string",
    "132120233": "string",
    "1326968": "string",
    "1327815": "string",
    "1334745": "string",
    "1347": "string",
    "1349": "string",
    "134_11": "string",
    "136_00": "string",
    "137619738": "string",
    "13_00": "string",
    "13_75": "string",
    "13a37b9a_f9ce_4750_adf3_beb35f980b3e": "string",
    "140_00": "string",
    "142071183": "string",
    "142991251": "string",
    "143877356": "string",
    "14622412": "string",
    "148": "string",
    "1483872": "string",
    "149847097": "string",
    "14de90b3_9e04_41ea_a16d_91b598e1ddf4": "string",
    "154_00": "string",
    "157098258": "string",
    "15992": "string",
    "15df2ef8_2f36_472f_87d8_1c09d2205e58": "string",
    "1612986": "string",
    "1644941754376": "string",
    "1644942294425": "string",
    "1644942296294": "string",
    "1644942590060": "string",
    "1644943882602": "string",
    "1644944635680": "string",
    "1644949095218": "string",
    "1646866742342": "string",
    "1646867576709": "string",
    "1646902240501": "string",
    "1646902245657": "string",
    "1646902254384": "string",
    "1646902330266": "string",
    "1646902336273": "string",
    "1646902339783": "string",
    "1646902351346": "string",
    "1646902355859": "string",
    "1646902646837": "string",
    "1646931775141": "string",
    "1646941196356": "string",
    "1646950327207": "string",
    "1646976996510": "string",
    "1646977027614": "string",
    "1650862520786": "string",
    "1654367486470": "string",
    "1659672566982": "string",
    "1659672846208": "string",
    "1659672850761": "string",
    "1659673011290": "string",
    "1659673023589": "string",
    "1659673088981": "string",
    "1659673124771": "string",
    "1659674095577": "string",
    "1659676685461": "string",
    "1659676877405": "string",
    "1659677064699": "string",
    "1659677113773": "string",
    "1659677268392": "string",
    "165_00": "string",
    "1662026727860": "string",
    "1662026728617": "string",
    "1662037460423": "string",
    "1691115": "string",
    "1707427": "string",
    "172872275": "string",
    "173054450": "string",
    "173678986": "string",
    "173_37": "string",
    "17_63": "string",
    "1802": "string",
    "180210687": "string",
    "180211087": "string",
    "1856640": "string",
    "1868": "string",
    "18_00": "string",
    "1918334": "string",
    "1993062": "string",
    "1dd13f76_0e49_466f_b786_63dcdf118780": "string",
    "1f0f3420_4b33_4a9c_b89a_af1822e0daf8": "string",
    "1f46842b_bcdd_40ff_8e14_bf72cc7220c5": "string",
    "20220106": "string",
    "20220206": "string",
    "20220212": "string",
    "20220215": "string",
    "20220301": "string",
    "20220305": "string",
    "20220306": "string",
    "20220309": "string",
    "20220310": "string",
    "20220311": "string",
    "20220314": "string",
    "20220331": "string",
    "20220409": "string",
    "20220410": "string",
    "20220425": "string",
    "20220524": "string",
    "20220601": "string",
    "20220604": "string",
    "20220630": "string",
    "20220801": "string",
    "20220803": "string",
    "20220805": "string",
    "20220831": "string",
    "20220901": "string",
    "20220904": "string",
    "20220930": "string",
    "20_00": "string",
    "221_00": "string",
    "22964": "string",
    "22_00": "string",
    "23b6859e_9932_441b_9152_104e69930dbb": "string",
    "2406946": "string",
    "2410413": "string",
    "2410875": "string",
    "25562": "string",
    "2627850": "string",
    "26543f30_47d6_46c8_8034_fa6edc3fe8a5": "string",
    "26784": "string",
    "275_00": "string",
    "27809c8f_09c9_4321_a7c4_965b21120781": "string",
    "2792": "string",
    "27a7a986_e888_4b62_a346_2d026f819b44": "string",
    "2854616": "string",
    "288ad3d6_50d4_4806_84f4_5fa818773a1b": "string",
    "2957": "string",
    "2_70": "string",
    "3000448": "string",
    "303643c6_293a_4245_a7ca_254e95d64f8f": "string",
    "3069243": "string",
    "3091745": "string",
    "344088214": "string",
    "344088697": "string",
    "344089150": "string",
    "344092072": "string",
    "344096334": "string",
    "344099821": "string",
    "344119443": "string",
    "3494423": "string",
    "352691155": "string",
    "352693349": "string",
    "352825130": "string",
    "352825271": "string",
    "352825323": "string",
    "352826040": "string",
    "352826095": "string",
    "352826130": "string",
    "352826189": "string",
    "352826192": "string",
    "352826262": "string",
    "352907986": "string",
    "352976605": "string",
    "353014559": "string",
    "353080508": "string",
    "353083195": "string",
    "3617": "string",
    "368467669": "string",
    "385185499": "string",
    "389ee133_2a79_4db9_a9ce_a7d92f9c749c": "string",
    "38cefb5f_3c57_4a07_8cc8_507ade312fa0": "string",
    "39": "string",
    "39c9e62c_c841_439d_b031_ee3b8fccf0d6": "string",
    "3edb50a5_0c4f_4ffe_8f49_c8fec4762c4e": "string",
    "3f840aaa_a30f_4f01_8d06_626245b6a79d": "string",
    "40": "string",
    "414160195": "string",
    "414165407": "string",
    "414165474": "string",
    "414168173": "string",
    "414169586": "string",
    "414169773": "string",
    "414171083": "string",
    "414172064": "string",
    "414224579": "string",
    "414229736": "string",
    "414235351": "string",
    "414245662": "string",
    "414248894": "string",
    "42": "string",
    "424264": "string",
    "424726333": "string",
    "424726374": "string",
    "424827451": "string",
    "42a16adb_cbe1_460c_a8c2_47ab74cf1715": "string",
    "42bd94ce_e405_4251_9509_a43c7b11aee6": "string",
    "436285": "string",
    "436660": "string",
    "437170": "string",
    "439744": "string",
    "4406159": "string",
    "441446": "string",
    "4430577": "string",
    "445313": "string",
    "447732": "string",
    "448889": "string",
    "449241": "string",
    "44f0e53e_cf3d_4539_948c_5242a89c38a0": "string",
    "45": "string",
    "452552": "string",
    "456303": "string",
    "456544": "string",
    "456884": "string",
    "463622": "string",
    "465": "string",
    "465631": "string",
    "466418": "string",
    "47": "string",
    "473632ec_9a22_4834_8981_b4a154c84ef9": "string",
    "4739": "string",
    "49e2e083_cd10_4128_913c_551bec853268": "string",
    "4_80": "string",
    "4bffb987_3732_4adb_bf69_c27a4dfc5e8b": "string",
    "4c7e09a9_5d66_40c1_860a_7b139cfc7214": "string",
    "4d5ed596_26d1_4952_ae24_90e8d813b016": "string",
    "4f7d8b51_cc79_423c_a440_ca155e5e687c": "string",
    "5104360": "string",
    "513315": "string",
    "51830": "string",
    "526014": "string",
    "5280884": "string",
    "5366797": "string",
    "53904271": "string",
    "53904377": "string",
    "53904441": "string",
    "53904990": "string",
    "53905840": "string",
    "53906564": "string",
    "53910872": "string",
    "5452674": "string",
    "54d11946_f228_43e8_ba75_2e2b95acb4b5": "string",
    "55": "string",
    "55586346": "string",
    "55586739": "string",
    "55601894": "string",
    "55601925": "string",
    "55602045": "string",
    "55602992": "string",
    "55603068": "string",
    "55603086": "string",
    "55603126": "string",
    "55603177": "string",
    "55603266": "string",
    "55615296": "string",
    "55627788": "string",
    "55638627": "string",
    "55651626": "string",
    "55651750": "string",
    "55_00": "string",
    "560651": "string",
    "5632390": "string",
    "56a47379_2b43_416c_a48b_6d0f4b90ba18": "string",
    "5704278": "string",
    "578704be_3a5f_4e05_96f4_476aa7132331": "string",
    "58038624": "string",
    "582": "string",
    "586": "string",
    "5874517": "string",
    "592212": "string",
    "593a6c64_3471_43d8_9e3d_56320d91b0f9": "string",
    "595520": "string",
    "595944": "string",
    "599600": "string",
    "5b0355f8_a5c6_4a47_a463_f2a03f9411e6": "string",
    "5b2da068_b9ac_4dba_bc21_5b9bcc423e29": "string",
    "604": "string",
    "608": "string",
    "61": "string",
    "612": "string",
    "61254868": "string",
    "6148e1ee_70b1_45e4_af26_5f41b49a5ce1": "string",
    "61_00": "string",
    "6275536": "string",
    "63": "string",
    "6390916": "string",
    "63_96": "string",
    "644781": "string",
    "65537143": "string",
    "65537496": "string",
    "65537639": "string",
    "65538070": "string",
    "65538357": "string",
    "65538390": "string",
    "65539117": "string",
    "65539235": "string",
    "65545678": "string",
    "65546376": "string",
    "65547156": "string",
    "65548094": "string",
    "65548375": "string",
    "6725009": "string",
    "67300974": "string",
    "67300993": "string",
    "67322226": "string",
    "6752732": "string",
    "6763135": "string",
    "6768941": "string",
    "68424": "string",
    "68_00": "string",
    "6ef7da9d_2cc2_4da2_8fc6_e4779fa21479": "string",
    "6f3fa75d_93c7_4137_8ae0_ed0d576bc2fe": "string",
    "7075623": "string",
    "7087650": "string",
    "7150a05a_56f6_41e0_91e6_4e3d7b980b96": "string",
    "715131": "string",
    "71628409": "string",
    "7241913": "string",
    "73247": "string",
    "7333660": "string",
    "7360235": "string",
    "736917": "string",
    "7386740": "string",
    "73981283": "string",
    "742d3feb_e02b_4c0f_a078_1c0c9116ce9e": "string",
    "745003": "string",
    "7541435": "string",
    "76_00": "string",
    "771": "string",
    "773d2453_f5fa_4aad_8532_ddf424a71ed7": "string",
    "7794913": "string",
    "785af5e0_79a9_4cc4_90e4_b78249f6fa6c": "string",
    "786085": "string",
    "78692": "string",
    "78776310": "string",
    "7b8fb7b8_430f_442b_a284_d00a93411dce": "string",
    "7e1086e3_8e2f_4635_aaeb_35d7249adae8": "string",
    "80": "string",
    "80_00": "string",
    "81": "string",
    "818": "string",
    "8184092": "string",
    "82": "string",
    "8202220": "string",
    "837": "string",
    "84": "string",
    "844d4410_6fb9_48c3_b450_dc40f7a2b408": "string",
    "8475271": "string",
    "849": "string",
    "854": "string",
    "86": "string",
    "8737397": "string",
    "8737490": "string",
    "8d7680df_4283_4885_99f6_4e9168360b8f": "string",
    "906485": "string",
    "90836": "string",
    "909b1673_fa2b_4de4_9acf_b8b56c4960f5": "string",
    "927777ad_8cee_40f1_ae6e_f0ae2fa97e12": "string",
    "939337": "string",
    "9427ba1e_15f3_4c6c_920d_0ebf13da070a": "string",
    "947": "string",
    "951b6b66_4d0e_48a2_96e6_15a7ab9ab173": "string",
    "959929": "string",
    "95_00": "string",
    "965422": "string",
    "96786251": "string",
    "97014316": "string",
    "97723333": "string",
    "981412": "string",
    "9_00": "string",
    "9_54": "string",
    "9_75": "string",
    "9f30b4c9_ead1_423c_8930_cfadaae54764": "string",
    "BOXES___SMALL": "string",
    "BOX_E___WARDROBE": "string",
    "Bader_Company____2_000_00": "string",
    "Bader_Program____2_000_00": "string",
    "Bader_Program____3_000_00": "string",
    "CPUCG5KYZO": "string",
    "California_Fee_Schedule": "string",
    "Credit_Card_Processing_Fee": "string",
    "DNX7VDCFSB": "string",
    "Late_Fee": "string",
    "Payment": "string",
    "Protection_Plan____2_000_00": "string",
    "Protection_Plan____2_500_00": "string",
    "Rent_Unit_00368___12x50x9": "string",
    "Rent_Unit_1092___10x10x8": "string",
    "Rent_Unit_1311___10x10x10": "string",
    "Rent_Unit_2160___5x10": "string",
    "Rent_Unit_229___10x10x0": "string",
    "Rent_Unit_3099___7_5x10": "string",
    "Rent_Unit_336___10x10x10": "string",
    "Rent_Unit_432___10x30x8": "string",
    "Rent_Unit_520___10x20x0": "string",
    "Rent_Unit_766___10x10x8": "string",
    "Rent_Unit_78___10x10x0": "string",
    "Rent_Unit_87___10x10": "string",
    "Rent_Unit_C195___5x8x8": "string",
    "Rent_Unit_C_12___10x15x8_5": "string",
    "Rent_Unit_D128___10x10x8": "string",
    "Rent_Unit_D1___5x10x10": "string",
    "Rent_Unit_D26___10x20x0": "string",
    "Rent_Unit_D2___10x20x0": "string",
    "Rent_Unit_G020___10x20x0": "string",
    "Rent_Unit_H451___10x10x0": "string",
    "Rent_Unit_H_27___10x15x8": "string",
    "Rent_Unit_IN_17_102___1x17x0": "string",
    "Rent_Unit_K047___10x10x0": "string",
    "Rent_Unit_OUT_21_102___1x21x0": "string",
    "SBOA_Tenant_Insurance____2_000_00": "string",
    "Xercor_Insurance_Services_LLC____3_000_00": "string",
    "____0057": "string",
    "____0579": "string",
    "____0665": "string",
    "____1005": "string",
    "____1007": "string",
    "____1063": "string",
    "____1181": "string",
    "____2297": "string",
    "____2696": "string",
    "____2756": "string",
    "____3029": "string",
    "____3151": "string",
    "____3603": "string",
    "____4778": "string",
    "____4843": "string",
    "____5483": "string",
    "____5817": "string",
    "____5979": "string",
    "____6090": "string",
    "____6114": "string",
    "____6499": "string",
    "____6584": "string",
    "____6833": "string",
    "____7108": "string",
    "____7700": "string",
    "____8014": "string",
    "____8212": "string",
    "____8318": "string",
    "____8403": "string",
    "____8546": "string",
    "____8760": "string",
    "____8851": "string",
    "____9053": "string",
    "a10564ab_6af8_47f8_9517_111cb2445525": "string",
    "a53db356_b328_435c_b17f_fc39e967bc8c": "string",
    "a566b1ed_253f_4844_ba81_55c5c2c99b5a": "string",
    "account_dim_id": "int",
    "acd28a24_d77b_45e2_911d_aef7c14b9dd9": "string",
    "ach": "string",
    "ae2af6e6_4a12_477d_ac4c_57a0f8a31e5c": "string",
    "american_express": "string",
    "amount": "decimal",
    "b34cc648_ef53_40f9_8756_31ce067aa9b7": "string",
    "bb48d444_e987_43c8_8d87_4ccd1af7f14d": "string",
    "be79e414_4ca2_4317_a58c_60fd6850ab2f": "string",
    "bf054065_80b3_41d0_9672_efbc23d87c8e": "string",
    "c7a02d09_a9e1_4d43_92aa_5119739f0c9e": "string",
    "card_on_file": "string",
    "cash": "string",
    "cbc1a65b_3484_4ab8_8364_5582cf68168a": "string",
    "charge_number": "string",
    "check_number": "string",
    "company_dim_id": "int",
    "d0913adf_6ec0_4a74_a11f_689c9b1e9d63": "string",
    "d68eabbf_f789_4b63_ad21_25aa20a226ea": "string",
    "date_dim_id": "int",
    "de056143_f1e9_4bba_b872_a0af34fb0ed7": "string",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "df89f01d_f95f_424f_9c8a_9832e0881287": "string",
    "discount": "decimal",
    "due_on_date_dim_id": "int",
    "e5ae3b82_b25e_4de3_b4e4_c676a6fb4401": "string",
    "e7ec37dd_61b1_49b2_9554_fe70c8c67b7a": "string",
    "e818d1b5_e4f0_4e4d_b332_8ae19f1022f7": "string",
    "e914bb3c_c58b_4098_a80b_489e1eb3ae62": "string",
    "eb8cbcb2_36f6_40d3_9902_485dc57c78a8": "string",
    "ec582b62_3c35_4ea8_a0a5_34bbeb381660": "string",
    "ef2314bd_7cde_4eac_8a95_3ebaaca4eb94": "string",
    "f": "string",
    "f076e615_d86c_4fdb_be88_3d94a55c8f57": "string",
    "f1545202_e924_4c8a_8e31_6b2c473571f8": "string",
    "f4982057_d497_4fe0_acb5_a0c9600c7889": "string",
    "fa103eee_c643_4196_9447_4fe88ce51f74": "string",
    "facility_dim_id": "int",
    "fms": "string",
    "in_store": "string",
    "is_reversal": "string",
    "line_description": "string",
    "mastercard": "string",
    "money_order_number": "string",
    "parent_payment_uuid": "string",
    "payer_account_dim_id": "int",
    "payment_kind": "string",
    "payment_line_fact_id": "bigint",
    "payment_source": "string",
    "payment_uuid": "string",
    "phone": "string",
    "provider": "string",
    "provider_id": "string",
    "receipt_number": "string",
    "received_epoch": "bigint",
    "service_end_date_dim_id": "int",
    "service_start_date_dim_id": "int",
    "tenant_dim_id": "int",
    "tenant_portal": "string",
    "transaction_id": "string",
    "transaction_type": "string",
    "unit_dim_id": "int",
    "visa": "string"
}

schema_name_id: 992
schema_scan_id: 4656668
updated: 2023-02-25 01:18:20

Schema Scans: 3

Last at 2023-02-27 09:16:30

Scan 4662286

duration: 0:00:19.440497

exit_message:

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

id: 4662286

payload:

{
    "datatype_dict": {
        "account_dim_id": "int",
        "amount": "decimal",
        "charge_number": "string",
        "check_number": "string",
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "discount": "decimal",
        "due_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "is_reversal": "string",
        "line_description": "string",
        "money_order_number": "string",
        "parent_payment_uuid": "string",
        "payer_account_dim_id": "int",
        "payment_kind": "string",
        "payment_line_fact_id": "bigint",
        "payment_source": "string",
        "payment_uuid": "string",
        "provider": "string",
        "provider_id": "string",
        "receipt_number": "string",
        "received_epoch": "bigint",
        "service_end_date_dim_id": "int",
        "service_start_date_dim_id": "int",
        "tenant_dim_id": "int",
        "transaction_id": "string",
        "transaction_type": "string",
        "unit_dim_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-stage",
        "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-27/1677510951",
        "key": "raw/payment_line_fact/2023-02-27/1677510951/data_1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_postgres.keplernormies_payment_line_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15717587439099338052,
        "service_name": "kepler-normies",
        "span_id": 4244553675852956342,
        "trace_id": 15717587439099338052
    }
}

running: False
schema_name_id: 992
start_time: 2023-02-27 09:16:30
success: True
trace_id: 15717587439099338052

Scan 4659043

duration: 0:00:19.236431

exit_message:

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

id: 4659043

payload:

{
    "datatype_dict": {
        "account_dim_id": "int",
        "amount": "decimal",
        "charge_number": "string",
        "check_number": "string",
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "discount": "decimal",
        "due_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "is_reversal": "string",
        "line_description": "string",
        "money_order_number": "string",
        "parent_payment_uuid": "string",
        "payer_account_dim_id": "int",
        "payment_kind": "string",
        "payment_line_fact_id": "bigint",
        "payment_source": "string",
        "payment_uuid": "string",
        "provider": "string",
        "provider_id": "string",
        "receipt_number": "string",
        "received_epoch": "bigint",
        "service_end_date_dim_id": "int",
        "service_start_date_dim_id": "int",
        "tenant_dim_id": "int",
        "transaction_id": "string",
        "transaction_type": "string",
        "unit_dim_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-stage",
        "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-26/1677396166",
        "key": "raw/payment_line_fact/2023-02-26/1677396166/data_1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_postgres.keplernormies_payment_line_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 661043827581623589,
        "service_name": "kepler-normies",
        "span_id": 15791678635262148072,
        "trace_id": 661043827581623589
    }
}

running: False
schema_name_id: 992
start_time: 2023-02-26 01:23:42
success: True
trace_id: 661043827581623589

Scan 4656668

duration: 0:00:19.092109

exit_message:

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

id: 4656668

payload:

{
    "datatype_dict": {
        "account_dim_id": "int",
        "amount": "decimal",
        "charge_number": "string",
        "check_number": "string",
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "discount": "decimal",
        "due_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "is_reversal": "string",
        "line_description": "string",
        "money_order_number": "string",
        "parent_payment_uuid": "string",
        "payer_account_dim_id": "int",
        "payment_kind": "string",
        "payment_line_fact_id": "bigint",
        "payment_source": "string",
        "payment_uuid": "string",
        "provider": "string",
        "provider_id": "string",
        "receipt_number": "string",
        "received_epoch": "bigint",
        "service_end_date_dim_id": "int",
        "service_start_date_dim_id": "int",
        "tenant_dim_id": "int",
        "transaction_id": "string",
        "transaction_type": "string",
        "unit_dim_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-stage",
        "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-25/1677309430",
        "key": "raw/payment_line_fact/2023-02-25/1677309430/data_1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_postgres.keplernormies_payment_line_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15839672382931293846,
        "service_name": "kepler-normies",
        "span_id": 6631611066848159910,
        "trace_id": 15839672382931293846
    }
}

running: False
schema_name_id: 992
start_time: 2023-02-25 01:18:01
success: True
trace_id: 15839672382931293846

Partitions:

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

Schema:

attributes:

{
    "001654440721": "string",
    "001654445851": "string",
    "001654485791": "string",
    "001654552871": "string",
    "001654881131": "string",
    "001716408051": "string",
    "001717018861": "string",
    "001717019101": "string",
    "001717020101": "string",
    "001717027991": "string",
    "001717028321": "string",
    "001717028621": "string",
    "001717028951": "string",
    "001717029951": "string",
    "001717030121": "string",
    "001717931471": "string",
    "001719441591": "string",
    "001719442041": "string",
    "001828888541": "string",
    "004003fe_f420_474b_b039_88b1179483bd": "string",
    "004007410212": "string",
    "004163509532": "string",
    "004163571792": "string",
    "004163592632": "string",
    "004163595492": "string",
    "004163595502": "string",
    "004163597762": "string",
    "004163599042": "string",
    "004163601052": "string",
    "004163602012": "string",
    "004163637352": "string",
    "004163640222": "string",
    "004163643972": "string",
    "004163649652": "string",
    "004163651182": "string",
    "004230918642": "string",
    "004230918722": "string",
    "004231484582": "string",
    "056d753c_29c3_4d6d_9351_a547c3ebeb8a": "string",
    "068aef80_ecff_4f3b_ba04_cac574cefb45": "string",
    "0_00": "string",
    "0bd61b94_4592_4242_b4ae_4b7ce3e7ad0d": "string",
    "0c3c17dd_2165_4142_8676_b0f98d71f526": "string",
    "0ca501f6_0746_46e5_b21c_f3300bd1c0f5": "string",
    "0d605c30_d7ce_47a2_8a96_56e5f6ab161b": "string",
    "0e927783_97b5_4723_8ffc_794ea13a08c3": "string",
    "0f775bc1_553c_4b6c_8cc1_148c8330002b": "string",
    "1": "string",
    "1006475": "string",
    "100_00": "string",
    "101858": "string",
    "101_00": "string",
    "1042150": "string",
    "104800017": "string",
    "1048165": "string",
    "1067654": "string",
    "107069871": "string",
    "1077411": "string",
    "108128": "string",
    "1084121": "string",
    "108605138": "string",
    "109": "string",
    "109_00": "string",
    "10_00": "string",
    "111_00": "string",
    "11264797": "string",
    "11488266": "string",
    "11494996": "string",
    "11497535": "string",
    "117709438": "string",
    "120_00": "string",
    "122_00": "string",
    "12403212": "string",
    "1251453": "string",
    "1275015": "string",
    "1287160": "string",
    "12_00": "string",
    "130_00": "string",
    "132033245": "string",
    "132120233": "string",
    "1326968": "string",
    "1327815": "string",
    "1334745": "string",
    "1347": "string",
    "1349": "string",
    "134_11": "string",
    "136_00": "string",
    "137619738": "string",
    "13_00": "string",
    "13_75": "string",
    "13a37b9a_f9ce_4750_adf3_beb35f980b3e": "string",
    "140_00": "string",
    "142071183": "string",
    "142991251": "string",
    "143877356": "string",
    "14622412": "string",
    "148": "string",
    "1483872": "string",
    "149847097": "string",
    "14de90b3_9e04_41ea_a16d_91b598e1ddf4": "string",
    "154_00": "string",
    "157098258": "string",
    "15992": "string",
    "15df2ef8_2f36_472f_87d8_1c09d2205e58": "string",
    "1612986": "string",
    "1644941754376": "string",
    "1644942294425": "string",
    "1644942296294": "string",
    "1644942590060": "string",
    "1644943882602": "string",
    "1644944635680": "string",
    "1644949095218": "string",
    "1646866742342": "string",
    "1646867576709": "string",
    "1646902240501": "string",
    "1646902245657": "string",
    "1646902254384": "string",
    "1646902330266": "string",
    "1646902336273": "string",
    "1646902339783": "string",
    "1646902351346": "string",
    "1646902355859": "string",
    "1646902646837": "string",
    "1646931775141": "string",
    "1646941196356": "string",
    "1646950327207": "string",
    "1646976996510": "string",
    "1646977027614": "string",
    "1650862520786": "string",
    "1654367486470": "string",
    "1659661716018": "string",
    "1659670718894": "string",
    "1659672566982": "string",
    "1659672846208": "string",
    "1659672850761": "string",
    "1659673011290": "string",
    "1659673023589": "string",
    "1659673088981": "string",
    "1659673124771": "string",
    "1659674095577": "string",
    "1659676685461": "string",
    "1659676877405": "string",
    "1659677064699": "string",
    "1659677113773": "string",
    "1659677268392": "string",
    "165_00": "string",
    "1662026727860": "string",
    "1662026728617": "string",
    "1662037460423": "string",
    "1691115": "string",
    "1707427": "string",
    "172872275": "string",
    "173054450": "string",
    "173678986": "string",
    "173_37": "string",
    "1748166": "string",
    "17_63": "string",
    "1802": "string",
    "180210687": "string",
    "180211087": "string",
    "1856640": "string",
    "1868": "string",
    "18_00": "string",
    "1918334": "string",
    "1993062": "string",
    "1dd13f76_0e49_466f_b786_63dcdf118780": "string",
    "1f0f3420_4b33_4a9c_b89a_af1822e0daf8": "string",
    "1f46842b_bcdd_40ff_8e14_bf72cc7220c5": "string",
    "20220106": "string",
    "20220206": "string",
    "20220212": "string",
    "20220215": "string",
    "20220301": "string",
    "20220305": "string",
    "20220306": "string",
    "20220309": "string",
    "20220310": "string",
    "20220311": "string",
    "20220314": "string",
    "20220331": "string",
    "20220409": "string",
    "20220410": "string",
    "20220425": "string",
    "20220524": "string",
    "20220601": "string",
    "20220604": "string",
    "20220630": "string",
    "20220801": "string",
    "20220803": "string",
    "20220805": "string",
    "20220831": "string",
    "20220901": "string",
    "20220904": "string",
    "20220930": "string",
    "20_00": "string",
    "221_00": "string",
    "22964": "string",
    "22_00": "string",
    "23b6859e_9932_441b_9152_104e69930dbb": "string",
    "2406946": "string",
    "2410413": "string",
    "2410875": "string",
    "25562": "string",
    "2627850": "string",
    "26543f30_47d6_46c8_8034_fa6edc3fe8a5": "string",
    "26784": "string",
    "275_00": "string",
    "27809c8f_09c9_4321_a7c4_965b21120781": "string",
    "2792": "string",
    "27a7a986_e888_4b62_a346_2d026f819b44": "string",
    "2854616": "string",
    "288ad3d6_50d4_4806_84f4_5fa818773a1b": "string",
    "28e42a52_e7df_45e4_bf66_da9d5d1fcd92": "string",
    "2957": "string",
    "2_70": "string",
    "3000448": "string",
    "303643c6_293a_4245_a7ca_254e95d64f8f": "string",
    "3069243": "string",
    "3091745": "string",
    "3255918": "string",
    "344088214": "string",
    "344088697": "string",
    "344089150": "string",
    "344092072": "string",
    "344096334": "string",
    "344099821": "string",
    "344119443": "string",
    "3494423": "string",
    "352691155": "string",
    "352693349": "string",
    "352825130": "string",
    "352825271": "string",
    "352825323": "string",
    "352826040": "string",
    "352826095": "string",
    "352826130": "string",
    "352826189": "string",
    "352826192": "string",
    "352826262": "string",
    "352907986": "string",
    "352976605": "string",
    "353014559": "string",
    "353080508": "string",
    "353083195": "string",
    "3617": "string",
    "368467669": "string",
    "385185499": "string",
    "389ee133_2a79_4db9_a9ce_a7d92f9c749c": "string",
    "38cefb5f_3c57_4a07_8cc8_507ade312fa0": "string",
    "39": "string",
    "39c9e62c_c841_439d_b031_ee3b8fccf0d6": "string",
    "3edb50a5_0c4f_4ffe_8f49_c8fec4762c4e": "string",
    "3f840aaa_a30f_4f01_8d06_626245b6a79d": "string",
    "40": "string",
    "414145183": "string",
    "414157664": "string",
    "414160195": "string",
    "414165407": "string",
    "414165474": "string",
    "414168173": "string",
    "414169586": "string",
    "414169773": "string",
    "414171083": "string",
    "414172064": "string",
    "414224579": "string",
    "414229736": "string",
    "414235351": "string",
    "414245662": "string",
    "414248894": "string",
    "42": "string",
    "424264": "string",
    "424726333": "string",
    "424726374": "string",
    "424827451": "string",
    "42a16adb_cbe1_460c_a8c2_47ab74cf1715": "string",
    "42bd94ce_e405_4251_9509_a43c7b11aee6": "string",
    "436285": "string",
    "436660": "string",
    "437170": "string",
    "439744": "string",
    "4406159": "string",
    "441446": "string",
    "4430577": "string",
    "445313": "string",
    "447732": "string",
    "448889": "string",
    "449241": "string",
    "44f0e53e_cf3d_4539_948c_5242a89c38a0": "string",
    "45": "string",
    "452552": "string",
    "456303": "string",
    "456544": "string",
    "456884": "string",
    "463622": "string",
    "465": "string",
    "465631": "string",
    "466418": "string",
    "47": "string",
    "473632ec_9a22_4834_8981_b4a154c84ef9": "string",
    "4739": "string",
    "491529": "string",
    "49e2e083_cd10_4128_913c_551bec853268": "string",
    "4_80": "string",
    "4bffb987_3732_4adb_bf69_c27a4dfc5e8b": "string",
    "4c7e09a9_5d66_40c1_860a_7b139cfc7214": "string",
    "4d5ed596_26d1_4952_ae24_90e8d813b016": "string",
    "4f7d8b51_cc79_423c_a440_ca155e5e687c": "string",
    "5104360": "string",
    "513315": "string",
    "51830": "string",
    "526014": "string",
    "5280884": "string",
    "5366797": "string",
    "53904271": "string",
    "53904377": "string",
    "53904441": "string",
    "53904990": "string",
    "53905840": "string",
    "53906564": "string",
    "53910872": "string",
    "5452674": "string",
    "54d11946_f228_43e8_ba75_2e2b95acb4b5": "string",
    "55": "string",
    "55586346": "string",
    "55586739": "string",
    "55601894": "string",
    "55601925": "string",
    "55602045": "string",
    "55602992": "string",
    "55603068": "string",
    "55603086": "string",
    "55603126": "string",
    "55603177": "string",
    "55603266": "string",
    "55615296": "string",
    "55627788": "string",
    "55638627": "string",
    "55651626": "string",
    "55651750": "string",
    "55853868": "string",
    "55_00": "string",
    "560651": "string",
    "5632390": "string",
    "56a47379_2b43_416c_a48b_6d0f4b90ba18": "string",
    "5704278": "string",
    "578704be_3a5f_4e05_96f4_476aa7132331": "string",
    "58038624": "string",
    "582": "string",
    "586": "string",
    "5874517": "string",
    "592212": "string",
    "593a6c64_3471_43d8_9e3d_56320d91b0f9": "string",
    "595520": "string",
    "595944": "string",
    "599600": "string",
    "5b0355f8_a5c6_4a47_a463_f2a03f9411e6": "string",
    "5b2da068_b9ac_4dba_bc21_5b9bcc423e29": "string",
    "604": "string",
    "608": "string",
    "61": "string",
    "612": "string",
    "61254868": "string",
    "6148e1ee_70b1_45e4_af26_5f41b49a5ce1": "string",
    "61_00": "string",
    "6275536": "string",
    "63": "string",
    "6390916": "string",
    "63_96": "string",
    "644781": "string",
    "65532513": "string",
    "65536784": "string",
    "65537143": "string",
    "65537496": "string",
    "65537639": "string",
    "65538070": "string",
    "65538357": "string",
    "65538390": "string",
    "65539117": "string",
    "65539235": "string",
    "65545678": "string",
    "65546376": "string",
    "65547156": "string",
    "65548094": "string",
    "65548375": "string",
    "6725009": "string",
    "67300974": "string",
    "67300993": "string",
    "67322226": "string",
    "6752732": "string",
    "6763135": "string",
    "6768941": "string",
    "68424": "string",
    "68_00": "string",
    "6ef7da9d_2cc2_4da2_8fc6_e4779fa21479": "string",
    "6f3fa75d_93c7_4137_8ae0_ed0d576bc2fe": "string",
    "7075623": "string",
    "7087650": "string",
    "7150a05a_56f6_41e0_91e6_4e3d7b980b96": "string",
    "715131": "string",
    "71628409": "string",
    "7241913": "string",
    "73247": "string",
    "7333660": "string",
    "7360235": "string",
    "736917": "string",
    "7386740": "string",
    "73981283": "string",
    "742d3feb_e02b_4c0f_a078_1c0c9116ce9e": "string",
    "745003": "string",
    "7541435": "string",
    "75_00": "string",
    "76_00": "string",
    "771": "string",
    "773d2453_f5fa_4aad_8532_ddf424a71ed7": "string",
    "7794913": "string",
    "783744": "string",
    "785af5e0_79a9_4cc4_90e4_b78249f6fa6c": "string",
    "786085": "string",
    "78692": "string",
    "78776310": "string",
    "7b8fb7b8_430f_442b_a284_d00a93411dce": "string",
    "7e1086e3_8e2f_4635_aaeb_35d7249adae8": "string",
    "80": "string",
    "80_00": "string",
    "81": "string",
    "81672020": "string",
    "818": "string",
    "8184092": "string",
    "82": "string",
    "8202220": "string",
    "837": "string",
    "84": "string",
    "844d4410_6fb9_48c3_b450_dc40f7a2b408": "string",
    "8475271": "string",
    "849": "string",
    "854": "string",
    "86": "string",
    "863": "string",
    "8737397": "string",
    "8737490": "string",
    "8d7680df_4283_4885_99f6_4e9168360b8f": "string",
    "906485": "string",
    "90836": "string",
    "909b1673_fa2b_4de4_9acf_b8b56c4960f5": "string",
    "927777ad_8cee_40f1_ae6e_f0ae2fa97e12": "string",
    "939337": "string",
    "9427ba1e_15f3_4c6c_920d_0ebf13da070a": "string",
    "947": "string",
    "951b6b66_4d0e_48a2_96e6_15a7ab9ab173": "string",
    "959929": "string",
    "95_00": "string",
    "9634fc2c_b421_4f43_9df8_d6691e86dd75": "string",
    "965422": "string",
    "96786251": "string",
    "97014316": "string",
    "97723333": "string",
    "981412": "string",
    "9_00": "string",
    "9_54": "string",
    "9_75": "string",
    "9f30b4c9_ead1_423c_8930_cfadaae54764": "string",
    "BOXES___SMALL": "string",
    "BOX_E___WARDROBE": "string",
    "Bader_Company____2_000_00": "string",
    "Bader_Program____2_000_00": "string",
    "Bader_Program____3_000_00": "string",
    "CPUCG5KYZO": "string",
    "California_Fee_Schedule": "string",
    "Credit_Card_Processing_Fee": "string",
    "DNX7VDCFSB": "string",
    "Late_Fee": "string",
    "Payment": "string",
    "Protection_Plan____2_000_00": "string",
    "Protection_Plan____2_500_00": "string",
    "Rent_Unit_00368___12x50x9": "string",
    "Rent_Unit_1092___10x10x8": "string",
    "Rent_Unit_1311___10x10x10": "string",
    "Rent_Unit_2160___5x10": "string",
    "Rent_Unit_229___10x10x0": "string",
    "Rent_Unit_231___10x10x8": "string",
    "Rent_Unit_3099___7_5x10": "string",
    "Rent_Unit_336___10x10x10": "string",
    "Rent_Unit_432___10x30x8": "string",
    "Rent_Unit_520___10x20x0": "string",
    "Rent_Unit_766___10x10x8": "string",
    "Rent_Unit_78___10x10x0": "string",
    "Rent_Unit_87___10x10": "string",
    "Rent_Unit_C195___5x8x8": "string",
    "Rent_Unit_C_12___10x15x8_5": "string",
    "Rent_Unit_D128___10x10x8": "string",
    "Rent_Unit_D1___5x10x10": "string",
    "Rent_Unit_D26___10x20x0": "string",
    "Rent_Unit_D2___10x20x0": "string",
    "Rent_Unit_G020___10x20x0": "string",
    "Rent_Unit_H451___10x10x0": "string",
    "Rent_Unit_H_27___10x15x8": "string",
    "Rent_Unit_IN_17_102___1x17x0": "string",
    "Rent_Unit_K047___10x10x0": "string",
    "Rent_Unit_OUT_21_102___1x21x0": "string",
    "SBOA_Tenant_Insurance____2_000_00": "string",
    "Xercor_Insurance_Services_LLC____3_000_00": "string",
    "____0057": "string",
    "____0579": "string",
    "____0665": "string",
    "____1005": "string",
    "____1007": "string",
    "____1063": "string",
    "____1181": "string",
    "____2297": "string",
    "____2696": "string",
    "____2756": "string",
    "____3029": "string",
    "____3151": "string",
    "____3603": "string",
    "____4013": "string",
    "____4778": "string",
    "____4843": "string",
    "____5422": "string",
    "____5483": "string",
    "____5817": "string",
    "____5979": "string",
    "____6090": "string",
    "____6114": "string",
    "____6499": "string",
    "____6584": "string",
    "____6833": "string",
    "____7108": "string",
    "____7700": "string",
    "____8014": "string",
    "____8212": "string",
    "____8318": "string",
    "____8403": "string",
    "____8546": "string",
    "____8760": "string",
    "____8851": "string",
    "____9053": "string",
    "a10564ab_6af8_47f8_9517_111cb2445525": "string",
    "a432c78b_ea84_4229_87f9_af6af7bbbd2f": "string",
    "a53db356_b328_435c_b17f_fc39e967bc8c": "string",
    "a566b1ed_253f_4844_ba81_55c5c2c99b5a": "string",
    "account_dim_id": "int",
    "acd28a24_d77b_45e2_911d_aef7c14b9dd9": "string",
    "ach": "string",
    "ae2af6e6_4a12_477d_ac4c_57a0f8a31e5c": "string",
    "american_express": "string",
    "amount": "decimal",
    "b34cc648_ef53_40f9_8756_31ce067aa9b7": "string",
    "bb48d444_e987_43c8_8d87_4ccd1af7f14d": "string",
    "be79e414_4ca2_4317_a58c_60fd6850ab2f": "string",
    "bf054065_80b3_41d0_9672_efbc23d87c8e": "string",
    "c7a02d09_a9e1_4d43_92aa_5119739f0c9e": "string",
    "card_on_file": "string",
    "cash": "string",
    "cbc1a65b_3484_4ab8_8364_5582cf68168a": "string",
    "charge_number": "string",
    "check_number": "string",
    "company_dim_id": "int",
    "d0913adf_6ec0_4a74_a11f_689c9b1e9d63": "string",
    "d68eabbf_f789_4b63_ad21_25aa20a226ea": "string",
    "date_dim_id": "int",
    "de056143_f1e9_4bba_b872_a0af34fb0ed7": "string",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "df89f01d_f95f_424f_9c8a_9832e0881287": "string",
    "discount": "decimal",
    "due_on_date_dim_id": "int",
    "e5ae3b82_b25e_4de3_b4e4_c676a6fb4401": "string",
    "e7ec37dd_61b1_49b2_9554_fe70c8c67b7a": "string",
    "e818d1b5_e4f0_4e4d_b332_8ae19f1022f7": "string",
    "e914bb3c_c58b_4098_a80b_489e1eb3ae62": "string",
    "eb8cbcb2_36f6_40d3_9902_485dc57c78a8": "string",
    "ec582b62_3c35_4ea8_a0a5_34bbeb381660": "string",
    "ef2314bd_7cde_4eac_8a95_3ebaaca4eb94": "string",
    "f": "string",
    "f076e615_d86c_4fdb_be88_3d94a55c8f57": "string",
    "f1545202_e924_4c8a_8e31_6b2c473571f8": "string",
    "f4982057_d497_4fe0_acb5_a0c9600c7889": "string",
    "fa103eee_c643_4196_9447_4fe88ce51f74": "string",
    "facility_dim_id": "int",
    "fms": "string",
    "in_store": "string",
    "is_reversal": "string",
    "line_description": "string",
    "mastercard": "string",
    "money_order_number": "string",
    "parent_payment_uuid": "string",
    "payer_account_dim_id": "int",
    "payment_kind": "string",
    "payment_line_fact_id": "bigint",
    "payment_source": "string",
    "payment_uuid": "string",
    "phone": "string",
    "provider": "string",
    "provider_id": "string",
    "receipt_number": "string",
    "received_epoch": "bigint",
    "service_end_date_dim_id": "int",
    "service_start_date_dim_id": "int",
    "tenant_dim_id": "int",
    "tenant_portal": "string",
    "transaction_id": "string",
    "transaction_type": "string",
    "unit_dim_id": "int",
    "visa": "string"
}

created: 2023-02-27 09:16:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_payment_line_fact`\n(\n `65532513`  string , `fms`  string , `a432c78b_ea84_4229_87f9_af6af7bbbd2f`  string , `0e927783_97b5_4723_8ffc_794ea13a08c3`  string , `Payment`  string , `12_00`  string , `0_00`  string , `414145183`  string , `Xercor_Insurance_Services_LLC____3_000_00`  string , `004163509532`  string , `____5422`  string , `mastercard`  string , `55853868`  string , `1748166`  string , `148`  string , `491529`  string , `20220805`  string , `20220801`  string , `20220831`  string , `42`  string , `1659661716018`  string , `f`  string , `81`  string , `tenant_portal`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-27/1677510951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_payment_line_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_payment_line_fact"
}

Server:

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

Raw:

{
    "name": {
        "created": "2020-11-13 17:24:11",
        "disabled": false,
        "format": "raw",
        "id": 992,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_postgres",
            "table": "keplernormies_payment_line_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "001654440721": "string",
            "001654445851": "string",
            "001654485791": "string",
            "001654552871": "string",
            "001654881131": "string",
            "001716408051": "string",
            "001717018861": "string",
            "001717019101": "string",
            "001717020101": "string",
            "001717027991": "string",
            "001717028321": "string",
            "001717028621": "string",
            "001717028951": "string",
            "001717029951": "string",
            "001717030121": "string",
            "001717931471": "string",
            "001719441591": "string",
            "001719442041": "string",
            "001828888541": "string",
            "004003fe_f420_474b_b039_88b1179483bd": "string",
            "004007410212": "string",
            "004163509532": "string",
            "004163571792": "string",
            "004163592632": "string",
            "004163595492": "string",
            "004163595502": "string",
            "004163597762": "string",
            "004163599042": "string",
            "004163601052": "string",
            "004163602012": "string",
            "004163637352": "string",
            "004163640222": "string",
            "004163643972": "string",
            "004163649652": "string",
            "004163651182": "string",
            "004230918642": "string",
            "004230918722": "string",
            "004231484582": "string",
            "056d753c_29c3_4d6d_9351_a547c3ebeb8a": "string",
            "068aef80_ecff_4f3b_ba04_cac574cefb45": "string",
            "0_00": "string",
            "0bd61b94_4592_4242_b4ae_4b7ce3e7ad0d": "string",
            "0c3c17dd_2165_4142_8676_b0f98d71f526": "string",
            "0ca501f6_0746_46e5_b21c_f3300bd1c0f5": "string",
            "0d605c30_d7ce_47a2_8a96_56e5f6ab161b": "string",
            "0e927783_97b5_4723_8ffc_794ea13a08c3": "string",
            "0f775bc1_553c_4b6c_8cc1_148c8330002b": "string",
            "1": "string",
            "1006475": "string",
            "100_00": "string",
            "101858": "string",
            "101_00": "string",
            "1042150": "string",
            "104800017": "string",
            "1048165": "string",
            "1067654": "string",
            "107069871": "string",
            "1077411": "string",
            "108128": "string",
            "1084121": "string",
            "108605138": "string",
            "109": "string",
            "109_00": "string",
            "10_00": "string",
            "111_00": "string",
            "11264797": "string",
            "11488266": "string",
            "11494996": "string",
            "11497535": "string",
            "117709438": "string",
            "120_00": "string",
            "122_00": "string",
            "12403212": "string",
            "1251453": "string",
            "1275015": "string",
            "1287160": "string",
            "12_00": "string",
            "130_00": "string",
            "132033245": "string",
            "132120233": "string",
            "1326968": "string",
            "1327815": "string",
            "1334745": "string",
            "1347": "string",
            "1349": "string",
            "134_11": "string",
            "136_00": "string",
            "137619738": "string",
            "13_00": "string",
            "13_75": "string",
            "13a37b9a_f9ce_4750_adf3_beb35f980b3e": "string",
            "140_00": "string",
            "142071183": "string",
            "142991251": "string",
            "143877356": "string",
            "14622412": "string",
            "148": "string",
            "1483872": "string",
            "149847097": "string",
            "14de90b3_9e04_41ea_a16d_91b598e1ddf4": "string",
            "154_00": "string",
            "157098258": "string",
            "15992": "string",
            "15df2ef8_2f36_472f_87d8_1c09d2205e58": "string",
            "1612986": "string",
            "1644941754376": "string",
            "1644942294425": "string",
            "1644942296294": "string",
            "1644942590060": "string",
            "1644943882602": "string",
            "1644944635680": "string",
            "1644949095218": "string",
            "1646866742342": "string",
            "1646867576709": "string",
            "1646902240501": "string",
            "1646902245657": "string",
            "1646902254384": "string",
            "1646902330266": "string",
            "1646902336273": "string",
            "1646902339783": "string",
            "1646902351346": "string",
            "1646902355859": "string",
            "1646902646837": "string",
            "1646931775141": "string",
            "1646941196356": "string",
            "1646950327207": "string",
            "1646976996510": "string",
            "1646977027614": "string",
            "1650862520786": "string",
            "1654367486470": "string",
            "1659661716018": "string",
            "1659670718894": "string",
            "1659672566982": "string",
            "1659672846208": "string",
            "1659672850761": "string",
            "1659673011290": "string",
            "1659673023589": "string",
            "1659673088981": "string",
            "1659673124771": "string",
            "1659674095577": "string",
            "1659676685461": "string",
            "1659676877405": "string",
            "1659677064699": "string",
            "1659677113773": "string",
            "1659677268392": "string",
            "165_00": "string",
            "1662026727860": "string",
            "1662026728617": "string",
            "1662037460423": "string",
            "1691115": "string",
            "1707427": "string",
            "172872275": "string",
            "173054450": "string",
            "173678986": "string",
            "173_37": "string",
            "1748166": "string",
            "17_63": "string",
            "1802": "string",
            "180210687": "string",
            "180211087": "string",
            "1856640": "string",
            "1868": "string",
            "18_00": "string",
            "1918334": "string",
            "1993062": "string",
            "1dd13f76_0e49_466f_b786_63dcdf118780": "string",
            "1f0f3420_4b33_4a9c_b89a_af1822e0daf8": "string",
            "1f46842b_bcdd_40ff_8e14_bf72cc7220c5": "string",
            "20220106": "string",
            "20220206": "string",
            "20220212": "string",
            "20220215": "string",
            "20220301": "string",
            "20220305": "string",
            "20220306": "string",
            "20220309": "string",
            "20220310": "string",
            "20220311": "string",
            "20220314": "string",
            "20220331": "string",
            "20220409": "string",
            "20220410": "string",
            "20220425": "string",
            "20220524": "string",
            "20220601": "string",
            "20220604": "string",
            "20220630": "string",
            "20220801": "string",
            "20220803": "string",
            "20220805": "string",
            "20220831": "string",
            "20220901": "string",
            "20220904": "string",
            "20220930": "string",
            "20_00": "string",
            "221_00": "string",
            "22964": "string",
            "22_00": "string",
            "23b6859e_9932_441b_9152_104e69930dbb": "string",
            "2406946": "string",
            "2410413": "string",
            "2410875": "string",
            "25562": "string",
            "2627850": "string",
            "26543f30_47d6_46c8_8034_fa6edc3fe8a5": "string",
            "26784": "string",
            "275_00": "string",
            "27809c8f_09c9_4321_a7c4_965b21120781": "string",
            "2792": "string",
            "27a7a986_e888_4b62_a346_2d026f819b44": "string",
            "2854616": "string",
            "288ad3d6_50d4_4806_84f4_5fa818773a1b": "string",
            "28e42a52_e7df_45e4_bf66_da9d5d1fcd92": "string",
            "2957": "string",
            "2_70": "string",
            "3000448": "string",
            "303643c6_293a_4245_a7ca_254e95d64f8f": "string",
            "3069243": "string",
            "3091745": "string",
            "3255918": "string",
            "344088214": "string",
            "344088697": "string",
            "344089150": "string",
            "344092072": "string",
            "344096334": "string",
            "344099821": "string",
            "344119443": "string",
            "3494423": "string",
            "352691155": "string",
            "352693349": "string",
            "352825130": "string",
            "352825271": "string",
            "352825323": "string",
            "352826040": "string",
            "352826095": "string",
            "352826130": "string",
            "352826189": "string",
            "352826192": "string",
            "352826262": "string",
            "352907986": "string",
            "352976605": "string",
            "353014559": "string",
            "353080508": "string",
            "353083195": "string",
            "3617": "string",
            "368467669": "string",
            "385185499": "string",
            "389ee133_2a79_4db9_a9ce_a7d92f9c749c": "string",
            "38cefb5f_3c57_4a07_8cc8_507ade312fa0": "string",
            "39": "string",
            "39c9e62c_c841_439d_b031_ee3b8fccf0d6": "string",
            "3edb50a5_0c4f_4ffe_8f49_c8fec4762c4e": "string",
            "3f840aaa_a30f_4f01_8d06_626245b6a79d": "string",
            "40": "string",
            "414145183": "string",
            "414157664": "string",
            "414160195": "string",
            "414165407": "string",
            "414165474": "string",
            "414168173": "string",
            "414169586": "string",
            "414169773": "string",
            "414171083": "string",
            "414172064": "string",
            "414224579": "string",
            "414229736": "string",
            "414235351": "string",
            "414245662": "string",
            "414248894": "string",
            "42": "string",
            "424264": "string",
            "424726333": "string",
            "424726374": "string",
            "424827451": "string",
            "42a16adb_cbe1_460c_a8c2_47ab74cf1715": "string",
            "42bd94ce_e405_4251_9509_a43c7b11aee6": "string",
            "436285": "string",
            "436660": "string",
            "437170": "string",
            "439744": "string",
            "4406159": "string",
            "441446": "string",
            "4430577": "string",
            "445313": "string",
            "447732": "string",
            "448889": "string",
            "449241": "string",
            "44f0e53e_cf3d_4539_948c_5242a89c38a0": "string",
            "45": "string",
            "452552": "string",
            "456303": "string",
            "456544": "string",
            "456884": "string",
            "463622": "string",
            "465": "string",
            "465631": "string",
            "466418": "string",
            "47": "string",
            "473632ec_9a22_4834_8981_b4a154c84ef9": "string",
            "4739": "string",
            "491529": "string",
            "49e2e083_cd10_4128_913c_551bec853268": "string",
            "4_80": "string",
            "4bffb987_3732_4adb_bf69_c27a4dfc5e8b": "string",
            "4c7e09a9_5d66_40c1_860a_7b139cfc7214": "string",
            "4d5ed596_26d1_4952_ae24_90e8d813b016": "string",
            "4f7d8b51_cc79_423c_a440_ca155e5e687c": "string",
            "5104360": "string",
            "513315": "string",
            "51830": "string",
            "526014": "string",
            "5280884": "string",
            "5366797": "string",
            "53904271": "string",
            "53904377": "string",
            "53904441": "string",
            "53904990": "string",
            "53905840": "string",
            "53906564": "string",
            "53910872": "string",
            "5452674": "string",
            "54d11946_f228_43e8_ba75_2e2b95acb4b5": "string",
            "55": "string",
            "55586346": "string",
            "55586739": "string",
            "55601894": "string",
            "55601925": "string",
            "55602045": "string",
            "55602992": "string",
            "55603068": "string",
            "55603086": "string",
            "55603126": "string",
            "55603177": "string",
            "55603266": "string",
            "55615296": "string",
            "55627788": "string",
            "55638627": "string",
            "55651626": "string",
            "55651750": "string",
            "55853868": "string",
            "55_00": "string",
            "560651": "string",
            "5632390": "string",
            "56a47379_2b43_416c_a48b_6d0f4b90ba18": "string",
            "5704278": "string",
            "578704be_3a5f_4e05_96f4_476aa7132331": "string",
            "58038624": "string",
            "582": "string",
            "586": "string",
            "5874517": "string",
            "592212": "string",
            "593a6c64_3471_43d8_9e3d_56320d91b0f9": "string",
            "595520": "string",
            "595944": "string",
            "599600": "string",
            "5b0355f8_a5c6_4a47_a463_f2a03f9411e6": "string",
            "5b2da068_b9ac_4dba_bc21_5b9bcc423e29": "string",
            "604": "string",
            "608": "string",
            "61": "string",
            "612": "string",
            "61254868": "string",
            "6148e1ee_70b1_45e4_af26_5f41b49a5ce1": "string",
            "61_00": "string",
            "6275536": "string",
            "63": "string",
            "6390916": "string",
            "63_96": "string",
            "644781": "string",
            "65532513": "string",
            "65536784": "string",
            "65537143": "string",
            "65537496": "string",
            "65537639": "string",
            "65538070": "string",
            "65538357": "string",
            "65538390": "string",
            "65539117": "string",
            "65539235": "string",
            "65545678": "string",
            "65546376": "string",
            "65547156": "string",
            "65548094": "string",
            "65548375": "string",
            "6725009": "string",
            "67300974": "string",
            "67300993": "string",
            "67322226": "string",
            "6752732": "string",
            "6763135": "string",
            "6768941": "string",
            "68424": "string",
            "68_00": "string",
            "6ef7da9d_2cc2_4da2_8fc6_e4779fa21479": "string",
            "6f3fa75d_93c7_4137_8ae0_ed0d576bc2fe": "string",
            "7075623": "string",
            "7087650": "string",
            "7150a05a_56f6_41e0_91e6_4e3d7b980b96": "string",
            "715131": "string",
            "71628409": "string",
            "7241913": "string",
            "73247": "string",
            "7333660": "string",
            "7360235": "string",
            "736917": "string",
            "7386740": "string",
            "73981283": "string",
            "742d3feb_e02b_4c0f_a078_1c0c9116ce9e": "string",
            "745003": "string",
            "7541435": "string",
            "75_00": "string",
            "76_00": "string",
            "771": "string",
            "773d2453_f5fa_4aad_8532_ddf424a71ed7": "string",
            "7794913": "string",
            "783744": "string",
            "785af5e0_79a9_4cc4_90e4_b78249f6fa6c": "string",
            "786085": "string",
            "78692": "string",
            "78776310": "string",
            "7b8fb7b8_430f_442b_a284_d00a93411dce": "string",
            "7e1086e3_8e2f_4635_aaeb_35d7249adae8": "string",
            "80": "string",
            "80_00": "string",
            "81": "string",
            "81672020": "string",
            "818": "string",
            "8184092": "string",
            "82": "string",
            "8202220": "string",
            "837": "string",
            "84": "string",
            "844d4410_6fb9_48c3_b450_dc40f7a2b408": "string",
            "8475271": "string",
            "849": "string",
            "854": "string",
            "86": "string",
            "863": "string",
            "8737397": "string",
            "8737490": "string",
            "8d7680df_4283_4885_99f6_4e9168360b8f": "string",
            "906485": "string",
            "90836": "string",
            "909b1673_fa2b_4de4_9acf_b8b56c4960f5": "string",
            "927777ad_8cee_40f1_ae6e_f0ae2fa97e12": "string",
            "939337": "string",
            "9427ba1e_15f3_4c6c_920d_0ebf13da070a": "string",
            "947": "string",
            "951b6b66_4d0e_48a2_96e6_15a7ab9ab173": "string",
            "959929": "string",
            "95_00": "string",
            "9634fc2c_b421_4f43_9df8_d6691e86dd75": "string",
            "965422": "string",
            "96786251": "string",
            "97014316": "string",
            "97723333": "string",
            "981412": "string",
            "9_00": "string",
            "9_54": "string",
            "9_75": "string",
            "9f30b4c9_ead1_423c_8930_cfadaae54764": "string",
            "BOXES___SMALL": "string",
            "BOX_E___WARDROBE": "string",
            "Bader_Company____2_000_00": "string",
            "Bader_Program____2_000_00": "string",
            "Bader_Program____3_000_00": "string",
            "CPUCG5KYZO": "string",
            "California_Fee_Schedule": "string",
            "Credit_Card_Processing_Fee": "string",
            "DNX7VDCFSB": "string",
            "Late_Fee": "string",
            "Payment": "string",
            "Protection_Plan____2_000_00": "string",
            "Protection_Plan____2_500_00": "string",
            "Rent_Unit_00368___12x50x9": "string",
            "Rent_Unit_1092___10x10x8": "string",
            "Rent_Unit_1311___10x10x10": "string",
            "Rent_Unit_2160___5x10": "string",
            "Rent_Unit_229___10x10x0": "string",
            "Rent_Unit_231___10x10x8": "string",
            "Rent_Unit_3099___7_5x10": "string",
            "Rent_Unit_336___10x10x10": "string",
            "Rent_Unit_432___10x30x8": "string",
            "Rent_Unit_520___10x20x0": "string",
            "Rent_Unit_766___10x10x8": "string",
            "Rent_Unit_78___10x10x0": "string",
            "Rent_Unit_87___10x10": "string",
            "Rent_Unit_C195___5x8x8": "string",
            "Rent_Unit_C_12___10x15x8_5": "string",
            "Rent_Unit_D128___10x10x8": "string",
            "Rent_Unit_D1___5x10x10": "string",
            "Rent_Unit_D26___10x20x0": "string",
            "Rent_Unit_D2___10x20x0": "string",
            "Rent_Unit_G020___10x20x0": "string",
            "Rent_Unit_H451___10x10x0": "string",
            "Rent_Unit_H_27___10x15x8": "string",
            "Rent_Unit_IN_17_102___1x17x0": "string",
            "Rent_Unit_K047___10x10x0": "string",
            "Rent_Unit_OUT_21_102___1x21x0": "string",
            "SBOA_Tenant_Insurance____2_000_00": "string",
            "Xercor_Insurance_Services_LLC____3_000_00": "string",
            "____0057": "string",
            "____0579": "string",
            "____0665": "string",
            "____1005": "string",
            "____1007": "string",
            "____1063": "string",
            "____1181": "string",
            "____2297": "string",
            "____2696": "string",
            "____2756": "string",
            "____3029": "string",
            "____3151": "string",
            "____3603": "string",
            "____4013": "string",
            "____4778": "string",
            "____4843": "string",
            "____5422": "string",
            "____5483": "string",
            "____5817": "string",
            "____5979": "string",
            "____6090": "string",
            "____6114": "string",
            "____6499": "string",
            "____6584": "string",
            "____6833": "string",
            "____7108": "string",
            "____7700": "string",
            "____8014": "string",
            "____8212": "string",
            "____8318": "string",
            "____8403": "string",
            "____8546": "string",
            "____8760": "string",
            "____8851": "string",
            "____9053": "string",
            "a10564ab_6af8_47f8_9517_111cb2445525": "string",
            "a432c78b_ea84_4229_87f9_af6af7bbbd2f": "string",
            "a53db356_b328_435c_b17f_fc39e967bc8c": "string",
            "a566b1ed_253f_4844_ba81_55c5c2c99b5a": "string",
            "account_dim_id": "int",
            "acd28a24_d77b_45e2_911d_aef7c14b9dd9": "string",
            "ach": "string",
            "ae2af6e6_4a12_477d_ac4c_57a0f8a31e5c": "string",
            "american_express": "string",
            "amount": "decimal",
            "b34cc648_ef53_40f9_8756_31ce067aa9b7": "string",
            "bb48d444_e987_43c8_8d87_4ccd1af7f14d": "string",
            "be79e414_4ca2_4317_a58c_60fd6850ab2f": "string",
            "bf054065_80b3_41d0_9672_efbc23d87c8e": "string",
            "c7a02d09_a9e1_4d43_92aa_5119739f0c9e": "string",
            "card_on_file": "string",
            "cash": "string",
            "cbc1a65b_3484_4ab8_8364_5582cf68168a": "string",
            "charge_number": "string",
            "check_number": "string",
            "company_dim_id": "int",
            "d0913adf_6ec0_4a74_a11f_689c9b1e9d63": "string",
            "d68eabbf_f789_4b63_ad21_25aa20a226ea": "string",
            "date_dim_id": "int",
            "de056143_f1e9_4bba_b872_a0af34fb0ed7": "string",
            "deleted": "string",
            "deleted_on_date_dim_id": "int",
            "df89f01d_f95f_424f_9c8a_9832e0881287": "string",
            "discount": "decimal",
            "due_on_date_dim_id": "int",
            "e5ae3b82_b25e_4de3_b4e4_c676a6fb4401": "string",
            "e7ec37dd_61b1_49b2_9554_fe70c8c67b7a": "string",
            "e818d1b5_e4f0_4e4d_b332_8ae19f1022f7": "string",
            "e914bb3c_c58b_4098_a80b_489e1eb3ae62": "string",
            "eb8cbcb2_36f6_40d3_9902_485dc57c78a8": "string",
            "ec582b62_3c35_4ea8_a0a5_34bbeb381660": "string",
            "ef2314bd_7cde_4eac_8a95_3ebaaca4eb94": "string",
            "f": "string",
            "f076e615_d86c_4fdb_be88_3d94a55c8f57": "string",
            "f1545202_e924_4c8a_8e31_6b2c473571f8": "string",
            "f4982057_d497_4fe0_acb5_a0c9600c7889": "string",
            "fa103eee_c643_4196_9447_4fe88ce51f74": "string",
            "facility_dim_id": "int",
            "fms": "string",
            "in_store": "string",
            "is_reversal": "string",
            "line_description": "string",
            "mastercard": "string",
            "money_order_number": "string",
            "parent_payment_uuid": "string",
            "payer_account_dim_id": "int",
            "payment_kind": "string",
            "payment_line_fact_id": "bigint",
            "payment_source": "string",
            "payment_uuid": "string",
            "phone": "string",
            "provider": "string",
            "provider_id": "string",
            "receipt_number": "string",
            "received_epoch": "bigint",
            "service_end_date_dim_id": "int",
            "service_start_date_dim_id": "int",
            "tenant_dim_id": "int",
            "tenant_portal": "string",
            "transaction_id": "string",
            "transaction_type": "string",
            "unit_dim_id": "int",
            "visa": "string"
        },
        "created": "2023-02-27 09:16:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_payment_line_fact`\n(\n `65532513`  string , `fms`  string , `a432c78b_ea84_4229_87f9_af6af7bbbd2f`  string , `0e927783_97b5_4723_8ffc_794ea13a08c3`  string , `Payment`  string , `12_00`  string , `0_00`  string , `414145183`  string , `Xercor_Insurance_Services_LLC____3_000_00`  string , `004163509532`  string , `____5422`  string , `mastercard`  string , `55853868`  string , `1748166`  string , `148`  string , `491529`  string , `20220805`  string , `20220801`  string , `20220831`  string , `42`  string , `1659661716018`  string , `f`  string , `81`  string , `tenant_portal`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-stage/raw/payment_line_fact/2023-02-27/1677510951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_payment_line_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_payment_line_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}