Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers

created: 2022-08-18 17:20:52
disabled: False
format: raw
id: 1108
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718386

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-17/1776453205'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-17/1776453205
id: 1718386
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162193988
updated: 2026-04-17 14:13:41

Version 1718174

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-17/1776434998'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-17/1776434998
id: 1718174
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162178184
updated: 2026-04-17 09:10:13

Version 1717440

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-17/1776402391'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-17/1776402391
id: 1717440
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162163572
updated: 2026-04-17 00:07:28

Version 1717317

created: 2026-04-16 20:16:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-16/1776388389'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-16/1776388389
id: 1717317
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162156043
updated: 2026-04-16 20:16:20

Version 1717150

created: 2026-04-16 14:14:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-16/1776366895'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-16/1776366895
id: 1717150
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162138031
updated: 2026-04-16 14:15:11

Version 1716983

created: 2026-04-16 09:11:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-16/1776348660'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-16/1776348660
id: 1716983
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162122507
updated: 2026-04-16 09:11:15

Version 1716220

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-16/1776316431'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-16/1776316431
id: 1716220
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162107799
updated: 2026-04-16 00:14:09

Version 1716117

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-15/1776302714'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-15/1776302714
id: 1716117
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162100335
updated: 2026-04-15 20:25:38

Version 1715974

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-15/1776280641'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-15/1776280641
id: 1715974
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162081735
updated: 2026-04-15 14:17:37

Version 1715759

created: 2026-04-15 08:40:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-15/1776260333'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-15/1776260333
id: 1715759
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162064426
updated: 2026-04-15 08:40:45

Version 1715008

created: 2026-04-15 00:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-15/1776229709'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-15/1776229709
id: 1715008
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162051952
updated: 2026-04-15 00:08:46

Version 1714900

created: 2026-04-14 20:19:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-14/1776215981'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-14/1776215981
id: 1714900
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162044300
updated: 2026-04-14 20:20:03

Version 1714724

created: 2026-04-14 14:14:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-14/1776194070'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-14/1776194070
id: 1714724
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162026103
updated: 2026-04-14 14:14:53

Version 1714573

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-14/1776175385'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-14/1776175385
id: 1714573
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 162010765
updated: 2026-04-14 09:03:53

Version 1713798

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-14/1776143222'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_call_center_transfers/2026-04-14/1776143222
id: 1713798
processed: 1

raw_data:

