Schema Info

Schema Name: sfdl_stage_redshift.analytics_dwh_fact_billable_instance

created: 2018-02-20 23:58:07
disabled: False
format: raw
id: 386
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_redshift",
    "table": "analytics_dwh_fact_billable_instance"
}

type: redshift

Schema Versions: 15

Version 906618

created: 2026-04-17 03:37:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-17/1776415005'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-17/1776415005
id: 906618
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6415198
updated: 2026-04-17 03:37:37

Version 906415

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-16/1776329954'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-16/1776329954
id: 906415
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6414665
updated: 2026-04-16 04:00:21

Version 906198

created: 2026-04-15 03:46:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-15/1776242749'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-15/1776242749
id: 906198
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6414174
updated: 2026-04-15 03:46:41

Version 905976

created: 2026-04-14 03:43:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-14/1776156186'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-14/1776156186
id: 905976
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6413662
updated: 2026-04-14 03:44:05

Version 905768

created: 2026-04-13 03:33:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-13/1776069148'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-13/1776069148
id: 905768
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6413124
updated: 2026-04-13 03:33:18

Version 905570

created: 2026-04-12 03:40:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-12/1775983166'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-12/1775983166
id: 905570
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6412733
updated: 2026-04-12 03:40:30

Version 905372

created: 2026-04-11 03:44:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-11/1775897017'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-11/1775897017
id: 905372
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6412357
updated: 2026-04-11 03:44:33

Version 905155

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-10/1775810465'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-10/1775810465
id: 905155
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6411860
updated: 2026-04-10 03:42:26

Version 904952

created: 2026-04-09 04:00:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-09/1775725169'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-09/1775725169
id: 904952
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6411355
updated: 2026-04-09 04:00:33

Version 904748

created: 2026-04-08 04:01:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-08/1775638846'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-08/1775638846
id: 904748
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6410871
updated: 2026-04-08 04:01:47

Version 904489

created: 2026-04-07 03:33:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-07/1775550728'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-07/1775550728
id: 904489
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6410312
updated: 2026-04-07 03:33:18

Version 904287

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-06/1775465110'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-06/1775465110
id: 904287
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6409781
updated: 2026-04-06 03:46:05

Version 904083

created: 2026-04-05 03:27:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-05/1775377592'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-05/1775377592
id: 904083
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6409390
updated: 2026-04-05 03:27:34

Version 903890

created: 2026-04-04 03:24:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-04/1775291023'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-04/1775291023
id: 903890
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6409019
updated: 2026-04-04 03:24:35

Version 903706

created: 2026-04-03 03:59:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-03/1775206747'\n",
    "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
]

hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-03/1775206747
id: 903706
processed: 1

raw_data:

{
    "_origin": "14",
    "amount_collected": "9",
    "audit_id": "0",
    "billable_instance_key": "1",
    "booking_billable_instance_num": "12",
    "facility_billable_instance_num": "13",
    "facility_key": "5",
    "invoice_id": "4",
    "item": "6",
    "reason": "8",
    "reservation_key": "2",
    "residual_percent": "10",
    "sparefoot_charge": "11",
    "statement_key": "3",
    "unit_price": "7"
}

schema_attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

schema_name_id: 386
schema_scan_id: 6408560
updated: 2026-04-03 03:59:58

Schema Scans: 15

Last at 2026-04-17 03:37:25

Scan 6415198

duration: 0:00:11.899221

exit_message:

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

id: 6415198

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-17/1776415005/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-17/1776415005",
        "key": "raw/dwh_fact_billable_instance/2026-04-17/1776415005/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1493381327593238798,
        "service_name": "redshift_unloads",
        "span_id": 14841766961631338695,
        "trace_id": 3312210674346048871
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-17 03:37:25
success: True
trace_id: 3312210674346048871

Scan 6414665

duration: 0:00:14.610167

exit_message:

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

id: 6414665

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-16/1776329954/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-16/1776329954",
        "key": "raw/dwh_fact_billable_instance/2026-04-16/1776329954/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7755020865277032984,
        "service_name": "redshift_unloads",
        "span_id": 3012452402696768997,
        "trace_id": 3814886059430070439
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-16 04:00:06
success: True
trace_id: 3814886059430070439

Scan 6414174

duration: 0:00:11.988657

exit_message:

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

