Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles

created: 2024-10-08 17:41:16
disabled: False
format: raw
id: 2468
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "newbookdev_newbookclients_accounts_profiles"
}

type: drivethrucsv

Schema Versions: 15

Version 4748431

created: 2024-11-05 22:46:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-05/1730866409'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866409
id: 4748431
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6674463
updated: 2024-11-05 22:46:12

Version 4747940

created: 2024-11-05 22:29:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-05/1730866333'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866333
id: 4747940
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6673972
updated: 2024-11-05 22:30:09

Version 4747448

created: 2024-11-05 22:17:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-05/1730866251'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866251
id: 4747448
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6673481
updated: 2024-11-05 22:17:19

Version 4746671

created: 2024-11-05 04:15:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730785670'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730785670
id: 4746671
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6671895
updated: 2024-11-05 04:15:52

Version 4746253

created: 2024-11-05 03:55:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730785095'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730785095
id: 4746253
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6671474
updated: 2024-11-05 03:55:17

Version 4745143

created: 2024-11-05 03:21:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730784790'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784790
id: 4745143
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6670360
updated: 2024-11-05 03:21:59

Version 4744597

created: 2024-11-05 03:07:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730784186'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784186
id: 4744597
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6669814
updated: 2024-11-05 03:07:35

Version 4743724

created: 2024-11-05 02:44:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730784023'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784023
id: 4743724
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6668941
updated: 2024-11-05 02:44:21

Version 4743305

created: 2024-11-05 02:33:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730783876'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783876
id: 4743305
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6668522
updated: 2024-11-05 02:33:15

Version 4742400

created: 2024-11-05 02:09:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730783737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783737
id: 4742400
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6667617
updated: 2024-11-05 02:09:24

Version 4741861

created: 2024-11-05 01:54:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730783641'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783641
id: 4741861
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6667078
updated: 2024-11-05 01:54:57

Version 4740914

created: 2024-11-05 01:29:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730783492'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783492
id: 4740914
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6666131
updated: 2024-11-05 01:29:59

Version 4740087

created: 2024-11-05 01:08:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730783274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783274
id: 4740087
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6665304
updated: 2024-11-05 01:08:11

Version 4739386

created: 2024-11-05 00:49:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730782876'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730782876
id: 4739386
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6664601
updated: 2024-11-05 00:49:30

Version 4738920

created: 2024-11-05 00:37:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-04/1730782782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730782782
id: 4738920
processed: 1

raw_data:

{
    "default": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "tenant": 1,
    "type": 4
}

schema_attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

schema_name_id: 2468
schema_scan_id: 6664133
updated: 2024-11-05 00:37:17

Schema Scans: 15

Last at 2024-11-05 22:46:01

Scan 6674463

duration: 0:00:11.592398

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6674463

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_newbookclients_accounts_profiles/2024-11-05/1730866409",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866409/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1922102701790096899,
        "service_name": "drive-thru",
        "span_id": 6663911165228527117,
        "trace_id": 18121538602082081238
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 22:46:01
success: True
trace_id: 18121538602082081238

Scan 6673972

duration: 0:00:11.270458

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6673972

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_newbookclients_accounts_profiles/2024-11-05/1730866333",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866333/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18377047665009754233,
        "service_name": "drive-thru",
        "span_id": 14009674121761357213,
        "trace_id": 12551699781319744147
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 22:29:58
success: True
trace_id: 12551699781319744147

Scan 6673481

duration: 0:00:13.971734

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6673481

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_newbookclients_accounts_profiles/2024-11-05/1730866251",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-05/1730866251/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 821611199523235784,
        "service_name": "drive-thru",
        "span_id": 12716782997083034769,
        "trace_id": 11580885030910798344
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 22:17:05
success: True
trace_id: 11580885030910798344

Scan 6671895

duration: 0:00:14.027966

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671895

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_newbookclients_accounts_profiles/2024-11-04/1730785670",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730785670/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7210401506756942761,
        "service_name": "drive-thru",
        "span_id": 17682966884256955061,
        "trace_id": 7322348791021654124
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 04:15:38
success: True
trace_id: 7322348791021654124

Scan 6671474

duration: 0:00:14.021072

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6671474

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_newbookclients_accounts_profiles/2024-11-04/1730785095",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730785095/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9330563054765251803,
        "service_name": "drive-thru",
        "span_id": 10032971609177237223,
        "trace_id": 10621727001977653824
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 03:55:03
success: True
trace_id: 10621727001977653824

