Schema Info
Schema Name: sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened
- created: 2019-06-25 11:03:05
- disabled: False
- format: raw
- id: 856
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_redshift", "table": "analytics_bi_reactfoot_facility_card_impression_flattened" } - type: redshift
Schema Versions: 3
-
Version 567483
- created: 2023-07-25 07:32:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`\n(\n `anonymousid` varchar(50) , `timestamp` varchar(50) , `timestamp_cst` timestamp , `userid` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_in_network` int , `properties_badged` int , `properties_isreact` int , `properties_site_id` int , `properties_rank` int , `properties_delay` int , `properties_facility_id` int , `properties_search_id` varchar(100) , `receivedat` varchar(50) , `receivedat_cst` timestamp , `originaltimestamp` varchar(50) , `originaltimestamp_cst` timestamp , `context_ip` varchar(50) , `context_campaign_content` varchar(200) , `context_campaign_source` varchar(200) , `context_campaign_term` varchar(200) , `context_campaign_medium` varchar(200) , `context_campaign_name` varchar(200) , `context_page_url` varchar(8000) , `context_page_path` varchar(2000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359
- id: 567483
- processed: 1
- raw_data:
{ "_origin": "34", "anonymousid": "0", "channel": "32", "context_campaign_content": "20", "context_campaign_medium": "23", "context_campaign_name": "24", "context_campaign_source": "21", "context_campaign_term": "22", "context_ip": "19", "context_page_path": "26", "context_page_referrer": "28", "context_page_search": "27", "context_page_url": "25", "context_useragent": "29", "day_key": "33", "event": "31", "originaltimestamp": "17", "originaltimestamp_cst": "18", "properties_badged": "8", "properties_category": "4", "properties_delay": "12", "properties_facility_id": "13", "properties_hit_timestamp": "5", "properties_hit_timestamp_cst": "6", "properties_in_network": "7", "properties_isreact": "9", "properties_rank": "11", "properties_search_id": "14", "properties_site_id": "10", "receivedat": "15", "receivedat_cst": "16", "timestamp": "1", "timestamp_cst": "2", "type": "30", "userid": "3" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" } - schema_name_id: 856
- schema_scan_id: 5050207
- updated: 2023-07-25 07:33:03
-
Version 567063
- created: 2023-07-24 07:32:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`\n(\n `anonymousid` varchar(50) , `timestamp` varchar(50) , `timestamp_cst` timestamp , `userid` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_in_network` int , `properties_badged` int , `properties_isreact` int , `properties_site_id` int , `properties_rank` int , `properties_delay` int , `properties_facility_id` int , `properties_search_id` varchar(100) , `receivedat` varchar(50) , `receivedat_cst` timestamp , `originaltimestamp` varchar(50) , `originaltimestamp_cst` timestamp , `context_ip` varchar(50) , `context_campaign_content` varchar(200) , `context_campaign_source` varchar(200) , `context_campaign_term` varchar(200) , `context_campaign_medium` varchar(200) , `context_campaign_name` varchar(200) , `context_page_url` varchar(8000) , `context_page_path` varchar(2000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-24/1690201903'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-24/1690201903
- id: 567063
- processed: 1
- raw_data:
{ "_origin": "34", "anonymousid": "0", "channel": "32", "context_campaign_content": "20", "context_campaign_medium": "23", "context_campaign_name": "24", "context_campaign_source": "21", "context_campaign_term": "22", "context_ip": "19", "context_page_path": "26", "context_page_referrer": "28", "context_page_search": "27", "context_page_url": "25", "context_useragent": "29", "day_key": "33", "event": "31", "originaltimestamp": "17", "originaltimestamp_cst": "18", "properties_badged": "8", "properties_category": "4", "properties_delay": "12", "properties_facility_id": "13", "properties_hit_timestamp": "5", "properties_hit_timestamp_cst": "6", "properties_in_network": "7", "properties_isreact": "9", "properties_rank": "11", "properties_search_id": "14", "properties_site_id": "10", "receivedat": "15", "receivedat_cst": "16", "timestamp": "1", "timestamp_cst": "2", "type": "30", "userid": "3" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" } - schema_name_id: 856
- schema_scan_id: 5047747
- updated: 2023-07-24 07:32:26
-
Version 566652
- created: 2023-07-23 07:33:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`\n(\n `anonymousid` varchar(50) , `timestamp` varchar(50) , `timestamp_cst` timestamp , `userid` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_in_network` int , `properties_badged` int , `properties_isreact` int , `properties_site_id` int , `properties_rank` int , `properties_delay` int , `properties_facility_id` int , `properties_search_id` varchar(100) , `receivedat` varchar(50) , `receivedat_cst` timestamp , `originaltimestamp` varchar(50) , `originaltimestamp_cst` timestamp , `context_ip` varchar(50) , `context_campaign_content` varchar(200) , `context_campaign_source` varchar(200) , `context_campaign_term` varchar(200) , `context_campaign_medium` varchar(200) , `context_campaign_name` varchar(200) , `context_page_url` varchar(8000) , `context_page_path` varchar(2000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-23/1690115578'\n", "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened" ] - hive_path: s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-23/1690115578
- id: 566652
- processed: 1
- raw_data:
{ "_origin": "34", "anonymousid": "0", "channel": "32", "context_campaign_content": "20", "context_campaign_medium": "23", "context_campaign_name": "24", "context_campaign_source": "21", "context_campaign_term": "22", "context_ip": "19", "context_page_path": "26", "context_page_referrer": "28", "context_page_search": "27", "context_page_url": "25", "context_useragent": "29", "day_key": "33", "event": "31", "originaltimestamp": "17", "originaltimestamp_cst": "18", "properties_badged": "8", "properties_category": "4", "properties_delay": "12", "properties_facility_id": "13", "properties_hit_timestamp": "5", "properties_hit_timestamp_cst": "6", "properties_in_network": "7", "properties_isreact": "9", "properties_rank": "11", "properties_search_id": "14", "properties_site_id": "10", "receivedat": "15", "receivedat_cst": "16", "timestamp": "1", "timestamp_cst": "2", "type": "30", "userid": "3" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" } - schema_name_id: 856
- schema_scan_id: 5045945
- updated: 2023-07-23 07:33:39
Schema Scans: 3
Last at 2023-07-25 07:32:50
-
Scan 5050207
- duration: 0:00:12.419035
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 5050207
- payload:
{ "datatype_dict": { "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "origin_key": "varchar", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359", "key": "raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359/reactfoot_facility_card_impression_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened", "type": "redshift" } } - running: False
- schema_name_id: 856
- start_time: 2023-07-25 07:32:50
- success: True
- trace_id: 1366337732174339185
-
Scan 5047747
- duration: 0:00:12.318071
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 5047747
- payload:
{ "datatype_dict": { "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "origin_key": "varchar", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_reactfoot_facility_card_impression_flattened/2023-07-24/1690201903/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-24/1690201903", "key": "raw/bi_reactfoot_facility_card_impression_flattened/2023-07-24/1690201903/reactfoot_facility_card_impression_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened", "type": "redshift" } } - running: False
- schema_name_id: 856
- start_time: 2023-07-24 07:32:14
- success: True
- trace_id: 4962979278790796714
-
Scan 5045945
- duration: 0:00:12.304956
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 5045945
- payload:
{ "datatype_dict": { "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "origin_key": "varchar", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-stage", "key": "meta/bi_reactfoot_facility_card_impression_flattened/2023-07-23/1690115578/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-stage", "hive_path": "s3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-23/1690115578", "key": "raw/bi_reactfoot_facility_card_impression_flattened/2023-07-23/1690115578/reactfoot_facility_card_impression_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened", "type": "redshift" } } - running: False
- schema_name_id: 856
- start_time: 2023-07-23 07:33:27
- success: True
- trace_id: 243660028771632053
- attributes:
{ "_origin": "string", "anonymousid": "varchar(50)", "channel": "varchar(50)", "context_campaign_content": "varchar(200)", "context_campaign_medium": "varchar(200)", "context_campaign_name": "varchar(200)", "context_campaign_source": "varchar(200)", "context_campaign_term": "varchar(200)", "context_ip": "varchar(50)", "context_page_path": "varchar(2000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_badged": "int", "properties_category": "varchar(500)", "properties_delay": "int", "properties_facility_id": "int", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_in_network": "int", "properties_isreact": "int", "properties_rank": "int", "properties_search_id": "varchar(100)", "properties_site_id": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "timestamp": "varchar(50)", "timestamp_cst": "timestamp", "type": "varchar(50)", "userid": "varchar(50)" } - created: 2023-07-25 07:32:51
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`\n(\n `anonymousid` varchar(50) , `timestamp` varchar(50) , `timestamp_cst` timestamp , `userid` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_in_network` int , `properties_badged` int , `properties_isreact` int , `properties_site_id` int , `properties_rank` int , `properties_delay` int , `properties_facility_id` int , `properties_search_id` varchar(100) , `receivedat` varchar(50) , `receivedat_cst` timestamp , `originaltimestamp` varchar(50) , `originaltimestamp_cst` timestamp , `context_ip` varchar(50) , `context_campaign_content` varchar(200) , `context_campaign_source` varchar(200) , `context_campaign_term` varchar(200) , `context_campaign_medium` varchar(200) , `context_campaign_name` varchar(200) , `context_page_url` varchar(8000) , `context_page_path` varchar(2000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2019-06-25 11:03:05",
"disabled": false,
"format": "raw",
"id": 856,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_redshift",
"table": "analytics_bi_reactfoot_facility_card_impression_flattened"
},
"type": "redshift"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousid": "varchar(50)",
"channel": "varchar(50)",
"context_campaign_content": "varchar(200)",
"context_campaign_medium": "varchar(200)",
"context_campaign_name": "varchar(200)",
"context_campaign_source": "varchar(200)",
"context_campaign_term": "varchar(200)",
"context_ip": "varchar(50)",
"context_page_path": "varchar(2000)",
"context_page_referrer": "varchar(8000)",
"context_page_search": "varchar(7500)",
"context_page_url": "varchar(8000)",
"context_useragent": "varchar(1000)",
"day_key": "int",
"event": "varchar(50)",
"originaltimestamp": "varchar(50)",
"originaltimestamp_cst": "timestamp",
"properties_badged": "int",
"properties_category": "varchar(500)",
"properties_delay": "int",
"properties_facility_id": "int",
"properties_hit_timestamp": "varchar(50)",
"properties_hit_timestamp_cst": "timestamp",
"properties_in_network": "int",
"properties_isreact": "int",
"properties_rank": "int",
"properties_search_id": "varchar(100)",
"properties_site_id": "int",
"receivedat": "varchar(50)",
"receivedat_cst": "timestamp",
"timestamp": "varchar(50)",
"timestamp_cst": "timestamp",
"type": "varchar(50)",
"userid": "varchar(50)"
},
"created": "2023-07-25 07:32:51",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`\n(\n `anonymousid` varchar(50) , `timestamp` varchar(50) , `timestamp_cst` timestamp , `userid` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_in_network` int , `properties_badged` int , `properties_isreact` int , `properties_site_id` int , `properties_rank` int , `properties_delay` int , `properties_facility_id` int , `properties_search_id` varchar(100) , `receivedat` varchar(50) , `receivedat_cst` timestamp , `originaltimestamp` varchar(50) , `originaltimestamp_cst` timestamp , `context_ip` varchar(50) , `context_campaign_content` varchar(200) , `context_campaign_source` varchar(200) , `context_campaign_term` varchar(200) , `context_campaign_medium` varchar(200) , `context_campaign_name` varchar(200) , `context_page_url` varchar(8000) , `context_page_path` varchar(2000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-stage/raw/bi_reactfoot_facility_card_impression_flattened/2023-07-25/1690288359'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_redshift.analytics_bi_reactfoot_facility_card_impression_flattened"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}