Schema Info

Schema Name: sfdl_stage_rds.sparefoot_sparefoot_billable_entities

created: 2022-08-12 10:58:44
disabled: False
format: raw
id: 1387
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 906582

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-17/1776404165'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-17/1776404165
id: 906582
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6415150
updated: 2026-04-17 00:36:20

Version 906362

created: 2026-04-16 00:12:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-16/1776316366'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-16/1776316366
id: 906362
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6414598
updated: 2026-04-16 00:13:09

Version 906156

created: 2026-04-15 00:29:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-15/1776230963'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-15/1776230963
id: 906156
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6414120
updated: 2026-04-15 00:29:48

Version 905934

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-14/1776143624'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-14/1776143624
id: 905934
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6413602
updated: 2026-04-14 00:14:08

Version 905716

created: 2026-04-13 00:18:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-13/1776057523'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-13/1776057523
id: 905716
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6413052
updated: 2026-04-13 00:19:02

Version 905520

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-12/1775970939'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-12/1775970939
id: 905520
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6412672
updated: 2026-04-12 00:16:01

Version 905327

created: 2026-04-11 00:40:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-11/1775885992'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-11/1775885992
id: 905327
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6412300
updated: 2026-04-11 00:40:34

Version 905103

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-10/1775797994'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-10/1775797994
id: 905103
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6411786
updated: 2026-04-10 00:13:43

Version 904898

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-09/1775713335'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-09/1775713335
id: 904898
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6411285
updated: 2026-04-09 00:42:48

Version 904681

created: 2026-04-08 00:33:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-08/1775626391'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-08/1775626391
id: 904681
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6410784
updated: 2026-04-08 00:33:39

Version 904462

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-07/1775538990'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-07/1775538990
id: 904462
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6410266
updated: 2026-04-07 00:17:03

Version 904249

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-06/1775452488'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-06/1775452488
id: 904249
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6409722
updated: 2026-04-06 00:15:21

Version 904045

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-05/1775366195'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-05/1775366195
id: 904045
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6409341
updated: 2026-04-05 00:16:58

Version 903840

created: 2026-04-04 00:12:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-04/1775279558'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-04/1775279558
id: 903840
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6408957
updated: 2026-04-04 00:12:55

Version 903629

