Schema Info
Schema Name: sfdl_prod_redshift.analytics_bi_bidding_report
- created: 2019-01-14 16:14:54
- disabled: False
- format: raw
- id: 613
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_redshift", "table": "analytics_bi_bidding_report" } - type: redshift
Schema Versions: 15
-
Version 1717834
- created: 2026-04-17 03:14:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-17/1776413490'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-17/1776413490
- id: 1717834
- 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: 613
- schema_scan_id: 162167871
- updated: 2026-04-17 03:14:16
-
Version 1716599
- created: 2026-04-16 03:15:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-16/1776327289'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-16/1776327289
- id: 1716599
- 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: 613
- schema_scan_id: 162112069
- updated: 2026-04-16 03:15:37
-
Version 1715439
- created: 2026-04-15 03:36:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-15/1776242165'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-15/1776242165
- id: 1715439
- 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: 613
- schema_scan_id: 162056302
- updated: 2026-04-15 03:36:39
-
Version 1714241
- created: 2026-04-14 03:38:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-14/1776155921'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-14/1776155921
- id: 1714241
- 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: 613
- schema_scan_id: 162000808
- updated: 2026-04-14 03:39:10
-
Version 1712982
- created: 2026-04-13 03:22:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-13/1776068555'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-13/1776068555
- id: 1712982
- 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: 613
- schema_scan_id: 161942891
- updated: 2026-04-13 03:22:56
-
Version 1711785
- created: 2026-04-12 03:15:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-12/1775981710'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-12/1775981710
- id: 1711785
- 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: 613
- schema_scan_id: 161893523
- updated: 2026-04-12 03:15:54
-
Version 1710521
- created: 2026-04-11 03:09:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-11/1775894876'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-11/1775894876
- id: 1710521
- 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: 613
- schema_scan_id: 161841315
- updated: 2026-04-11 03:09:25
-
Version 1709426
- created: 2026-04-10 03:16:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-10/1775808945'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-10/1775808945
- id: 1709426
- 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: 613
- schema_scan_id: 161786145
- updated: 2026-04-10 03:16:21
-
Version 1708287
- created: 2026-04-09 03:15:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-09/1775722506'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-09/1775722506
- id: 1708287
- 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: 613
- schema_scan_id: 161730589
- updated: 2026-04-09 03:15:36
-
Version 1707120
- created: 2026-04-08 03:42:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-08/1775637754'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-08/1775637754
- id: 1707120
- 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: 613
- schema_scan_id: 161675835
- updated: 2026-04-08 03:43:02
-
Version 1705907
- created: 2026-04-07 03:30:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-07/1775550604'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-07/1775550604
- id: 1705907
- 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: 613
- schema_scan_id: 161619672
- updated: 2026-04-07 03:30:26
-
Version 1704669
- created: 2026-04-06 03:15:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-06/1775463321'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-06/1775463321
- id: 1704669
- 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: 613
- schema_scan_id: 161561833
- updated: 2026-04-06 03:15:45
-
Version 1703463
- created: 2026-04-05 03:21:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-05/1775377280'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-05/1775377280
- id: 1703463
- 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: 613
- schema_scan_id: 161515067
- updated: 2026-04-05 03:21:52
-
Version 1702349
- created: 2026-04-04 03:39:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-04/1775291980'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-04/1775291980
- id: 1702349
- 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: 613
- schema_scan_id: 161460726
- updated: 2026-04-04 03:40:02
-
Version 1701108
- created: 2026-04-03 03:27:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-03/1775204817'\n", "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" ] - hive_path: s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-03/1775204817
- id: 1701108
- 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: 613
- schema_scan_id: 161402125
- updated: 2026-04-03 03:27:19
Schema Scans: 15
Last at 2026-04-17 03:14:01
-
Scan 162167871
- duration: 0:00:14.935574
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167871
- 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-prod", "key": "meta/bi_bidding_report/2026-04-17/1776413490/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-17/1776413490", "key": "raw/bi_bidding_report/2026-04-17/1776413490/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-17 03:14:01
- success: True
- trace_id: 7012092257472632947
-
Scan 162112069
- duration: 0:00:12.297115
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112069
- 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-prod", "key": "meta/bi_bidding_report/2026-04-16/1776327289/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-16/1776327289", "key": "raw/bi_bidding_report/2026-04-16/1776327289/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-16 03:15:25
- success: True
- trace_id: 14205073495350472313
-
Scan 162056302
- duration: 0:00:12.280597
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056302
- 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-prod", "key": "meta/bi_bidding_report/2026-04-15/1776242165/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-15/1776242165", "key": "raw/bi_bidding_report/2026-04-15/1776242165/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-15 03:36:27
- success: True
- trace_id: 10542750896601235476
-
Scan 162000808
- duration: 0:00:15.067342
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000808
- 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-prod", "key": "meta/bi_bidding_report/2026-04-14/1776155921/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-14/1776155921", "key": "raw/bi_bidding_report/2026-04-14/1776155921/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-14 03:38:55
- success: True
- trace_id: 656147193419719492
-
Scan 161942891
- duration: 0:00:14.764189
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161942891
- 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-prod", "key": "meta/bi_bidding_report/2026-04-13/1776068555/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-13/1776068555", "key": "raw/bi_bidding_report/2026-04-13/1776068555/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-13 03:22:42
- success: True
- trace_id: 16766392218548374415
-
Scan 161893523
- duration: 0:00:14.832965
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161893523
- 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-prod", "key": "meta/bi_bidding_report/2026-04-12/1775981710/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-12/1775981710", "key": "raw/bi_bidding_report/2026-04-12/1775981710/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-12 03:15:39
- success: True
- trace_id: 5018700384698610808
-
Scan 161841315
- duration: 0:00:14.901986
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841315
- 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-prod", "key": "meta/bi_bidding_report/2026-04-11/1775894876/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-11/1775894876", "key": "raw/bi_bidding_report/2026-04-11/1775894876/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-11 03:09:10
- success: True
- trace_id: 9964306983473282003
-
Scan 161786145
- duration: 0:00:14.897646
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161786145
- 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-prod", "key": "meta/bi_bidding_report/2026-04-10/1775808945/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-10/1775808945", "key": "raw/bi_bidding_report/2026-04-10/1775808945/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-10 03:16:06
- success: True
- trace_id: 1923684240034241672
-
Scan 161730589
- duration: 0:00:15.035011
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730589
- 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-prod", "key": "meta/bi_bidding_report/2026-04-09/1775722506/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-09/1775722506", "key": "raw/bi_bidding_report/2026-04-09/1775722506/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-09 03:15:21
- success: True
- trace_id: 4353674238603139106
-
Scan 161675835
- duration: 0:00:14.893240
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675835
- 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-prod", "key": "meta/bi_bidding_report/2026-04-08/1775637754/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-08/1775637754", "key": "raw/bi_bidding_report/2026-04-08/1775637754/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-08 03:42:47
- success: True
- trace_id: 14540924894849646366
-
Scan 161619672
- duration: 0:00:14.876043
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161619672
- 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-prod", "key": "meta/bi_bidding_report/2026-04-07/1775550604/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-07/1775550604", "key": "raw/bi_bidding_report/2026-04-07/1775550604/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-07 03:30:11
- success: True
- trace_id: 8059044840124397306
-
Scan 161561833
- duration: 0:00:15.110912
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561833
- 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-prod", "key": "meta/bi_bidding_report/2026-04-06/1775463321/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-06/1775463321", "key": "raw/bi_bidding_report/2026-04-06/1775463321/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-06 03:15:30
- success: True
- trace_id: 2913368816107990922
-
Scan 161515067
- duration: 0:00:14.872202
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161515067
- 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-prod", "key": "meta/bi_bidding_report/2026-04-05/1775377280/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-05/1775377280", "key": "raw/bi_bidding_report/2026-04-05/1775377280/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-05 03:21:38
- success: True
- trace_id: 10749783583332346943
-
Scan 161460726
- duration: 0:00:14.743373
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460726
- 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-prod", "key": "meta/bi_bidding_report/2026-04-04/1775291980/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-04/1775291980", "key": "raw/bi_bidding_report/2026-04-04/1775291980/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-04 03:39:47
- success: True
- trace_id: 5980844118909860030
-
Scan 161402125
- duration: 0:00:15.008690
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402125
- 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-prod", "key": "meta/bi_bidding_report/2026-04-03/1775204817/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-prod", "hive_path": "s3://sfdl-redshift-analytics-prod/raw/bi_bidding_report/2026-04-03/1775204817", "key": "raw/bi_bidding_report/2026-04-03/1775204817/bidding_report.dat0000_part_00.gz" }, "schema": { "name": "sfdl_prod_redshift.analytics_bi_bidding_report", "type": "redshift" } } - running: False
- schema_name_id: 613
- start_time: 2026-04-03 03:27:04
- success: True
- trace_id: 17141246472725789303
- 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:02
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-17/1776413490'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2019-01-14 16:14:54",
"disabled": false,
"format": "raw",
"id": 613,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_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:02",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/bi_bidding_report/2026-04-17/1776413490'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_redshift.analytics_bi_bidding_report`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_redshift.analytics_bi_bidding_report"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}