Schema Info

Schema Name: sfdl_stage_mssql.sitelink_billing_base_data

created: 2019-04-17 14:44:37
disabled: False
format: raw
id: 828
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_mssql",
    "table": "sitelink_billing_base_data"
}

type: mssql

Schema Versions: 15

Version 906520

created: 2026-04-17 00:05:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-17/1776402337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-17/1776402337
id: 906520
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6415078
updated: 2026-04-17 00:05:58

Version 906306

created: 2026-04-16 00:05:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-16/1776315947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-16/1776315947
id: 906306
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6414536
updated: 2026-04-16 00:06:11

Version 906094

created: 2026-04-15 00:05:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-15/1776229465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-15/1776229465
id: 906094
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6414044
updated: 2026-04-15 00:05:18

Version 905879

created: 2026-04-14 00:05:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-14/1776143128'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-14/1776143128
id: 905879
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6413532
updated: 2026-04-14 00:05:49

Version 905724

created: 2026-04-13 00:20:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-13/1776057609'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-13/1776057609
id: 905724
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6413061
updated: 2026-04-13 00:20:26

Version 905461

created: 2026-04-12 00:05:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-12/1775970336'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-12/1775970336
id: 905461
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6412604
updated: 2026-04-12 00:05:55

Version 905259

created: 2026-04-11 00:05:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-11/1775883921'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-11/1775883921
id: 905259
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6412227
updated: 2026-04-11 00:05:38

Version 905049

created: 2026-04-10 00:06:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-10/1775797553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-10/1775797553
id: 905049
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6411728
updated: 2026-04-10 00:06:15

Version 904841

created: 2026-04-09 00:11:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-09/1775711438'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-09/1775711438
id: 904841
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6411224
updated: 2026-04-09 00:11:15

Version 904617

created: 2026-04-08 00:05:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-08/1775624715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-08/1775624715
id: 904617
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6410706
updated: 2026-04-08 00:05:49

Version 904401

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-07/1775538275'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-07/1775538275
id: 904401
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6410185
updated: 2026-04-07 00:04:55

Version 904197

created: 2026-04-06 00:05:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-06/1775451935'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-06/1775451935
id: 904197
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6409669
updated: 2026-04-06 00:05:59

Version 903994

created: 2026-04-05 00:05:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-05/1775365545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-05/1775365545
id: 903994
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6409287
updated: 2026-04-05 00:06:08

Version 903791

created: 2026-04-04 00:05:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-04/1775279137'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-04/1775279137
id: 903791
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6408905
updated: 2026-04-04 00:05:54

Version 903573

created: 2026-04-03 00:06:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-03/1775192763'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-03/1775192763
id: 903573
processed: 1

raw_data:

{
    "AccountNumber": 0,
    "ActualChargeAmt": 7,
    "ChargeCreated": 3,
    "ChargeDesc": 2,
    "ChargeDiscountAmt": 8,
    "ChargeEnd": 5,
    "ChargeID": 1,
    "ChargeIsNSF": 16,
    "ChargeStart": 4,
    "ChargeUnowedAmt": 9,
    "CreditNote": 17,
    "CreditTag": 15,
    "PaidTowardChargeAmt": 13,
    "PaymentType": 14,
    "ReceiptAmt": 12,
    "ReceiptDate": 11,
    "ReceiptNumber": 10,
    "StdChargeAmt": 6
}

schema_attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

schema_name_id: 828
schema_scan_id: 6408404
updated: 2026-04-03 00:06:32

Schema Scans: 15

Last at 2026-04-17 00:05:43

Scan 6415078

duration: 0:00:14.875277

exit_message:

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

id: 6415078

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-17/1776402337",
        "key": "raw/billing_base_data/2026-04-17/1776402337/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2060793231420266240,
        "service_name": "Default Service",
        "span_id": 14535718278323443709,
        "trace_id": 2060793231420266240
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-17 00:05:43
success: True
trace_id: 2060793231420266240

Scan 6414536

duration: 0:00:14.782328

exit_message:

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

id: 6414536

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-16/1776315947",
        "key": "raw/billing_base_data/2026-04-16/1776315947/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11024329042598737169,
        "service_name": "Default Service",
        "span_id": 12766339293680714451,
        "trace_id": 11024329042598737169
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-16 00:05:56
success: True
trace_id: 11024329042598737169

Scan 6414044

duration: 0:00:12.174046

exit_message:

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