created: 2026-04-03 00:13:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_rds`",
    "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_rds.sparefoot_sparefoot_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-03/1775193188'\n",
    "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-stage/raw/sparefoot_billable_entities/2026-04-03/1775193188
id: 903629
processed: 1

raw_data:

{
    "account_id": "int32",
    "billable_entity_id": "int32",
    "edit_sequence": "string",
    "ns_cust_id": "int32",
    "ns_name": "string",
    "ns_parent_id": "int32",
    "payment_type": "string",
    "published": "int16",
    "qb_cust_id": "int32",
    "qb_name": "string",
    "timestamp": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

schema_name_id: 1387
schema_scan_id: 6408464
updated: 2026-04-03 00:13:23

Schema Scans: 15

Last at 2026-04-17 00:36:08

Scan 6415150

duration: 0:00:11.830566

exit_message:

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

id: 6415150

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_billable_entities/2026-04-17/1776404165",
        "key": "raw/sparefoot_billable_entities/2026-04-17/1776404165/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 107808785461567726,
        "service_name": "sparefoot",
        "span_id": 12867549505446790183,
        "trace_id": 107808785461567726
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-17 00:36:08
success: True
trace_id: 107808785461567726

Scan 6414598

duration: 0:00:11.860014

exit_message:

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

id: 6414598

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_billable_entities/2026-04-16/1776316366",
        "key": "raw/sparefoot_billable_entities/2026-04-16/1776316366/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6337632066723588539,
        "service_name": "sparefoot",
        "span_id": 4383022342807918367,
        "trace_id": 6337632066723588539
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-16 00:12:57
success: True
trace_id: 6337632066723588539

Scan 6414120

duration: 0:00:11.891363

exit_message:

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

id: 6414120

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_billable_entities/2026-04-15/1776230963",
        "key": "raw/sparefoot_billable_entities/2026-04-15/1776230963/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11724303957948209642,
        "service_name": "sparefoot",
        "span_id": 6642006698538203375,
        "trace_id": 11724303957948209642
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-15 00:29:36
success: True
trace_id: 11724303957948209642

Scan 6413602

duration: 0:00:11.746586

exit_message:

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

id: 6413602

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_billable_entities/2026-04-14/1776143624",
        "key": "raw/sparefoot_billable_entities/2026-04-14/1776143624/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8024089845257460603,
        "service_name": "sparefoot",
        "span_id": 18356261272090722225,
        "trace_id": 8024089845257460603
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-14 00:13:56
success: True
trace_id: 8024089845257460603

Scan 6413052

duration: 0:00:14.563409

exit_message:

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

id: 6413052

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_billable_entities/2026-04-13/1776057523",
        "key": "raw/sparefoot_billable_entities/2026-04-13/1776057523/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1888523603711873058,
        "service_name": "sparefoot",
        "span_id": 405240796926800843,
        "trace_id": 1888523603711873058
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-13 00:18:47
success: True
trace_id: 1888523603711873058

Scan 6412672

duration: 0:00:14.430285

exit_message:

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

id: 6412672

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_billable_entities/2026-04-12/1775970939",
        "key": "raw/sparefoot_billable_entities/2026-04-12/1775970939/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 2132034174887022739,
        "service_name": "sparefoot",
        "span_id": 8139199018971613925,
        "trace_id": 2132034174887022739
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-12 00:15:47
success: True
trace_id: 2132034174887022739

Scan 6412300

duration: 0:00:11.878353

exit_message:

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

id: 6412300

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_billable_entities/2026-04-11/1775885992",
        "key": "raw/sparefoot_billable_entities/2026-04-11/1775885992/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6464632274583918404,
        "service_name": "sparefoot",
        "span_id": 5588747598816045290,
        "trace_id": 6464632274583918404
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-11 00:40:22
success: True
trace_id: 6464632274583918404

Scan 6411786

duration: 0:00:11.824425

exit_message:

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

id: 6411786

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_billable_entities/2026-04-10/1775797994",
        "key": "raw/sparefoot_billable_entities/2026-04-10/1775797994/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 69849461500958084,
        "service_name": "sparefoot",
        "span_id": 926987297848959917,
        "trace_id": 69849461500958084
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-10 00:13:31
success: True
trace_id: 69849461500958084

Scan 6411285

duration: 0:00:12.081387

exit_message:

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

id: 6411285

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_billable_entities/2026-04-09/1775713335",
        "key": "raw/sparefoot_billable_entities/2026-04-09/1775713335/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 20367222798578223,
        "service_name": "sparefoot",
        "span_id": 6746530584080859667,
        "trace_id": 20367222798578223
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-09 00:42:36
success: True
trace_id: 20367222798578223

Scan 6410784

duration: 0:00:11.896606

exit_message:

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

id: 6410784

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_billable_entities/2026-04-08/1775626391",
        "key": "raw/sparefoot_billable_entities/2026-04-08/1775626391/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15207692275499159190,
        "service_name": "sparefoot",
        "span_id": 8439206636917598142,
        "trace_id": 15207692275499159190
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-08 00:33:28
success: True
trace_id: 15207692275499159190

Scan 6410266

duration: 0:00:11.934201

exit_message:

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

id: 6410266

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_billable_entities/2026-04-07/1775538990",
        "key": "raw/sparefoot_billable_entities/2026-04-07/1775538990/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3631237825606523060,
        "service_name": "sparefoot",
        "span_id": 1869909680859142110,
        "trace_id": 3631237825606523060
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-07 00:16:51
success: True
trace_id: 3631237825606523060

Scan 6409722

duration: 0:00:14.416647

exit_message:

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

id: 6409722

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_billable_entities/2026-04-06/1775452488",
        "key": "raw/sparefoot_billable_entities/2026-04-06/1775452488/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10230292366385304166,
        "service_name": "sparefoot",
        "span_id": 14632463513479518469,
        "trace_id": 10230292366385304166
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-06 00:15:07
success: True
trace_id: 10230292366385304166

Scan 6409341

duration: 0:00:11.872198

exit_message:

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

id: 6409341

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_billable_entities/2026-04-05/1775366195",
        "key": "raw/sparefoot_billable_entities/2026-04-05/1775366195/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4750409796195440063,
        "service_name": "sparefoot",
        "span_id": 13772355470200296567,
        "trace_id": 4750409796195440063
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-05 00:16:46
success: True
trace_id: 4750409796195440063

Scan 6408957

duration: 0:00:14.371524

exit_message:

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

id: 6408957

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_billable_entities/2026-04-04/1775279558",
        "key": "raw/sparefoot_billable_entities/2026-04-04/1775279558/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7758286571314327946,
        "service_name": "sparefoot",
        "span_id": 3070422553037369719,
        "trace_id": 7758286571314327946
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-04 00:12:41
success: True
trace_id: 7758286571314327946

Scan 6408464

duration: 0:00:11.748569

exit_message:

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

id: 6408464

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_billable_entities/2026-04-03/1775193188",
        "key": "raw/sparefoot_billable_entities/2026-04-03/1775193188/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_stage_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14074451592887625423,
        "service_name": "sparefoot",
        "span_id": 9011345436249035271,
        "trace_id": 14074451592887625423
    }
}

running: False
schema_name_id: 1387
start_time: 2026-04-03 00:13:12
success: True
trace_id: 14074451592887625423

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "billable_entity_id": "int",
    "edit_sequence": "string",
    "ns_cust_id": "int",
    "ns_name": "string",
    "ns_parent_id": "int",
    "payment_type": "string",
    "published": "smallint",
    "qb_cust_id": "int",
    "qb_name": "string",
    "timestamp": "timestamp"
}

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

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_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-17/1776404165'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
}

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:58:44",
        "disabled": false,
        "format": "raw",
        "id": 1387,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_rds",
            "table": "sparefoot_sparefoot_billable_entities"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "billable_entity_id": "int",
            "edit_sequence": "string",
            "ns_cust_id": "int",
            "ns_name": "string",
            "ns_parent_id": "int",
            "payment_type": "string",
            "published": "smallint",
            "qb_cust_id": "int",
            "qb_name": "string",
            "timestamp": "timestamp"
        },
        "created": "2026-04-17 00:36:09",
        "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_billable_entities`\n(\n `account_id`  int , `billable_entity_id`  int , `edit_sequence`  string , `ns_cust_id`  int , `ns_name`  string , `ns_parent_id`  int , `payment_type`  string , `published`  smallint , `qb_cust_id`  int , `qb_name`  string , `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_billable_entities/2026-04-17/1776404165'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_rds.sparefoot_sparefoot_billable_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_rds.sparefoot_sparefoot_billable_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}