Schema Info

Schema Name: sfdl_stage_mssql.sitelink_programdefaults_paymenttypes

created: 2019-02-12 14:54:28
disabled: False
format: raw
id: 719
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 906517

created: 2026-04-17 00:03:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-17/1776402164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402164
id: 906517
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6415065
updated: 2026-04-17 00:03:18

Version 906302

created: 2026-04-16 00:01:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-16/1776315673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315673
id: 906302
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6414518
updated: 2026-04-16 00:01:42

Version 906090

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-15/1776229341'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229341
id: 906090
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6414031
updated: 2026-04-15 00:02:48

Version 905877

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-14/1776142953'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142953
id: 905877
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6413520
updated: 2026-04-14 00:02:51

Version 905715

created: 2026-04-13 00:18:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-13/1776057516'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-13/1776057516
id: 905715
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6413051
updated: 2026-04-13 00:18:58

Version 905460

created: 2026-04-12 00:04:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-12/1775970258'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970258
id: 905460
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6412594
updated: 2026-04-12 00:04:47

Version 905256

created: 2026-04-11 00:03:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-11/1775883772'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883772
id: 905256
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6412209
updated: 2026-04-11 00:03:15

Version 905045

created: 2026-04-10 00:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-10/1775797362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797362
id: 905045
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6411706
updated: 2026-04-10 00:03:10

Version 904833

created: 2026-04-09 00:09:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-09/1775711377'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-09/1775711377
id: 904833
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6411216
updated: 2026-04-09 00:09:56

Version 904613

created: 2026-04-08 00:01:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-08/1775624464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624464
id: 904613
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6410689
updated: 2026-04-08 00:01:41

Version 904399

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-07/1775538144'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538144
id: 904399
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6410182
updated: 2026-04-07 00:02:50

Version 904188

created: 2026-04-06 00:02:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-06/1775451759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451759
id: 904188
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6409643
updated: 2026-04-06 00:03:02

Version 903983

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-05/1775365340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365340
id: 903983
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6409258
updated: 2026-04-05 00:02:41

Version 903783

created: 2026-04-04 00:02:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-04/1775278957'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278957
id: 903783
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6408882
updated: 2026-04-04 00:02:53

Version 903568

created: 2026-04-03 00:02:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-03/1775192536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192536
id: 903568
processed: 1

raw_data:

{
    "Allowed": 3,
    "CorpCode": 0,
    "LocationCode": 1,
    "OnlineAllowed": 4,
    "PaymentType": 2,
    "ReversalsAllowed": 5
}

schema_attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

schema_name_id: 719
schema_scan_id: 6408382
updated: 2026-04-03 00:02:44

Schema Scans: 15

Last at 2026-04-17 00:03:04

Scan 6415065

duration: 0:00:14.542862

exit_message:

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

id: 6415065

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-17/1776402164",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402164/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14679137369911781375,
        "service_name": "Default Service",
        "span_id": 13157103592490456570,
        "trace_id": 14679137369911781375
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-17 00:03:04
success: True
trace_id: 14679137369911781375

Scan 6414518

duration: 0:00:11.935266

exit_message:

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

id: 6414518

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-16/1776315673",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315673/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3208171301132734021,
        "service_name": "Default Service",
        "span_id": 11145842544914905454,
        "trace_id": 3208171301132734021
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-16 00:01:30
success: True
trace_id: 3208171301132734021

Scan 6414031

duration: 0:00:12.038932

exit_message:

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

id: 6414031

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-15/1776229341",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229341/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3062493831707797795,
        "service_name": "Default Service",
        "span_id": 7384342583390748253,
        "trace_id": 3062493831707797795
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-15 00:02:36
success: True
trace_id: 3062493831707797795

Scan 6413520

duration: 0:00:11.787335

exit_message:

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

id: 6413520

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-14/1776142953",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142953/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14850313172823009438,
        "service_name": "Default Service",
        "span_id": 1923681315665744286,
        "trace_id": 14850313172823009438
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-14 00:02:39
success: True
trace_id: 14850313172823009438

Scan 6413051

duration: 0:00:14.362635

exit_message:

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

id: 6413051

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-13/1776057516",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-13/1776057516/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6092929054313675366,
        "service_name": "Default Service",
        "span_id": 6546411679940241814,
        "trace_id": 6092929054313675366
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-13 00:18:43
success: True
trace_id: 6092929054313675366

Scan 6412594

duration: 0:00:14.338775

exit_message:

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

id: 6412594

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-12/1775970258",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970258/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3751859631155904047,
        "service_name": "Default Service",
        "span_id": 14901622786535700323,
        "trace_id": 3751859631155904047
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-12 00:04:33
success: True
trace_id: 3751859631155904047

