Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code

created: 2022-08-18 17:18:39
disabled: False
format: raw
id: 1097
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718407

created: 2026-04-17 14:17:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-17/1776453430'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-17/1776453430
id: 1718407
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162194046
updated: 2026-04-17 14:17:26

Version 1718186

created: 2026-04-17 09:11:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-17/1776435058'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-17/1776435058
id: 1718186
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162178200
updated: 2026-04-17 09:11:13

Version 1717442

created: 2026-04-17 00:07:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-17/1776402411'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402411
id: 1717442
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162163575
updated: 2026-04-17 00:07:35

Version 1717324

created: 2026-04-16 20:17:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-16/1776388596'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-16/1776388596
id: 1717324
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162156064
updated: 2026-04-16 20:17:18

Version 1717133

created: 2026-04-16 14:13:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-16/1776366659'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-16/1776366659
id: 1717133
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162138003
updated: 2026-04-16 14:13:57

Version 1717003

created: 2026-04-16 09:15:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-16/1776348933'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-16/1776348933
id: 1717003
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162122548
updated: 2026-04-16 09:15:50

Version 1716212

created: 2026-04-16 00:09:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-16/1776316151'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-16/1776316151
id: 1716212
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162107788
updated: 2026-04-16 00:10:00

Version 1716108

created: 2026-04-15 20:24:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-15/1776302649'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-15/1776302649
id: 1716108
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162100324
updated: 2026-04-15 20:24:33

Version 1715973

created: 2026-04-15 14:17:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-15/1776280635'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-15/1776280635
id: 1715973
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162081734
updated: 2026-04-15 14:17:32

Version 1715771

created: 2026-04-15 08:42:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-15/1776260547'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-15/1776260547
id: 1715771
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162064500
updated: 2026-04-15 08:42:49

Version 1715044

created: 2026-04-15 00:24:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-15/1776230636'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-15/1776230636
id: 1715044
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162052016
updated: 2026-04-15 00:24:16

Version 1714881

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-14/1776215457'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-14/1776215457
id: 1714881
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162044229
updated: 2026-04-14 20:12:47

Version 1714725

created: 2026-04-14 14:14:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-14/1776194044'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-14/1776194044
id: 1714725
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162026104
updated: 2026-04-14 14:15:01

Version 1714580

created: 2026-04-14 09:07:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-14/1776175615'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-14/1776175615
id: 1714580
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 162010898
updated: 2026-04-14 09:07:13

Version 1713834

created: 2026-04-14 00:16:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-14/1776143767'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_searches_by_zip_code/2026-04-14/1776143767
id: 1713834
processed: 1

raw_data:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "int64",
    "num_searches": "int64",
    "num_visits": "int64",
    "state": "string",
    "zip_code": "string"
}

schema_attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

schema_name_id: 1097
schema_scan_id: 161996379
updated: 2026-04-14 00:16:24

Schema Scans: 15

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

Scan 162194046

duration: 0:00:11.733426

exit_message:

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

id: 162194046

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_searches_by_zip_code/2026-04-17/1776453430",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-17/1776453430/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10515150005698900579,
        "service_name": "sparefoot",
        "span_id": 6858252031146729733,
        "trace_id": 10515150005698900579
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-17 14:17:14
success: True
trace_id: 10515150005698900579

Scan 162178200

duration: 0:00:11.822050

exit_message:

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

id: 162178200

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_searches_by_zip_code/2026-04-17/1776435058",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-17/1776435058/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4163632885396282445,
        "service_name": "sparefoot",
        "span_id": 17192452512317611534,
        "trace_id": 4163632885396282445
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-17 09:11:01
success: True
trace_id: 4163632885396282445

Scan 162163575

duration: 0:00:14.281407

exit_message:

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

id: 162163575

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_searches_by_zip_code/2026-04-17/1776402411",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-17/1776402411/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14286035790377771077,
        "service_name": "sparefoot",
        "span_id": 12696955545854502133,
        "trace_id": 14286035790377771077
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-17 00:07:20
success: True
trace_id: 14286035790377771077

Scan 162156064

duration: 0:00:16.779091

exit_message:

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

id: 162156064

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_searches_by_zip_code/2026-04-16/1776388596",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-16/1776388596/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9986564875172685168,
        "service_name": "sparefoot",
        "span_id": 18375092460678769643,
        "trace_id": 9986564875172685168
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-16 20:17:01
success: True
trace_id: 9986564875172685168

Scan 162138003

duration: 0:00:14.279093

exit_message:

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

id: 162138003

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_searches_by_zip_code/2026-04-16/1776366659",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-16/1776366659/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15709367487381665154,
        "service_name": "sparefoot",
        "span_id": 17497677614338119239,
        "trace_id": 15709367487381665154
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-16 14:13:43
success: True
trace_id: 15709367487381665154

Scan 162122548

duration: 0:00:14.245482

exit_message:

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

