Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers

created: 2022-08-12 10:59:26
disabled: False
format: raw
id: 1390
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906538

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-17/1776402941
id: 906538
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: 1390
schema_scan_id: 6415106
updated: 2026-04-17 00:16:17

Version 906309

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-16/1776315948
id: 906309
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: 1390
schema_scan_id: 6414542
updated: 2026-04-16 00:06:27

Version 906125

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-15/1776229848
id: 906125
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: 1390
schema_scan_id: 6414087
updated: 2026-04-15 00:11:11

Version 905911

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-14/1776143477
id: 905911
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: 1390
schema_scan_id: 6413577
updated: 2026-04-14 00:11:37

Version 905678

created: 2026-04-13 00:13:45

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-13/1776057213
id: 905678
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: 1390
schema_scan_id: 6413009
updated: 2026-04-13 00:13:59

Version 905497

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-12/1775970644
id: 905497
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: 1390
schema_scan_id: 6412649
updated: 2026-04-12 00:11:12

Version 905264

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-11/1775883965
id: 905264
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: 1390
schema_scan_id: 6412235
updated: 2026-04-11 00:06:20

Version 905051

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-10/1775797564
id: 905051
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: 1390
schema_scan_id: 6411730
updated: 2026-04-10 00:06:23

Version 904875

created: 2026-04-09 00:14:59

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-09/1775711670
id: 904875
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: 1390
schema_scan_id: 6411262
updated: 2026-04-09 00:15:11

Version 904620

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-08/1775624764
id: 904620
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: 1390
schema_scan_id: 6410715
updated: 2026-04-08 00:06:22

Version 904458

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-07/1775538968
id: 904458
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: 1390
schema_scan_id: 6410262
updated: 2026-04-07 00:16:51

Version 904208

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-06/1775451991
id: 904208
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: 1390
schema_scan_id: 6409680
updated: 2026-04-06 00:06:56

Version 904017

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-05/1775365730
id: 904017
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: 1390
schema_scan_id: 6409311
updated: 2026-04-05 00:09:21

Version 903814

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-04/1775279372
id: 903814
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: 1390
schema_scan_id: 6408930
updated: 2026-04-04 00:09:50

Version 903579

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

ddl:

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

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_call_center_transfers/2026-04-03/1775192804
id: 903579
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: 1390
schema_scan_id: 6408412
updated: 2026-04-03 00:07:07

Schema Scans: 15

Last at 2026-04-17 00:16:03

Scan 6415106

duration: 0:00:14.392732

exit_message:

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

id: 6415106

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

running: False
schema_name_id: 1390
start_time: 2026-04-17 00:16:03
success: True
trace_id: 4181482033493060317

Scan 6414542

duration: 0:00:14.381425

exit_message:

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

id: 6414542

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

running: False
schema_name_id: 1390
start_time: 2026-04-16 00:06:13
success: True
trace_id: 3172258447149129492

Scan 6414087

duration: 0:00:14.451748

exit_message:

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

id: 6414087

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

running: False
schema_name_id: 1390
start_time: 2026-04-15 00:10:56
success: True
trace_id: 1166054884936194200

Scan 6413577

duration: 0:00:11.987932

exit_message:

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

id: 6413577

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

running: False
schema_name_id: 1390
start_time: 2026-04-14 00:11:25
success: True
trace_id: 15526216820102475345

Scan 6413009

duration: 0:00:14.419319

exit_message:

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

id: 6413009

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_call_center_transfers/2026-04-13/1776057213",
        "key": "raw/sparefoot_call_center_transfers/2026-04-13/1776057213/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11170754587971756210,
        "service_name": "sparefoot",
        "span_id": 15981065482260061850,
        "trace_id": 11170754587971756210
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-13 00:13:44
success: True
trace_id: 11170754587971756210

Scan 6412649

duration: 0:00:11.872526

exit_message:

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

id: 6412649

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_call_center_transfers/2026-04-12/1775970644",
        "key": "raw/sparefoot_call_center_transfers/2026-04-12/1775970644/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10594933324525112141,
        "service_name": "sparefoot",
        "span_id": 12605848484088624980,
        "trace_id": 10594933324525112141
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-12 00:11:01
success: True
trace_id: 10594933324525112141

Scan 6412235

duration: 0:00:11.769349

exit_message:

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

