Schema Info

Schema Name: sfdl_stage_mssql.sitelink_zz_healthcheck_sldb

created: 2019-05-28 15:40:35
disabled: False
format: raw
id: 845
is_partitioned: False
is_schema_datatyped: True

name:

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

type: mssql

Schema Versions: 15

Version 514291

created: 2023-03-20 18:00:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679353213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679353213
id: 514291
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: 845
schema_scan_id: 4722022
updated: 2023-03-20 18:00:53

Version 514290

created: 2023-03-20 17:00:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679349613'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679349613
id: 514290
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: 845
schema_scan_id: 4721858
updated: 2023-03-20 17:00:53

Version 514287

created: 2023-03-20 16:01:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679346023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679346023
id: 514287
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: 845
schema_scan_id: 4721528
updated: 2023-03-20 16:01:13

Version 514284

created: 2023-03-20 15:00:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679342413'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679342413
id: 514284
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: 845
schema_scan_id: 4721208
updated: 2023-03-20 15:01:01

Version 514214

created: 2023-03-20 14:01:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679338815'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679338815
id: 514214
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: 845
schema_scan_id: 4720979
updated: 2023-03-20 14:01:13

Version 514213

created: 2023-03-20 13:00:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679335215'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679335215
id: 514213
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: 845
schema_scan_id: 4720779
updated: 2023-03-20 13:00:58

Version 514209

created: 2023-03-20 12:00:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679331619'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679331619
id: 514209
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: 845
schema_scan_id: 4720514
updated: 2023-03-20 12:01:10

Version 514204

created: 2023-03-20 11:00:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679328017'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679328017
id: 514204
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: 845
schema_scan_id: 4720309
updated: 2023-03-20 11:01:09

Version 514201

created: 2023-03-20 10:01:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679324418'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679324418
id: 514201
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: 845
schema_scan_id: 4720162
updated: 2023-03-20 10:01:19

Version 514196

created: 2023-03-20 09:00:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679320817'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679320817
id: 514196
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: 845
schema_scan_id: 4720027
updated: 2023-03-20 09:00:57

Version 514126

created: 2023-03-20 08:00:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679317214'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679317214
id: 514126
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: 845
schema_scan_id: 4719831
updated: 2023-03-20 08:00:54

Version 513859

created: 2023-03-19 18:00:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-19/1679266816'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679266816
id: 513859
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: 845
schema_scan_id: 4718633
updated: 2023-03-19 18:00:56

Version 513858

created: 2023-03-19 17:00:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-19/1679263212'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679263212
id: 513858
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: 845
schema_scan_id: 4718566
updated: 2023-03-19 17:01:05

Version 513857

created: 2023-03-19 16:00:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-19/1679259620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679259620
id: 513857
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: 845
schema_scan_id: 4718492
updated: 2023-03-19 16:01:00

Version 513855

created: 2023-03-19 15:00:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-19/1679256011'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
]

hive_path: s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679256011
id: 513855
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: 845
schema_scan_id: 4718417
updated: 2023-03-19 15:01:00

Schema Scans: 15

Last at 2023-03-20 18:00:41

Scan 4722022

duration: 0:00:11.564620

exit_message:

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

id: 4722022

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679353213",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679353213/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 10589007754066617950,
        "service_name": "Default Service",
        "span_id": 10079944845391429960,
        "trace_id": 10589007754066617950
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 18:00:41
success: True
trace_id: 10589007754066617950

Scan 4721858

duration: 0:00:11.475006

exit_message:

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

id: 4721858

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679349613",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679349613/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 11699389406877329211,
        "service_name": "Default Service",
        "span_id": 17730662725421706010,
        "trace_id": 11699389406877329211
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 17:00:42
success: True
trace_id: 11699389406877329211

Scan 4721528

duration: 0:00:11.603278

exit_message:

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

id: 4721528

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679346023",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679346023/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 5675001532967936559,
        "service_name": "Default Service",
        "span_id": 14978627222522330123,
        "trace_id": 5675001532967936559
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 16:01:02
success: True
trace_id: 5675001532967936559

Scan 4721208

duration: 0:00:11.418344

exit_message:

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

id: 4721208

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679342413",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679342413/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 170236263761597792,
        "service_name": "Default Service",
        "span_id": 5172942196770629847,
        "trace_id": 170236263761597792
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 15:00:49
success: True
trace_id: 170236263761597792

Scan 4720979

duration: 0:00:11.482481

exit_message:

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

id: 4720979

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679338815",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679338815/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3486897450634626530,
        "service_name": "Default Service",
        "span_id": 15175313566002896182,
        "trace_id": 3486897450634626530
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 14:01:02
success: True
trace_id: 3486897450634626530