id: 6414044

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-15/1776229465",
        "key": "raw/billing_base_data/2026-04-15/1776229465/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15203448556906184505,
        "service_name": "Default Service",
        "span_id": 16361418137706055530,
        "trace_id": 15203448556906184505
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-15 00:05:05
success: True
trace_id: 15203448556906184505

Scan 6413532

duration: 0:00:14.630677

exit_message:

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

id: 6413532

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-14/1776143128",
        "key": "raw/billing_base_data/2026-04-14/1776143128/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16602207951005150077,
        "service_name": "Default Service",
        "span_id": 12506885158927287410,
        "trace_id": 16602207951005150077
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-14 00:05:34
success: True
trace_id: 16602207951005150077

Scan 6413061

duration: 0:00:12.202176

exit_message:

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

id: 6413061

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-13/1776057609",
        "key": "raw/billing_base_data/2026-04-13/1776057609/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14708204751476596567,
        "service_name": "Default Service",
        "span_id": 2447226292556759690,
        "trace_id": 14708204751476596567
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-13 00:20:14
success: True
trace_id: 14708204751476596567

Scan 6412604

duration: 0:00:14.749944

exit_message:

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

id: 6412604

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-12/1775970336",
        "key": "raw/billing_base_data/2026-04-12/1775970336/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6670365051383273282,
        "service_name": "Default Service",
        "span_id": 7845298251128587497,
        "trace_id": 6670365051383273282
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-12 00:05:41
success: True
trace_id: 6670365051383273282

Scan 6412227

duration: 0:00:12.171239

exit_message:

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

id: 6412227

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-11/1775883921",
        "key": "raw/billing_base_data/2026-04-11/1775883921/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 9867163606791423314,
        "service_name": "Default Service",
        "span_id": 2697690367132114536,
        "trace_id": 9867163606791423314
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-11 00:05:26
success: True
trace_id: 9867163606791423314

Scan 6411728

duration: 0:00:12.238470

exit_message:

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

id: 6411728

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-10/1775797553",
        "key": "raw/billing_base_data/2026-04-10/1775797553/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 4311829582415512002,
        "service_name": "Default Service",
        "span_id": 9413159548587227013,
        "trace_id": 4311829582415512002
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-10 00:06:03
success: True
trace_id: 4311829582415512002

Scan 6411224

duration: 0:00:14.729211

exit_message:

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

id: 6411224

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-09/1775711438",
        "key": "raw/billing_base_data/2026-04-09/1775711438/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3788457404397106738,
        "service_name": "Default Service",
        "span_id": 15423225386112360763,
        "trace_id": 3788457404397106738
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-09 00:11:00
success: True
trace_id: 3788457404397106738

Scan 6410706

duration: 0:00:12.185743

exit_message:

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

id: 6410706

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-08/1775624715",
        "key": "raw/billing_base_data/2026-04-08/1775624715/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15217491724210384469,
        "service_name": "Default Service",
        "span_id": 11154702032762105719,
        "trace_id": 15217491724210384469
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-08 00:05:37
success: True
trace_id: 15217491724210384469

Scan 6410185

duration: 0:00:14.684542

exit_message:

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

id: 6410185

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-07/1775538275",
        "key": "raw/billing_base_data/2026-04-07/1775538275/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11193248549032404434,
        "service_name": "Default Service",
        "span_id": 11401780631807420139,
        "trace_id": 11193248549032404434
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-07 00:04:41
success: True
trace_id: 11193248549032404434

Scan 6409669

duration: 0:00:14.723674

exit_message:

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

id: 6409669

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-06/1775451935",
        "key": "raw/billing_base_data/2026-04-06/1775451935/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7324090575404137811,
        "service_name": "Default Service",
        "span_id": 13678820445939223522,
        "trace_id": 7324090575404137811
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-06 00:05:44
success: True
trace_id: 7324090575404137811

Scan 6409287

duration: 0:00:14.896933

exit_message:

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

id: 6409287

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-05/1775365545",
        "key": "raw/billing_base_data/2026-04-05/1775365545/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17519375305916461223,
        "service_name": "Default Service",
        "span_id": 2803365404016481710,
        "trace_id": 17519375305916461223
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-05 00:05:53
success: True
trace_id: 17519375305916461223

Scan 6408905

duration: 0:00:12.199036

exit_message:

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