Scan 6412209

duration: 0:00:14.445665

exit_message:

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

id: 6412209

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-11/1775883772",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883772/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2231315487829329884,
        "service_name": "Default Service",
        "span_id": 17318179461086303268,
        "trace_id": 2231315487829329884
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-11 00:03:01
success: True
trace_id: 2231315487829329884

Scan 6411706

duration: 0:00:14.386797

exit_message:

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

id: 6411706

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-10/1775797362",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797362/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7836483365737991334,
        "service_name": "Default Service",
        "span_id": 1108180588469235902,
        "trace_id": 7836483365737991334
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-10 00:02:55
success: True
trace_id: 7836483365737991334

Scan 6411216

duration: 0:00:14.318405

exit_message:

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

id: 6411216

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-09/1775711377",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-09/1775711377/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15162988411082636702,
        "service_name": "Default Service",
        "span_id": 17544717475108327099,
        "trace_id": 15162988411082636702
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-09 00:09:42
success: True
trace_id: 15162988411082636702

Scan 6410689

duration: 0:00:11.863254

exit_message:

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

id: 6410689

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-08/1775624464",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624464/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10968286942814736571,
        "service_name": "Default Service",
        "span_id": 12659505317416405163,
        "trace_id": 10968286942814736571
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-08 00:01:30
success: True
trace_id: 10968286942814736571

Scan 6410182

duration: 0:00:14.451322

exit_message:

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

id: 6410182

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-07/1775538144",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538144/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14246757388377928579,
        "service_name": "Default Service",
        "span_id": 962185695313527193,
        "trace_id": 14246757388377928579
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-07 00:02:35
success: True
trace_id: 14246757388377928579

Scan 6409643

duration: 0:00:14.331749

exit_message:

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

id: 6409643

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-06/1775451759",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451759/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 13704201164581109558,
        "service_name": "Default Service",
        "span_id": 5028158589335162371,
        "trace_id": 13704201164581109558
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-06 00:02:48
success: True
trace_id: 13704201164581109558

Scan 6409258

duration: 0:00:14.294244

exit_message:

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

id: 6409258

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-05/1775365340",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365340/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17681570398566847440,
        "service_name": "Default Service",
        "span_id": 15920937770570803564,
        "trace_id": 17681570398566847440
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-05 00:02:27
success: True
trace_id: 17681570398566847440

Scan 6408882

duration: 0:00:11.761844

exit_message:

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

id: 6408882

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-04/1775278957",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278957/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 554765728332780838,
        "service_name": "Default Service",
        "span_id": 2149144816877279518,
        "trace_id": 554765728332780838
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-04 00:02:42
success: True
trace_id: 554765728332780838

Scan 6408382

duration: 0:00:11.810039

exit_message:

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

id: 6408382

payload:

{
    "datatype_dict": {
        "Allowed": "int",
        "CorpCode": "string",
        "LocationCode": "string",
        "OnlineAllowed": "boolean",
        "PaymentType": "string",
        "ReversalsAllowed": "boolean"
    },
    "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/ProgramDefaults_PaymentTypes/2026-04-03/1775192536",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192536/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15719774698847746188,
        "service_name": "Default Service",
        "span_id": 5762978069999132625,
        "trace_id": 15719774698847746188
    }
}

running: False
schema_name_id: 719
start_time: 2026-04-03 00:02:33
success: True
trace_id: 15719774698847746188

Partitions:

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

Schema:

attributes:

{
    "Allowed": "int",
    "CorpCode": "string",
    "LocationCode": "string",
    "OnlineAllowed": "boolean",
    "PaymentType": "string",
    "ReversalsAllowed": "boolean"
}

created: 2026-04-17 00:03:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-17/1776402164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
}

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-02-12 14:54:28",
        "disabled": false,
        "format": "raw",
        "id": 719,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_mssql",
            "table": "sitelink_programdefaults_paymenttypes"
        },
        "type": "mssql"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Allowed": "int",
            "CorpCode": "string",
            "LocationCode": "string",
            "OnlineAllowed": "boolean",
            "PaymentType": "string",
            "ReversalsAllowed": "boolean"
        },
        "created": "2026-04-17 00:03:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`\n(\n `CorpCode`  string , `LocationCode`  string , `PaymentType`  string , `Allowed`  int , `OnlineAllowed`  boolean , `ReversalsAllowed`  boolean \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/ProgramDefaults_PaymentTypes/2026-04-17/1776402164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_programdefaults_paymenttypes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_programdefaults_paymenttypes"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}