{
    "call_center_transfer_id": "int32",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int32",
    "referring_user_id": "int32",
    "search_string": "string",
    "site_id": "int32",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

schema_name_id: 1108
schema_scan_id: 161996312
updated: 2026-04-14 00:07:16

Schema Scans: 15

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

Scan 162193988

duration: 0:00:11.839304

exit_message:

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

id: 162193988

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_call_center_transfers/2026-04-17/1776453205",
        "key": "raw/sparefoot_call_center_transfers/2026-04-17/1776453205/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4652166383468696394,
        "service_name": "sparefoot",
        "span_id": 14700609579655909742,
        "trace_id": 4652166383468696394
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-17 14:13:29
success: True
trace_id: 4652166383468696394

Scan 162178184

duration: 0:00:11.844487

exit_message:

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

id: 162178184

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_call_center_transfers/2026-04-17/1776434998",
        "key": "raw/sparefoot_call_center_transfers/2026-04-17/1776434998/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5362489955848203351,
        "service_name": "sparefoot",
        "span_id": 10810977434573525782,
        "trace_id": 5362489955848203351
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-17 09:10:01
success: True
trace_id: 5362489955848203351

Scan 162163572

duration: 0:00:11.761687

exit_message:

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

id: 162163572

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_call_center_transfers/2026-04-17/1776402391",
        "key": "raw/sparefoot_call_center_transfers/2026-04-17/1776402391/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15549803958780197193,
        "service_name": "sparefoot",
        "span_id": 7460690614615448760,
        "trace_id": 15549803958780197193
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-17 00:07:16
success: True
trace_id: 15549803958780197193

Scan 162156043

duration: 0:00:11.891826

exit_message:

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

id: 162156043

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_call_center_transfers/2026-04-16/1776388389",
        "key": "raw/sparefoot_call_center_transfers/2026-04-16/1776388389/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10399670088335289628,
        "service_name": "sparefoot",
        "span_id": 1221383933491623029,
        "trace_id": 10399670088335289628
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-16 20:16:08
success: True
trace_id: 10399670088335289628

Scan 162138031

duration: 0:00:11.790220

exit_message:

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

id: 162138031

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_call_center_transfers/2026-04-16/1776366895",
        "key": "raw/sparefoot_call_center_transfers/2026-04-16/1776366895/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5975294294400456041,
        "service_name": "sparefoot",
        "span_id": 15562555357635903811,
        "trace_id": 5975294294400456041
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-16 14:14:59
success: True
trace_id: 5975294294400456041

Scan 162122507

duration: 0:00:11.896828

exit_message:

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

id: 162122507

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_call_center_transfers/2026-04-16/1776348660",
        "key": "raw/sparefoot_call_center_transfers/2026-04-16/1776348660/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2075585956252196104,
        "service_name": "sparefoot",
        "span_id": 13127617550675579988,
        "trace_id": 2075585956252196104
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-16 09:11:03
success: True
trace_id: 2075585956252196104

Scan 162107799

duration: 0:00:14.427858

exit_message:

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

id: 162107799

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_call_center_transfers/2026-04-16/1776316431",
        "key": "raw/sparefoot_call_center_transfers/2026-04-16/1776316431/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15859564949338995196,
        "service_name": "sparefoot",
        "span_id": 1846691364609238569,
        "trace_id": 15859564949338995196
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-16 00:13:54
success: True
trace_id: 15859564949338995196

Scan 162100335

duration: 0:00:14.415172

exit_message:

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

id: 162100335

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_call_center_transfers/2026-04-15/1776302714",
        "key": "raw/sparefoot_call_center_transfers/2026-04-15/1776302714/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5571388378261348427,
        "service_name": "sparefoot",
        "span_id": 15448209976711796827,
        "trace_id": 5571388378261348427
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-15 20:25:24
success: True
trace_id: 5571388378261348427

Scan 162081735

duration: 0:00:11.908258

exit_message:

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

id: 162081735

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_call_center_transfers/2026-04-15/1776280641",
        "key": "raw/sparefoot_call_center_transfers/2026-04-15/1776280641/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3502678388709437725,
        "service_name": "sparefoot",
        "span_id": 16222402496789165789,
        "trace_id": 3502678388709437725
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-15 14:17:25
success: True
trace_id: 3502678388709437725

Scan 162064426

duration: 0:00:11.909134

exit_message:

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

id: 162064426

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_call_center_transfers/2026-04-15/1776260333",
        "key": "raw/sparefoot_call_center_transfers/2026-04-15/1776260333/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1392676359931050433,
        "service_name": "sparefoot",
        "span_id": 13075206848136560376,
        "trace_id": 1392676359931050433
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-15 08:40:33
success: True
trace_id: 1392676359931050433

Scan 162051952

duration: 0:00:14.394861

exit_message:

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

id: 162051952

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_call_center_transfers/2026-04-15/1776229709",
        "key": "raw/sparefoot_call_center_transfers/2026-04-15/1776229709/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13769366756211486752,
        "service_name": "sparefoot",
        "span_id": 12314735029236273676,
        "trace_id": 13769366756211486752
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-15 00:08:32
success: True
trace_id: 13769366756211486752

Scan 162044300

duration: 0:00:14.483958

exit_message:

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

id: 162044300

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_call_center_transfers/2026-04-14/1776215981",
        "key": "raw/sparefoot_call_center_transfers/2026-04-14/1776215981/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6666884843797857527,
        "service_name": "sparefoot",
        "span_id": 7280277658119620037,
        "trace_id": 6666884843797857527
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-14 20:19:48
success: True
trace_id: 6666884843797857527

Scan 162026103

duration: 0:00:11.852858

exit_message:

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

id: 162026103

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_call_center_transfers/2026-04-14/1776194070",
        "key": "raw/sparefoot_call_center_transfers/2026-04-14/1776194070/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4910426073375984615,
        "service_name": "sparefoot",
        "span_id": 17605130166316684478,
        "trace_id": 4910426073375984615
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-14 14:14:41
success: True
trace_id: 4910426073375984615

Scan 162010765

duration: 0:00:11.802996

exit_message:

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

id: 162010765

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_call_center_transfers/2026-04-14/1776175385",
        "key": "raw/sparefoot_call_center_transfers/2026-04-14/1776175385/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3095823415236690764,
        "service_name": "sparefoot",
        "span_id": 1516201596395479512,
        "trace_id": 3095823415236690764
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-14 09:03:42
success: True
trace_id: 3095823415236690764

Scan 161996312

duration: 0:00:11.772309

exit_message:

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

id: 161996312

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_call_center_transfers/2026-04-14/1776143222",
        "key": "raw/sparefoot_call_center_transfers/2026-04-14/1776143222/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16690674407540484774,
        "service_name": "sparefoot",
        "span_id": 7988344564242149266,
        "trace_id": 16690674407540484774
    }
}

running: False
schema_name_id: 1108
start_time: 2026-04-14 00:07:04
success: True
trace_id: 16690674407540484774

Partitions:

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

Schema:

attributes:

{
    "call_center_transfer_id": "int",
    "confirmation_code": "string",
    "email": "string",
    "first_name": "string",
    "last_name": "string",
    "phone_number": "string",
    "receiving_user_id": "int",
    "referring_user_id": "int",
    "search_string": "string",
    "site_id": "int",
    "timestamp": "timestamp"
}

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

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_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-17/1776453205'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-18 17:20:52",
        "disabled": false,
        "format": "raw",
        "id": 1108,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_rds",
            "table": "sparefoot_sparefoot_call_center_transfers"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "call_center_transfer_id": "int",
            "confirmation_code": "string",
            "email": "string",
            "first_name": "string",
            "last_name": "string",
            "phone_number": "string",
            "receiving_user_id": "int",
            "referring_user_id": "int",
            "search_string": "string",
            "site_id": "int",
            "timestamp": "timestamp"
        },
        "created": "2026-04-17 14:13:29",
        "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_call_center_transfers`\n(\n `call_center_transfer_id`  int , `confirmation_code`  string , `email`  string , `first_name`  string , `last_name`  string , `phone_number`  string , `receiving_user_id`  int , `referring_user_id`  int , `search_string`  string , `site_id`  int , `timestamp`  timestamp \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_call_center_transfers/2026-04-17/1776453205'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_call_center_transfers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}