Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_content

created: 2022-08-18 17:25:37
disabled: False
format: raw
id: 1136
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_rds",
    "table": "sparefoot_sparefoot_content"
}

type: rds

Schema Versions: 15

Version 1718403

created: 2026-04-17 14:16:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776453404'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776453404
id: 1718403
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162194040
updated: 2026-04-17 14:16:59

Version 1718182

created: 2026-04-17 09:10:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776435026'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776435026
id: 1718182
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162178195
updated: 2026-04-17 09:10:43

Version 1717449

created: 2026-04-17 00:11:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776402659'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776402659
id: 1717449
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162163604
updated: 2026-04-17 00:11:58

Version 1717351

created: 2026-04-16 20:24:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776388894'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776388894
id: 1717351
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162156152
updated: 2026-04-16 20:24:39

Version 1717158

created: 2026-04-16 14:15:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776366892'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776366892
id: 1717158
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162138044
updated: 2026-04-16 14:15:39

Version 1716966

created: 2026-04-16 09:08:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776348490'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776348490
id: 1716966
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162122482
updated: 2026-04-16 09:08:28

Version 1716221

created: 2026-04-16 00:13:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776316436'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776316436
id: 1716221
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162107800
updated: 2026-04-16 00:14:10

Version 1716127

created: 2026-04-15 20:26:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776302802'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776302802
id: 1716127
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162100353
updated: 2026-04-15 20:27:00

Version 1715983

created: 2026-04-15 14:18:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776280699'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776280699
id: 1715983
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162081790
updated: 2026-04-15 14:18:34

Version 1715752

created: 2026-04-15 08:39:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776260345'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776260345
id: 1715752
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162064380
updated: 2026-04-15 08:39:31

Version 1715041

created: 2026-04-15 00:23:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776230620'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776230620
id: 1715041
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162052013
updated: 2026-04-15 00:24:08

Version 1714876

created: 2026-04-14 20:12:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776215452'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776215452
id: 1714876
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162044224
updated: 2026-04-14 20:12:14

Version 1714714

created: 2026-04-14 14:13:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776193981'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776193981
id: 1714714
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162026093
updated: 2026-04-14 14:13:18

Version 1714572

created: 2026-04-14 09:03:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776175378'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776175378
id: 1714572
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 162010759
updated: 2026-04-14 09:03:49

Version 1713792

created: 2026-04-14 00:06:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776143196'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776143196
id: 1713792
processed: 1

raw_data:

