Schema Info
Schema Name: sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened
- created: 2018-12-06 10:17:32
- disabled: False
- format: raw
- id: 1114
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_bi_reactfoot_product_list_viewed_flattened" } - type: redshift
Schema Versions: 3
-
Version 4693954
- created: 2023-04-20 07:32:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\n(\n `anonymousid` varchar(100) , `timestamp_utc` varchar(50) , `timestamp_cst` timestamp , `search_id` varchar(50) , `user_id` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_isreact` int , `properties_site_id` int , `properties_value` int , `properties_page` int , `properties_paidsearchfilter` binary , `properties_products_reviewcount` int , `properties_products_unitcount` int , `properties_products_hasclosestbadge` binary , `properties_products_hascontactlessbadge` binary , `properties_products_hasrecommendedbadge` binary , `properties_products_hastopratedbadge` binary , `properties_products_istopyielder` binary , `properties_products_reviewaverage` decimal(38,18) , `properties_products_name` varchar(200) , `properties_products_rank` int , `properties_products_id` int , `properties_products_innetwork` int , `properties_products_position` int , `properties_products_distance` decimal(38,18) , `properties_products_units_squarefootage` decimal(38,18) , `properties_products_units_sizetext` varchar(200) , `properties_products_units_maxbookingdate` varchar(50) , `properties_products_units_maxbookingdate_cst` timestamp , `properties_products_units_id` int , `properties_products_units_pricevalue` decimal(38,18) , `properties_products_units_unittypetext` varchar(200) , `properties_products_units_amenities` varchar(1000) , `properties_products_units_promotion` varchar(1000) , `properties_products_units_amenitieslist` varchar(1000) , `properties_list_id` varchar(100) , `properties_searchterm` varchar(4000) , `properties_productid` 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(3000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_page_title` varchar(2000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nPARTITIONED BY (dt string)\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-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899
- id: 4693954
- processed: 1
- raw_data:
{ "_origin": "61", "anonymousid": "0", "channel": "59", "context_campaign_content": "46", "context_campaign_medium": "49", "context_campaign_name": "50", "context_campaign_source": "47", "context_campaign_term": "48", "context_ip": "45", "context_page_path": "52", "context_page_referrer": "54", "context_page_search": "53", "context_page_title": "55", "context_page_url": "51", "context_useragent": "56", "day_key": "60", "event": "58", "originaltimestamp": "43", "originaltimestamp_cst": "44", "properties_category": "5", "properties_hit_timestamp": "6", "properties_hit_timestamp_cst": "7", "properties_isreact": "8", "properties_list_id": "37", "properties_page": "11", "properties_paidsearchfilter": "12", "properties_productid": "39", "properties_products_distance": "26", "properties_products_hasclosestbadge": "15", "properties_products_hascontactlessbadge": "16", "properties_products_hasrecommendedbadge": "17", "properties_products_hastopratedbadge": "18", "properties_products_id": "23", "properties_products_innetwork": "24", "properties_products_istopyielder": "19", "properties_products_name": "21", "properties_products_position": "25", "properties_products_rank": "22", "properties_products_reviewaverage": "20", "properties_products_reviewcount": "13", "properties_products_unitcount": "14", "properties_products_units_amenities": "34", "properties_products_units_amenitieslist": "36", "properties_products_units_id": "31", "properties_products_units_maxbookingdate": "29", "properties_products_units_maxbookingdate_cst": "30", "properties_products_units_pricevalue": "32", "properties_products_units_promotion": "35", "properties_products_units_sizetext": "28", "properties_products_units_squarefootage": "27", "properties_products_units_unittypetext": "33", "properties_search_id": "40", "properties_searchterm": "38", "properties_site_id": "9", "properties_value": "10", "receivedat": "41", "receivedat_cst": "42", "search_id": "3", "timestamp_cst": "2", "timestamp_utc": "1", "type": "57", "user_id": "4" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" } - schema_name_id: 1114
- schema_scan_id: 6168564
- updated: 2023-04-20 07:32:22
-
Version 4693934
- created: 2023-04-19 07:31:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\n(\n `anonymousid` varchar(100) , `timestamp_utc` varchar(50) , `timestamp_cst` timestamp , `search_id` varchar(50) , `user_id` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_isreact` int , `properties_site_id` int , `properties_value` int , `properties_page` int , `properties_paidsearchfilter` binary , `properties_products_reviewcount` int , `properties_products_unitcount` int , `properties_products_hasclosestbadge` binary , `properties_products_hascontactlessbadge` binary , `properties_products_hasrecommendedbadge` binary , `properties_products_hastopratedbadge` binary , `properties_products_istopyielder` binary , `properties_products_reviewaverage` decimal(38,18) , `properties_products_name` varchar(200) , `properties_products_rank` int , `properties_products_id` int , `properties_products_innetwork` int , `properties_products_position` int , `properties_products_distance` decimal(38,18) , `properties_products_units_squarefootage` decimal(38,18) , `properties_products_units_sizetext` varchar(200) , `properties_products_units_maxbookingdate` varchar(50) , `properties_products_units_maxbookingdate_cst` timestamp , `properties_products_units_id` int , `properties_products_units_pricevalue` decimal(38,18) , `properties_products_units_unittypetext` varchar(200) , `properties_products_units_amenities` varchar(1000) , `properties_products_units_promotion` varchar(1000) , `properties_products_units_amenitieslist` varchar(1000) , `properties_list_id` varchar(100) , `properties_searchterm` varchar(4000) , `properties_productid` 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(3000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_page_title` varchar(2000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nPARTITIONED BY (dt string)\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-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-19/1681907492'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-19/1681907492
- id: 4693934
- processed: 1
- raw_data:
{ "_origin": "61", "anonymousid": "0", "channel": "59", "context_campaign_content": "46", "context_campaign_medium": "49", "context_campaign_name": "50", "context_campaign_source": "47", "context_campaign_term": "48", "context_ip": "45", "context_page_path": "52", "context_page_referrer": "54", "context_page_search": "53", "context_page_title": "55", "context_page_url": "51", "context_useragent": "56", "day_key": "60", "event": "58", "originaltimestamp": "43", "originaltimestamp_cst": "44", "properties_category": "5", "properties_hit_timestamp": "6", "properties_hit_timestamp_cst": "7", "properties_isreact": "8", "properties_list_id": "37", "properties_page": "11", "properties_paidsearchfilter": "12", "properties_productid": "39", "properties_products_distance": "26", "properties_products_hasclosestbadge": "15", "properties_products_hascontactlessbadge": "16", "properties_products_hasrecommendedbadge": "17", "properties_products_hastopratedbadge": "18", "properties_products_id": "23", "properties_products_innetwork": "24", "properties_products_istopyielder": "19", "properties_products_name": "21", "properties_products_position": "25", "properties_products_rank": "22", "properties_products_reviewaverage": "20", "properties_products_reviewcount": "13", "properties_products_unitcount": "14", "properties_products_units_amenities": "34", "properties_products_units_amenitieslist": "36", "properties_products_units_id": "31", "properties_products_units_maxbookingdate": "29", "properties_products_units_maxbookingdate_cst": "30", "properties_products_units_pricevalue": "32", "properties_products_units_promotion": "35", "properties_products_units_sizetext": "28", "properties_products_units_squarefootage": "27", "properties_products_units_unittypetext": "33", "properties_search_id": "40", "properties_searchterm": "38", "properties_site_id": "9", "properties_value": "10", "receivedat": "41", "receivedat_cst": "42", "search_id": "3", "timestamp_cst": "2", "timestamp_utc": "1", "type": "57", "user_id": "4" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" } - schema_name_id: 1114
- schema_scan_id: 6167329
- updated: 2023-04-19 07:31:52
-
Version 4693920
- created: 2023-04-18 07:33:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\n(\n `anonymousid` varchar(100) , `timestamp_utc` varchar(50) , `timestamp_cst` timestamp , `search_id` varchar(50) , `user_id` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_isreact` int , `properties_site_id` int , `properties_value` int , `properties_page` int , `properties_paidsearchfilter` binary , `properties_products_reviewcount` int , `properties_products_unitcount` int , `properties_products_hasclosestbadge` binary , `properties_products_hascontactlessbadge` binary , `properties_products_hasrecommendedbadge` binary , `properties_products_hastopratedbadge` binary , `properties_products_istopyielder` binary , `properties_products_reviewaverage` decimal(38,18) , `properties_products_name` varchar(200) , `properties_products_rank` int , `properties_products_id` int , `properties_products_innetwork` int , `properties_products_position` int , `properties_products_distance` decimal(38,18) , `properties_products_units_squarefootage` decimal(38,18) , `properties_products_units_sizetext` varchar(200) , `properties_products_units_maxbookingdate` varchar(50) , `properties_products_units_maxbookingdate_cst` timestamp , `properties_products_units_id` int , `properties_products_units_pricevalue` decimal(38,18) , `properties_products_units_unittypetext` varchar(200) , `properties_products_units_amenities` varchar(1000) , `properties_products_units_promotion` varchar(1000) , `properties_products_units_amenitieslist` varchar(1000) , `properties_list_id` varchar(100) , `properties_searchterm` varchar(4000) , `properties_productid` 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(3000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_page_title` varchar(2000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nPARTITIONED BY (dt string)\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-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-18/1681821102'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened" ] - hive_path: s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-18/1681821102
- id: 4693920
- processed: 1
- raw_data:
{ "_origin": "61", "anonymousid": "0", "channel": "59", "context_campaign_content": "46", "context_campaign_medium": "49", "context_campaign_name": "50", "context_campaign_source": "47", "context_campaign_term": "48", "context_ip": "45", "context_page_path": "52", "context_page_referrer": "54", "context_page_search": "53", "context_page_title": "55", "context_page_url": "51", "context_useragent": "56", "day_key": "60", "event": "58", "originaltimestamp": "43", "originaltimestamp_cst": "44", "properties_category": "5", "properties_hit_timestamp": "6", "properties_hit_timestamp_cst": "7", "properties_isreact": "8", "properties_list_id": "37", "properties_page": "11", "properties_paidsearchfilter": "12", "properties_productid": "39", "properties_products_distance": "26", "properties_products_hasclosestbadge": "15", "properties_products_hascontactlessbadge": "16", "properties_products_hasrecommendedbadge": "17", "properties_products_hastopratedbadge": "18", "properties_products_id": "23", "properties_products_innetwork": "24", "properties_products_istopyielder": "19", "properties_products_name": "21", "properties_products_position": "25", "properties_products_rank": "22", "properties_products_reviewaverage": "20", "properties_products_reviewcount": "13", "properties_products_unitcount": "14", "properties_products_units_amenities": "34", "properties_products_units_amenitieslist": "36", "properties_products_units_id": "31", "properties_products_units_maxbookingdate": "29", "properties_products_units_maxbookingdate_cst": "30", "properties_products_units_pricevalue": "32", "properties_products_units_promotion": "35", "properties_products_units_sizetext": "28", "properties_products_units_squarefootage": "27", "properties_products_units_unittypetext": "33", "properties_search_id": "40", "properties_searchterm": "38", "properties_site_id": "9", "properties_value": "10", "receivedat": "41", "receivedat_cst": "42", "search_id": "3", "timestamp_cst": "2", "timestamp_utc": "1", "type": "57", "user_id": "4" } - schema_attributes:
{ "_origin": "string", "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" } - schema_name_id: 1114
- schema_scan_id: 6166302
- updated: 2023-04-18 07:33:44
Schema Scans: 3
Last at 2023-04-20 07:32:02
-
Scan 6168564
- duration: 0:00:23.571283
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 6168564
- payload:
{ "datatype_dict": { "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "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_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899", "key": "raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899/reactfoot_product_list_viewed_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened", "type": "redshift" } } - running: False
- schema_name_id: 1114
- start_time: 2023-04-20 07:32:02
- success: True
- trace_id: 9014486951009337420
-
Scan 6167329
- duration: 0:00:15.799823
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 6167329
- payload:
{ "datatype_dict": { "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "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_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/bi_reactfoot_product_list_viewed_flattened/2023-04-19/1681907492/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-19/1681907492", "key": "raw/bi_reactfoot_product_list_viewed_flattened/2023-04-19/1681907492/reactfoot_product_list_viewed_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened", "type": "redshift" } } - running: False
- schema_name_id: 1114
- start_time: 2023-04-19 07:31:39
- success: True
- trace_id: 17442861110534774518
-
Scan 6166302
- duration: 0:00:46.247453
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 0, "partitions_applied": false, "success": true } - id: 6166302
- payload:
{ "datatype_dict": { "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "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_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/bi_reactfoot_product_list_viewed_flattened/2023-04-18/1681821102/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-18/1681821102", "key": "raw/bi_reactfoot_product_list_viewed_flattened/2023-04-18/1681821102/reactfoot_product_list_viewed_flattened.dat0000_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened", "type": "redshift" } } - running: False
- schema_name_id: 1114
- start_time: 2023-04-18 07:33:00
- success: True
- trace_id: 3299553581087372861
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\nADD\n\n\n PARTITION (dt='2021-10-27') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-27'\n PARTITION (dt='2021-10-28') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-28'\n PARTITION (dt='2021-10-29') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-29/'\n;" ] - name: dt
- state:
[ { "info": { "id": 179894, "location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-27", "name": "dt", "value": "2021-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-10-27 07:35:39", "last_data": "2021-10-28 07:34:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 179932, "location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-28", "name": "dt", "value": "2021-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-10-28 07:34:25", "last_data": "2021-10-29 07:34:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 179975, "location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-29/", "name": "dt", "value": "2021-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-10-29 07:34:37", "last_data": "2021-10-29 07:34:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousid": "varchar(100)", "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(3000)", "context_page_referrer": "varchar(8000)", "context_page_search": "varchar(7500)", "context_page_title": "varchar(2000)", "context_page_url": "varchar(8000)", "context_useragent": "varchar(1000)", "day_key": "int", "event": "varchar(50)", "originaltimestamp": "varchar(50)", "originaltimestamp_cst": "timestamp", "properties_category": "varchar(500)", "properties_hit_timestamp": "varchar(50)", "properties_hit_timestamp_cst": "timestamp", "properties_isreact": "int", "properties_list_id": "varchar(100)", "properties_page": "int", "properties_paidsearchfilter": "binary", "properties_productid": "int", "properties_products_distance": "decimal(38,18)", "properties_products_hasclosestbadge": "binary", "properties_products_hascontactlessbadge": "binary", "properties_products_hasrecommendedbadge": "binary", "properties_products_hastopratedbadge": "binary", "properties_products_id": "int", "properties_products_innetwork": "int", "properties_products_istopyielder": "binary", "properties_products_name": "varchar(200)", "properties_products_position": "int", "properties_products_rank": "int", "properties_products_reviewaverage": "decimal(38,18)", "properties_products_reviewcount": "int", "properties_products_unitcount": "int", "properties_products_units_amenities": "varchar(1000)", "properties_products_units_amenitieslist": "varchar(1000)", "properties_products_units_id": "int", "properties_products_units_maxbookingdate": "varchar(50)", "properties_products_units_maxbookingdate_cst": "timestamp", "properties_products_units_pricevalue": "decimal(38,18)", "properties_products_units_promotion": "varchar(1000)", "properties_products_units_sizetext": "varchar(200)", "properties_products_units_squarefootage": "decimal(38,18)", "properties_products_units_unittypetext": "varchar(200)", "properties_search_id": "varchar(100)", "properties_searchterm": "varchar(4000)", "properties_site_id": "int", "properties_value": "int", "receivedat": "varchar(50)", "receivedat_cst": "timestamp", "search_id": "varchar(50)", "timestamp_cst": "timestamp", "timestamp_utc": "varchar(50)", "type": "varchar(50)", "user_id": "varchar(50)" } - created: 2023-04-20 07:32:04
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\n(\n `anonymousid` varchar(100) , `timestamp_utc` varchar(50) , `timestamp_cst` timestamp , `search_id` varchar(50) , `user_id` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_isreact` int , `properties_site_id` int , `properties_value` int , `properties_page` int , `properties_paidsearchfilter` binary , `properties_products_reviewcount` int , `properties_products_unitcount` int , `properties_products_hasclosestbadge` binary , `properties_products_hascontactlessbadge` binary , `properties_products_hasrecommendedbadge` binary , `properties_products_hastopratedbadge` binary , `properties_products_istopyielder` binary , `properties_products_reviewaverage` decimal(38,18) , `properties_products_name` varchar(200) , `properties_products_rank` int , `properties_products_id` int , `properties_products_innetwork` int , `properties_products_position` int , `properties_products_distance` decimal(38,18) , `properties_products_units_squarefootage` decimal(38,18) , `properties_products_units_sizetext` varchar(200) , `properties_products_units_maxbookingdate` varchar(50) , `properties_products_units_maxbookingdate_cst` timestamp , `properties_products_units_id` int , `properties_products_units_pricevalue` decimal(38,18) , `properties_products_units_unittypetext` varchar(200) , `properties_products_units_amenities` varchar(1000) , `properties_products_units_promotion` varchar(1000) , `properties_products_units_amenitieslist` varchar(1000) , `properties_list_id` varchar(100) , `properties_searchterm` varchar(4000) , `properties_productid` 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(3000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_page_title` varchar(2000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nPARTITIONED BY (dt string)\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-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-12-06 10:17:32",
"disabled": false,
"format": "raw",
"id": 1114,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_redshift",
"table": "analytics_bi_reactfoot_product_list_viewed_flattened"
},
"type": "redshift"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\nADD\n\n\n PARTITION (dt='2021-10-27') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-27'\n PARTITION (dt='2021-10-28') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-28'\n PARTITION (dt='2021-10-29') location 's3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-29/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 179894,
"location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-27",
"name": "dt",
"value": "2021-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-10-27 07:35:39",
"last_data": "2021-10-28 07:34:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 179932,
"location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-28",
"name": "dt",
"value": "2021-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-10-28 07:34:25",
"last_data": "2021-10-29 07:34:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 179975,
"location": "s3://sfdl-redshift-analytics-dev/raw_incremental/bi_reactfoot_product_list_viewed_flattened/dt=2021-10-29/",
"name": "dt",
"value": "2021-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-10-29 07:34:37",
"last_data": "2021-10-29 07:34:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousid": "varchar(100)",
"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(3000)",
"context_page_referrer": "varchar(8000)",
"context_page_search": "varchar(7500)",
"context_page_title": "varchar(2000)",
"context_page_url": "varchar(8000)",
"context_useragent": "varchar(1000)",
"day_key": "int",
"event": "varchar(50)",
"originaltimestamp": "varchar(50)",
"originaltimestamp_cst": "timestamp",
"properties_category": "varchar(500)",
"properties_hit_timestamp": "varchar(50)",
"properties_hit_timestamp_cst": "timestamp",
"properties_isreact": "int",
"properties_list_id": "varchar(100)",
"properties_page": "int",
"properties_paidsearchfilter": "binary",
"properties_productid": "int",
"properties_products_distance": "decimal(38,18)",
"properties_products_hasclosestbadge": "binary",
"properties_products_hascontactlessbadge": "binary",
"properties_products_hasrecommendedbadge": "binary",
"properties_products_hastopratedbadge": "binary",
"properties_products_id": "int",
"properties_products_innetwork": "int",
"properties_products_istopyielder": "binary",
"properties_products_name": "varchar(200)",
"properties_products_position": "int",
"properties_products_rank": "int",
"properties_products_reviewaverage": "decimal(38,18)",
"properties_products_reviewcount": "int",
"properties_products_unitcount": "int",
"properties_products_units_amenities": "varchar(1000)",
"properties_products_units_amenitieslist": "varchar(1000)",
"properties_products_units_id": "int",
"properties_products_units_maxbookingdate": "varchar(50)",
"properties_products_units_maxbookingdate_cst": "timestamp",
"properties_products_units_pricevalue": "decimal(38,18)",
"properties_products_units_promotion": "varchar(1000)",
"properties_products_units_sizetext": "varchar(200)",
"properties_products_units_squarefootage": "decimal(38,18)",
"properties_products_units_unittypetext": "varchar(200)",
"properties_search_id": "varchar(100)",
"properties_searchterm": "varchar(4000)",
"properties_site_id": "int",
"properties_value": "int",
"receivedat": "varchar(50)",
"receivedat_cst": "timestamp",
"search_id": "varchar(50)",
"timestamp_cst": "timestamp",
"timestamp_utc": "varchar(50)",
"type": "varchar(50)",
"user_id": "varchar(50)"
},
"created": "2023-04-20 07:32:04",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`\n(\n `anonymousid` varchar(100) , `timestamp_utc` varchar(50) , `timestamp_cst` timestamp , `search_id` varchar(50) , `user_id` varchar(50) , `properties_category` varchar(500) , `properties_hit_timestamp` varchar(50) , `properties_hit_timestamp_cst` timestamp , `properties_isreact` int , `properties_site_id` int , `properties_value` int , `properties_page` int , `properties_paidsearchfilter` binary , `properties_products_reviewcount` int , `properties_products_unitcount` int , `properties_products_hasclosestbadge` binary , `properties_products_hascontactlessbadge` binary , `properties_products_hasrecommendedbadge` binary , `properties_products_hastopratedbadge` binary , `properties_products_istopyielder` binary , `properties_products_reviewaverage` decimal(38,18) , `properties_products_name` varchar(200) , `properties_products_rank` int , `properties_products_id` int , `properties_products_innetwork` int , `properties_products_position` int , `properties_products_distance` decimal(38,18) , `properties_products_units_squarefootage` decimal(38,18) , `properties_products_units_sizetext` varchar(200) , `properties_products_units_maxbookingdate` varchar(50) , `properties_products_units_maxbookingdate_cst` timestamp , `properties_products_units_id` int , `properties_products_units_pricevalue` decimal(38,18) , `properties_products_units_unittypetext` varchar(200) , `properties_products_units_amenities` varchar(1000) , `properties_products_units_promotion` varchar(1000) , `properties_products_units_amenitieslist` varchar(1000) , `properties_list_id` varchar(100) , `properties_searchterm` varchar(4000) , `properties_productid` 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(3000) , `context_page_search` varchar(7500) , `context_page_referrer` varchar(8000) , `context_page_title` varchar(2000) , `context_useragent` varchar(1000) , `type` varchar(50) , `event` varchar(50) , `channel` varchar(50) , `day_key` int , `_origin` string \n)\nPARTITIONED BY (dt string)\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-dev/raw/bi_reactfoot_product_list_viewed_flattened/2023-04-20/1681993899'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_bi_reactfoot_product_list_viewed_flattened"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}