Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code

created: 2022-08-12 10:20:25
disabled: False
format: raw
id: 1332
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906533

created: 2026-04-17 00:14:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863
id: 906533
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: 1332
schema_scan_id: 6415100
updated: 2026-04-17 00:14:44

Version 906338

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-16/1776316200'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-16/1776316200
id: 906338
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: 1332
schema_scan_id: 6414573
updated: 2026-04-16 00:10:24

Version 906150

created: 2026-04-15 00:28:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-15/1776230921'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-15/1776230921
id: 906150
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: 1332
schema_scan_id: 6414114
updated: 2026-04-15 00:29:07

Version 905909

created: 2026-04-14 00:11:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-14/1776143474'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-14/1776143474
id: 905909
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: 1332
schema_scan_id: 6413575
updated: 2026-04-14 00:11:33

Version 905702

created: 2026-04-13 00:17:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-13/1776057454'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-13/1776057454
id: 905702
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: 1332
schema_scan_id: 6413037
updated: 2026-04-13 00:17:54

Version 905515

created: 2026-04-12 00:15:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-12/1775970908'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-12/1775970908
id: 905515
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: 1332
schema_scan_id: 6412667
updated: 2026-04-12 00:15:25

Version 905292

created: 2026-04-11 00:11:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-11/1775884264'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-11/1775884264
id: 905292
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: 1332
schema_scan_id: 6412264
updated: 2026-04-11 00:11:23

Version 905052

created: 2026-04-10 00:06:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-10/1775797569'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-10/1775797569
id: 905052
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: 1332
schema_scan_id: 6411732
updated: 2026-04-10 00:06:26

Version 904842

created: 2026-04-09 00:11:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-09/1775711449'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-09/1775711449
id: 904842
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: 1332
schema_scan_id: 6411226
updated: 2026-04-09 00:11:20

Version 904643

created: 2026-04-08 00:08:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-08/1775624917'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-08/1775624917
id: 904643
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: 1332
schema_scan_id: 6410738
updated: 2026-04-08 00:09:03

Version 904444

created: 2026-04-07 00:13:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-07/1775538777'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-07/1775538777
id: 904444
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: 1332
schema_scan_id: 6410248
updated: 2026-04-07 00:13:19

Version 904227

created: 2026-04-06 00:10:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-06/1775452231'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-06/1775452231
id: 904227
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: 1332
schema_scan_id: 6409700
updated: 2026-04-06 00:11:09

Version 904018

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-05/1775365739'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-05/1775365739
id: 904018
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: 1332
schema_scan_id: 6409313
updated: 2026-04-05 00:09:30

Version 903813

created: 2026-04-04 00:09:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-04/1775279365'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-04/1775279365
id: 903813
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: 1332
schema_scan_id: 6408929
updated: 2026-04-04 00:09:44

Version 903577

created: 2026-04-03 00:06:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-03/1775192798'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-03/1775192798
id: 903577
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: 1332
schema_scan_id: 6408410
updated: 2026-04-03 00:06:59

Schema Scans: 15

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

Scan 6415100

duration: 0:00:11.699877

exit_message:

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

id: 6415100

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12062971376046553709,
        "service_name": "sparefoot",
        "span_id": 8446033131494972307,
        "trace_id": 12062971376046553709
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-17 00:14:32
success: True
trace_id: 12062971376046553709

Scan 6414573

duration: 0:00:11.709409

exit_message:

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

id: 6414573

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-16/1776316200",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-16/1776316200/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9557178589531521617,
        "service_name": "sparefoot",
        "span_id": 17800742097886524909,
        "trace_id": 9557178589531521617
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-16 00:10:13
success: True
trace_id: 9557178589531521617

Scan 6414114

duration: 0:00:14.289569

exit_message:

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

id: 6414114

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-15/1776230921",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-15/1776230921/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5128228774298102688,
        "service_name": "sparefoot",
        "span_id": 3743712128200722101,
        "trace_id": 5128228774298102688
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-15 00:28:53
success: True
trace_id: 5128228774298102688

Scan 6413575

duration: 0:00:14.533169

exit_message:

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

id: 6413575

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-14/1776143474",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-14/1776143474/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7102781761909167317,
        "service_name": "sparefoot",
        "span_id": 2702836771362717978,
        "trace_id": 7102781761909167317
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-14 00:11:18
success: True
trace_id: 7102781761909167317