Scan 6670360

duration: 0:00:13.897711

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6670360

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_newbookclients_accounts_profiles/2024-11-04/1730784790",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784790/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4584662268054810099,
        "service_name": "drive-thru",
        "span_id": 7959513860741046887,
        "trace_id": 10623792558540381831
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 03:21:45
success: True
trace_id: 10623792558540381831

Scan 6669814

duration: 0:00:13.838866

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6669814

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_newbookclients_accounts_profiles/2024-11-04/1730784186",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784186/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7331141587339378025,
        "service_name": "drive-thru",
        "span_id": 17893347129723894216,
        "trace_id": 11182844620433104254
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 03:07:21
success: True
trace_id: 11182844620433104254

Scan 6668941

duration: 0:00:11.347282

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668941

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_newbookclients_accounts_profiles/2024-11-04/1730784023",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730784023/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14413054938421673913,
        "service_name": "drive-thru",
        "span_id": 5950997118709549139,
        "trace_id": 11083922530902302465
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 02:44:10
success: True
trace_id: 11083922530902302465

Scan 6668522

duration: 0:00:11.383555

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6668522

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_newbookclients_accounts_profiles/2024-11-04/1730783876",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783876/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3860823214539178036,
        "service_name": "drive-thru",
        "span_id": 17968512680938928754,
        "trace_id": 7944966293788961097
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 02:33:03
success: True
trace_id: 7944966293788961097

Scan 6667617

duration: 0:00:11.470123

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6667617

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_newbookclients_accounts_profiles/2024-11-04/1730783737",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783737/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7234163240223030532,
        "service_name": "drive-thru",
        "span_id": 17804543988026581897,
        "trace_id": 14404574606085597337
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 02:09:13
success: True
trace_id: 14404574606085597337

Scan 6667078

duration: 0:00:13.809107

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6667078

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_newbookclients_accounts_profiles/2024-11-04/1730783641",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783641/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4596040149739353589,
        "service_name": "drive-thru",
        "span_id": 17752136613499059118,
        "trace_id": 845383096463327667
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 01:54:43
success: True
trace_id: 845383096463327667

Scan 6666131

duration: 0:00:11.275500

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6666131

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_newbookclients_accounts_profiles/2024-11-04/1730783492",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783492/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9441912140369053641,
        "service_name": "drive-thru",
        "span_id": 7133244642156204273,
        "trace_id": 15609534593738730023
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 01:29:48
success: True
trace_id: 15609534593738730023

Scan 6665304

duration: 0:00:11.498650

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6665304

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_newbookclients_accounts_profiles/2024-11-04/1730783274",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730783274/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2573216638366143658,
        "service_name": "drive-thru",
        "span_id": 6309738174540211001,
        "trace_id": 8787148827281139361
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 01:07:59
success: True
trace_id: 8787148827281139361

Scan 6664601

duration: 0:00:11.329045

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6664601

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_newbookclients_accounts_profiles/2024-11-04/1730782876",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730782876/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13590519005048195728,
        "service_name": "drive-thru",
        "span_id": 9204419949859497430,
        "trace_id": 16636088535099346830
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 00:49:19
success: True
trace_id: 16636088535099346830

Scan 6664133

duration: 0:00:11.305067

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 6664133

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_newbookclients_accounts_profiles/2024-11-04/1730782782",
        "key": "raw/newbookdev_newbookclients_accounts_profiles/2024-11-04/1730782782/clients_accounts_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13518404241828949102,
        "service_name": "drive-thru",
        "span_id": 6856363630993542489,
        "trace_id": 11330398304820498446
    }
}

running: False
schema_name_id: 2468
start_time: 2024-11-05 00:37:06
success: True
trace_id: 11330398304820498446

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "default": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "tenant": "string",
    "type": "string"
}

created: 2024-11-05 22:46:01

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-05/1730866409'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2024-10-08 17:41:16",
        "disabled": false,
        "format": "raw",
        "id": 2468,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookclients_accounts_profiles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "default": "string",
            "id": "string",
            "name": "string",
            "newbook_region": "string",
            "tenant": "string",
            "type": "string"
        },
        "created": "2024-11-05 22:46:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `name`  string , `type`  string , `default`  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_newbookclients_accounts_profiles/2024-11-05/1730866409'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookclients_accounts_profiles"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}