Schema Info

Schema Name: sfdl_dev_mssql.sitelink_apilicensekeys

created: 2018-10-23 15:40:30
disabled: False
format: raw
id: 1063
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 4773321

created: 2026-04-17 00:01:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-17/1776402087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-17/1776402087
id: 4773321
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: 1063
schema_scan_id: 6867624
updated: 2026-04-17 00:02:12

Version 4773260

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-16/1776315674'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-16/1776315674
id: 4773260
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: 1063
schema_scan_id: 6867361
updated: 2026-04-16 00:01:53

Version 4773199

created: 2026-04-15 00:01:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-15/1776229270'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-15/1776229270
id: 4773199
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: 1063
schema_scan_id: 6867097
updated: 2026-04-15 00:01:50

Version 4773138

created: 2026-04-14 00:01:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-14/1776142873'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-14/1776142873
id: 4773138
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: 1063
schema_scan_id: 6866835
updated: 2026-04-14 00:01:36

Version 4773077

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-13/1776056467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-13/1776056467
id: 4773077
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: 1063
schema_scan_id: 6866524
updated: 2026-04-13 00:01:31

Version 4773028

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-12/1775970056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-12/1775970056
id: 4773028
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: 1063
schema_scan_id: 6866349
updated: 2026-04-12 00:01:18

Version 4772979

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-11/1775883666'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-11/1775883666
id: 4772979
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: 1063
schema_scan_id: 6866176
updated: 2026-04-11 00:01:34

Version 4772918

created: 2026-04-10 00:01:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-10/1775797257'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-10/1775797257
id: 4772918
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: 1063
schema_scan_id: 6865904
updated: 2026-04-10 00:01:36

Version 4772857

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-09/1775710855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-09/1775710855
id: 4772857
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: 1063
schema_scan_id: 6865635
updated: 2026-04-09 00:01:33

Version 4772796

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-08/1775624460'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-08/1775624460
id: 4772796
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: 1063
schema_scan_id: 6865366
updated: 2026-04-08 00:01:39

Version 4772735

created: 2026-04-07 00:01:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-07/1775538059'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-07/1775538059
id: 4772735
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: 1063
schema_scan_id: 6865089
updated: 2026-04-07 00:01:33

Version 4772674

created: 2026-04-06 00:01:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-06/1775451658'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-06/1775451658
id: 4772674
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: 1063
schema_scan_id: 6864775
updated: 2026-04-06 00:01:39

Version 4772625

created: 2026-04-05 00:01:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-05/1775365245'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-05/1775365245
id: 4772625
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: 1063
schema_scan_id: 6864603
updated: 2026-04-05 00:01:39

Version 4772576

created: 2026-04-04 00:01:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-04/1775278855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-04/1775278855
id: 4772576
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: 1063
schema_scan_id: 6864430
updated: 2026-04-04 00:01:30

Version 4772515

created: 2026-04-03 00:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-03/1775192455'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-03/1775192455
id: 4772515
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: 1063
schema_scan_id: 6864160
updated: 2026-04-03 00:01:49

Schema Scans: 15

Last at 2026-04-17 00:01:57

Scan 6867624

duration: 0:00:14.465688

exit_message:

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

id: 6867624

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-17/1776402087",
        "key": "raw/APILicenseKeys/2026-04-17/1776402087/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17601130775123684245,
        "service_name": "Default Service",
        "span_id": 7434596742365374698,
        "trace_id": 17601130775123684245
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-17 00:01:57
success: True
trace_id: 17601130775123684245

Scan 6867361

duration: 0:00:14.317132

exit_message:

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

id: 6867361

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-16/1776315674",
        "key": "raw/APILicenseKeys/2026-04-16/1776315674/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 13379799860533953176,
        "service_name": "Default Service",
        "span_id": 14612953431976178339,
        "trace_id": 13379799860533953176
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-16 00:01:39
success: True
trace_id: 13379799860533953176

Scan 6867097

duration: 0:00:14.415525

exit_message:

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

id: 6867097

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-15/1776229270",
        "key": "raw/APILicenseKeys/2026-04-15/1776229270/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 9613949927132421017,
        "service_name": "Default Service",
        "span_id": 8829480204122545734,
        "trace_id": 9613949927132421017
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-15 00:01:36
success: True
trace_id: 9613949927132421017

Scan 6866835

duration: 0:00:14.526240

exit_message:

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

id: 6866835

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-14/1776142873",
        "key": "raw/APILicenseKeys/2026-04-14/1776142873/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6448016009687453602,
        "service_name": "Default Service",
        "span_id": 1357043216513577049,
        "trace_id": 6448016009687453602
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-14 00:01:21
success: True
trace_id: 6448016009687453602

Scan 6866524

duration: 0:00:11.774718

exit_message:

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