id: 6412235

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_call_center_transfers/2026-04-11/1775883965",
        "key": "raw/sparefoot_call_center_transfers/2026-04-11/1775883965/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9396543576448394610,
        "service_name": "sparefoot",
        "span_id": 12953686047400455979,
        "trace_id": 9396543576448394610
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-11 00:06:08
success: True
trace_id: 9396543576448394610

Scan 6411730

duration: 0:00:14.334752

exit_message:

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

id: 6411730

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_call_center_transfers/2026-04-10/1775797564",
        "key": "raw/sparefoot_call_center_transfers/2026-04-10/1775797564/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6383772118839714086,
        "service_name": "sparefoot",
        "span_id": 9844579184491499000,
        "trace_id": 6383772118839714086
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-10 00:06:09
success: True
trace_id: 6383772118839714086

Scan 6411262

duration: 0:00:11.960478

exit_message:

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

id: 6411262

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_call_center_transfers/2026-04-09/1775711670",
        "key": "raw/sparefoot_call_center_transfers/2026-04-09/1775711670/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16459754069118994143,
        "service_name": "sparefoot",
        "span_id": 8792618739997456692,
        "trace_id": 16459754069118994143
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-09 00:14:59
success: True
trace_id: 16459754069118994143

Scan 6410715

duration: 0:00:11.804365

exit_message:

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

id: 6410715

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_call_center_transfers/2026-04-08/1775624764",
        "key": "raw/sparefoot_call_center_transfers/2026-04-08/1775624764/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8584156833188971243,
        "service_name": "sparefoot",
        "span_id": 14607636329381256221,
        "trace_id": 8584156833188971243
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-08 00:06:10
success: True
trace_id: 8584156833188971243

Scan 6410262

duration: 0:00:14.407121

exit_message:

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

id: 6410262

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_call_center_transfers/2026-04-07/1775538968",
        "key": "raw/sparefoot_call_center_transfers/2026-04-07/1775538968/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2877322986351417170,
        "service_name": "sparefoot",
        "span_id": 15681774439661914825,
        "trace_id": 2877322986351417170
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-07 00:16:37
success: True
trace_id: 2877322986351417170

Scan 6409680

duration: 0:00:11.880353

exit_message:

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

id: 6409680

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_call_center_transfers/2026-04-06/1775451991",
        "key": "raw/sparefoot_call_center_transfers/2026-04-06/1775451991/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11650141934456356267,
        "service_name": "sparefoot",
        "span_id": 6046310678900719762,
        "trace_id": 11650141934456356267
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-06 00:06:44
success: True
trace_id: 11650141934456356267

Scan 6409311

duration: 0:00:14.528288

exit_message:

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

id: 6409311

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_call_center_transfers/2026-04-05/1775365730",
        "key": "raw/sparefoot_call_center_transfers/2026-04-05/1775365730/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1329520540940931141,
        "service_name": "sparefoot",
        "span_id": 1708996601186430574,
        "trace_id": 1329520540940931141
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-05 00:09:07
success: True
trace_id: 1329520540940931141

Scan 6408930

duration: 0:00:14.365550

exit_message:

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

id: 6408930

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_call_center_transfers/2026-04-04/1775279372",
        "key": "raw/sparefoot_call_center_transfers/2026-04-04/1775279372/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5831722789967136729,
        "service_name": "sparefoot",
        "span_id": 8345854558990766841,
        "trace_id": 5831722789967136729
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-04 00:09:36
success: True
trace_id: 5831722789967136729

Scan 6408412

duration: 0:00:14.427434

exit_message:

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

id: 6408412

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_call_center_transfers/2026-04-03/1775192804",
        "key": "raw/sparefoot_call_center_transfers/2026-04-03/1775192804/call_center_transfers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8774567529035678677,
        "service_name": "sparefoot",
        "span_id": 8259204431022243981,
        "trace_id": 8774567529035678677
    }
}

running: False
schema_name_id: 1390
start_time: 2026-04-03 00:06:53
success: True
trace_id: 8774567529035678677

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 00:16:03

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_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-stage/raw/sparefoot_call_center_transfers/2026-04-17/1776402941'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers"
}

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:59:26",
        "disabled": false,
        "format": "raw",
        "id": 1390,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_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 00:16:03",
        "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_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-stage/raw/sparefoot_call_center_transfers/2026-04-17/1776402941'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_call_center_transfers"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}