Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_search_locations

created: 2022-11-29 15:14:52
disabled: False
format: raw
id: 1231
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718422

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-17/1776454337'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-17/1776454337
id: 1718422
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162194190
updated: 2026-04-17 14:32:55

Version 1718244

created: 2026-04-17 09:29:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-17/1776436156'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-17/1776436156
id: 1718244
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162178388
updated: 2026-04-17 09:29:40

Version 1717486

created: 2026-04-17 00:37:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-17/1776404231'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-17/1776404231
id: 1717486
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162163727
updated: 2026-04-17 00:37:35

Version 1717362

created: 2026-04-16 20:34:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-16/1776389676'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-16/1776389676
id: 1717362
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162156232
updated: 2026-04-16 20:35:04

Version 1717196

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-16/1776368091'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-16/1776368091
id: 1717196
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162138268
updated: 2026-04-16 14:35:12

Version 1717032

created: 2026-04-16 09:34:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-16/1776350062'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-16/1776350062
id: 1717032
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162122803
updated: 2026-04-16 09:34:43

Version 1716248

created: 2026-04-16 00:34:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-16/1776317666'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-16/1776317666
id: 1716248
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162107862
updated: 2026-04-16 00:34:50

Version 1716071

created: 2026-04-15 20:09:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-15/1776301745'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-15/1776301745
id: 1716071
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162100196
updated: 2026-04-15 20:09:30

Version 1716002

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-15/1776281467'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-15/1776281467
id: 1716002
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162082102
updated: 2026-04-15 14:31:37

Version 1715810

created: 2026-04-15 09:05:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-15/1776261690'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-15/1776261690
id: 1715810
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162066430
updated: 2026-04-15 09:06:46

Version 1715039

created: 2026-04-15 00:21:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-15/1776230467'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-15/1776230467
id: 1715039
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162052010
updated: 2026-04-15 00:21:38

Version 1714927

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-14/1776216727'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-14/1776216727
id: 1714927
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162044366
updated: 2026-04-14 20:32:30

Version 1714766

created: 2026-04-14 14:21:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-14/1776194385'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-14/1776194385
id: 1714766
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162026217
updated: 2026-04-14 14:21:13

Version 1714625

created: 2026-04-14 09:33:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-14/1776177164'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-14/1776177164
id: 1714625
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 162011176
updated: 2026-04-14 09:33:17

Version 1713847

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-14/1776143956'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_search_locations/2026-04-14/1776143956
id: 1713847
processed: 1

raw_data:

{
    "geocoder": "string",
    "location_id": "int32",
    "search_key": "string",
    "search_location_id": "int32"
}

schema_attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

schema_name_id: 1231
schema_scan_id: 161996396
updated: 2026-04-14 00:19:37

Schema Scans: 15

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

Scan 162194190

duration: 0:00:14.272035

exit_message:

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

id: 162194190

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_search_locations/2026-04-17/1776454337",
        "key": "raw/sparefoot_search_locations/2026-04-17/1776454337/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16159129870227537557,
        "service_name": "sparefoot",
        "span_id": 3977499727407705473,
        "trace_id": 16159129870227537557
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-17 14:32:40
success: True
trace_id: 16159129870227537557

Scan 162178388

duration: 0:00:11.766449

exit_message:

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

id: 162178388

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_search_locations/2026-04-17/1776436156",
        "key": "raw/sparefoot_search_locations/2026-04-17/1776436156/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6671636235175244789,
        "service_name": "sparefoot",
        "span_id": 5298844427482940582,
        "trace_id": 6671636235175244789
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-17 09:29:28
success: True
trace_id: 6671636235175244789

Scan 162163727

duration: 0:00:14.139928

exit_message:

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

id: 162163727

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_search_locations/2026-04-17/1776404231",
        "key": "raw/sparefoot_search_locations/2026-04-17/1776404231/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4173127387173899683,
        "service_name": "sparefoot",
        "span_id": 201878118887557529,
        "trace_id": 4173127387173899683
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-17 00:37:21
success: True
trace_id: 4173127387173899683

Scan 162156232

duration: 0:00:11.686166

exit_message:

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

id: 162156232

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_search_locations/2026-04-16/1776389676",
        "key": "raw/sparefoot_search_locations/2026-04-16/1776389676/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13699127498369851244,
        "service_name": "sparefoot",
        "span_id": 7628167889526093009,
        "trace_id": 13699127498369851244
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-16 20:34:52
success: True
trace_id: 13699127498369851244

Scan 162138268

duration: 0:00:11.781316

exit_message:

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

id: 162138268

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_search_locations/2026-04-16/1776368091",
        "key": "raw/sparefoot_search_locations/2026-04-16/1776368091/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12603584475871712179,
        "service_name": "sparefoot",
        "span_id": 10392540666074285968,
        "trace_id": 12603584475871712179
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-16 14:35:00
success: True
trace_id: 12603584475871712179

Scan 162122803

duration: 0:00:11.529786

exit_message:

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