Scan 6413037

duration: 0:00:14.242212

exit_message:

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

id: 6413037

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-13/1776057454",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-13/1776057454/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16227110984702097451,
        "service_name": "sparefoot",
        "span_id": 14185801740558639369,
        "trace_id": 16227110984702097451
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-13 00:17:39
success: True
trace_id: 16227110984702097451

Scan 6412667

duration: 0:00:14.365458

exit_message:

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

id: 6412667

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-12/1775970908",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-12/1775970908/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10848773694244101642,
        "service_name": "sparefoot",
        "span_id": 8654065615597355660,
        "trace_id": 10848773694244101642
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-12 00:15:11
success: True
trace_id: 10848773694244101642

Scan 6412264

duration: 0:00:11.648133

exit_message:

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

id: 6412264

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-11/1775884264",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-11/1775884264/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6085194585971823287,
        "service_name": "sparefoot",
        "span_id": 12931668800675843219,
        "trace_id": 6085194585971823287
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-11 00:11:11
success: True
trace_id: 6085194585971823287

Scan 6411732

duration: 0:00:11.794460

exit_message:

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

id: 6411732

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-10/1775797569",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-10/1775797569/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13313206427187604828,
        "service_name": "sparefoot",
        "span_id": 12684763059997934905,
        "trace_id": 13313206427187604828
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-10 00:06:15
success: True
trace_id: 13313206427187604828

Scan 6411226

duration: 0:00:11.868766

exit_message:

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

id: 6411226

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-09/1775711449",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-09/1775711449/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7287577426324800504,
        "service_name": "sparefoot",
        "span_id": 9710454131646179302,
        "trace_id": 7287577426324800504
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-09 00:11:08
success: True
trace_id: 7287577426324800504

Scan 6410738

duration: 0:00:14.420662

exit_message:

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

id: 6410738

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-08/1775624917",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-08/1775624917/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3523297809052377732,
        "service_name": "sparefoot",
        "span_id": 6089744421292091655,
        "trace_id": 3523297809052377732
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-08 00:08:49
success: True
trace_id: 3523297809052377732

Scan 6410248

duration: 0:00:14.266539

exit_message:

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

id: 6410248

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-07/1775538777",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-07/1775538777/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 18296316507783513544,
        "service_name": "sparefoot",
        "span_id": 1799210532676226397,
        "trace_id": 18296316507783513544
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-07 00:13:04
success: True
trace_id: 18296316507783513544

Scan 6409700

duration: 0:00:14.352144

exit_message:

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

id: 6409700

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-06/1775452231",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-06/1775452231/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 98977624173875362,
        "service_name": "sparefoot",
        "span_id": 2230387789760572961,
        "trace_id": 98977624173875362
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-06 00:10:55
success: True
trace_id: 98977624173875362

Scan 6409313

duration: 0:00:14.373787

exit_message:

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

id: 6409313

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-05/1775365739",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-05/1775365739/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8535470137525652930,
        "service_name": "sparefoot",
        "span_id": 17210531467105469263,
        "trace_id": 8535470137525652930
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-05 00:09:16
success: True
trace_id: 8535470137525652930

Scan 6408929

duration: 0:00:11.700369

exit_message:

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

id: 6408929

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-04/1775279365",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-04/1775279365/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13619183575477114208,
        "service_name": "sparefoot",
        "span_id": 9768436530165421897,
        "trace_id": 13619183575477114208
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-04 00:09:32
success: True
trace_id: 13619183575477114208

Scan 6408410

duration: 0:00:14.317016

exit_message:

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

id: 6408410

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-stage",
        "hive_path": "s3://sfdl-rds-sparefoot-stage/raw/sparefoot_searches_by_zip_code/2026-04-03/1775192798",
        "key": "raw/sparefoot_searches_by_zip_code/2026-04-03/1775192798/searches_by_zip_code.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2316400757789078286,
        "service_name": "sparefoot",
        "span_id": 14186779266286149201,
        "trace_id": 2316400757789078286
    }
}

running: False
schema_name_id: 1332
start_time: 2026-04-03 00:06:45
success: True
trace_id: 2316400757789078286

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 00:14:32

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-12 10:20:25",
        "disabled": false,
        "format": "raw",
        "id": 1332,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:14:32",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/sparefoot_searches_by_zip_code/2026-04-17/1776402863'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_searches_by_zip_code"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}