Schema Info

Schema Name: sfdl_prod_rds.sparefoot_sparefoot_billable_entities

created: 2022-08-18 17:25:56
disabled: False
format: raw
id: 1138
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 1718412

created: 2026-04-17 14:17:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-17/1776453434'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776453434
id: 1718412
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: 1138
schema_scan_id: 162194053
updated: 2026-04-17 14:17:42

Version 1718232

created: 2026-04-17 09:26:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-17/1776435976'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776435976
id: 1718232
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: 1138
schema_scan_id: 162178338
updated: 2026-04-17 09:26:35

Version 1717476

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-17/1776402938'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776402938
id: 1717476
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: 1138
schema_scan_id: 162163654
updated: 2026-04-17 00:15:53

Version 1717368

created: 2026-04-16 20:39:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-16/1776389987'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776389987
id: 1717368
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: 1138
schema_scan_id: 162156250
updated: 2026-04-16 20:40:13

Version 1717186

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-16/1776367192'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776367192
id: 1717186
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: 1138
schema_scan_id: 162138141
updated: 2026-04-16 14:20:43

Version 1717044

created: 2026-04-16 09:41:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-16/1776350474'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776350474
id: 1717044
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: 1138
schema_scan_id: 162122889
updated: 2026-04-16 09:41:46

Version 1716239

created: 2026-04-16 00:19:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-16/1776316751'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776316751
id: 1716239
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: 1138
schema_scan_id: 162107829
updated: 2026-04-16 00:19:31

Version 1716133

created: 2026-04-15 20:29:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-15/1776302972'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776302972
id: 1716133
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: 1138
schema_scan_id: 162100367
updated: 2026-04-15 20:29:50

Version 1715994

created: 2026-04-15 14:20:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-15/1776280840'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776280840
id: 1715994
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: 1138
schema_scan_id: 162081814
updated: 2026-04-15 14:21:04

Version 1715791

created: 2026-04-15 08:45:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-15/1776260622'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776260622
id: 1715791
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: 1138
schema_scan_id: 162064568
updated: 2026-04-15 08:45:31

Version 1715047

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-15/1776230654'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776230654
id: 1715047
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: 1138
schema_scan_id: 162052019
updated: 2026-04-15 00:24:28

Version 1714921

created: 2026-04-14 20:27:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-14/1776216416'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776216416
id: 1714921
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: 1138
schema_scan_id: 162044346
updated: 2026-04-14 20:27:13

Version 1714760

created: 2026-04-14 14:18:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-14/1776194217'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776194217
id: 1714760
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: 1138
schema_scan_id: 162026171
updated: 2026-04-14 14:19:33

Version 1714602

created: 2026-04-14 09:11:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-14/1776175867'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776175867
id: 1714602
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: 1138
schema_scan_id: 162010973
updated: 2026-04-14 09:12:01

Version 1713845

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/sparefoot_billable_entities/2026-04-14/1776143797'\n",
    "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
]

hive_path: s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776143797
id: 1713845
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: 1138
schema_scan_id: 161996390
updated: 2026-04-14 00:17:06

Schema Scans: 15

Last at 2026-04-17 14:17:27

Scan 162194053

duration: 0:00:14.463250

exit_message:

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

id: 162194053

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776453434",
        "key": "raw/sparefoot_billable_entities/2026-04-17/1776453434/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12887314830529235349,
        "service_name": "sparefoot",
        "span_id": 4889775541154738552,
        "trace_id": 12887314830529235349
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-17 14:17:27
success: True
trace_id: 12887314830529235349

Scan 162178338

duration: 0:00:11.702489

exit_message:

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

id: 162178338

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776435976",
        "key": "raw/sparefoot_billable_entities/2026-04-17/1776435976/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17287449376104942695,
        "service_name": "sparefoot",
        "span_id": 2276613514772273122,
        "trace_id": 17287449376104942695
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-17 09:26:23
success: True
trace_id: 17287449376104942695

Scan 162163654

duration: 0:00:11.703759

exit_message:

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

id: 162163654

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-17/1776402938",
        "key": "raw/sparefoot_billable_entities/2026-04-17/1776402938/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 17047612416399217428,
        "service_name": "sparefoot",
        "span_id": 1339505498251640239,
        "trace_id": 17047612416399217428
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-17 00:15:41
success: True
trace_id: 17047612416399217428

Scan 162156250

duration: 0:00:14.530022

exit_message:

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

id: 162156250

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776389987",
        "key": "raw/sparefoot_billable_entities/2026-04-16/1776389987/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8947473816271740745,
        "service_name": "sparefoot",
        "span_id": 5457043377688432083,
        "trace_id": 8947473816271740745
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-16 20:39:58
success: True
trace_id: 8947473816271740745

Scan 162138141

duration: 0:00:11.938868

exit_message:

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