id: 6414174

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-15/1776242749/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-15/1776242749",
        "key": "raw/dwh_fact_billable_instance/2026-04-15/1776242749/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 10014095339579157943,
        "service_name": "redshift_unloads",
        "span_id": 10000310231217907573,
        "trace_id": 5891243706815640144
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-15 03:46:29
success: True
trace_id: 5891243706815640144

Scan 6413662

duration: 0:00:14.878211

exit_message:

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

id: 6413662

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-14/1776156186/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-14/1776156186",
        "key": "raw/dwh_fact_billable_instance/2026-04-14/1776156186/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 5295023387648032773,
        "service_name": "redshift_unloads",
        "span_id": 15008179166123562520,
        "trace_id": 14954350359405958832
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-14 03:43:51
success: True
trace_id: 14954350359405958832

Scan 6413124

duration: 0:00:11.999654

exit_message:

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

id: 6413124

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-13/1776069148/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-13/1776069148",
        "key": "raw/dwh_fact_billable_instance/2026-04-13/1776069148/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11362594315330537406,
        "service_name": "redshift_unloads",
        "span_id": 11232632031011539226,
        "trace_id": 6936632910466852739
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-13 03:33:06
success: True
trace_id: 6936632910466852739

Scan 6412733

duration: 0:00:12.019342

exit_message:

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

id: 6412733

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-12/1775983166/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-12/1775983166",
        "key": "raw/dwh_fact_billable_instance/2026-04-12/1775983166/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 7375131041422624704,
        "service_name": "redshift_unloads",
        "span_id": 9894522134747940355,
        "trace_id": 3724132741358749424
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-12 03:40:18
success: True
trace_id: 3724132741358749424

Scan 6412357

duration: 0:00:12.014035

exit_message:

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

id: 6412357

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-11/1775897017/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-11/1775897017",
        "key": "raw/dwh_fact_billable_instance/2026-04-11/1775897017/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 14223964418856745123,
        "service_name": "redshift_unloads",
        "span_id": 16737544438946857395,
        "trace_id": 5411715681116108100
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-11 03:44:21
success: True
trace_id: 5411715681116108100

Scan 6411860

duration: 0:00:12.070752

exit_message:

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

id: 6411860

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-10/1775810465/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-10/1775810465",
        "key": "raw/dwh_fact_billable_instance/2026-04-10/1775810465/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 11859123707720258478,
        "service_name": "redshift_unloads",
        "span_id": 6622267043473895715,
        "trace_id": 2354139301868397703
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-10 03:42:14
success: True
trace_id: 2354139301868397703

Scan 6411355

duration: 0:00:14.451917

exit_message:

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

id: 6411355

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-09/1775725169/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-09/1775725169",
        "key": "raw/dwh_fact_billable_instance/2026-04-09/1775725169/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 9627228985550396973,
        "service_name": "redshift_unloads",
        "span_id": 8812535934711384129,
        "trace_id": 12788162543570276309
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-09 04:00:19
success: True
trace_id: 12788162543570276309

Scan 6410871

duration: 0:00:14.411328

exit_message:

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

id: 6410871

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-08/1775638846/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-08/1775638846",
        "key": "raw/dwh_fact_billable_instance/2026-04-08/1775638846/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2645729508768350403,
        "service_name": "redshift_unloads",
        "span_id": 3995012834872566378,
        "trace_id": 4301773849555898001
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-08 04:01:33
success: True
trace_id: 4301773849555898001

Scan 6410312

duration: 0:00:14.452041

exit_message:

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

id: 6410312

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-07/1775550728/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-07/1775550728",
        "key": "raw/dwh_fact_billable_instance/2026-04-07/1775550728/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 2038503781700180659,
        "service_name": "redshift_unloads",
        "span_id": 16301644425804654141,
        "trace_id": 5783672443131191425
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-07 03:33:03
success: True
trace_id: 5783672443131191425

Scan 6409781

duration: 0:00:11.972191

exit_message:

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

id: 6409781

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-06/1775465110/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-06/1775465110",
        "key": "raw/dwh_fact_billable_instance/2026-04-06/1775465110/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 15905000122239169207,
        "service_name": "redshift_unloads",
        "span_id": 18333735033443930268,
        "trace_id": 6137693610813961844
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-06 03:45:54
success: True
trace_id: 6137693610813961844

Scan 6409390

duration: 0:00:11.910127

exit_message:

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

