Schema Info

Schema Name: sfdl_dev_mssql.sitelink_zz_healthcheck_sldb

created: 2019-08-13 13:53:03
disabled: False
format: raw
id: 1272
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 4762511

created: 2025-07-23 14:30:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753298990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753298990
id: 4762511
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819238
updated: 2025-07-23 14:30:15

Version 4762510

created: 2025-07-23 14:00:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753297212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753297212
id: 4762510
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819237
updated: 2025-07-23 14:00:55

Version 4762508

created: 2025-07-23 13:00:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753293613'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753293613
id: 4762508
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819228
updated: 2025-07-23 13:00:44

Version 4762506

created: 2025-07-23 12:01:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753290015'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753290015
id: 4762506
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819223
updated: 2025-07-23 12:01:36

Version 4762500

created: 2025-07-23 11:00:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753286412'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753286412
id: 4762500
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819207
updated: 2025-07-23 11:00:42

Version 4762498

created: 2025-07-23 10:00:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753282811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753282811
id: 4762498
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819195
updated: 2025-07-23 10:00:44

Version 4762494

created: 2025-07-23 09:46:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753281989'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753281989
id: 4762494
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819182
updated: 2025-07-23 09:46:45

Version 4762488

created: 2025-07-23 09:45:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753281929'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753281929
id: 4762488
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819174
updated: 2025-07-23 09:46:00

Version 4762458

created: 2025-07-23 09:00:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753279217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753279217
id: 4762458
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819029
updated: 2025-07-23 09:00:57

Version 4762456

created: 2025-07-23 08:00:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753275611'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753275611
id: 4762456
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819027
updated: 2025-07-23 08:00:46

Version 4762455

created: 2025-07-23 07:49:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753274971'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753274971
id: 4762455
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819026
updated: 2025-07-23 07:50:01

Version 4762454

created: 2025-07-23 07:35:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753274096'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753274096
id: 4762454
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819025
updated: 2025-07-23 07:35:25

Version 4762453

created: 2025-07-23 07:21:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753273261'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2025-07-23/1753273261
id: 4762453
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 6819021
updated: 2025-07-23 07:21:34

Version 4676196

created: 2020-02-07 10:28:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2020-02-07/1581092877'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2020-02-07/1581092877
id: 4676196
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 5418420
updated: 2020-02-07 10:28:15

Version 4676194

created: 2020-02-06 17:02:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2020-02-06/1581030145'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-dev/raw/zz_healthcheck_sldb/2020-02-06/1581030145
id: 4676194
processed: 1

raw_data:

{
    "database_name": 2,
    "database_status": 3,
    "host_name": 0,
    "last_check_utc": 4,
    "server_name": 1
}

schema_attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

schema_name_id: 1272
schema_scan_id: 5417552
updated: 2020-02-06 17:02:48

Schema Scans: 15

Last at 2025-07-23 14:30:03

Scan 6819238

duration: 0:00:11.608480

exit_message:

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

id: 6819238

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753298990",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753298990/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10920427442140366134,
        "service_name": "Default Service",
        "span_id": 4673429612041564890,
        "trace_id": 10920427442140366134
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 14:30:03
success: True
trace_id: 10920427442140366134

Scan 6819237

duration: 0:00:11.696922

exit_message:

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

id: 6819237

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753297212",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753297212/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10515014048148871346,
        "service_name": "Default Service",
        "span_id": 7566366242519553883,
        "trace_id": 10515014048148871346
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 14:00:43
success: True
trace_id: 10515014048148871346

Scan 6819228

duration: 0:00:14.050108

exit_message:

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

id: 6819228

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753293613",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753293613/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 8751232997667558323,
        "service_name": "Default Service",
        "span_id": 5043662114025645142,
        "trace_id": 8751232997667558323
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 13:00:30
success: True
trace_id: 8751232997667558323

Scan 6819223

duration: 0:00:14.152992

exit_message:

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

id: 6819223

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753290015",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753290015/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3550293542292837591,
        "service_name": "Default Service",
        "span_id": 6976566217463664574,
        "trace_id": 3550293542292837591
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 12:01:22
success: True
trace_id: 3550293542292837591

Scan 6819207

duration: 0:00:14.056827

exit_message:

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

id: 6819207

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753286412",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753286412/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6509047835612209166,
        "service_name": "Default Service",
        "span_id": 17349985372968891446,
        "trace_id": 6509047835612209166
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 11:00:28
success: True
trace_id: 6509047835612209166

Scan 6819195

duration: 0:00:14.067072

exit_message:

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

id: 6819195

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753282811",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753282811/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 9264969406107762458,
        "service_name": "Default Service",
        "span_id": 5953069696215838654,
        "trace_id": 9264969406107762458
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 10:00:30
success: True
trace_id: 9264969406107762458

