Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles

created: 2024-10-08 18:00:27
disabled: False
format: raw
id: 2732
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748839

created: 2024-11-05 23:04:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-05/1730866513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866513
id: 4748839
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: 2732
schema_scan_id: 6674871
updated: 2024-11-05 23:04:30

Version 4748427

created: 2024-11-05 22:45:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-05/1730866439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866439
id: 4748427
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: 2732
schema_scan_id: 6674459
updated: 2024-11-05 22:46:07

Version 4747836

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-05/1730866316'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866316
id: 4747836
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: 2732
schema_scan_id: 6673868
updated: 2024-11-05 22:27:30

Version 4747051

created: 2024-11-05 04:45:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730785726'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730785726
id: 4747051
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: 2732
schema_scan_id: 6672283
updated: 2024-11-05 04:45:18

Version 4746217

created: 2024-11-05 03:53:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730785127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730785127
id: 4746217
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: 2732
schema_scan_id: 6671438
updated: 2024-11-05 03:53:45

Version 4745843

created: 2024-11-05 03:40:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730784822'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784822
id: 4745843
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: 2732
schema_scan_id: 6671061
updated: 2024-11-05 03:40:50

Version 4745200

created: 2024-11-05 03:23:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730784218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784218
id: 4745200
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: 2732
schema_scan_id: 6670417
updated: 2024-11-05 03:23:24

Version 4743398

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730784056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784056
id: 4743398
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: 2732
schema_scan_id: 6668615
updated: 2024-11-05 02:35:50

Version 4742661

created: 2024-11-05 02:16:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730783901'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783901
id: 4742661
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: 2732
schema_scan_id: 6667879
updated: 2024-11-05 02:16:20

Version 4742638

created: 2024-11-05 02:15:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730783770'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783770
id: 4742638
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: 2732
schema_scan_id: 6667855
updated: 2024-11-05 02:15:41

Version 4741657

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730783610'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783610
id: 4741657
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: 2732
schema_scan_id: 6666874
updated: 2024-11-05 01:49:32

Version 4741132

created: 2024-11-05 01:35:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730783526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783526
id: 4741132
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: 2732
schema_scan_id: 6666349
updated: 2024-11-05 01:35:47

Version 4740426

created: 2024-11-05 01:16:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730783308'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783308
id: 4740426
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: 2732
schema_scan_id: 6665643
updated: 2024-11-05 01:17:09

Version 4739486

created: 2024-11-05 00:51:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730782908'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730782908
id: 4739486
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: 2732
schema_scan_id: 6664701
updated: 2024-11-05 00:52:05

Version 4738965

created: 2024-11-05 00:38:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-04/1730782807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730782807
id: 4738965
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: 2732
schema_scan_id: 6664179
updated: 2024-11-05 00:38:32

Schema Scans: 15

Last at 2024-11-05 23:04:19

Scan 6674871

duration: 0:00:11.632555

exit_message:

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

id: 6674871

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_newbookinstances_login_profiles/2024-11-05/1730866513",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866513/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14599907436217729361,
        "service_name": "drive-thru",
        "span_id": 15770616381321494310,
        "trace_id": 3221250691206091925
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 23:04:19
success: True
trace_id: 3221250691206091925

Scan 6674459

duration: 0:00:11.523187

exit_message:

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

id: 6674459

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_newbookinstances_login_profiles/2024-11-05/1730866439",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866439/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14073572103342686108,
        "service_name": "drive-thru",
        "span_id": 9638028595714064767,
        "trace_id": 16490300777361929397
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 22:45:55
success: True
trace_id: 16490300777361929397

Scan 6673868

duration: 0:00:13.776578

exit_message:

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

id: 6673868

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_newbookinstances_login_profiles/2024-11-05/1730866316",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-05/1730866316/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7897019121402628278,
        "service_name": "drive-thru",
        "span_id": 1273816799800441710,
        "trace_id": 12732710094066454281
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 22:27:16
success: True
trace_id: 12732710094066454281

Scan 6672283

duration: 0:00:14.007458

exit_message:

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

id: 6672283

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_newbookinstances_login_profiles/2024-11-04/1730785726",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730785726/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10006982627576285276,
        "service_name": "drive-thru",
        "span_id": 6223195655457146049,
        "trace_id": 16457154410078351994
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 04:45:04
success: True
trace_id: 16457154410078351994

Scan 6671438

duration: 0:00:13.975918

exit_message:

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

