Schema Info
Schema Name: sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection
- created: 2024-05-09 13:19:59
- disabled: False
- format: raw
- id: 2283
- is_partitioned: False
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "sandbox_rs_insurance_tpp_connection" } - type: redshift
Schema Versions: 2
-
Version 4705540
- created: 2024-05-09 13:28:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`\n(\n `brand` string , `calculation_2522578805527556096` bigint , `calculation_510314195221766144` bigint , `calculation_510314195221999617` string , `facility_has_ess_fms_flag` bigint , `facility_has_leads_flag__copy_2__2522578805528223746` bigint , `facility_has_leads_flag__copy_3__2522578805528248323` bigint , `facility_has_leads_flag__copy_4__2522578805528260612` bigint , `facility_has_leads_flag__copy_5__2522578805528268805` bigint , `facility_has_leads_flag__copy__2522578805528211457` bigint , `facility_has_se_fms_flag` bigint , `facility_has_slwe_fms_flag` bigint , `facility_id` string , `facility_name` string , `has_collections___copy_2__2522578805529120776` string , `has_collections___copy_3__2522578805529133065` string , `has_collections___copy_4__2522578805529141258` string , `has_collections___copy_5__2522578805529149451` string , `has_collections___copy__2522578805529108487` string , `has_ess_cc___copy__2522578805528981510` string , `has_ess_fms_` string , `has_se_fms_` string , `has_slwe_fms_` string , `install_base` string , `invoice_label` string , `invoice_total` double , `logo_segment` string , `logo_size` bigint , `month` date , `next_invoice` double , `number_of_facilities` bigint , `parent_id` string , `parent_name` string , `previous_invoice` double , `product` string , `product_customer_flag` bigint , `product_facility_id` string , `product_group` string , `rev_start__facility` date , `rev_start__facility_by_product` date \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715279269'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection" ] - hive_path: s3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715279269
- id: 4705540
- processed: 1
- raw_data:
{ "brand": "string", "calculation_2522578805527556096": "int64", "calculation_510314195221766144": "int64", "calculation_510314195221999617": "string", "facility has ess fms flag": "int64", "facility has leads flag (copy 2)_2522578805528223746": "int64", "facility has leads flag (copy 3)_2522578805528248323": "int64", "facility has leads flag (copy 4)_2522578805528260612": "int64", "facility has leads flag (copy 5)_2522578805528268805": "int64", "facility has leads flag (copy)_2522578805528211457": "int64", "facility has se fms flag": "int64", "facility has slwe fms flag": "int64", "facility id": "string", "facility name": "string", "has collections? (copy 2)_2522578805529120776": "string", "has collections? (copy 3)_2522578805529133065": "string", "has collections? (copy 4)_2522578805529141258": "string", "has collections? (copy 5)_2522578805529149451": "string", "has collections? (copy)_2522578805529108487": "string", "has ess cc? (copy)_2522578805528981510": "string", "has ess fms?": "string", "has se fms?": "string", "has slwe fms?": "string", "install base": "string", "invoice label": "string", "invoice total": "double", "logo segment": "string", "logo size": "int64", "month": "date32[day]", "next invoice": "double", "number of facilities": "int64", "parent id": "string", "parent name": "string", "previous invoice": "double", "product": "string", "product customer flag": "int64", "product facility id": "string", "product group": "string", "rev start: facility": "date32[day]", "rev start: facility by product": "date32[day]" } - schema_attributes:
{ "brand": "string", "calculation_2522578805527556096": "bigint", "calculation_510314195221766144": "bigint", "calculation_510314195221999617": "string", "facility_has_ess_fms_flag": "bigint", "facility_has_leads_flag__copy_2__2522578805528223746": "bigint", "facility_has_leads_flag__copy_3__2522578805528248323": "bigint", "facility_has_leads_flag__copy_4__2522578805528260612": "bigint", "facility_has_leads_flag__copy_5__2522578805528268805": "bigint", "facility_has_leads_flag__copy__2522578805528211457": "bigint", "facility_has_se_fms_flag": "bigint", "facility_has_slwe_fms_flag": "bigint", "facility_id": "string", "facility_name": "string", "has_collections___copy_2__2522578805529120776": "string", "has_collections___copy_3__2522578805529133065": "string", "has_collections___copy_4__2522578805529141258": "string", "has_collections___copy_5__2522578805529149451": "string", "has_collections___copy__2522578805529108487": "string", "has_ess_cc___copy__2522578805528981510": "string", "has_ess_fms_": "string", "has_se_fms_": "string", "has_slwe_fms_": "string", "install_base": "string", "invoice_label": "string", "invoice_total": "double", "logo_segment": "string", "logo_size": "bigint", "month": "date", "next_invoice": "double", "number_of_facilities": "bigint", "parent_id": "string", "parent_name": "string", "previous_invoice": "double", "product": "string", "product_customer_flag": "bigint", "product_facility_id": "string", "product_group": "string", "rev_start__facility": "date", "rev_start__facility_by_product": "date" } - schema_name_id: 2283
- schema_scan_id: 6488196
- updated: 2024-05-09 13:28:39
-
Version 4705521
- created: 2024-05-09 13:20:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`\n(\n `brand` string , `calculation_2522578805527556096` bigint , `calculation_510314195221766144` bigint , `calculation_510314195221999617` string , `facility_has_ess_fms_flag` bigint , `facility_has_leads_flag__copy_2__2522578805528223746` bigint , `facility_has_leads_flag__copy_3__2522578805528248323` bigint , `facility_has_leads_flag__copy_4__2522578805528260612` bigint , `facility_has_leads_flag__copy_5__2522578805528268805` bigint , `facility_has_leads_flag__copy__2522578805528211457` bigint , `facility_has_se_fms_flag` bigint , `facility_has_slwe_fms_flag` bigint , `facility_id` string , `facility_name` string , `has_collections___copy_2__2522578805529120776` string , `has_collections___copy_3__2522578805529133065` string , `has_collections___copy_4__2522578805529141258` string , `has_collections___copy_5__2522578805529149451` string , `has_collections___copy__2522578805529108487` string , `has_ess_cc___copy__2522578805528981510` string , `has_ess_fms_` string , `has_se_fms_` string , `has_slwe_fms_` string , `install_base` string , `invoice_label` string , `invoice_total` double , `logo_segment` string , `logo_size` bigint , `month` date , `next_invoice` double , `number_of_facilities` bigint , `parent_id` string , `parent_name` string , `previous_invoice` double , `product` string , `product_customer_flag` bigint , `product_facility_id` string , `product_group` string , `rev_start__facility` date , `rev_start__facility_by_product` date \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715278723'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection" ] - hive_path: s3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715278723
- id: 4705521
- processed: 1
- raw_data:
{ "brand": "string", "calculation_2522578805527556096": "int64", "calculation_510314195221766144": "int64", "calculation_510314195221999617": "string", "facility has ess fms flag": "int64", "facility has leads flag (copy 2)_2522578805528223746": "int64", "facility has leads flag (copy 3)_2522578805528248323": "int64", "facility has leads flag (copy 4)_2522578805528260612": "int64", "facility has leads flag (copy 5)_2522578805528268805": "int64", "facility has leads flag (copy)_2522578805528211457": "int64", "facility has se fms flag": "int64", "facility has slwe fms flag": "int64", "facility id": "string", "facility name": "string", "has collections? (copy 2)_2522578805529120776": "string", "has collections? (copy 3)_2522578805529133065": "string", "has collections? (copy 4)_2522578805529141258": "string", "has collections? (copy 5)_2522578805529149451": "string", "has collections? (copy)_2522578805529108487": "string", "has ess cc? (copy)_2522578805528981510": "string", "has ess fms?": "string", "has se fms?": "string", "has slwe fms?": "string", "install base": "string", "invoice label": "string", "invoice total": "double", "logo segment": "string", "logo size": "int64", "month": "date32[day]", "next invoice": "double", "number of facilities": "int64", "parent id": "string", "parent name": "string", "previous invoice": "double", "product": "string", "product customer flag": "int64", "product facility id": "string", "product group": "string", "rev start: facility": "date32[day]", "rev start: facility by product": "date32[day]" } - schema_attributes:
{ "brand": "string", "calculation_2522578805527556096": "bigint", "calculation_510314195221766144": "bigint", "calculation_510314195221999617": "string", "facility_has_ess_fms_flag": "bigint", "facility_has_leads_flag__copy_2__2522578805528223746": "bigint", "facility_has_leads_flag__copy_3__2522578805528248323": "bigint", "facility_has_leads_flag__copy_4__2522578805528260612": "bigint", "facility_has_leads_flag__copy_5__2522578805528268805": "bigint", "facility_has_leads_flag__copy__2522578805528211457": "bigint", "facility_has_se_fms_flag": "bigint", "facility_has_slwe_fms_flag": "bigint", "facility_id": "string", "facility_name": "string", "has_collections___copy_2__2522578805529120776": "string", "has_collections___copy_3__2522578805529133065": "string", "has_collections___copy_4__2522578805529141258": "string", "has_collections___copy_5__2522578805529149451": "string", "has_collections___copy__2522578805529108487": "string", "has_ess_cc___copy__2522578805528981510": "string", "has_ess_fms_": "string", "has_se_fms_": "string", "has_slwe_fms_": "string", "install_base": "string", "invoice_label": "string", "invoice_total": "double", "logo_segment": "string", "logo_size": "bigint", "month": "date", "next_invoice": "double", "number_of_facilities": "bigint", "parent_id": "string", "parent_name": "string", "previous_invoice": "double", "product": "string", "product_customer_flag": "bigint", "product_facility_id": "string", "product_group": "string", "rev_start__facility": "date", "rev_start__facility_by_product": "date" } - schema_name_id: 2283
- schema_scan_id: 6488082
- updated: 2024-05-09 13:20:14
Schema Scans: 2
Last at 2024-05-09 13:28:24
-
Scan 6488196
- duration: 0:00:14.951384
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6488196
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-redshift-sandbox-dev", "hive_path": "s3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715279269", "key": "raw/rs_insurance_tpp_connection/2024-05-09/1715279269/0007_part_00.parquet" }, "schema": { "name": "sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection", "type": "redshift" }, "trace_context": { "parent_id": 14019113715068547669, "service_name": "drive-thru", "span_id": 11903122645337165075, "trace_id": 2071080153512964488 } } - running: False
- schema_name_id: 2283
- start_time: 2024-05-09 13:28:24
- success: True
- trace_id: 2071080153512964488
-
Scan 6488082
- duration: 0:00:15.177766
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6488082
- payload:
{ "datatype_dict": null, "file_format": "parquet", "is_schema_datatyped": false, "s3": { "bucket": "sfdl-redshift-sandbox-dev", "hive_path": "s3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715278723", "key": "raw/rs_insurance_tpp_connection/2024-05-09/1715278723/0007_part_00.parquet" }, "schema": { "name": "sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection", "type": "redshift" }, "trace_context": { "parent_id": 11866265078977625839, "service_name": "drive-thru", "span_id": 2509816213855347074, "trace_id": 7760577871705342546 } } - running: False
- schema_name_id: 2283
- start_time: 2024-05-09 13:19:59
- success: True
- trace_id: 7760577871705342546
- attributes:
{ "brand": "string", "calculation_2522578805527556096": "bigint", "calculation_510314195221766144": "bigint", "calculation_510314195221999617": "string", "facility_has_ess_fms_flag": "bigint", "facility_has_leads_flag__copy_2__2522578805528223746": "bigint", "facility_has_leads_flag__copy_3__2522578805528248323": "bigint", "facility_has_leads_flag__copy_4__2522578805528260612": "bigint", "facility_has_leads_flag__copy_5__2522578805528268805": "bigint", "facility_has_leads_flag__copy__2522578805528211457": "bigint", "facility_has_se_fms_flag": "bigint", "facility_has_slwe_fms_flag": "bigint", "facility_id": "string", "facility_name": "string", "has_collections___copy_2__2522578805529120776": "string", "has_collections___copy_3__2522578805529133065": "string", "has_collections___copy_4__2522578805529141258": "string", "has_collections___copy_5__2522578805529149451": "string", "has_collections___copy__2522578805529108487": "string", "has_ess_cc___copy__2522578805528981510": "string", "has_ess_fms_": "string", "has_se_fms_": "string", "has_slwe_fms_": "string", "install_base": "string", "invoice_label": "string", "invoice_total": "double", "logo_segment": "string", "logo_size": "bigint", "month": "date", "next_invoice": "double", "number_of_facilities": "bigint", "parent_id": "string", "parent_name": "string", "previous_invoice": "double", "product": "string", "product_customer_flag": "bigint", "product_facility_id": "string", "product_group": "string", "rev_start__facility": "date", "rev_start__facility_by_product": "date" } - created: 2024-05-09 13:28:26
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`\n(\n `brand` string , `calculation_2522578805527556096` bigint , `calculation_510314195221766144` bigint , `calculation_510314195221999617` string , `facility_has_ess_fms_flag` bigint , `facility_has_leads_flag__copy_2__2522578805528223746` bigint , `facility_has_leads_flag__copy_3__2522578805528248323` bigint , `facility_has_leads_flag__copy_4__2522578805528260612` bigint , `facility_has_leads_flag__copy_5__2522578805528268805` bigint , `facility_has_leads_flag__copy__2522578805528211457` bigint , `facility_has_se_fms_flag` bigint , `facility_has_slwe_fms_flag` bigint , `facility_id` string , `facility_name` string , `has_collections___copy_2__2522578805529120776` string , `has_collections___copy_3__2522578805529133065` string , `has_collections___copy_4__2522578805529141258` string , `has_collections___copy_5__2522578805529149451` string , `has_collections___copy__2522578805529108487` string , `has_ess_cc___copy__2522578805528981510` string , `has_ess_fms_` string , `has_se_fms_` string , `has_slwe_fms_` string , `install_base` string , `invoice_label` string , `invoice_total` double , `logo_segment` string , `logo_size` bigint , `month` date , `next_invoice` double , `number_of_facilities` bigint , `parent_id` string , `parent_name` string , `previous_invoice` double , `product` string , `product_customer_flag` bigint , `product_facility_id` string , `product_group` string , `rev_start__facility` date , `rev_start__facility_by_product` date \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715279269'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-05-09 13:19:59",
"disabled": false,
"format": "raw",
"id": 2283,
"is_partitioned": false,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_redshift",
"table": "sandbox_rs_insurance_tpp_connection"
},
"type": "redshift"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"brand": "string",
"calculation_2522578805527556096": "bigint",
"calculation_510314195221766144": "bigint",
"calculation_510314195221999617": "string",
"facility_has_ess_fms_flag": "bigint",
"facility_has_leads_flag__copy_2__2522578805528223746": "bigint",
"facility_has_leads_flag__copy_3__2522578805528248323": "bigint",
"facility_has_leads_flag__copy_4__2522578805528260612": "bigint",
"facility_has_leads_flag__copy_5__2522578805528268805": "bigint",
"facility_has_leads_flag__copy__2522578805528211457": "bigint",
"facility_has_se_fms_flag": "bigint",
"facility_has_slwe_fms_flag": "bigint",
"facility_id": "string",
"facility_name": "string",
"has_collections___copy_2__2522578805529120776": "string",
"has_collections___copy_3__2522578805529133065": "string",
"has_collections___copy_4__2522578805529141258": "string",
"has_collections___copy_5__2522578805529149451": "string",
"has_collections___copy__2522578805529108487": "string",
"has_ess_cc___copy__2522578805528981510": "string",
"has_ess_fms_": "string",
"has_se_fms_": "string",
"has_slwe_fms_": "string",
"install_base": "string",
"invoice_label": "string",
"invoice_total": "double",
"logo_segment": "string",
"logo_size": "bigint",
"month": "date",
"next_invoice": "double",
"number_of_facilities": "bigint",
"parent_id": "string",
"parent_name": "string",
"previous_invoice": "double",
"product": "string",
"product_customer_flag": "bigint",
"product_facility_id": "string",
"product_group": "string",
"rev_start__facility": "date",
"rev_start__facility_by_product": "date"
},
"created": "2024-05-09 13:28:26",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`\n(\n `brand` string , `calculation_2522578805527556096` bigint , `calculation_510314195221766144` bigint , `calculation_510314195221999617` string , `facility_has_ess_fms_flag` bigint , `facility_has_leads_flag__copy_2__2522578805528223746` bigint , `facility_has_leads_flag__copy_3__2522578805528248323` bigint , `facility_has_leads_flag__copy_4__2522578805528260612` bigint , `facility_has_leads_flag__copy_5__2522578805528268805` bigint , `facility_has_leads_flag__copy__2522578805528211457` bigint , `facility_has_se_fms_flag` bigint , `facility_has_slwe_fms_flag` bigint , `facility_id` string , `facility_name` string , `has_collections___copy_2__2522578805529120776` string , `has_collections___copy_3__2522578805529133065` string , `has_collections___copy_4__2522578805529141258` string , `has_collections___copy_5__2522578805529149451` string , `has_collections___copy__2522578805529108487` string , `has_ess_cc___copy__2522578805528981510` string , `has_ess_fms_` string , `has_se_fms_` string , `has_slwe_fms_` string , `install_base` string , `invoice_label` string , `invoice_total` double , `logo_segment` string , `logo_size` bigint , `month` date , `next_invoice` double , `number_of_facilities` bigint , `parent_id` string , `parent_name` string , `previous_invoice` double , `product` string , `product_customer_flag` bigint , `product_facility_id` string , `product_group` string , `rev_start__facility` date , `rev_start__facility_by_product` date \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-sandbox-dev/raw/rs_insurance_tpp_connection/2024-05-09/1715279269'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.sandbox_rs_insurance_tpp_connection"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}