Schema Info

Schema Name: sfdl_prod_mssql.sitelink_apilicensekeys

created: 2018-09-04 10:22:39
disabled: False
format: raw
id: 532
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 1717415

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-17/1776402226'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-17/1776402226
id: 1717415
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 162163497
updated: 2026-04-17 00:04:03

Version 1716177

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-16/1776315826'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-16/1776315826
id: 1716177
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 162107705
updated: 2026-04-16 00:04:17

Version 1714989

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-15/1776229511'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-15/1776229511
id: 1714989
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 162051888
updated: 2026-04-15 00:05:36

Version 1713778

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-14/1776142966'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-14/1776142966
id: 1713778
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161996265
updated: 2026-04-14 00:03:03

Version 1712559

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-13/1776056604'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-13/1776056604
id: 1712559
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161938364
updated: 2026-04-13 00:03:41

Version 1711350

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-12/1775970076'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-12/1775970076
id: 1711350
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161888928
updated: 2026-04-12 00:03:04

Version 1710160

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-11/1775883711'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-11/1775883711
id: 1710160
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161837145
updated: 2026-04-11 00:02:10

Version 1709012

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-10/1775797402'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-10/1775797402
id: 1709012
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161781542
updated: 2026-04-10 00:03:44

Version 1707866

created: 2026-04-09 00:03:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-09/1775711012'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-09/1775711012
id: 1707866
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161726502
updated: 2026-04-09 00:03:51

Version 1706655

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-08/1775624592'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-08/1775624592
id: 1706655
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161671069
updated: 2026-04-08 00:03:36

Version 1705478

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-07/1775538205'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-07/1775538205
id: 1705478
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161615149
updated: 2026-04-07 00:03:46

Version 1704241

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-06/1775451809'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-06/1775451809
id: 1704241
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161557118
updated: 2026-04-06 00:03:48

Version 1703057

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-05/1775365364'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-05/1775365364
id: 1703057
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161510861
updated: 2026-04-05 00:03:32

Version 1701879

created: 2026-04-04 00:04:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-04/1775278914'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-04/1775278914
id: 1701879
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161455678
updated: 2026-04-04 00:04:29

Version 1700674

created: 2026-04-03 00:04:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-03/1775192627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-prod/raw/APILicenseKeys/2026-04-03/1775192627
id: 1700674
processed: 1

raw_data:

{
    "APILicenseKeyID": 0,
    "dCreated": 5,
    "dDeleted": 7,
    "dUpdated": 6,
    "iAccessLevel": 2,
    "iAccessLevelReportingAPI": 3,
    "sAPIKeySha1": 1,
    "sCompanyName": 4
}

schema_attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

schema_name_id: 532
schema_scan_id: 161396903
updated: 2026-04-03 00:04:48

Schema Scans: 15

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

Scan 162163497

duration: 0:00:11.702173

exit_message:

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

id: 162163497

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-17/1776402226",
        "key": "raw/APILicenseKeys/2026-04-17/1776402226/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7085459819014494941,
        "service_name": "Default Service",
        "span_id": 18099570522284431274,
        "trace_id": 7085459819014494941
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-17 00:03:51
success: True
trace_id: 7085459819014494941

Scan 162107705

duration: 0:00:11.837728

exit_message:

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

id: 162107705

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-16/1776315826",
        "key": "raw/APILicenseKeys/2026-04-16/1776315826/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15538412000833525445,
        "service_name": "Default Service",
        "span_id": 6292489599818290155,
        "trace_id": 15538412000833525445
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-16 00:04:05
success: True
trace_id: 15538412000833525445

Scan 162051888

duration: 0:00:14.329707

exit_message:

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

id: 162051888

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-15/1776229511",
        "key": "raw/APILicenseKeys/2026-04-15/1776229511/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2483833577451272633,
        "service_name": "Default Service",
        "span_id": 8689814753537176568,
        "trace_id": 2483833577451272633
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-15 00:05:22
success: True
trace_id: 2483833577451272633

Scan 161996265

duration: 0:00:11.798308

exit_message:

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

id: 161996265

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-14/1776142966",
        "key": "raw/APILicenseKeys/2026-04-14/1776142966/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16230779648706355691,
        "service_name": "Default Service",
        "span_id": 338737383682016827,
        "trace_id": 16230779648706355691
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-14 00:02:51
success: True
trace_id: 16230779648706355691

Scan 161938364

duration: 0:00:11.928562

exit_message:

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

id: 161938364

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-13/1776056604",
        "key": "raw/APILicenseKeys/2026-04-13/1776056604/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 1846271446856917852,
        "service_name": "Default Service",
        "span_id": 12462308975096541113,
        "trace_id": 1846271446856917852
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-13 00:03:29
success: True
trace_id: 1846271446856917852

Scan 161888928

duration: 0:00:14.306185

exit_message:

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

id: 161888928

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-12/1775970076",
        "key": "raw/APILicenseKeys/2026-04-12/1775970076/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16940171494080014250,
        "service_name": "Default Service",
        "span_id": 3642371965157969530,
        "trace_id": 16940171494080014250
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-12 00:02:50
success: True
trace_id: 16940171494080014250

Scan 161837145

duration: 0:00:11.755202

exit_message:

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

