Schema Info
Schema Name: sfdl_stage_redshift.analytics_dwh_dim_facility
- created: 2018-02-21 00:02:46
- disabled: False
- format: raw
- id: 400
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_dwh_dim_facility" } - type: redshift
Schema Versions: 15
-
Version 906657
- created: 2026-04-17 03:55:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-17/1776416137'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-17/1776416137
- id: 906657
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6415237
- updated: 2026-04-17 03:56:02
-
Version 906430
- created: 2026-04-16 04:01:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-16/1776330054'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-16/1776330054
- id: 906430
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6414680
- updated: 2026-04-16 04:01:22
-
Version 906218
- created: 2026-04-15 03:58:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-15/1776243508'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-15/1776243508
- id: 906218
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6414194
- updated: 2026-04-15 03:58:56
-
Version 906008
- created: 2026-04-14 03:56:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-14/1776156952'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-14/1776156952
- id: 906008
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6413694
- updated: 2026-04-14 03:56:17
-
Version 905751
- created: 2026-04-13 03:22:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-13/1776068500'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-13/1776068500
- id: 905751
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6413106
- updated: 2026-04-13 03:22:18
-
Version 905587
- created: 2026-04-12 04:02:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-12/1775984548'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-12/1775984548
- id: 905587
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6412751
- updated: 2026-04-12 04:03:02
-
Version 905359
- created: 2026-04-11 03:30:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-11/1775896216'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-11/1775896216
- id: 905359
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6412343
- updated: 2026-04-11 03:30:49
-
Version 905161
- created: 2026-04-10 03:55:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-10/1775811277'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-10/1775811277
- id: 905161
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6411866
- updated: 2026-04-10 03:55:21
-
Version 904926
- created: 2026-04-09 03:50:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-09/1775724583'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-09/1775724583
- id: 904926
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6411328
- updated: 2026-04-09 03:50:18
-
Version 904718
- created: 2026-04-08 03:39:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-08/1775637517'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-08/1775637517
- id: 904718
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6410839
- updated: 2026-04-08 03:39:14
-
Version 904534
- created: 2026-04-07 03:54:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-07/1775552024'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-07/1775552024
- id: 904534
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6410360
- updated: 2026-04-07 03:54:42
-
Version 904313
- created: 2026-04-06 03:56:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-06/1775465801'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-06/1775465801
- id: 904313
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6409807
- updated: 2026-04-06 03:57:07
-
Version 904114
- created: 2026-04-05 04:04:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-05/1775379877'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-05/1775379877
- id: 904114
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6409422
- updated: 2026-04-05 04:05:04
-
Version 903906
- created: 2026-04-04 03:43:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-04/1775292216'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-04/1775292216
- id: 903906
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6409035
- updated: 2026-04-04 03:44:05
-
Version 903691
- created: 2026-04-03 03:51:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-03/1775206260'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-03/1775206260
- id: 903691
- processed: 1
- raw_data:
{ "_24_hr_access": "22", "_origin": "31", "aaa_active": "12", "aaa_eligible": "13", "aaa_opt_in": "14", "admin_fee": "25", "audit_id": "0", "bid_flat": "30", "bid_percent": "7", "billable_entity_key": "11", "client_key": "3", "company_code": "10", "corporation_key": "28", "corporation_name": "29", "created_date": "9", "egate_access": "19", "elevator": "23", "facility_key": "1", "facility_name": "2", "fenced_lighted": "21", "free_truck_rental": "17", "handcarts": "24", "integration_key": "5", "is_directory": "6", "is_physical_facility": "15", "listing_type_key": "26", "location_key": "4", "minimum_bid": "8", "surveillance": "20", "truck_access": "18", "truck_rental": "16", "uplid_key": "27" } - schema_attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - schema_name_id: 400
- schema_scan_id: 6408545
- updated: 2026-04-03 03:51:28
Schema Scans: 15
Last at 2026-04-17 03:55:47
-
Scan 6415237
- duration: 0:00:15.151020
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415237
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-17/1776416137/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-17/1776416137", "key": "raw/dwh_dim_facility/2026-04-17/1776416137/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 829831012619607619, "service_name": "redshift_unloads", "span_id": 16579568634513758828, "trace_id": 7538515302940463081 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-17 03:55:47
- success: True
- trace_id: 7538515302940463081
-
Scan 6414680
- duration: 0:00:15.005653
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414680
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-16/1776330054/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-16/1776330054", "key": "raw/dwh_dim_facility/2026-04-16/1776330054/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 6016878297055550015, "service_name": "redshift_unloads", "span_id": 18045613674874221567, "trace_id": 548184945774551525 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-16 04:01:07
- success: True
- trace_id: 548184945774551525
-
Scan 6414194
- duration: 0:00:15.048295
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414194
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-15/1776243508/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-15/1776243508", "key": "raw/dwh_dim_facility/2026-04-15/1776243508/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 16944510224067610813, "service_name": "redshift_unloads", "span_id": 9045092727706522689, "trace_id": 9351200443322508890 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-15 03:58:41
- success: True
- trace_id: 9351200443322508890
-
Scan 6413694
- duration: 0:00:12.430427
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413694
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-14/1776156952/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-14/1776156952", "key": "raw/dwh_dim_facility/2026-04-14/1776156952/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 7560997101526464412, "service_name": "redshift_unloads", "span_id": 15344907786419684666, "trace_id": 3681744978733032463 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-14 03:56:05
- success: True
- trace_id: 3681744978733032463
-
Scan 6413106
- duration: 0:00:14.988592
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413106
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-13/1776068500/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-13/1776068500", "key": "raw/dwh_dim_facility/2026-04-13/1776068500/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 3992816182314763834, "service_name": "redshift_unloads", "span_id": 17859867189780522864, "trace_id": 12208434921739795993 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-13 03:22:04
- success: True
- trace_id: 12208434921739795993
-
Scan 6412751
- duration: 0:00:12.434427
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412751
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-12/1775984548/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-12/1775984548", "key": "raw/dwh_dim_facility/2026-04-12/1775984548/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 1718819531225758862, "service_name": "redshift_unloads", "span_id": 13610112212599422646, "trace_id": 862619832774912445 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-12 04:02:50
- success: True
- trace_id: 862619832774912445
-
Scan 6412343
- duration: 0:00:15.116686
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412343
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-11/1775896216/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-11/1775896216", "key": "raw/dwh_dim_facility/2026-04-11/1775896216/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 11687523075808717674, "service_name": "redshift_unloads", "span_id": 12766962154461239662, "trace_id": 2514615113389088494 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-11 03:30:34
- success: True
- trace_id: 2514615113389088494
-
Scan 6411866
- duration: 0:00:15.176084
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411866
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-10/1775811277/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-10/1775811277", "key": "raw/dwh_dim_facility/2026-04-10/1775811277/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 7390498104594910714, "service_name": "redshift_unloads", "span_id": 999694657999527709, "trace_id": 15511480651162094864 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-10 03:55:06
- success: True
- trace_id: 15511480651162094864
-
Scan 6411328
- duration: 0:00:15.035636
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411328
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-09/1775724583/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-09/1775724583", "key": "raw/dwh_dim_facility/2026-04-09/1775724583/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 17303483786026575390, "service_name": "redshift_unloads", "span_id": 8425946419348575281, "trace_id": 18185358871460714448 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-09 03:50:03
- success: True
- trace_id: 18185358871460714448
-
Scan 6410839
- duration: 0:00:12.452428
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410839
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-08/1775637517/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-08/1775637517", "key": "raw/dwh_dim_facility/2026-04-08/1775637517/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 18071038001110870869, "service_name": "redshift_unloads", "span_id": 16139180156188601237, "trace_id": 14122037648284879682 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-08 03:39:02
- success: True
- trace_id: 14122037648284879682
-
Scan 6410360
- duration: 0:00:14.977270
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410360
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-07/1775552024/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-07/1775552024", "key": "raw/dwh_dim_facility/2026-04-07/1775552024/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 3543059872092318092, "service_name": "redshift_unloads", "span_id": 4486984401669290015, "trace_id": 2969742802656993146 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-07 03:54:27
- success: True
- trace_id: 2969742802656993146
-
Scan 6409807
- duration: 0:00:12.408782
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409807
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-06/1775465801/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-06/1775465801", "key": "raw/dwh_dim_facility/2026-04-06/1775465801/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 12900030629076420253, "service_name": "redshift_unloads", "span_id": 9826203018568969509, "trace_id": 15645018993680421856 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-06 03:56:55
- success: True
- trace_id: 15645018993680421856
-
Scan 6409422
- duration: 0:00:14.999000
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409422
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-05/1775379877/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-05/1775379877", "key": "raw/dwh_dim_facility/2026-04-05/1775379877/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 11967315653141887516, "service_name": "redshift_unloads", "span_id": 4879225338662883081, "trace_id": 17960396051976799346 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-05 04:04:49
- success: True
- trace_id: 17960396051976799346
-
Scan 6409035
- duration: 0:00:15.059664
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409035
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-04/1775292216/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-04/1775292216", "key": "raw/dwh_dim_facility/2026-04-04/1775292216/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 4091299354702508483, "service_name": "redshift_unloads", "span_id": 10023941465061407976, "trace_id": 2801819254025231904 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-04 03:43:50
- success: True
- trace_id: 2801819254025231904
-
Scan 6408545
- duration: 0:00:14.947945
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408545
- payload:
{ "datatype_dict": { "_24_hr_access": "int", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "origin_key": "varchar", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/dwh_dim_facility/2026-04-03/1775206260/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/dwh_dim_facility/2026-04-03/1775206260", "key": "raw/dwh_dim_facility/2026-04-03/1775206260/0007_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_dwh_dim_facility", "type": "redshift" }, "trace_context": { "parent_id": 16676063634749987830, "service_name": "redshift_unloads", "span_id": 955859821114493734, "trace_id": 15734292888070106257 } } - running: False
- schema_name_id: 400
- start_time: 2026-04-03 03:51:13
- success: True
- trace_id: 15734292888070106257
- attributes:
{ "_24_hr_access": "int", "_origin": "string", "aaa_active": "int", "aaa_eligible": "int", "aaa_opt_in": "int", "admin_fee": "decimal", "audit_id": "bigint", "bid_flat": "decimal(6,2)", "bid_percent": "decimal(6,2)", "billable_entity_key": "int", "client_key": "bigint", "company_code": "varchar(128)", "corporation_key": "bigint", "corporation_name": "varchar(500)", "created_date": "date", "egate_access": "int", "elevator": "int", "facility_key": "int", "facility_name": "varchar(255)", "fenced_lighted": "int", "free_truck_rental": "int", "handcarts": "int", "integration_key": "int", "is_directory": "int", "is_physical_facility": "int", "listing_type_key": "int", "location_key": "int", "minimum_bid": "decimal(6,2)", "surveillance": "int", "truck_access": "int", "truck_rental": "int", "uplid_key": "int" } - created: 2026-04-17 03:55:48
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-17/1776416137'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2018-02-21 00:02:46",
"disabled": false,
"format": "raw",
"id": 400,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_dwh_dim_facility"
},
"type": "redshift"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"_24_hr_access": "int",
"_origin": "string",
"aaa_active": "int",
"aaa_eligible": "int",
"aaa_opt_in": "int",
"admin_fee": "decimal",
"audit_id": "bigint",
"bid_flat": "decimal(6,2)",
"bid_percent": "decimal(6,2)",
"billable_entity_key": "int",
"client_key": "bigint",
"company_code": "varchar(128)",
"corporation_key": "bigint",
"corporation_name": "varchar(500)",
"created_date": "date",
"egate_access": "int",
"elevator": "int",
"facility_key": "int",
"facility_name": "varchar(255)",
"fenced_lighted": "int",
"free_truck_rental": "int",
"handcarts": "int",
"integration_key": "int",
"is_directory": "int",
"is_physical_facility": "int",
"listing_type_key": "int",
"location_key": "int",
"minimum_bid": "decimal(6,2)",
"surveillance": "int",
"truck_access": "int",
"truck_rental": "int",
"uplid_key": "int"
},
"created": "2026-04-17 03:55:48",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_dwh_dim_facility`\n(\n `audit_id` bigint , `facility_key` int , `facility_name` varchar(255) , `client_key` bigint , `location_key` int , `integration_key` int , `is_directory` int , `bid_percent` decimal(6,2) , `minimum_bid` decimal(6,2) , `created_date` date , `company_code` varchar(128) , `billable_entity_key` int , `aaa_active` int , `aaa_eligible` int , `aaa_opt_in` int , `is_physical_facility` int , `truck_rental` int , `free_truck_rental` int , `truck_access` int , `egate_access` int , `surveillance` int , `fenced_lighted` int , `_24_hr_access` int , `elevator` int , `handcarts` int , `admin_fee` decimal , `listing_type_key` int , `uplid_key` int , `corporation_key` bigint , `corporation_name` varchar(500) , `bid_flat` 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/dwh_dim_facility/2026-04-17/1776416137'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_dwh_dim_facility`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_dwh_dim_facility"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}