id: 6408905

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-04/1775279137",
        "key": "raw/billing_base_data/2026-04-04/1775279137/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2548115531745444090,
        "service_name": "Default Service",
        "span_id": 15704305854191035360,
        "trace_id": 2548115531745444090
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-04 00:05:42
success: True
trace_id: 2548115531745444090

Scan 6408404

duration: 0:00:14.799815

exit_message:

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

id: 6408404

payload:

{
    "datatype_dict": {
        "AccountNumber": "string",
        "ActualChargeAmt": "decimal(28,4)",
        "ChargeCreated": "timestamp",
        "ChargeDesc": "string",
        "ChargeDiscountAmt": "decimal(28,4)",
        "ChargeEnd": "timestamp",
        "ChargeID": "int",
        "ChargeIsNSF": "boolean",
        "ChargeStart": "timestamp",
        "ChargeUnowedAmt": "decimal(28,4)",
        "CreditNote": "string",
        "CreditTag": "string",
        "PaidTowardChargeAmt": "decimal(28,4)",
        "PaymentType": "string",
        "ReceiptAmt": "decimal(28,4)",
        "ReceiptDate": "timestamp",
        "ReceiptNumber": "int",
        "StdChargeAmt": "decimal(28,4)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-mssql-sitelink-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/billing_base_data/2026-04-03/1775192763",
        "key": "raw/billing_base_data/2026-04-03/1775192763/billing_base_data.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_billing_base_data",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 12231340041607087742,
        "service_name": "Default Service",
        "span_id": 6933008066593797685,
        "trace_id": 12231340041607087742
    }
}

running: False
schema_name_id: 828
start_time: 2026-04-03 00:06:17
success: True
trace_id: 12231340041607087742

Partitions:

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

Schema:

attributes:

{
    "AccountNumber": "string",
    "ActualChargeAmt": "decimal(28,4)",
    "ChargeCreated": "timestamp",
    "ChargeDesc": "string",
    "ChargeDiscountAmt": "decimal(28,4)",
    "ChargeEnd": "timestamp",
    "ChargeID": "int",
    "ChargeIsNSF": "boolean",
    "ChargeStart": "timestamp",
    "ChargeUnowedAmt": "decimal(28,4)",
    "CreditNote": "string",
    "CreditTag": "string",
    "PaidTowardChargeAmt": "decimal(28,4)",
    "PaymentType": "string",
    "ReceiptAmt": "decimal(28,4)",
    "ReceiptDate": "timestamp",
    "ReceiptNumber": "int",
    "StdChargeAmt": "decimal(28,4)"
}

created: 2026-04-17 00:05:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-17/1776402337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-04-17 14:44:37",
        "disabled": false,
        "format": "raw",
        "id": 828,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_mssql",
            "table": "sitelink_billing_base_data"
        },
        "type": "mssql"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountNumber": "string",
            "ActualChargeAmt": "decimal(28,4)",
            "ChargeCreated": "timestamp",
            "ChargeDesc": "string",
            "ChargeDiscountAmt": "decimal(28,4)",
            "ChargeEnd": "timestamp",
            "ChargeID": "int",
            "ChargeIsNSF": "boolean",
            "ChargeStart": "timestamp",
            "ChargeUnowedAmt": "decimal(28,4)",
            "CreditNote": "string",
            "CreditTag": "string",
            "PaidTowardChargeAmt": "decimal(28,4)",
            "PaymentType": "string",
            "ReceiptAmt": "decimal(28,4)",
            "ReceiptDate": "timestamp",
            "ReceiptNumber": "int",
            "StdChargeAmt": "decimal(28,4)"
        },
        "created": "2026-04-17 00:05:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_billing_base_data`\n(\n `AccountNumber`  string , `ChargeID`  int , `ChargeDesc`  string , `ChargeCreated`  timestamp , `ChargeStart`  timestamp , `ChargeEnd`  timestamp , `StdChargeAmt`  decimal(28,4) , `ActualChargeAmt`  decimal(28,4) , `ChargeDiscountAmt`  decimal(28,4) , `ChargeUnowedAmt`  decimal(28,4) , `ReceiptNumber`  int , `ReceiptDate`  timestamp , `ReceiptAmt`  decimal(28,4) , `PaidTowardChargeAmt`  decimal(28,4) , `PaymentType`  string , `CreditTag`  string , `ChargeIsNSF`  boolean , `CreditNote`  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-mssql-sitelink-stage/raw/billing_base_data/2026-04-17/1776402337'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_billing_base_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_billing_base_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}