{
    "body": "string",
    "content_id": "int32",
    "content_template_id": "int32",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int32",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "int16",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1136
schema_scan_id: 161996305
updated: 2026-04-14 00:06:57

Schema Scans: 15

Last at 2026-04-17 14:16:47

Scan 162194040

duration: 0:00:11.937156

exit_message:

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

id: 162194040

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776453404",
        "key": "raw/sparefoot_content/2026-04-17/1776453404/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17343826206300362494,
        "service_name": "sparefoot",
        "span_id": 4483544898851695057,
        "trace_id": 17343826206300362494
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-17 14:16:47
success: True
trace_id: 17343826206300362494

Scan 162178195

duration: 0:00:11.965265

exit_message:

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

id: 162178195

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776435026",
        "key": "raw/sparefoot_content/2026-04-17/1776435026/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15729576751270506518,
        "service_name": "sparefoot",
        "span_id": 806031013319760758,
        "trace_id": 15729576751270506518
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-17 09:10:32
success: True
trace_id: 15729576751270506518

Scan 162163604

duration: 0:00:11.893558

exit_message:

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

id: 162163604

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776402659",
        "key": "raw/sparefoot_content/2026-04-17/1776402659/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15652348484433329983,
        "service_name": "sparefoot",
        "span_id": 17921842806215474053,
        "trace_id": 15652348484433329983
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-17 00:11:46
success: True
trace_id: 15652348484433329983

Scan 162156152

duration: 0:00:11.825768

exit_message:

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

id: 162156152

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776388894",
        "key": "raw/sparefoot_content/2026-04-16/1776388894/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13857616052305776717,
        "service_name": "sparefoot",
        "span_id": 12030656345182126161,
        "trace_id": 13857616052305776717
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-16 20:24:27
success: True
trace_id: 13857616052305776717

Scan 162138044

duration: 0:00:14.348559

exit_message:

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

id: 162138044

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776366892",
        "key": "raw/sparefoot_content/2026-04-16/1776366892/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1487131400696170125,
        "service_name": "sparefoot",
        "span_id": 3505692706196052664,
        "trace_id": 1487131400696170125
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-16 14:15:24
success: True
trace_id: 1487131400696170125

Scan 162122482

duration: 0:00:11.804857

exit_message:

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

id: 162122482

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776348490",
        "key": "raw/sparefoot_content/2026-04-16/1776348490/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3306994836508280126,
        "service_name": "sparefoot",
        "span_id": 14448789233968218963,
        "trace_id": 3306994836508280126
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-16 09:08:17
success: True
trace_id: 3306994836508280126

Scan 162107800

duration: 0:00:11.747994

exit_message:

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

id: 162107800

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-16/1776316436",
        "key": "raw/sparefoot_content/2026-04-16/1776316436/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15529988468591454817,
        "service_name": "sparefoot",
        "span_id": 9276860818465821621,
        "trace_id": 15529988468591454817
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-16 00:13:58
success: True
trace_id: 15529988468591454817

Scan 162100353

duration: 0:00:11.933330

exit_message:

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

id: 162100353

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776302802",
        "key": "raw/sparefoot_content/2026-04-15/1776302802/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9387656475220344253,
        "service_name": "sparefoot",
        "span_id": 17618802009105070970,
        "trace_id": 9387656475220344253
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-15 20:26:48
success: True
trace_id: 9387656475220344253

Scan 162081790

duration: 0:00:11.817517

exit_message:

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

id: 162081790

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776280699",
        "key": "raw/sparefoot_content/2026-04-15/1776280699/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14125028816625794374,
        "service_name": "sparefoot",
        "span_id": 17519534287008181913,
        "trace_id": 14125028816625794374
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-15 14:18:22
success: True
trace_id: 14125028816625794374

Scan 162064380

duration: 0:00:14.309388

exit_message:

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

id: 162064380

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776260345",
        "key": "raw/sparefoot_content/2026-04-15/1776260345/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7131774232916602369,
        "service_name": "sparefoot",
        "span_id": 13001874225682434767,
        "trace_id": 7131774232916602369
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-15 08:39:17
success: True
trace_id: 7131774232916602369

Scan 162052013

duration: 0:00:14.457201

exit_message:

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

id: 162052013

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-15/1776230620",
        "key": "raw/sparefoot_content/2026-04-15/1776230620/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16484616793395041281,
        "service_name": "sparefoot",
        "span_id": 3956332579531269393,
        "trace_id": 16484616793395041281
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-15 00:23:53
success: True
trace_id: 16484616793395041281

Scan 162044224

duration: 0:00:11.891011

exit_message:

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

id: 162044224

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776215452",
        "key": "raw/sparefoot_content/2026-04-14/1776215452/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18262595517009593223,
        "service_name": "sparefoot",
        "span_id": 16472943594541751208,
        "trace_id": 18262595517009593223
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-14 20:12:03
success: True
trace_id: 18262595517009593223

Scan 162026093

duration: 0:00:14.421428

exit_message:

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

id: 162026093

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776193981",
        "key": "raw/sparefoot_content/2026-04-14/1776193981/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15666630008376405505,
        "service_name": "sparefoot",
        "span_id": 10755936091547785855,
        "trace_id": 15666630008376405505
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-14 14:13:04
success: True
trace_id: 15666630008376405505

Scan 162010759

duration: 0:00:14.350070

exit_message:

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

id: 162010759

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776175378",
        "key": "raw/sparefoot_content/2026-04-14/1776175378/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6475520408869046987,
        "service_name": "sparefoot",
        "span_id": 4777721421763819194,
        "trace_id": 6475520408869046987
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-14 09:03:34
success: True
trace_id: 6475520408869046987

Scan 161996305

duration: 0:00:11.885249

exit_message:

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

id: 161996305

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-14/1776143196",
        "key": "raw/sparefoot_content/2026-04-14/1776143196/content.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18300083902670082245,
        "service_name": "sparefoot",
        "span_id": 11837108366854547614,
        "trace_id": 18300083902670082245
    }
}

running: False
schema_name_id: 1136
start_time: 2026-04-14 00:06:45
success: True
trace_id: 18300083902670082245

Partitions:

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

Schema:

attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "smallint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

created: 2026-04-17 14:16:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776453404'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-18 17:25:37",
        "disabled": false,
        "format": "raw",
        "id": 1136,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_content"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "body": "string",
            "content_id": "int",
            "content_template_id": "int",
            "head_title": "string",
            "hireahelper_anchor": "string",
            "hireahelper_url": "string",
            "location_id": "int",
            "meta_description": "string",
            "meta_keywords": "string",
            "publish": "smallint",
            "subtitle": "string",
            "title": "string",
            "uri": "string"
        },
        "created": "2026-04-17 14:16:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_content`\n(\n `body`  string , `content_id`  int , `content_template_id`  int , `head_title`  string , `hireahelper_anchor`  string , `hireahelper_url`  string , `location_id`  int , `meta_description`  string , `meta_keywords`  string , `publish`  smallint , `subtitle`  string , `title`  string , `uri`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-prod/raw/sparefoot_content/2026-04-17/1776453404'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_content`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_content"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}