id: 6866524

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-13/1776056467",
        "key": "raw/APILicenseKeys/2026-04-13/1776056467/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16283800046380172292,
        "service_name": "Default Service",
        "span_id": 8398100003440821138,
        "trace_id": 16283800046380172292
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-13 00:01:20
success: True
trace_id: 16283800046380172292

Scan 6866349

duration: 0:00:14.432370

exit_message:

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

id: 6866349

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-12/1775970056",
        "key": "raw/APILicenseKeys/2026-04-12/1775970056/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 4878668185303035219,
        "service_name": "Default Service",
        "span_id": 1463625607281447136,
        "trace_id": 4878668185303035219
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-12 00:01:04
success: True
trace_id: 4878668185303035219

Scan 6866176

duration: 0:00:11.909727

exit_message:

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

id: 6866176

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-11/1775883666",
        "key": "raw/APILicenseKeys/2026-04-11/1775883666/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6065010934186522740,
        "service_name": "Default Service",
        "span_id": 3953956159909698422,
        "trace_id": 6065010934186522740
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-11 00:01:22
success: True
trace_id: 6065010934186522740

Scan 6865904

duration: 0:00:11.832399

exit_message:

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

id: 6865904

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-10/1775797257",
        "key": "raw/APILicenseKeys/2026-04-10/1775797257/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6386888251208378106,
        "service_name": "Default Service",
        "span_id": 6331525068002906110,
        "trace_id": 6386888251208378106
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-10 00:01:25
success: True
trace_id: 6386888251208378106

Scan 6865635

duration: 0:00:14.427570

exit_message:

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

id: 6865635

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-09/1775710855",
        "key": "raw/APILicenseKeys/2026-04-09/1775710855/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15868813792214858721,
        "service_name": "Default Service",
        "span_id": 16350525484428418893,
        "trace_id": 15868813792214858721
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-09 00:01:18
success: True
trace_id: 15868813792214858721

Scan 6865366

duration: 0:00:14.385650

exit_message:

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

id: 6865366

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-08/1775624460",
        "key": "raw/APILicenseKeys/2026-04-08/1775624460/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5491090670390383802,
        "service_name": "Default Service",
        "span_id": 17646591168655654101,
        "trace_id": 5491090670390383802
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-08 00:01:25
success: True
trace_id: 5491090670390383802

Scan 6865089

duration: 0:00:14.368123

exit_message:

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

id: 6865089

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-07/1775538059",
        "key": "raw/APILicenseKeys/2026-04-07/1775538059/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11985709905775042827,
        "service_name": "Default Service",
        "span_id": 2523519819280147972,
        "trace_id": 11985709905775042827
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-07 00:01:19
success: True
trace_id: 11985709905775042827

Scan 6864775

duration: 0:00:11.778446

exit_message:

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

id: 6864775

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-06/1775451658",
        "key": "raw/APILicenseKeys/2026-04-06/1775451658/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7172454984323123076,
        "service_name": "Default Service",
        "span_id": 16661407807349416017,
        "trace_id": 7172454984323123076
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-06 00:01:27
success: True
trace_id: 7172454984323123076

Scan 6864603

duration: 0:00:14.319776

exit_message:

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

id: 6864603

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-05/1775365245",
        "key": "raw/APILicenseKeys/2026-04-05/1775365245/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 385836768469250648,
        "service_name": "Default Service",
        "span_id": 8445758218076867439,
        "trace_id": 385836768469250648
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-05 00:01:25
success: True
trace_id: 385836768469250648

Scan 6864430

duration: 0:00:11.833661

exit_message:

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

id: 6864430

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-04/1775278855",
        "key": "raw/APILicenseKeys/2026-04-04/1775278855/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17749372655278853522,
        "service_name": "Default Service",
        "span_id": 14009368307834130933,
        "trace_id": 17749372655278853522
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-04 00:01:18
success: True
trace_id: 17749372655278853522

Scan 6864160

duration: 0:00:27.486272

exit_message:

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

id: 6864160

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-dev",
        "hive_path": "s3://sfdl-mssql-sitelink-dev/raw/APILicenseKeys/2026-04-03/1775192455",
        "key": "raw/APILicenseKeys/2026-04-03/1775192455/APILicenseKeys.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_APILicenseKeys",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2092859656131618282,
        "service_name": "Default Service",
        "span_id": 116359692374405812,
        "trace_id": 2092859656131618282
    }
}

running: False
schema_name_id: 1063
start_time: 2026-04-03 00:01:22
success: True
trace_id: 2092859656131618282

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:01:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-17/1776402087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2018-10-23 15:40:30",
        "disabled": false,
        "format": "raw",
        "id": 1063,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:01:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/APILicenseKeys/2026-04-17/1776402087'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_apilicensekeys`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_apilicensekeys"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}