Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_penske_referrals

created: 2022-08-12 10:21:38
disabled: False
format: raw
id: 1341
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906532

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-17/1776402856'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-17/1776402856
id: 906532
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6415099
updated: 2026-04-17 00:14:38

Version 906326

created: 2026-04-16 00:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-16/1776316087'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-16/1776316087
id: 906326
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6414560
updated: 2026-04-16 00:08:25

Version 906099

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-15/1776229573'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-15/1776229573
id: 906099
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6414057
updated: 2026-04-15 00:06:28

Version 905928

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-14/1776143572'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-14/1776143572
id: 905928
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6413596
updated: 2026-04-14 00:13:30

Version 905682

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-13/1776057251'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-13/1776057251
id: 905682
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6413013
updated: 2026-04-13 00:14:29

Version 905470

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-12/1775970432'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-12/1775970432
id: 905470
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6412620
updated: 2026-04-12 00:07:29

Version 905288

created: 2026-04-11 00:10:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-11/1775884223'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-11/1775884223
id: 905288
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6412260
updated: 2026-04-11 00:10:44

Version 905067

created: 2026-04-10 00:08:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-10/1775797687'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-10/1775797687
id: 905067
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6411748
updated: 2026-04-10 00:08:21

Version 904827

created: 2026-04-09 00:07:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-09/1775711252'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-09/1775711252
id: 904827
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6411209
updated: 2026-04-09 00:07:47

Version 904641

created: 2026-04-08 00:08:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-08/1775624902'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-08/1775624902
id: 904641
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6410736
updated: 2026-04-08 00:08:39

Version 904446

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-07/1775538796'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-07/1775538796
id: 904446
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6410250
updated: 2026-04-07 00:13:33

Version 904244

created: 2026-04-06 00:13:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-06/1775452400'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-06/1775452400
id: 904244
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6409717
updated: 2026-04-06 00:13:44

Version 904032

created: 2026-04-05 00:12:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-05/1775365966'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-05/1775365966
id: 904032
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6409328
updated: 2026-04-05 00:13:04

Version 903790

created: 2026-04-04 00:05:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-04/1775279139'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-04/1775279139
id: 903790
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6408904
updated: 2026-04-04 00:05:56

Version 903611

created: 2026-04-03 00:10:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-03/1775193019'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_penske_referrals/2026-04-03/1775193019
id: 903611
processed: 1

raw_data:

{
    "confirmation_code": "string",
    "pick_up_date": "date32[day]",
    "referral_id": "int32",
    "rental_type": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]",
    "visit_id": "string",
    "zip": "string"
}

schema_attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

schema_name_id: 1341
schema_scan_id: 6408445
updated: 2026-04-03 00:10:44

Schema Scans: 15

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

Scan 6415099

duration: 0:00:14.254722

exit_message:

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

id: 6415099

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_penske_referrals/2026-04-17/1776402856",
        "key": "raw/sparefoot_penske_referrals/2026-04-17/1776402856/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9910990243282912801,
        "service_name": "sparefoot",
        "span_id": 11623393840215837620,
        "trace_id": 9910990243282912801
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-17 00:14:23
success: True
trace_id: 9910990243282912801

Scan 6414560

duration: 0:00:14.285149

exit_message:

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

id: 6414560

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_penske_referrals/2026-04-16/1776316087",
        "key": "raw/sparefoot_penske_referrals/2026-04-16/1776316087/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8024206947047636317,
        "service_name": "sparefoot",
        "span_id": 1539265580738402891,
        "trace_id": 8024206947047636317
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-16 00:08:10
success: True
trace_id: 8024206947047636317

Scan 6414057

duration: 0:00:11.704892

exit_message:

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

id: 6414057

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_penske_referrals/2026-04-15/1776229573",
        "key": "raw/sparefoot_penske_referrals/2026-04-15/1776229573/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9490453133304179416,
        "service_name": "sparefoot",
        "span_id": 13442570238717897250,
        "trace_id": 9490453133304179416
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-15 00:06:16
success: True
trace_id: 9490453133304179416

Scan 6413596

duration: 0:00:14.246647

exit_message:

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

id: 6413596

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_penske_referrals/2026-04-14/1776143572",
        "key": "raw/sparefoot_penske_referrals/2026-04-14/1776143572/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15896420150960701510,
        "service_name": "sparefoot",
        "span_id": 16243056354819298703,
        "trace_id": 15896420150960701510
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-14 00:13:16
success: True
trace_id: 15896420150960701510

Scan 6413013

duration: 0:00:11.894327

exit_message:

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

id: 6413013

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_penske_referrals/2026-04-13/1776057251",
        "key": "raw/sparefoot_penske_referrals/2026-04-13/1776057251/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5174800820995654710,
        "service_name": "sparefoot",
        "span_id": 10713421729930961391,
        "trace_id": 5174800820995654710
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-13 00:14:17
success: True
trace_id: 5174800820995654710

Scan 6412620

duration: 0:00:14.172948

exit_message:

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

id: 6412620

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_penske_referrals/2026-04-12/1775970432",
        "key": "raw/sparefoot_penske_referrals/2026-04-12/1775970432/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17013690743789918688,
        "service_name": "sparefoot",
        "span_id": 4729780186676901910,
        "trace_id": 17013690743789918688
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-12 00:07:15
success: True
trace_id: 17013690743789918688

