Schema Info

Schema Name: sfdl_prod_mssql.sitelink_programdefaults_paymenttypes

created: 2019-06-12 17:16:17
disabled: False
format: raw
id: 711
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 1717413

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148
id: 1717413
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: 711
schema_scan_id: 162163432
updated: 2026-04-17 00:03:34

Version 1716174

created: 2026-04-16 00:02:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315724'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315724
id: 1716174
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: 711
schema_scan_id: 162107681
updated: 2026-04-16 00:02:57

Version 1714984

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229371'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229371
id: 1714984
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: 711
schema_scan_id: 162051843
updated: 2026-04-15 00:03:16

Version 1713777

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142947
id: 1713777
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: 711
schema_scan_id: 161996263
updated: 2026-04-14 00:02:45

Version 1712556

created: 2026-04-13 00:02:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-13/1776056549'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-13/1776056549
id: 1712556
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: 711
schema_scan_id: 161938269
updated: 2026-04-13 00:02:49

Version 1711349

created: 2026-04-12 00:02:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970122
id: 1711349
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: 711
schema_scan_id: 161888863
updated: 2026-04-12 00:02:40

Version 1710161

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883715
id: 1710161
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: 711
schema_scan_id: 161837163
updated: 2026-04-11 00:02:19

Version 1709010

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797333'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797333
id: 1709010
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: 711
schema_scan_id: 161781468
updated: 2026-04-10 00:03:19

Version 1707865

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-09/1775710947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-09/1775710947
id: 1707865
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: 711
schema_scan_id: 161726489
updated: 2026-04-09 00:02:49

Version 1706654

created: 2026-04-08 00:02:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624535
id: 1706654
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: 711
schema_scan_id: 161671058
updated: 2026-04-08 00:02:32

Version 1705474

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538114'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538114
id: 1705474
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: 711
schema_scan_id: 161615115
updated: 2026-04-07 00:02:44

Version 1704239

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451659'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451659
id: 1704239
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: 711
schema_scan_id: 161557091
updated: 2026-04-06 00:02:48

Version 1703055

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365318
id: 1703055
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: 711
schema_scan_id: 161510757
updated: 2026-04-05 00:02:48

Version 1701877

created: 2026-04-04 00:03:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278937'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278937
id: 1701877
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: 711
schema_scan_id: 161455622
updated: 2026-04-04 00:04:00

Version 1700672

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192518'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192518
id: 1700672
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: 711
schema_scan_id: 161396603
updated: 2026-04-03 00:02:26

Schema Scans: 15

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

Scan 162163432

duration: 0:00:11.843407

exit_message:

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

id: 162163432

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7726780127631811283,
        "service_name": "Default Service",
        "span_id": 934739838200391570,
        "trace_id": 7726780127631811283
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-17 00:03:22
success: True
trace_id: 7726780127631811283

Scan 162107681

duration: 0:00:14.286557

exit_message:

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

id: 162107681

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315724",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-16/1776315724/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 4649766635682115805,
        "service_name": "Default Service",
        "span_id": 15529855206297177771,
        "trace_id": 4649766635682115805
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-16 00:02:43
success: True
trace_id: 4649766635682115805

Scan 162051843

duration: 0:00:11.773089

exit_message:

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

id: 162051843

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229371",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-15/1776229371/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7684193985649999670,
        "service_name": "Default Service",
        "span_id": 10807524661344358089,
        "trace_id": 7684193985649999670
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-15 00:03:04
success: True
trace_id: 7684193985649999670

Scan 161996263

duration: 0:00:14.287643

exit_message:

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

id: 161996263

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142947",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-14/1776142947/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 913094825562694024,
        "service_name": "Default Service",
        "span_id": 11857854637026364214,
        "trace_id": 913094825562694024
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-14 00:02:31
success: True
trace_id: 913094825562694024

Scan 161938269

duration: 0:00:14.435689

exit_message:

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

id: 161938269

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-13/1776056549",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-13/1776056549/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 889370381609565295,
        "service_name": "Default Service",
        "span_id": 6928525663546861791,
        "trace_id": 889370381609565295
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-13 00:02:35
success: True
trace_id: 889370381609565295

