Schema Info
Schema Name: sfdl_stage_redshift.analytics_bi_bidding_report
- created: 2019-01-14 13:27:30
- disabled: False
- format: raw
- id: 694
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_bi_bidding_report" } - type: redshift
Schema Versions: 15
-
Version 906604
- created: 2026-04-17 03:14:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-17/1776413655'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-17/1776413655
- id: 906604
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6415181
- updated: 2026-04-17 03:14:35
-
Version 906394
- created: 2026-04-16 03:54:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-16/1776329635'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-16/1776329635
- id: 906394
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6414644
- updated: 2026-04-16 03:54:20
-
Version 906174
- created: 2026-04-15 03:24:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-15/1776241462'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-15/1776241462
- id: 906174
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6414146
- updated: 2026-04-15 03:24:53
-
Version 905961
- created: 2026-04-14 03:23:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-14/1776155024'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-14/1776155024
- id: 905961
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6413645
- updated: 2026-04-14 03:24:07
-
Version 905754
- created: 2026-04-13 03:26:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-13/1776068763'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-13/1776068763
- id: 905754
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6413109
- updated: 2026-04-13 03:26:23
-
Version 905544
- created: 2026-04-12 03:19:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-12/1775981949'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-12/1775981949
- id: 905544
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6412704
- updated: 2026-04-12 03:21:22
-
Version 905341
- created: 2026-04-11 03:14:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-11/1775895250'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-11/1775895250
- id: 905341
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6412324
- updated: 2026-04-11 03:17:28
-
Version 905127
- created: 2026-04-10 03:11:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-10/1775808680'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-10/1775808680
- id: 905127
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6411828
- updated: 2026-04-10 03:11:55
-
Version 904913
- created: 2026-04-09 03:15:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-09/1775722512'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-09/1775722512
- id: 904913
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6411311
- updated: 2026-04-09 03:15:58
-
Version 904719
- created: 2026-04-08 03:39:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-08/1775637535'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-08/1775637535
- id: 904719
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6410840
- updated: 2026-04-08 03:39:25
-
Version 904485
- created: 2026-04-07 03:22:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-07/1775550133'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-07/1775550133
- id: 904485
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6410308
- updated: 2026-04-07 03:22:43
-
Version 904272
- created: 2026-04-06 03:27:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-06/1775464029'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-06/1775464029
- id: 904272
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6409764
- updated: 2026-04-06 03:27:51
-
Version 904070
- created: 2026-04-05 03:19:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-05/1775377127'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-05/1775377127
- id: 904070
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6409373
- updated: 2026-04-05 03:19:33
-
Version 903919
- created: 2026-04-04 03:53:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-04/1775292822'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-04/1775292822
- id: 903919
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6409048
- updated: 2026-04-04 03:54:07
-
Version 903654
- created: 2026-04-03 03:21:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-03/1775204466'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-03/1775204466
- id: 903654
- processed: 1
- raw_data:
{ "_origin": "30", "account_id": "3", "avg_large_unit_price": "23", "avg_medium_unit_price": "22", "avg_small_unit_price": "21", "bid_flat": "13", "bid_percent": "14", "bid_type": "12", "city": "9", "city_avg_large_price": "29", "city_avg_medium_price": "28", "city_avg_small_price": "27", "company_code": "7", "corp_name": "5", "corporate_key": "4", "facility_count_in_city": "17", "facility_count_in_zip": "16", "facility_key": "1", "facility_name": "6", "integration": "8", "location_key": "2", "minimum_bid": "15", "move_in_rate": "19", "reporting_date": "0", "state": "10", "submit_rate": "20", "unit_groups_available": "18", "zip": "11", "zip_avg_large_price": "26", "zip_avg_medium_price": "25", "zip_avg_small_price": "24" } - schema_attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - schema_name_id: 694
- schema_scan_id: 6408503
- updated: 2026-04-03 03:21:38
Schema Scans: 15
Last at 2026-04-17 03:14:22
-
Scan 6415181
- duration: 0:00:12.480130
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415181
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-17/1776413655/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-17/1776413655", "key": "raw/bi_bidding_report/2026-04-17/1776413655/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-17 03:14:22
- success: True
- trace_id: 3720465497234921800
-
Scan 6414644
- duration: 0:00:12.459205
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414644
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-16/1776329635/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-16/1776329635", "key": "raw/bi_bidding_report/2026-04-16/1776329635/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-16 03:54:07
- success: True
- trace_id: 3641744546927269573
-
Scan 6414146
- duration: 0:00:12.353187
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414146
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-15/1776241462/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-15/1776241462", "key": "raw/bi_bidding_report/2026-04-15/1776241462/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-15 03:24:41
- success: True
- trace_id: 7655087024135930134
-
Scan 6413645
- duration: 0:00:12.435697
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413645
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-14/1776155024/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-14/1776155024", "key": "raw/bi_bidding_report/2026-04-14/1776155024/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-14 03:23:55
- success: True
- trace_id: 8696661921287734208
-
Scan 6413109
- duration: 0:00:12.254244
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413109
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-13/1776068763/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-13/1776068763", "key": "raw/bi_bidding_report/2026-04-13/1776068763/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-13 03:26:11
- success: True
- trace_id: 1883718893638926636
-
Scan 6412704
- duration: 0:01:46.689122
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412704
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-12/1775981949/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-12/1775981949", "key": "raw/bi_bidding_report/2026-04-12/1775981949/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-12 03:19:35
- success: True
- trace_id: 3789808817516863035
-
Scan 6412324
- duration: 0:03:00.380077
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412324
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-11/1775895250/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-11/1775895250", "key": "raw/bi_bidding_report/2026-04-11/1775895250/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-11 03:14:28
- success: True
- trace_id: 3618533371830539006
-
Scan 6411828
- duration: 0:00:14.987538
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411828
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-10/1775808680/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-10/1775808680", "key": "raw/bi_bidding_report/2026-04-10/1775808680/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-10 03:11:40
- success: True
- trace_id: 9541337403272053956
-
Scan 6411311
- duration: 0:00:14.928537
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411311
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-09/1775722512/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-09/1775722512", "key": "raw/bi_bidding_report/2026-04-09/1775722512/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-09 03:15:43
- success: True
- trace_id: 13334372632220037584
-
Scan 6410840
- duration: 0:00:15.072351
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410840
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-08/1775637535/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-08/1775637535", "key": "raw/bi_bidding_report/2026-04-08/1775637535/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-08 03:39:10
- success: True
- trace_id: 1849722726672920627
-
Scan 6410308
- duration: 0:00:14.957714
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410308
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-07/1775550133/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-07/1775550133", "key": "raw/bi_bidding_report/2026-04-07/1775550133/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-07 03:22:28
- success: True
- trace_id: 14324126607420801334
-
Scan 6409764
- duration: 0:00:15.002851
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409764
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-06/1775464029/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-06/1775464029", "key": "raw/bi_bidding_report/2026-04-06/1775464029/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-06 03:27:36
- success: True
- trace_id: 2072909248129445743
-
Scan 6409373
- duration: 0:00:15.156745
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409373
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-05/1775377127/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-05/1775377127", "key": "raw/bi_bidding_report/2026-04-05/1775377127/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-05 03:19:18
- success: True
- trace_id: 6814620958848259705
-
Scan 6409048
- duration: 0:00:12.427244
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409048
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-04/1775292822/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-04/1775292822", "key": "raw/bi_bidding_report/2026-04-04/1775292822/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-04 03:53:55
- success: True
- trace_id: 12929868076113558770
-
Scan 6408503
- duration: 0:00:14.914745
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408503
- payload:
{ "datatype_dict": { "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "origin_key": "varchar", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_bidding_report/2026-04-03/1775204466/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_bidding_report/2026-04-03/1775204466", "key": "raw/bi_bidding_report/2026-04-03/1775204466/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 694
- start_time: 2026-04-03 03:21:23
- success: True
- trace_id: 4760195991152933631
- attributes:
{ "_origin": "string", "account_id": "bigint", "avg_large_unit_price": "decimal(6,2)", "avg_medium_unit_price": "decimal(6,2)", "avg_small_unit_price": "decimal(6,2)", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "bid_type": "varchar(10)", "city": "varchar(100)", "city_avg_large_price": "decimal(6,2)", "city_avg_medium_price": "decimal(6,2)", "city_avg_small_price": "decimal(6,2)", "company_code": "varchar(128)", "corp_name": "varchar(255)", "corporate_key": "bigint", "facility_count_in_city": "bigint", "facility_count_in_zip": "bigint", "facility_key": "int", "facility_name": "varchar(255)", "integration": "varchar(100)", "location_key": "int", "minimum_bid": "decimal(6,2)", "move_in_rate": "double", "reporting_date": "date", "state": "varchar(2)", "submit_rate": "double", "unit_groups_available": "bigint", "zip": "varchar(6)", "zip_avg_large_price": "decimal(6,2)", "zip_avg_medium_price": "decimal(6,2)", "zip_avg_small_price": "decimal(6,2)" } - created: 2026-04-17 03:14:23
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-17/1776413655'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-01-14 13:27:30",
"disabled": false,
"format": "raw",
"id": 694,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_bi_bidding_report"
},
"type": "redshift"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"_origin": "string",
"account_id": "bigint",
"avg_large_unit_price": "decimal(6,2)",
"avg_medium_unit_price": "decimal(6,2)",
"avg_small_unit_price": "decimal(6,2)",
"bid_flat": "decimal(6,2)",
"bid_percent": "decimal(6,2)",
"bid_type": "varchar(10)",
"city": "varchar(100)",
"city_avg_large_price": "decimal(6,2)",
"city_avg_medium_price": "decimal(6,2)",
"city_avg_small_price": "decimal(6,2)",
"company_code": "varchar(128)",
"corp_name": "varchar(255)",
"corporate_key": "bigint",
"facility_count_in_city": "bigint",
"facility_count_in_zip": "bigint",
"facility_key": "int",
"facility_name": "varchar(255)",
"integration": "varchar(100)",
"location_key": "int",
"minimum_bid": "decimal(6,2)",
"move_in_rate": "double",
"reporting_date": "date",
"state": "varchar(2)",
"submit_rate": "double",
"unit_groups_available": "bigint",
"zip": "varchar(6)",
"zip_avg_large_price": "decimal(6,2)",
"zip_avg_medium_price": "decimal(6,2)",
"zip_avg_small_price": "decimal(6,2)"
},
"created": "2026-04-17 03:14:23",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_bidding_report`\n(\n `reporting_date` date , `facility_key` int , `location_key` int , `account_id` bigint , `corporate_key` bigint , `corp_name` varchar(255) , `facility_name` varchar(255) , `company_code` varchar(128) , `integration` varchar(100) , `city` varchar(100) , `state` varchar(2) , `zip` varchar(6) , `bid_type` varchar(10) , `bid_flat` decimal(6,2) , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `facility_count_in_zip` bigint , `facility_count_in_city` bigint , `unit_groups_available` bigint , `move_in_rate` double , `submit_rate` double , `avg_small_unit_price` decimal(6,2) , `avg_medium_unit_price` decimal(6,2) , `avg_large_unit_price` decimal(6,2) , `zip_avg_small_price` decimal(6,2) , `zip_avg_medium_price` decimal(6,2) , `zip_avg_large_price` decimal(6,2) , `city_avg_small_price` decimal(6,2) , `city_avg_medium_price` decimal(6,2) , `city_avg_large_price` decimal(6,2) , `_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/bi_bidding_report/2026-04-17/1776413655'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_bidding_report`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_bidding_report"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}