id: 161837145

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-11/1775883711",
        "key": "raw/APILicenseKeys/2026-04-11/1775883711/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 749014365578545356,
        "service_name": "Default Service",
        "span_id": 11822006883893612400,
        "trace_id": 749014365578545356
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-11 00:01:58
success: True
trace_id: 749014365578545356

Scan 161781542

duration: 0:00:11.824338

exit_message:

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

id: 161781542

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-10/1775797402",
        "key": "raw/APILicenseKeys/2026-04-10/1775797402/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2739247502324331215,
        "service_name": "Default Service",
        "span_id": 6532102704010716418,
        "trace_id": 2739247502324331215
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-10 00:03:33
success: True
trace_id: 2739247502324331215

Scan 161726502

duration: 0:00:14.237424

exit_message:

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

id: 161726502

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-09/1775711012",
        "key": "raw/APILicenseKeys/2026-04-09/1775711012/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5084550395982592954,
        "service_name": "Default Service",
        "span_id": 16802021882165543347,
        "trace_id": 5084550395982592954
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-09 00:03:37
success: True
trace_id: 5084550395982592954

Scan 161671069

duration: 0:00:14.279287

exit_message:

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

id: 161671069

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-08/1775624592",
        "key": "raw/APILicenseKeys/2026-04-08/1775624592/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2154958243872703862,
        "service_name": "Default Service",
        "span_id": 7103947953560796995,
        "trace_id": 2154958243872703862
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-08 00:03:22
success: True
trace_id: 2154958243872703862

Scan 161615149

duration: 0:00:11.710424

exit_message:

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

id: 161615149

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-07/1775538205",
        "key": "raw/APILicenseKeys/2026-04-07/1775538205/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16645641981217374268,
        "service_name": "Default Service",
        "span_id": 17173334277419533365,
        "trace_id": 16645641981217374268
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-07 00:03:35
success: True
trace_id: 16645641981217374268

Scan 161557118

duration: 0:00:14.310364

exit_message:

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

id: 161557118

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-06/1775451809",
        "key": "raw/APILicenseKeys/2026-04-06/1775451809/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11177656464814335600,
        "service_name": "Default Service",
        "span_id": 12675448060521040488,
        "trace_id": 11177656464814335600
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-06 00:03:34
success: True
trace_id: 11177656464814335600

Scan 161510861

duration: 0:00:11.843130

exit_message:

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

id: 161510861

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-05/1775365364",
        "key": "raw/APILicenseKeys/2026-04-05/1775365364/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6061633009474001472,
        "service_name": "Default Service",
        "span_id": 2954666817039785584,
        "trace_id": 6061633009474001472
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-05 00:03:20
success: True
trace_id: 6061633009474001472

Scan 161455678

duration: 0:00:14.351742

exit_message:

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

id: 161455678

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-04/1775278914",
        "key": "raw/APILicenseKeys/2026-04-04/1775278914/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7180387302287943396,
        "service_name": "Default Service",
        "span_id": 3263730607782972370,
        "trace_id": 7180387302287943396
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-04 00:04:14
success: True
trace_id: 7180387302287943396

Scan 161396903

duration: 0:00:14.377665

exit_message:

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

id: 161396903

payload:

{
    "datatype_dict": {
        "APILicenseKeyID": "int",
        "dCreated": "timestamp",
        "dDeleted": "timestamp",
        "dUpdated": "timestamp",
        "iAccessLevel": "int",
        "iAccessLevelReportingAPI": "int",
        "sAPIKeySha1": "string",
        "sCompanyName": "string"
    },
    "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/APILicenseKeys/2026-04-03/1775192627",
        "key": "raw/APILicenseKeys/2026-04-03/1775192627/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_prod_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5869629844734452203,
        "service_name": "Default Service",
        "span_id": 2651072313645660427,
        "trace_id": 5869629844734452203
    }
}

running: False
schema_name_id: 532
start_time: 2026-04-03 00:04:33
success: True
trace_id: 5869629844734452203

Partitions:

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

Schema:

attributes:

{
    "APILicenseKeyID": "int",
    "dCreated": "timestamp",
    "dDeleted": "timestamp",
    "dUpdated": "timestamp",
    "iAccessLevel": "int",
    "iAccessLevelReportingAPI": "int",
    "sAPIKeySha1": "string",
    "sCompanyName": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-17/1776402226'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-09-04 10:22:39",
        "disabled": false,
        "format": "raw",
        "id": 532,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_mssql",
            "table": "sitelink_apilicensekeys"
        },
        "type": "mssql"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "APILicenseKeyID": "int",
            "dCreated": "timestamp",
            "dDeleted": "timestamp",
            "dUpdated": "timestamp",
            "iAccessLevel": "int",
            "iAccessLevelReportingAPI": "int",
            "sAPIKeySha1": "string",
            "sCompanyName": "string"
        },
        "created": "2026-04-17 00:03:52",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_mssql.sitelink_apilicensekeys`\n(\n `APILicenseKeyID`  int , `sAPIKeySha1`  string , `iAccessLevel`  int , `iAccessLevelReportingAPI`  int , `sCompanyName`  string , `dCreated`  timestamp , `dUpdated`  timestamp , `dDeleted`  timestamp \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/APILicenseKeys/2026-04-17/1776402226'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_mssql.sitelink_apilicensekeys`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_mssql.sitelink_apilicensekeys"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}