Scan 161888863

duration: 0:00:14.407892

exit_message:

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

id: 161888863

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970122",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-12/1775970122/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3817404868345913183,
        "service_name": "Default Service",
        "span_id": 10901834189736948440,
        "trace_id": 3817404868345913183
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-12 00:02:26
success: True
trace_id: 3817404868345913183

Scan 161837163

duration: 0:00:14.380124

exit_message:

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

id: 161837163

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883715",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-11/1775883715/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16870165693787443122,
        "service_name": "Default Service",
        "span_id": 3029397587851918570,
        "trace_id": 16870165693787443122
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-11 00:02:04
success: True
trace_id: 16870165693787443122

Scan 161781468

duration: 0:00:14.289120

exit_message:

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

id: 161781468

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797333",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-10/1775797333/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 13005254879336622103,
        "service_name": "Default Service",
        "span_id": 3627600363435463400,
        "trace_id": 13005254879336622103
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-10 00:03:05
success: True
trace_id: 13005254879336622103

Scan 161726489

duration: 0:00:11.753233

exit_message:

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

id: 161726489

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-09/1775710947",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-09/1775710947/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5046403040139314799,
        "service_name": "Default Service",
        "span_id": 10405476193218535255,
        "trace_id": 5046403040139314799
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-09 00:02:37
success: True
trace_id: 5046403040139314799

Scan 161671058

duration: 0:00:11.771160

exit_message:

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

id: 161671058

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624535",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-08/1775624535/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15962116252551661652,
        "service_name": "Default Service",
        "span_id": 15187660520744624483,
        "trace_id": 15962116252551661652
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-08 00:02:20
success: True
trace_id: 15962116252551661652

Scan 161615115

duration: 0:00:14.375879

exit_message:

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

id: 161615115

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538114",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-07/1775538114/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6398889587744868459,
        "service_name": "Default Service",
        "span_id": 119075867465504525,
        "trace_id": 6398889587744868459
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-07 00:02:30
success: True
trace_id: 6398889587744868459

Scan 161557091

duration: 0:00:14.298399

exit_message:

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

id: 161557091

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451659",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-06/1775451659/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3823704727388731620,
        "service_name": "Default Service",
        "span_id": 17881453722814145535,
        "trace_id": 3823704727388731620
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-06 00:02:33
success: True
trace_id: 3823704727388731620

Scan 161510757

duration: 0:00:14.241989

exit_message:

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

id: 161510757

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365318",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-05/1775365318/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16525805407235493878,
        "service_name": "Default Service",
        "span_id": 11676938109380861675,
        "trace_id": 16525805407235493878
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-05 00:02:34
success: True
trace_id: 16525805407235493878

Scan 161455622

duration: 0:00:11.770591

exit_message:

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

id: 161455622

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278937",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-04/1775278937/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10729896960444455500,
        "service_name": "Default Service",
        "span_id": 16953156224488828288,
        "trace_id": 10729896960444455500
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-04 00:03:49
success: True
trace_id: 10729896960444455500

Scan 161396603

duration: 0:00:14.389371

exit_message:

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

id: 161396603

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-prod",
        "hive_path": "s3://sfdl-mssql-sitelink-prod/raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192518",
        "key": "raw/ProgramDefaults_PaymentTypes/2026-04-03/1775192518/ProgramDefaults_PaymentTypes.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_ProgramDefaults_PaymentTypes",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16376535227419766458,
        "service_name": "Default Service",
        "span_id": 139530131341339005,
        "trace_id": 16376535227419766458
    }
}

running: False
schema_name_id: 711
start_time: 2026-04-03 00:02:12
success: True
trace_id: 16376535227419766458

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:22

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2019-06-12 17:16:17",
        "disabled": false,
        "format": "raw",
        "id": 711,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:22",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/ProgramDefaults_PaymentTypes/2026-04-17/1776402148'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_programdefaults_paymenttypes`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_programdefaults_paymenttypes"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}