Scan 4720779

duration: 0:00:11.517021

exit_message:

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

id: 4720779

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679335215",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679335215/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 6990646153757840061,
        "service_name": "Default Service",
        "span_id": 7269367243800771096,
        "trace_id": 6990646153757840061
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 13:00:47
success: True
trace_id: 6990646153757840061

Scan 4720514

duration: 0:00:11.509913

exit_message:

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

id: 4720514

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679331619",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679331619/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 7820154359419856567,
        "service_name": "Default Service",
        "span_id": 17229095281926049408,
        "trace_id": 7820154359419856567
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 12:00:59
success: True
trace_id: 7820154359419856567

Scan 4720309

duration: 0:00:11.389518

exit_message:

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

id: 4720309

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679328017",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679328017/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3611733763949859449,
        "service_name": "Default Service",
        "span_id": 7784020203493098730,
        "trace_id": 3611733763949859449
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 11:00:57
success: True
trace_id: 3611733763949859449

Scan 4720162

duration: 0:00:11.556804

exit_message:

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

id: 4720162

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679324418",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679324418/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 2976474854681623362,
        "service_name": "Default Service",
        "span_id": 15374953208968535391,
        "trace_id": 2976474854681623362
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 10:01:07
success: True
trace_id: 2976474854681623362

Scan 4720027

duration: 0:00:11.628296

exit_message:

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

id: 4720027

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679320817",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679320817/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16832391782751108582,
        "service_name": "Default Service",
        "span_id": 18429780829289811507,
        "trace_id": 16832391782751108582
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 09:00:45
success: True
trace_id: 16832391782751108582

Scan 4719831

duration: 0:00:11.607951

exit_message:

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

id: 4719831

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-20/1679317214",
        "key": "raw/zz_healthcheck_sldb/2023-03-20/1679317214/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 15321094039373527149,
        "service_name": "Default Service",
        "span_id": 1904119149551611811,
        "trace_id": 15321094039373527149
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-20 08:00:42
success: True
trace_id: 15321094039373527149

Scan 4718633

duration: 0:00:11.617083

exit_message:

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

id: 4718633

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679266816",
        "key": "raw/zz_healthcheck_sldb/2023-03-19/1679266816/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 16694521100991210445,
        "service_name": "Default Service",
        "span_id": 14928875158643879549,
        "trace_id": 16694521100991210445
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-19 18:00:44
success: True
trace_id: 16694521100991210445

Scan 4718566

duration: 0:00:11.755596

exit_message:

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

id: 4718566

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679263212",
        "key": "raw/zz_healthcheck_sldb/2023-03-19/1679263212/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 13911600978465490562,
        "service_name": "Default Service",
        "span_id": 17765006772957877989,
        "trace_id": 13911600978465490562
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-19 17:00:53
success: True
trace_id: 13911600978465490562

Scan 4718492

duration: 0:00:11.651773

exit_message:

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

id: 4718492

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679259620",
        "key": "raw/zz_healthcheck_sldb/2023-03-19/1679259620/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 3554234317837764701,
        "service_name": "Default Service",
        "span_id": 7692710216961889767,
        "trace_id": 3554234317837764701
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-19 16:00:48
success: True
trace_id: 3554234317837764701

Scan 4718417

duration: 0:00:11.842040

exit_message:

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

id: 4718417

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-stage",
        "hive_path": "s3://sfdl-mssql-sitelink-stage/raw/zz_healthcheck_sldb/2023-03-19/1679256011",
        "key": "raw/zz_healthcheck_sldb/2023-03-19/1679256011/zz_healthcheck_sldb.dat.gz"
    },
    "schema": {
        "name": "sfdl_stage_mssql.sitelink_zz_healthcheck_sldb",
        "type": "mssql"
    },
    "trace_context": {
        "parent_id": 12780751242894278538,
        "service_name": "Default Service",
        "span_id": 15797004067549242536,
        "trace_id": 12780751242894278538
    }
}

running: False
schema_name_id: 845
start_time: 2023-03-19 15:00:49
success: True
trace_id: 12780751242894278538

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: 2023-03-20 18:00:42

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679353213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2019-05-28 15:40:35",
        "disabled": false,
        "format": "raw",
        "id": 845,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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": "2023-03-20 18:00:42",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_mssql`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/zz_healthcheck_sldb/2023-03-20/1679353213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_mssql.sitelink_zz_healthcheck_sldb`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_mssql.sitelink_zz_healthcheck_sldb"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}