Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookusers_profiles

created: 2024-10-08 18:41:12
disabled: False
format: raw
id: 3109
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4749513

created: 2024-11-05 23:59:43

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-05/1730866630
id: 4749513
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6675613
updated: 2024-11-05 23:59:54

Version 4749178

created: 2024-11-05 23:25:52

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-05/1730866592
id: 4749178
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6675210
updated: 2024-11-05 23:26:03

Version 4748951

created: 2024-11-05 23:10:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-05/1730866497
id: 4748951
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6674983
updated: 2024-11-05 23:10:46

Version 4747260

created: 2024-11-05 05:08:22

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730785830
id: 4747260
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6672530
updated: 2024-11-05 05:08:34

Version 4746569

created: 2024-11-05 04:10:05

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730785185
id: 4746569
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6671792
updated: 2024-11-05 04:10:16

Version 4745869

created: 2024-11-05 03:41:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730784881
id: 4745869
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6671086
updated: 2024-11-05 03:41:39

Version 4745013

created: 2024-11-05 03:18:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730784276
id: 4745013
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6670230
updated: 2024-11-05 03:18:30

Version 4744673

created: 2024-11-05 03:09:24

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730784115
id: 4744673
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6669890
updated: 2024-11-05 03:09:34

Version 4743654

created: 2024-11-05 02:42:20

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730783946
id: 4743654
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6668871
updated: 2024-11-05 02:42:33

Version 4743062

created: 2024-11-05 02:26:39

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730783828
id: 4743062
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6668279
updated: 2024-11-05 02:26:49

Version 4742230

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730783711
id: 4742230
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6667447
updated: 2024-11-05 02:04:48

Version 4741598

created: 2024-11-05 01:47:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730783586
id: 4741598
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6666815
updated: 2024-11-05 01:48:01

Version 4740800

created: 2024-11-05 01:26:49

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730783367
id: 4740800
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6666017
updated: 2024-11-05 01:27:02

Version 4739919

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730782963
id: 4739919
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6665136
updated: 2024-11-05 01:03:40

Version 4738693

created: 2024-11-05 00:31:07

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookusers_profiles/2024-11-04/1730782766
id: 4738693
processed: 1

raw_data:

{
    "active": 5,
    "id": 2,
    "name": 3,
    "newbook_region": 0,
    "privileges": 4,
    "tenant": 1
}

schema_attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

schema_name_id: 3109
schema_scan_id: 6663906
updated: 2024-11-05 00:31:18

Schema Scans: 15

Last at 2024-11-05 23:59:43

Scan 6675613

duration: 0:00:11.449624

exit_message:

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

id: 6675613

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_newbookusers_profiles/2024-11-05/1730866630",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-05/1730866630/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13634068007081164216,
        "service_name": "drive-thru",
        "span_id": 13161215461891459341,
        "trace_id": 10402611829825828913
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 23:59:43
success: True
trace_id: 10402611829825828913

Scan 6675210

duration: 0:00:11.533015

exit_message:

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

id: 6675210

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_newbookusers_profiles/2024-11-05/1730866592",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-05/1730866592/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 502086919300573131,
        "service_name": "drive-thru",
        "span_id": 16015522914940804853,
        "trace_id": 15683357063473178962
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 23:25:51
success: True
trace_id: 15683357063473178962

Scan 6674983

duration: 0:00:13.997013

exit_message:

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

id: 6674983

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_newbookusers_profiles/2024-11-05/1730866497",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-05/1730866497/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13916544991164990908,
        "service_name": "drive-thru",
        "span_id": 17659918560366854780,
        "trace_id": 3481097365649350352
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 23:10:32
success: True
trace_id: 3481097365649350352

Scan 6672530

duration: 0:00:11.537936

exit_message:

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

id: 6672530

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_newbookusers_profiles/2024-11-04/1730785830",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730785830/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12050111257138492253,
        "service_name": "drive-thru",
        "span_id": 815526917763266089,
        "trace_id": 1856788311482668091
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 05:08:22
success: True
trace_id: 1856788311482668091

Scan 6671792

duration: 0:00:11.476513

exit_message:

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

id: 6671792

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_newbookusers_profiles/2024-11-04/1730785185",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730785185/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1495935347468275336,
        "service_name": "drive-thru",
        "span_id": 12768587852795838644,
        "trace_id": 17547591500746661885
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 04:10:05
success: True
trace_id: 17547591500746661885