Scan 6819182

duration: 0:00:11.463497

exit_message:

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

id: 6819182

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753281989",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753281989/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5464202509931367451,
        "service_name": "Default Service",
        "span_id": 11287461621287999327,
        "trace_id": 5464202509931367451
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 09:46:34
success: True
trace_id: 5464202509931367451

Scan 6819174

duration: 0:00:14.027193

exit_message:

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

id: 6819174

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753281929",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753281929/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 4878961752217314774,
        "service_name": "Default Service",
        "span_id": 5764506260992056368,
        "trace_id": 4878961752217314774
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 09:45:46
success: True
trace_id: 4878961752217314774

Scan 6819029

duration: 0:00:11.491048

exit_message:

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

id: 6819029

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753279217",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753279217/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 550879531536298157,
        "service_name": "Default Service",
        "span_id": 16514289905927505393,
        "trace_id": 550879531536298157
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 09:00:46
success: True
trace_id: 550879531536298157

Scan 6819027

duration: 0:00:14.119297

exit_message:

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

id: 6819027

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753275611",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753275611/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5818562844539744671,
        "service_name": "Default Service",
        "span_id": 16264943052733735198,
        "trace_id": 5818562844539744671
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 08:00:31
success: True
trace_id: 5818562844539744671

Scan 6819026

duration: 0:00:14.110977

exit_message:

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

id: 6819026

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753274971",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753274971/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 14424816307279115398,
        "service_name": "Default Service",
        "span_id": 7045868993844851467,
        "trace_id": 14424816307279115398
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 07:49:47
success: True
trace_id: 14424816307279115398

Scan 6819025

duration: 0:00:14.087461

exit_message:

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

id: 6819025

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753274096",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753274096/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6641178308053732371,
        "service_name": "Default Service",
        "span_id": 10806880477439568198,
        "trace_id": 6641178308053732371
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 07:35:10
success: True
trace_id: 6641178308053732371

Scan 6819021

duration: 0:00:14.087413

exit_message:

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

id: 6819021

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2025-07-23/1753273261",
        "key": "raw/zz_healthcheck_sldb/2025-07-23/1753273261/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 17137906614299175933,
        "service_name": "Default Service",
        "span_id": 15599202256319030577,
        "trace_id": 17137906614299175933
    }
}

running: False
schema_name_id: 1272
start_time: 2025-07-23 07:21:20
success: True
trace_id: 17137906614299175933

Scan 5418420

duration: 0:00:13.655807

exit_message:

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

id: 5418420

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2020-02-07/1581092877",
        "key": "raw/zz_healthcheck_sldb/2020-02-07/1581092877/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 9084817452877580227,
        "service_name": "Default Service",
        "span_id": 1471177302826097797,
        "trace_id": 9084817452877580227
    }
}

running: False
schema_name_id: 1272
start_time: 2020-02-07 10:28:04
success: True
trace_id: 9084817452877580227

Scan 5417552

duration: 0:00:13.624054

exit_message:

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

id: 5417552

payload:

{
    "datatype_dict": {
        "database_name": "string",
        "database_status": "string",
        "host_name": "string",
        "last_check_utc": "timestamp",
        "server_name": "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/zz_healthcheck_sldb/2020-02-06/1581030145",
        "key": "raw/zz_healthcheck_sldb/2020-02-06/1581030145/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_dev_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 12691751230405964777,
        "service_name": "Default Service",
        "span_id": 10222633212856084109,
        "trace_id": 12691751230405964777
    }
}

running: False
schema_name_id: 1272
start_time: 2020-02-06 17:02:37
success: True
trace_id: 12691751230405964777

Partitions:

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

Schema:

attributes:

{
    "database_name": "string",
    "database_status": "string",
    "host_name": "string",
    "last_check_utc": "timestamp",
    "server_name": "string"
}

created: 2025-07-23 14:30:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753298990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-08-13 13:53:03",
        "disabled": false,
        "format": "raw",
        "id": 1272,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_mssql",
            "table": "sitelink_zz_healthcheck_sldb"
        },
        "type": "mssql"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "database_name": "string",
            "database_status": "string",
            "host_name": "string",
            "last_check_utc": "timestamp",
            "server_name": "string"
        },
        "created": "2025-07-23 14:30:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`\n(\n `host_name`  string , `server_name`  string , `database_name`  string , `database_status`  string , `last_check_utc`  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/zz_healthcheck_sldb/2025-07-23/1753298990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_mssql.sitelink_zz_healthcheck_sldb`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_mssql.sitelink_zz_healthcheck_sldb"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}