Schema Info
Schema Name: sfdl_dev_drivethru.newbookdev_newbookactivities_tickets
- created: 2024-10-08 17:38:44
- disabled: False
- format: raw
- id: 2433
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "newbookdev_newbookactivities_tickets" } - type: drivethrucsv
Schema Versions: 15
-
Version 4748141
- created: 2024-11-05 22:36:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356
- id: 4748141
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6674173
- updated: 2024-11-05 22:36:18
-
Version 4747691
- created: 2024-11-05 22:23:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866292'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866292
- id: 4747691
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6673723
- updated: 2024-11-05 22:23:42
-
Version 4747376
- created: 2024-11-05 22:14:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866226'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866226
- id: 4747376
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6673408
- updated: 2024-11-05 22:14:36
-
Version 4746648
- created: 2024-11-05 04:14:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785644'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785644
- id: 4746648
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6671871
- updated: 2024-11-05 04:14:38
-
Version 4745918
- created: 2024-11-05 03:42:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785078'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785078
- id: 4745918
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6671138
- updated: 2024-11-05 03:43:10
-
Version 4745026
- created: 2024-11-05 03:18:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784773'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784773
- id: 4745026
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6670242
- updated: 2024-11-05 03:18:53
-
Version 4744271
- created: 2024-11-05 02:58:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784170'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784170
- id: 4744271
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6669488
- updated: 2024-11-05 02:58:43
-
Version 4743990
- created: 2024-11-05 02:51:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784008'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784008
- id: 4743990
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6669206
- updated: 2024-11-05 02:51:22
-
Version 4742849
- created: 2024-11-05 02:21:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783832'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783832
- id: 4742849
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6668066
- updated: 2024-11-05 02:21:17
-
Version 4742140
- created: 2024-11-05 02:02:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783720'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783720
- id: 4742140
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6667357
- updated: 2024-11-05 02:02:25
-
Version 4741791
- created: 2024-11-05 01:52:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783629'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783629
- id: 4741791
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6667008
- updated: 2024-11-05 01:53:05
-
Version 4740879
- created: 2024-11-05 01:28:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783475'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783475
- id: 4740879
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6666096
- updated: 2024-11-05 01:29:10
-
Version 4740011
- created: 2024-11-05 01:05:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783257'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783257
- id: 4740011
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6665228
- updated: 2024-11-05 01:06:10
-
Version 4739197
- created: 2024-11-05 00:44:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782860'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782860
- id: 4739197
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6664412
- updated: 2024-11-05 00:44:30
-
Version 4738483
- created: 2024-11-05 00:25:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782770'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782770
- id: 4738483
- processed: 1
- raw_data:
{ "account_id": 18, "activity_configuration_id": 5, "adults": 9, "amount": 24, "animals": 12, "cancelled_by": 31, "cancelled_when": 30, "children": 10, "configuration_included_adults": 13, "configuration_included_animals": 16, "configuration_included_children": 14, "configuration_included_infants": 15, "created_by": 33, "created_when": 32, "description": 21, "for": 6, "for_id": 7, "gl_account_id": 20, "gl_category_id": 19, "guests_memberships_id": 8, "id": 2, "infants": 11, "interval": 22, "interval_multiplier": 23, "inventory_item_id": 17, "newbook_region": 0, "per_adult": 25, "per_animal": 28, "per_child": 26, "per_infant": 27, "period_from": 3, "period_to": 4, "tax_free": 29, "tenant": 1 } - schema_attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - schema_name_id: 2433
- schema_scan_id: 6663694
- updated: 2024-11-05 00:25:51
Schema Scans: 15
Last at 2024-11-05 22:36:06
-
Scan 6674173
- duration: 0:00:12.495060
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6674173
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7434185867920817815, "service_name": "drive-thru", "span_id": 13724128060993080801, "trace_id": 17361184684536881844 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 22:36:06
- success: True
- trace_id: 17361184684536881844
-
Scan 6673723
- duration: 0:00:14.696655
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673723
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866292", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866292/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8025116364883706354, "service_name": "drive-thru", "span_id": 6778167045146493421, "trace_id": 10384601180252695298 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 22:23:28
- success: True
- trace_id: 10384601180252695298
-
Scan 6673408
- duration: 0:00:12.321160
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6673408
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866226", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866226/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4693412824410682069, "service_name": "drive-thru", "span_id": 16073550024466491883, "trace_id": 801899175152924621 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 22:14:24
- success: True
- trace_id: 801899175152924621
-
Scan 6671871
- duration: 0:00:14.928509
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671871
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785644", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785644/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16161073893865295639, "service_name": "drive-thru", "span_id": 10228498765881163967, "trace_id": 13930743223804455044 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 04:14:23
- success: True
- trace_id: 13930743223804455044
-
Scan 6671138
- duration: 0:00:12.331258
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6671138
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785078", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730785078/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1313077389629091736, "service_name": "drive-thru", "span_id": 5000478501316778214, "trace_id": 10970272040447177270 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 03:42:58
- success: True
- trace_id: 10970272040447177270
-
Scan 6670242
- duration: 0:00:12.120126
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6670242
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784773", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784773/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12766592831567477663, "service_name": "drive-thru", "span_id": 12185978319437884361, "trace_id": 1928246999357775040 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 03:18:41
- success: True
- trace_id: 1928246999357775040
-
Scan 6669488
- duration: 0:00:14.774068
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669488
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784170", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784170/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3353550467352764045, "service_name": "drive-thru", "span_id": 13844242448178198200, "trace_id": 13884435111246593039 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 02:58:28
- success: True
- trace_id: 13884435111246593039
-
Scan 6669206
- duration: 0:00:14.697848
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6669206
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784008", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730784008/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14308184531013860823, "service_name": "drive-thru", "span_id": 2194055758967769645, "trace_id": 10284531229482492721 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 02:51:07
- success: True
- trace_id: 10284531229482492721
-
Scan 6668066
- duration: 0:00:14.608636
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6668066
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783832", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783832/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7739961540954699889, "service_name": "drive-thru", "span_id": 15898302787989704389, "trace_id": 2700321837468819488 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 02:21:03
- success: True
- trace_id: 2700321837468819488
-
Scan 6667357
- duration: 0:00:14.347215
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667357
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783720", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783720/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4192729899848121788, "service_name": "drive-thru", "span_id": 2342773540366921975, "trace_id": 14277329947716498677 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 02:02:11
- success: True
- trace_id: 14277329947716498677
-
Scan 6667008
- duration: 0:00:14.781734
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6667008
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783629", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783629/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17795254653667978359, "service_name": "drive-thru", "span_id": 5899338987619363666, "trace_id": 2068115569249349667 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 01:52:50
- success: True
- trace_id: 2068115569249349667
-
Scan 6666096
- duration: 0:00:14.720986
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6666096
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783475", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783475/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8996769860609803501, "service_name": "drive-thru", "span_id": 17610437742025847367, "trace_id": 13622157031835175176 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 01:28:55
- success: True
- trace_id: 13622157031835175176
-
Scan 6665228
- duration: 0:00:12.160071
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6665228
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783257", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730783257/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1858059454461429866, "service_name": "drive-thru", "span_id": 2795968507157730061, "trace_id": 215148648953110529 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 01:05:58
- success: True
- trace_id: 215148648953110529
-
Scan 6664412
- duration: 0:00:12.291343
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6664412
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782860", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782860/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4356677874180487861, "service_name": "drive-thru", "span_id": 3965321228336642846, "trace_id": 4767747639665716908 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 00:44:17
- success: True
- trace_id: 4767747639665716908
-
Scan 6663694
- duration: 0:00:12.269606
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6663694
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-dev", "hive_path": "s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782770", "key": "raw/newbookdev_newbookactivities_tickets/2024-11-04/1730782770/activities_tickets.csv.gz" }, "schema": { "name": "sfdl_dev_drivethru.newbookdev_newbookactivities_tickets", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8814717329275731269, "service_name": "drive-thru", "span_id": 9441702712034436803, "trace_id": 4191864940974012415 } } - running: False
- schema_name_id: 2433
- start_time: 2024-11-05 00:25:38
- success: True
- trace_id: 4191864940974012415
- attributes:
{ "account_id": "string", "activity_configuration_id": "string", "adults": "string", "amount": "string", "animals": "string", "cancelled_by": "string", "cancelled_when": "string", "children": "string", "configuration_included_adults": "string", "configuration_included_animals": "string", "configuration_included_children": "string", "configuration_included_infants": "string", "created_by": "string", "created_when": "string", "description": "string", "for": "string", "for_id": "string", "gl_account_id": "string", "gl_category_id": "string", "guests_memberships_id": "string", "id": "string", "infants": "string", "interval": "string", "interval_multiplier": "string", "inventory_item_id": "string", "newbook_region": "string", "per_adult": "string", "per_animal": "string", "per_child": "string", "per_infant": "string", "period_from": "string", "period_to": "string", "tax_free": "string", "tenant": "string" } - created: 2024-11-05 22:36:07
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2024-10-08 17:38:44",
"disabled": false,
"format": "raw",
"id": 2433,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "newbookdev_newbookactivities_tickets"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"account_id": "string",
"activity_configuration_id": "string",
"adults": "string",
"amount": "string",
"animals": "string",
"cancelled_by": "string",
"cancelled_when": "string",
"children": "string",
"configuration_included_adults": "string",
"configuration_included_animals": "string",
"configuration_included_children": "string",
"configuration_included_infants": "string",
"created_by": "string",
"created_when": "string",
"description": "string",
"for": "string",
"for_id": "string",
"gl_account_id": "string",
"gl_category_id": "string",
"guests_memberships_id": "string",
"id": "string",
"infants": "string",
"interval": "string",
"interval_multiplier": "string",
"inventory_item_id": "string",
"newbook_region": "string",
"per_adult": "string",
"per_animal": "string",
"per_child": "string",
"per_infant": "string",
"period_from": "string",
"period_to": "string",
"tax_free": "string",
"tenant": "string"
},
"created": "2024-11-05 22:36:07",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`\n(\n `newbook_region` string , `tenant` string , `id` string , `period_from` string , `period_to` string , `activity_configuration_id` string , `for` string , `for_id` string , `guests_memberships_id` string , `adults` string , `children` string , `infants` string , `animals` string , `configuration_included_adults` string , `configuration_included_children` string , `configuration_included_infants` string , `configuration_included_animals` string , `inventory_item_id` string , `account_id` string , `gl_category_id` string , `gl_account_id` string , `description` string , `interval` string , `interval_multiplier` string , `amount` string , `per_adult` string , `per_child` string , `per_infant` string , `per_animal` string , `tax_free` string , `cancelled_when` string , `cancelled_by` string , `created_when` string , `created_by` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookactivities_tickets/2024-11-05/1730866356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookactivities_tickets`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookactivities_tickets"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}