id: 162122548

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_searches_by_zip_code/2026-04-16/1776348933",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-16/1776348933/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6957336860417464229,
        "service_name": "sparefoot",
        "span_id": 1979060566672920697,
        "trace_id": 6957336860417464229
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-16 09:15:36
success: True
trace_id: 6957336860417464229

Scan 162107788

duration: 0:00:14.225771

exit_message:

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

id: 162107788

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_searches_by_zip_code/2026-04-16/1776316151",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-16/1776316151/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13172856232980232925,
        "service_name": "sparefoot",
        "span_id": 11102756814700253595,
        "trace_id": 13172856232980232925
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-16 00:09:46
success: True
trace_id: 13172856232980232925

Scan 162100324

duration: 0:00:14.405331

exit_message:

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

id: 162100324

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_searches_by_zip_code/2026-04-15/1776302649",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-15/1776302649/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7782705579666092511,
        "service_name": "sparefoot",
        "span_id": 8416971223789239575,
        "trace_id": 7782705579666092511
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-15 20:24:19
success: True
trace_id: 7782705579666092511

Scan 162081734

duration: 0:00:11.797709

exit_message:

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

id: 162081734

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_searches_by_zip_code/2026-04-15/1776280635",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-15/1776280635/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6035261374753880361,
        "service_name": "sparefoot",
        "span_id": 4596461704380061519,
        "trace_id": 6035261374753880361
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-15 14:17:21
success: True
trace_id: 6035261374753880361

Scan 162064500

duration: 0:00:11.691941

exit_message:

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

id: 162064500

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_searches_by_zip_code/2026-04-15/1776260547",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-15/1776260547/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7499765848725160104,
        "service_name": "sparefoot",
        "span_id": 3609317762826196473,
        "trace_id": 7499765848725160104
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-15 08:42:37
success: True
trace_id: 7499765848725160104

Scan 162052016

duration: 0:00:14.169944

exit_message:

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

id: 162052016

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_searches_by_zip_code/2026-04-15/1776230636",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-15/1776230636/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11479430628981609521,
        "service_name": "sparefoot",
        "span_id": 14315173909158473866,
        "trace_id": 11479430628981609521
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-15 00:24:02
success: True
trace_id: 11479430628981609521

Scan 162044229

duration: 0:00:14.209589

exit_message:

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

id: 162044229

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_searches_by_zip_code/2026-04-14/1776215457",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-14/1776215457/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11547609111177465558,
        "service_name": "sparefoot",
        "span_id": 5068133198254343898,
        "trace_id": 11547609111177465558
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-14 20:12:33
success: True
trace_id: 11547609111177465558

Scan 162026104

duration: 0:00:11.682566

exit_message:

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

id: 162026104

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_searches_by_zip_code/2026-04-14/1776194044",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-14/1776194044/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9700296278624804132,
        "service_name": "sparefoot",
        "span_id": 17052604185905414294,
        "trace_id": 9700296278624804132
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-14 14:14:49
success: True
trace_id: 9700296278624804132

Scan 162010898

duration: 0:00:11.960534

exit_message:

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

id: 162010898

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_searches_by_zip_code/2026-04-14/1776175615",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-14/1776175615/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17977226901910284279,
        "service_name": "sparefoot",
        "span_id": 1522617239871229385,
        "trace_id": 17977226901910284279
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-14 09:07:01
success: True
trace_id: 17977226901910284279

Scan 161996379

duration: 0:00:14.171821

exit_message:

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

id: 161996379

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_searches_by_zip_code/2026-04-14/1776143767",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-14/1776143767/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13953302446914131062,
        "service_name": "sparefoot",
        "span_id": 12706361185369049426,
        "trace_id": 13953302446914131062
    }
}

running: False
schema_name_id: 1097
start_time: 2026-04-14 00:16:10
success: True
trace_id: 13953302446914131062

Partitions:

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

Schema:

attributes:

{
    "city": "string",
    "latitude": "double",
    "longitude": "double",
    "num_clicks": "bigint",
    "num_searches": "bigint",
    "num_visits": "bigint",
    "state": "string",
    "zip_code": "string"
}

created: 2026-04-17 14:17:14

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_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-17/1776453430'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
}

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:18:39",
        "disabled": false,
        "format": "raw",
        "id": 1097,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_searches_by_zip_code"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "city": "string",
            "latitude": "double",
            "longitude": "double",
            "num_clicks": "bigint",
            "num_searches": "bigint",
            "num_visits": "bigint",
            "state": "string",
            "zip_code": "string"
        },
        "created": "2026-04-17 14:17:14",
        "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_searches_by_zip_code`\n(\n `city`  string , `latitude`  double , `longitude`  double , `num_clicks`  bigint , `num_searches`  bigint , `num_visits`  bigint , `state`  string , `zip_code`  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_searches_by_zip_code/2026-04-17/1776453430'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_searches_by_zip_code"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}