Scan 6671086

duration: 0:00:11.476747

exit_message:

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

id: 6671086

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_newbookusers_profiles/2024-11-04/1730784881",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730784881/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14784491889117957998,
        "service_name": "drive-thru",
        "span_id": 15090551606190567289,
        "trace_id": 12717250907001872093
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 03:41:28
success: True
trace_id: 12717250907001872093

Scan 6670230

duration: 0:00:11.413850

exit_message:

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

id: 6670230

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_newbookusers_profiles/2024-11-04/1730784276",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730784276/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12353817595922050494,
        "service_name": "drive-thru",
        "span_id": 4680857730778779000,
        "trace_id": 6093589412708617393
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 03:18:18
success: True
trace_id: 6093589412708617393

Scan 6669890

duration: 0:00:11.405580

exit_message:

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

id: 6669890

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_newbookusers_profiles/2024-11-04/1730784115",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730784115/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14000193650071377204,
        "service_name": "drive-thru",
        "span_id": 15739430405415005332,
        "trace_id": 6500144054085335707
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 03:09:23
success: True
trace_id: 6500144054085335707

Scan 6668871

duration: 0:00:13.950223

exit_message:

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

id: 6668871

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_newbookusers_profiles/2024-11-04/1730783946",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730783946/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9187892729615156843,
        "service_name": "drive-thru",
        "span_id": 1779625888902992571,
        "trace_id": 9179668987684314652
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 02:42:19
success: True
trace_id: 9179668987684314652

Scan 6668279

duration: 0:00:11.352300

exit_message:

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

id: 6668279

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_newbookusers_profiles/2024-11-04/1730783828",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730783828/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12822086321872504709,
        "service_name": "drive-thru",
        "span_id": 8307713754192559387,
        "trace_id": 17844744425368992751
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 02:26:38
success: True
trace_id: 17844744425368992751

Scan 6667447

duration: 0:00:11.291645

exit_message:

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

id: 6667447

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_newbookusers_profiles/2024-11-04/1730783711",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730783711/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5691451626698624624,
        "service_name": "drive-thru",
        "span_id": 5677668758119772627,
        "trace_id": 16636211677609377590
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 02:04:37
success: True
trace_id: 16636211677609377590

Scan 6666815

duration: 0:00:11.290396

exit_message:

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

id: 6666815

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_newbookusers_profiles/2024-11-04/1730783586",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730783586/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2588910239721293566,
        "service_name": "drive-thru",
        "span_id": 3473528613770017551,
        "trace_id": 10641000341469824151
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 01:47:49
success: True
trace_id: 10641000341469824151

Scan 6666017

duration: 0:00:14.080518

exit_message:

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

id: 6666017

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_newbookusers_profiles/2024-11-04/1730783367",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730783367/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1993207416938480765,
        "service_name": "drive-thru",
        "span_id": 4818298758385192106,
        "trace_id": 4145031086284273920
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 01:26:48
success: True
trace_id: 4145031086284273920

Scan 6665136

duration: 0:00:11.274329

exit_message:

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

id: 6665136

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_newbookusers_profiles/2024-11-04/1730782963",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730782963/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7331874764094661299,
        "service_name": "drive-thru",
        "span_id": 12601502783845538849,
        "trace_id": 3837389375132045478
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 01:03:29
success: True
trace_id: 3837389375132045478

Scan 6663906

duration: 0:00:11.504421

exit_message:

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

id: 6663906

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_newbookusers_profiles/2024-11-04/1730782766",
        "key": "raw/newbookdev_newbookusers_profiles/2024-11-04/1730782766/users_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookusers_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13135111964638431578,
        "service_name": "drive-thru",
        "span_id": 12458623463825719118,
        "trace_id": 1200682404173381826
    }
}

running: False
schema_name_id: 3109
start_time: 2024-11-05 00:31:06
success: True
trace_id: 1200682404173381826

Partitions:

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

Schema:

attributes:

{
    "active": "string",
    "id": "string",
    "name": "string",
    "newbook_region": "string",
    "privileges": "string",
    "tenant": "string"
}

created: 2024-11-05 23:59:43

ddl:

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