id: 162138141

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776367192",
        "key": "raw/sparefoot_billable_entities/2026-04-16/1776367192/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3283565242610819195,
        "service_name": "sparefoot",
        "span_id": 3505978424999662687,
        "trace_id": 3283565242610819195
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-16 14:20:31
success: True
trace_id: 3283565242610819195

Scan 162122889

duration: 0:00:11.835508

exit_message:

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

id: 162122889

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776350474",
        "key": "raw/sparefoot_billable_entities/2026-04-16/1776350474/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 6581405686093068793,
        "service_name": "sparefoot",
        "span_id": 4772995460988410614,
        "trace_id": 6581405686093068793
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-16 09:41:34
success: True
trace_id: 6581405686093068793

Scan 162107829

duration: 0:00:11.869108

exit_message:

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

id: 162107829

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-16/1776316751",
        "key": "raw/sparefoot_billable_entities/2026-04-16/1776316751/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3416432368503038493,
        "service_name": "sparefoot",
        "span_id": 9411690462017519674,
        "trace_id": 3416432368503038493
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-16 00:19:20
success: True
trace_id: 3416432368503038493

Scan 162100367

duration: 0:00:14.301277

exit_message:

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

id: 162100367

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776302972",
        "key": "raw/sparefoot_billable_entities/2026-04-15/1776302972/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4799371249461453867,
        "service_name": "sparefoot",
        "span_id": 8636141599145686115,
        "trace_id": 4799371249461453867
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-15 20:29:35
success: True
trace_id: 4799371249461453867

Scan 162081814

duration: 0:00:11.937191

exit_message:

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

id: 162081814

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776280840",
        "key": "raw/sparefoot_billable_entities/2026-04-15/1776280840/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5006488986137524649,
        "service_name": "sparefoot",
        "span_id": 10304250406634356354,
        "trace_id": 5006488986137524649
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-15 14:20:53
success: True
trace_id: 5006488986137524649

Scan 162064568

duration: 0:00:14.336754

exit_message:

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

id: 162064568

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776260622",
        "key": "raw/sparefoot_billable_entities/2026-04-15/1776260622/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4149874957531293858,
        "service_name": "sparefoot",
        "span_id": 3140258910513445182,
        "trace_id": 4149874957531293858
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-15 08:45:17
success: True
trace_id: 4149874957531293858

Scan 162052019

duration: 0:00:11.955903

exit_message:

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

id: 162052019

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-15/1776230654",
        "key": "raw/sparefoot_billable_entities/2026-04-15/1776230654/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 7077255875983209373,
        "service_name": "sparefoot",
        "span_id": 13018275629511292287,
        "trace_id": 7077255875983209373
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-15 00:24:16
success: True
trace_id: 7077255875983209373

Scan 162044346

duration: 0:00:14.545367

exit_message:

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

id: 162044346

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776216416",
        "key": "raw/sparefoot_billable_entities/2026-04-14/1776216416/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 12996186944698896132,
        "service_name": "sparefoot",
        "span_id": 207825133986552856,
        "trace_id": 12996186944698896132
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-14 20:26:59
success: True
trace_id: 12996186944698896132

Scan 162026171

duration: 0:01:15.665200

exit_message:

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

id: 162026171

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776194217",
        "key": "raw/sparefoot_billable_entities/2026-04-14/1776194217/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5917896755585360231,
        "service_name": "sparefoot",
        "span_id": 8795823014176152016,
        "trace_id": 5917896755585360231
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-14 14:18:18
success: True
trace_id: 5917896755585360231

Scan 162010973

duration: 0:00:11.817790

exit_message:

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

id: 162010973

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776175867",
        "key": "raw/sparefoot_billable_entities/2026-04-14/1776175867/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5211953044875489407,
        "service_name": "sparefoot",
        "span_id": 3857082739844498485,
        "trace_id": 5211953044875489407
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-14 09:11:49
success: True
trace_id: 5211953044875489407

Scan 161996390

duration: 0:00:11.780821

exit_message:

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

id: 161996390

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-prod",
        "hive_path": "s3://sfdl-rds-sparefoot-prod/raw/sparefoot_billable_entities/2026-04-14/1776143797",
        "key": "raw/sparefoot_billable_entities/2026-04-14/1776143797/billable_entities.parquet.gz"
    },
    "schema": {
        "name": "sfdl_prod_rds.sparefoot_sparefoot_billable_entities",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16396439055239944067,
        "service_name": "sparefoot",
        "span_id": 7959759691147332529,
        "trace_id": 16396439055239944067
    }
}

running: False
schema_name_id: 1138
start_time: 2026-04-14 00:16:54
success: True
trace_id: 16396439055239944067

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 14:17:28

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_billable_entities/2026-04-17/1776453434'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-08-18 17:25:56",
        "disabled": false,
        "format": "raw",
        "id": 1138,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_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 14:17:28",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_rds.sparefoot_sparefoot_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-prod/raw/sparefoot_billable_entities/2026-04-17/1776453434'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_rds.sparefoot_sparefoot_billable_entities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_rds.sparefoot_sparefoot_billable_entities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}