id: 6671438

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_newbookinstances_login_profiles/2024-11-04/1730785127",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730785127/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3069595525375765858,
        "service_name": "drive-thru",
        "span_id": 12729825754008996894,
        "trace_id": 453721691532129315
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 03:53:31
success: True
trace_id: 453721691532129315

Scan 6671061

duration: 0:00:11.434412

exit_message:

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

id: 6671061

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_newbookinstances_login_profiles/2024-11-04/1730784822",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784822/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13010053505280433776,
        "service_name": "drive-thru",
        "span_id": 17065750967072947928,
        "trace_id": 13279549438338889201
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 03:40:39
success: True
trace_id: 13279549438338889201

Scan 6670417

duration: 0:00:11.254226

exit_message:

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

id: 6670417

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_newbookinstances_login_profiles/2024-11-04/1730784218",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784218/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1353608030517861880,
        "service_name": "drive-thru",
        "span_id": 17183866486306295478,
        "trace_id": 11174760859876398390
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 03:23:13
success: True
trace_id: 11174760859876398390

Scan 6668615

duration: 0:00:13.850197

exit_message:

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

id: 6668615

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_newbookinstances_login_profiles/2024-11-04/1730784056",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730784056/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16569497436441248620,
        "service_name": "drive-thru",
        "span_id": 18141221156345499760,
        "trace_id": 17472467182617497278
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 02:35:36
success: True
trace_id: 17472467182617497278

Scan 6667879

duration: 0:00:13.888037

exit_message:

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

id: 6667879

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_newbookinstances_login_profiles/2024-11-04/1730783901",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783901/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17164415763904413395,
        "service_name": "drive-thru",
        "span_id": 12541855051192599005,
        "trace_id": 4280470539246972670
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 02:16:06
success: True
trace_id: 4280470539246972670

Scan 6667855

duration: 0:00:13.824149

exit_message:

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

id: 6667855

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_newbookinstances_login_profiles/2024-11-04/1730783770",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783770/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17951021822748615458,
        "service_name": "drive-thru",
        "span_id": 11265578208949831121,
        "trace_id": 15292874916921435807
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 02:15:28
success: True
trace_id: 15292874916921435807

Scan 6666874

duration: 0:00:11.353458

exit_message:

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

id: 6666874

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_newbookinstances_login_profiles/2024-11-04/1730783610",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783610/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3128022170140043451,
        "service_name": "drive-thru",
        "span_id": 3102645986925620815,
        "trace_id": 8593621420868847811
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 01:49:21
success: True
trace_id: 8593621420868847811

Scan 6666349

duration: 0:00:11.547240

exit_message:

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

id: 6666349

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_newbookinstances_login_profiles/2024-11-04/1730783526",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783526/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16015410303093333690,
        "service_name": "drive-thru",
        "span_id": 10083628393986685387,
        "trace_id": 469783402214472878
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 01:35:35
success: True
trace_id: 469783402214472878

Scan 6665643

duration: 0:00:11.434073

exit_message:

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

id: 6665643

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_newbookinstances_login_profiles/2024-11-04/1730783308",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730783308/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 500030048784342492,
        "service_name": "drive-thru",
        "span_id": 14418920234387575560,
        "trace_id": 17743388836590150857
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 01:16:58
success: True
trace_id: 17743388836590150857

Scan 6664701

duration: 0:00:11.443401

exit_message:

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

id: 6664701

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_newbookinstances_login_profiles/2024-11-04/1730782908",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730782908/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12880937040394285999,
        "service_name": "drive-thru",
        "span_id": 11025238546820029114,
        "trace_id": 13812555032302635669
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 00:51:54
success: True
trace_id: 13812555032302635669

Scan 6664179

duration: 0:00:14.136100

exit_message:

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

id: 6664179

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_newbookinstances_login_profiles/2024-11-04/1730782807",
        "key": "raw/newbookdev_newbookinstances_login_profiles/2024-11-04/1730782807/instances_login_profiles.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17056324400223210428,
        "service_name": "drive-thru",
        "span_id": 3386880994317286653,
        "trace_id": 3453901094672384559
    }
}

running: False
schema_name_id: 2732
start_time: 2024-11-05 00:38:18
success: True
trace_id: 3453901094672384559

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:04:19

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-05/1730866513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_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:00:27",
        "disabled": false,
        "format": "raw",
        "id": 2732,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookinstances_login_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:04:19",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookinstances_login_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_newbookinstances_login_profiles/2024-11-05/1730866513'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookinstances_login_profiles"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}