id: 6409390

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-05/1775377592/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-05/1775377592",
        "key": "raw/dwh_fact_billable_instance/2026-04-05/1775377592/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 3044705312455530673,
        "service_name": "redshift_unloads",
        "span_id": 15108887532928711168,
        "trace_id": 18193048338111582680
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-05 03:27:22
success: True
trace_id: 18193048338111582680

Scan 6409019

duration: 0:00:14.690891

exit_message:

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

id: 6409019

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-04/1775291023/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-04/1775291023",
        "key": "raw/dwh_fact_billable_instance/2026-04-04/1775291023/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 1194560344399669580,
        "service_name": "redshift_unloads",
        "span_id": 10185528329046348586,
        "trace_id": 4938885507450619606
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-04 03:24:20
success: True
trace_id: 4938885507450619606

Scan 6408560

duration: 0:00:14.448356

exit_message:

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

id: 6408560

payload:

{
    "datatype_dict": {
        "amount_collected": "decimal(6,2)",
        "audit_id": "bigint",
        "billable_instance_key": "int",
        "booking_billable_instance_num": "int",
        "facility_billable_instance_num": "int",
        "facility_key": "int",
        "invoice_id": "int",
        "item": "varchar(128)",
        "origin_key": "varchar",
        "reason": "varchar(32)",
        "reservation_key": "varchar(32)",
        "residual_percent": "decimal(3,2)",
        "sparefoot_charge": "decimal(6,2)",
        "statement_key": "int",
        "unit_price": "decimal(6,2)"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": false,
        "header_s3_object": {
            "bucket": "sfdl-redshift-analytics-stage",
            "key": "meta/dwh_fact_billable_instance/2026-04-03/1775206747/header.json"
        },
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-redshift-analytics-stage",
        "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-03/1775206747",
        "key": "raw/dwh_fact_billable_instance/2026-04-03/1775206747/0007_part_00.gz"
    },
    "schema": {
        "name": "sfdl_stage_redshift.analytics_dwh_fact_billable_instance",
        "type": "redshift"
    },
    "trace_context": {
        "parent_id": 8231043707246162783,
        "service_name": "redshift_unloads",
        "span_id": 13415983576979754052,
        "trace_id": 15961210486967166935
    }
}

running: False
schema_name_id: 386
start_time: 2026-04-03 03:59:44
success: True
trace_id: 15961210486967166935

Partitions:

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

Schema:

attributes:

{
    "_origin": "string",
    "amount_collected": "decimal(6,2)",
    "audit_id": "bigint",
    "billable_instance_key": "int",
    "booking_billable_instance_num": "int",
    "facility_billable_instance_num": "int",
    "facility_key": "int",
    "invoice_id": "int",
    "item": "varchar(128)",
    "reason": "varchar(32)",
    "reservation_key": "varchar(32)",
    "residual_percent": "decimal(3,2)",
    "sparefoot_charge": "decimal(6,2)",
    "statement_key": "int",
    "unit_price": "decimal(6,2)"
}

created: 2026-04-17 03:37:26

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-17/1776415005'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2018-02-20 23:58:07",
        "disabled": false,
        "format": "raw",
        "id": 386,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_redshift",
            "table": "analytics_dwh_fact_billable_instance"
        },
        "type": "redshift"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "amount_collected": "decimal(6,2)",
            "audit_id": "bigint",
            "billable_instance_key": "int",
            "booking_billable_instance_num": "int",
            "facility_billable_instance_num": "int",
            "facility_key": "int",
            "invoice_id": "int",
            "item": "varchar(128)",
            "reason": "varchar(32)",
            "reservation_key": "varchar(32)",
            "residual_percent": "decimal(3,2)",
            "sparefoot_charge": "decimal(6,2)",
            "statement_key": "int",
            "unit_price": "decimal(6,2)"
        },
        "created": "2026-04-17 03:37:26",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_fact_billable_instance`\n(\n `audit_id`  bigint , `billable_instance_key`  int , `reservation_key`  varchar(32) , `statement_key`  int , `invoice_id`  int , `facility_key`  int , `item`  varchar(128) , `unit_price`  decimal(6,2) , `reason`  varchar(32) , `amount_collected`  decimal(6,2) , `residual_percent`  decimal(3,2) , `sparefoot_charge`  decimal(6,2) , `booking_billable_instance_num`  int , `facility_billable_instance_num`  int , `_origin`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-redshift-analytics-stage/raw/dwh_fact_billable_instance/2026-04-17/1776415005'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_fact_billable_instance`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_fact_billable_instance"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}