Schema Info

Schema Name: sfdl_dev_drivethru.newbookdev_newbookaccess_cards

created: 2024-10-08 17:35:49
disabled: False
format: raw
id: 2396
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4748008

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-05/1730866340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-05/1730866340
id: 4748008
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6674040
updated: 2024-11-05 22:32:16

Version 4747627

created: 2024-11-05 22:21:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-05/1730866279'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-05/1730866279
id: 4747627
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6673659
updated: 2024-11-05 22:22:01

Version 4747332

created: 2024-11-05 22:10:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-05/1730866220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-05/1730866220
id: 4747332
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6673364
updated: 2024-11-05 22:10:50

Version 4746594

created: 2024-11-05 04:11:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730785634'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730785634
id: 4746594
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6671817
updated: 2024-11-05 04:11:37

Version 4745871

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730785073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730785073
id: 4745871
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6671088
updated: 2024-11-05 03:41:43

Version 4745035

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730784768'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730784768
id: 4745035
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6670252
updated: 2024-11-05 03:19:08

Version 4744231

created: 2024-11-05 02:57:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730784164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730784164
id: 4744231
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6669448
updated: 2024-11-05 02:57:34

Version 4743691

created: 2024-11-05 02:43:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730784002'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730784002
id: 4743691
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6668908
updated: 2024-11-05 02:43:28

Version 4743359

created: 2024-11-05 02:34:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730783860'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730783860
id: 4743359
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6668576
updated: 2024-11-05 02:34:43

Version 4742271

created: 2024-11-05 02:05:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730783715'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730783715
id: 4742271
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6667488
updated: 2024-11-05 02:05:56

Version 4741538

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730783625'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730783625
id: 4741538
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6666755
updated: 2024-11-05 01:46:23

Version 4740701

created: 2024-11-05 01:24:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730783470'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730783470
id: 4740701
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6665918
updated: 2024-11-05 01:24:28

Version 4739979

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730783252'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730783252
id: 4739979
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6665196
updated: 2024-11-05 01:05:19

Version 4739403

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730782854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730782854
id: 4739403
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6664618
updated: 2024-11-05 00:49:54

Version 4738431

created: 2024-11-05 00:24:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-04/1730782737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/newbookdev_newbookaccess_cards/2024-11-04/1730782737
id: 4738431
processed: 1

raw_data:

{
    "access_code": 4,
    "active": 7,
    "available": 6,
    "card_name": 3,
    "id": 2,
    "newbook_region": 0,
    "site_id": 5,
    "tenant": 1
}

schema_attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

schema_name_id: 2396
schema_scan_id: 6663642
updated: 2024-11-05 00:24:28

Schema Scans: 15

Last at 2024-11-05 22:32:02

Scan 6674040

duration: 0:00:14.045047

exit_message:

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

id: 6674040

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_newbookaccess_cards/2024-11-05/1730866340",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-05/1730866340/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 714454209529403588,
        "service_name": "drive-thru",
        "span_id": 13836238480863874299,
        "trace_id": 1805207466665705729
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 22:32:02
success: True
trace_id: 1805207466665705729

Scan 6673659

duration: 0:00:11.354989

exit_message:

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

id: 6673659

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_newbookaccess_cards/2024-11-05/1730866279",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-05/1730866279/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 28233721737214728,
        "service_name": "drive-thru",
        "span_id": 15117409196900467942,
        "trace_id": 11171880031953074043
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 22:21:50
success: True
trace_id: 11171880031953074043

Scan 6673364

duration: 0:00:14.217827

exit_message:

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

id: 6673364

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_newbookaccess_cards/2024-11-05/1730866220",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-05/1730866220/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10304163103904795489,
        "service_name": "drive-thru",
        "span_id": 5337556541835357789,
        "trace_id": 17745478210209088873
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 22:10:36
success: True
trace_id: 17745478210209088873

Scan 6671817

duration: 0:00:11.517283

exit_message:

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

id: 6671817

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_newbookaccess_cards/2024-11-04/1730785634",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730785634/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15956536100628022199,
        "service_name": "drive-thru",
        "span_id": 3485551889492220499,
        "trace_id": 10716175631661622488
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 04:11:26
success: True
trace_id: 10716175631661622488

Scan 6671088

duration: 0:00:13.977128

exit_message:

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

id: 6671088

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_newbookaccess_cards/2024-11-04/1730785073",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730785073/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 218080410596457447,
        "service_name": "drive-thru",
        "span_id": 14424513928894849349,
        "trace_id": 8111526986158316405
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 03:41:29
success: True
trace_id: 8111526986158316405

Scan 6670252

duration: 0:00:13.903494

exit_message:

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