id: 162122803

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_search_locations/2026-04-16/1776350062",
        "key": "raw/sparefoot_search_locations/2026-04-16/1776350062/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2196838200917528028,
        "service_name": "sparefoot",
        "span_id": 3896655935642819893,
        "trace_id": 2196838200917528028
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-16 09:34:32
success: True
trace_id: 2196838200917528028

Scan 162107862

duration: 0:00:11.777005

exit_message:

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

id: 162107862

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_search_locations/2026-04-16/1776317666",
        "key": "raw/sparefoot_search_locations/2026-04-16/1776317666/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17639723817182782352,
        "service_name": "sparefoot",
        "span_id": 17290858978499533880,
        "trace_id": 17639723817182782352
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-16 00:34:39
success: True
trace_id: 17639723817182782352

Scan 162100196

duration: 0:00:11.747524

exit_message:

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

id: 162100196

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_search_locations/2026-04-15/1776301745",
        "key": "raw/sparefoot_search_locations/2026-04-15/1776301745/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11457133075299644651,
        "service_name": "sparefoot",
        "span_id": 1077426105649399808,
        "trace_id": 11457133075299644651
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-15 20:09:18
success: True
trace_id: 11457133075299644651

Scan 162082102

duration: 0:00:14.248599

exit_message:

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

id: 162082102

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_search_locations/2026-04-15/1776281467",
        "key": "raw/sparefoot_search_locations/2026-04-15/1776281467/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17328097409023517252,
        "service_name": "sparefoot",
        "span_id": 4367525831853309790,
        "trace_id": 17328097409023517252
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-15 14:31:23
success: True
trace_id: 17328097409023517252

Scan 162066430

duration: 0:01:12.977663

exit_message:

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

id: 162066430

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_search_locations/2026-04-15/1776261690",
        "key": "raw/sparefoot_search_locations/2026-04-15/1776261690/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11746110862537515811,
        "service_name": "sparefoot",
        "span_id": 1737373985740045878,
        "trace_id": 11746110862537515811
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-15 09:05:33
success: True
trace_id: 11746110862537515811

Scan 162052010

duration: 0:00:11.753472

exit_message:

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

id: 162052010

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_search_locations/2026-04-15/1776230467",
        "key": "raw/sparefoot_search_locations/2026-04-15/1776230467/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 364134598103573670,
        "service_name": "sparefoot",
        "span_id": 11830149610483411340,
        "trace_id": 364134598103573670
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-15 00:21:26
success: True
trace_id: 364134598103573670

Scan 162044366

duration: 0:00:14.281331

exit_message:

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

id: 162044366

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_search_locations/2026-04-14/1776216727",
        "key": "raw/sparefoot_search_locations/2026-04-14/1776216727/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14363818779037834483,
        "service_name": "sparefoot",
        "span_id": 855693526912281971,
        "trace_id": 14363818779037834483
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-14 20:32:16
success: True
trace_id: 14363818779037834483

Scan 162026217

duration: 0:00:14.355255

exit_message:

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

id: 162026217

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_search_locations/2026-04-14/1776194385",
        "key": "raw/sparefoot_search_locations/2026-04-14/1776194385/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7404095833204673232,
        "service_name": "sparefoot",
        "span_id": 18238778885889741119,
        "trace_id": 7404095833204673232
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-14 14:20:59
success: True
trace_id: 7404095833204673232

Scan 162011176

duration: 0:00:14.201353

exit_message:

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

id: 162011176

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_search_locations/2026-04-14/1776177164",
        "key": "raw/sparefoot_search_locations/2026-04-14/1776177164/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2519547115318094318,
        "service_name": "sparefoot",
        "span_id": 15360743982083728339,
        "trace_id": 2519547115318094318
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-14 09:33:03
success: True
trace_id: 2519547115318094318

Scan 161996396

duration: 0:00:11.689278

exit_message:

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

id: 161996396

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_search_locations/2026-04-14/1776143956",
        "key": "raw/sparefoot_search_locations/2026-04-14/1776143956/search_locations_3.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_search_locations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7356111363757868481,
        "service_name": "sparefoot",
        "span_id": 6039277853146654885,
        "trace_id": 7356111363757868481
    }
}

running: False
schema_name_id: 1231
start_time: 2026-04-14 00:19:25
success: True
trace_id: 7356111363757868481

Partitions:

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

Schema:

attributes:

{
    "geocoder": "string",
    "location_id": "int",
    "search_key": "string",
    "search_location_id": "int"
}

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

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_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-17/1776454337'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
}

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-11-29 15:14:52",
        "disabled": false,
        "format": "raw",
        "id": 1231,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_search_locations"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "geocoder": "string",
            "location_id": "int",
            "search_key": "string",
            "search_location_id": "int"
        },
        "created": "2026-04-17 14:32:41",
        "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_search_locations`\n(\n `geocoder`  string , `location_id`  int , `search_key`  string , `search_location_id`  int \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_search_locations/2026-04-17/1776454337'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_search_locations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_search_locations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}