Scan 6412260

duration: 0:00:11.815308

exit_message:

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

id: 6412260

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_penske_referrals/2026-04-11/1775884223",
        "key": "raw/sparefoot_penske_referrals/2026-04-11/1775884223/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10292406696494463702,
        "service_name": "sparefoot",
        "span_id": 14362170612497011185,
        "trace_id": 10292406696494463702
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-11 00:10:33
success: True
trace_id: 10292406696494463702

Scan 6411748

duration: 0:00:11.707506

exit_message:

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

id: 6411748

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_penske_referrals/2026-04-10/1775797687",
        "key": "raw/sparefoot_penske_referrals/2026-04-10/1775797687/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15902107798230251929,
        "service_name": "sparefoot",
        "span_id": 7810714039632142040,
        "trace_id": 15902107798230251929
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-10 00:08:10
success: True
trace_id: 15902107798230251929

Scan 6411209

duration: 0:00:11.727675

exit_message:

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

id: 6411209

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_penske_referrals/2026-04-09/1775711252",
        "key": "raw/sparefoot_penske_referrals/2026-04-09/1775711252/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14294037803700953923,
        "service_name": "sparefoot",
        "span_id": 13721821808131273314,
        "trace_id": 14294037803700953923
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-09 00:07:35
success: True
trace_id: 14294037803700953923

Scan 6410736

duration: 0:00:14.284944

exit_message:

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

id: 6410736

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_penske_referrals/2026-04-08/1775624902",
        "key": "raw/sparefoot_penske_referrals/2026-04-08/1775624902/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1710710245481521712,
        "service_name": "sparefoot",
        "span_id": 8192804053652355340,
        "trace_id": 1710710245481521712
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-08 00:08:25
success: True
trace_id: 1710710245481521712

Scan 6410250

duration: 0:00:14.361248

exit_message:

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

id: 6410250

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_penske_referrals/2026-04-07/1775538796",
        "key": "raw/sparefoot_penske_referrals/2026-04-07/1775538796/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14117765094576290121,
        "service_name": "sparefoot",
        "span_id": 11809803158544233234,
        "trace_id": 14117765094576290121
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-07 00:13:18
success: True
trace_id: 14117765094576290121

Scan 6409717

duration: 0:00:11.851224

exit_message:

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

id: 6409717

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_penske_referrals/2026-04-06/1775452400",
        "key": "raw/sparefoot_penske_referrals/2026-04-06/1775452400/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14698641044019132909,
        "service_name": "sparefoot",
        "span_id": 2582432835195303475,
        "trace_id": 14698641044019132909
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-06 00:13:32
success: True
trace_id: 14698641044019132909

Scan 6409328

duration: 0:00:11.815326

exit_message:

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

id: 6409328

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_penske_referrals/2026-04-05/1775365966",
        "key": "raw/sparefoot_penske_referrals/2026-04-05/1775365966/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15633345506634139157,
        "service_name": "sparefoot",
        "span_id": 2327494077490111506,
        "trace_id": 15633345506634139157
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-05 00:12:53
success: True
trace_id: 15633345506634139157

Scan 6408904

duration: 0:00:14.277455

exit_message:

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

id: 6408904

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_penske_referrals/2026-04-04/1775279139",
        "key": "raw/sparefoot_penske_referrals/2026-04-04/1775279139/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16058907248108614775,
        "service_name": "sparefoot",
        "span_id": 10788859890938623654,
        "trace_id": 16058907248108614775
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-04 00:05:42
success: True
trace_id: 16058907248108614775

Scan 6408445

duration: 0:00:14.297181

exit_message:

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

id: 6408445

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_penske_referrals/2026-04-03/1775193019",
        "key": "raw/sparefoot_penske_referrals/2026-04-03/1775193019/penske_referrals.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_penske_referrals",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8086846058476371242,
        "service_name": "sparefoot",
        "span_id": 1217810963502485915,
        "trace_id": 8086846058476371242
    }
}

running: False
schema_name_id: 1341
start_time: 2026-04-03 00:10:29
success: True
trace_id: 8086846058476371242

Partitions:

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

Schema:

attributes:

{
    "confirmation_code": "string",
    "pick_up_date": "date",
    "referral_id": "int",
    "rental_type": "string",
    "site_id": "int",
    "timestamp": "timestamp",
    "visit_id": "string",
    "zip": "string"
}

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

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_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-17/1776402856'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
}

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:21:38",
        "disabled": false,
        "format": "raw",
        "id": 1341,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_penske_referrals"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "confirmation_code": "string",
            "pick_up_date": "date",
            "referral_id": "int",
            "rental_type": "string",
            "site_id": "int",
            "timestamp": "timestamp",
            "visit_id": "string",
            "zip": "string"
        },
        "created": "2026-04-17 00:14:24",
        "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_penske_referrals`\n(\n `confirmation_code`  string , `pick_up_date`  date , `referral_id`  int , `rental_type`  string , `site_id`  int , `timestamp`  timestamp , `visit_id`  string , `zip`  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_penske_referrals/2026-04-17/1776402856'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_penske_referrals`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_penske_referrals"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}