id: 6670252

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_newbookaccess_cards/2024-11-04/1730784768",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730784768/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4260083041252470521,
        "service_name": "drive-thru",
        "span_id": 1373204968288163138,
        "trace_id": 5804810316695818736
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 03:18:54
success: True
trace_id: 5804810316695818736

Scan 6669448

duration: 0:00:11.480386

exit_message:

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

id: 6669448

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_newbookaccess_cards/2024-11-04/1730784164",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730784164/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6052268308128943699,
        "service_name": "drive-thru",
        "span_id": 11272461248844069316,
        "trace_id": 12382463711741937095
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 02:57:23
success: True
trace_id: 12382463711741937095

Scan 6668908

duration: 0:00:11.634449

exit_message:

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

id: 6668908

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_newbookaccess_cards/2024-11-04/1730784002",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730784002/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15813457459196213327,
        "service_name": "drive-thru",
        "span_id": 6061795533260043738,
        "trace_id": 11197573220423376457
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 02:43:16
success: True
trace_id: 11197573220423376457

Scan 6668576

duration: 0:00:11.424413

exit_message:

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

id: 6668576

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_newbookaccess_cards/2024-11-04/1730783860",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730783860/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12845913439381118935,
        "service_name": "drive-thru",
        "span_id": 14218682507850816774,
        "trace_id": 18343769048344563395
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 02:34:32
success: True
trace_id: 18343769048344563395

Scan 6667488

duration: 0:00:11.498899

exit_message:

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

id: 6667488

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_newbookaccess_cards/2024-11-04/1730783715",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730783715/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1418758354833280837,
        "service_name": "drive-thru",
        "span_id": 11651514658159428908,
        "trace_id": 1532071710889553065
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 02:05:44
success: True
trace_id: 1532071710889553065

Scan 6666755

duration: 0:00:11.453633

exit_message:

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

id: 6666755

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_newbookaccess_cards/2024-11-04/1730783625",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730783625/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 835873839742834833,
        "service_name": "drive-thru",
        "span_id": 14389778507733698748,
        "trace_id": 17610260442785926234
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 01:46:12
success: True
trace_id: 17610260442785926234

Scan 6665918

duration: 0:00:13.827400

exit_message:

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

id: 6665918

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_newbookaccess_cards/2024-11-04/1730783470",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730783470/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15553544580656895520,
        "service_name": "drive-thru",
        "span_id": 1176838196885075226,
        "trace_id": 8028328435515037727
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 01:24:14
success: True
trace_id: 8028328435515037727

Scan 6665196

duration: 0:00:11.369942

exit_message:

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

id: 6665196

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_newbookaccess_cards/2024-11-04/1730783252",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730783252/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15774771409682371392,
        "service_name": "drive-thru",
        "span_id": 8764544079686386984,
        "trace_id": 9675909271111722035
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 01:05:08
success: True
trace_id: 9675909271111722035

Scan 6664618

duration: 0:00:11.378100

exit_message:

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

id: 6664618

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_newbookaccess_cards/2024-11-04/1730782854",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730782854/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3066211301671797336,
        "service_name": "drive-thru",
        "span_id": 291277067020278519,
        "trace_id": 11824820000139880404
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 00:49:42
success: True
trace_id: 11824820000139880404

Scan 6663642

duration: 0:00:11.496675

exit_message:

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

id: 6663642

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_newbookaccess_cards/2024-11-04/1730782737",
        "key": "raw/newbookdev_newbookaccess_cards/2024-11-04/1730782737/access_cards.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.newbookdev_newbookaccess_cards",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4106142210648676687,
        "service_name": "drive-thru",
        "span_id": 13021406080938766440,
        "trace_id": 8629203799432799725
    }
}

running: False
schema_name_id: 2396
start_time: 2024-11-05 00:24:16
success: True
trace_id: 8629203799432799725

Partitions:

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

Schema:

attributes:

{
    "access_code": "string",
    "active": "string",
    "available": "string",
    "card_name": "string",
    "id": "string",
    "newbook_region": "string",
    "site_id": "string",
    "tenant": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-05/1730866340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
}

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:35:49",
        "disabled": false,
        "format": "raw",
        "id": 2396,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "newbookdev_newbookaccess_cards"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "access_code": "string",
            "active": "string",
            "available": "string",
            "card_name": "string",
            "id": "string",
            "newbook_region": "string",
            "site_id": "string",
            "tenant": "string"
        },
        "created": "2024-11-05 22:32:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.newbookdev_newbookaccess_cards`\n(\n `newbook_region`  string , `tenant`  string , `id`  string , `card_name`  string , `access_code`  string , `site_id`  string , `available`  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_newbookaccess_cards/2024-11-05/1730866340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.newbookdev_newbookaccess_cards`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.newbookdev_newbookaccess_cards"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}