Schema Info

Schema Name: sfdl_dev_drivethru.testbasicauth_demotable

created: 2022-06-16 15:42:02
disabled: False
format: raw
id: 1826
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 4689385

created: 2022-06-17 10:23:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479416'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479416
id: 4689385
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936686
updated: 2022-06-17 10:23:51

Version 4689384

created: 2022-06-17 10:22:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479356
id: 4689384
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936685
updated: 2022-06-17 10:23:10

Version 4689383

created: 2022-06-17 10:20:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479225'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479225
id: 4689383
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936684
updated: 2022-06-17 10:20:40

Version 4689382

created: 2022-06-17 10:20:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479193'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479193
id: 4689382
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936682
updated: 2022-06-17 10:20:23

Version 4689381

created: 2022-06-17 10:18:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479120'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479120
id: 4689381
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936681
updated: 2022-06-17 10:18:54

Version 4689380

created: 2022-06-17 10:18:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655479073
id: 4689380
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936680
updated: 2022-06-17 10:18:33

Version 4689379

created: 2022-06-17 10:16:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655478948'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655478948
id: 4689379
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936676
updated: 2022-06-17 10:16:27

Version 4689378

created: 2022-06-17 10:13:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655478835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655478835
id: 4689378
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936675
updated: 2022-06-17 10:14:10

Version 4689377

created: 2022-06-17 10:13:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655478807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-17/1655478807
id: 4689377
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936673
updated: 2022-06-17 10:14:07

Version 4689375

created: 2022-06-16 17:04:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655417038'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655417038
id: 4689375
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936576
updated: 2022-06-16 17:04:27

Version 4689374

created: 2022-06-16 17:03:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655417003'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655417003
id: 4689374
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936575
updated: 2022-06-16 17:03:47

Version 4689373

created: 2022-06-16 17:03:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655416965'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655416965
id: 4689373
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936573
updated: 2022-06-16 17:03:18

Version 4689372

created: 2022-06-16 16:36:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655415369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655415369
id: 4689372
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936559
updated: 2022-06-16 16:36:34

Version 4689365

created: 2022-06-16 15:59:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655413134'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655413134
id: 4689365
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936541
updated: 2022-06-16 15:59:11

Version 4689364

created: 2022-06-16 15:42:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-16/1655412112'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-dev/raw/testbasicauth_demotable/2022-06-16/1655412112
id: 4689364
processed: 1

raw_data:

{
    "Animal": 1,
    "Breed": 2,
    "Name": 0,
    "Owner": 3
}

schema_attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

schema_name_id: 1826
schema_scan_id: 5936532
updated: 2022-06-16 15:42:16

Schema Scans: 15

Last at 2022-06-17 10:23:39

Scan 5936686

duration: 0:00:14.202831

exit_message:

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

id: 5936686

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/testbasicauth_demotable/2022-06-17/1655479416",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479416/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14993812353640607409,
        "service_name": "drive-thru",
        "span_id": 4748324125690894454,
        "trace_id": 1322018862624493664
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:23:39
success: True
trace_id: 1322018862624493664

Scan 5936685

duration: 0:00:16.743995

exit_message:

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

id: 5936685

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/testbasicauth_demotable/2022-06-17/1655479356",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479356/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13829071682682339644,
        "service_name": "drive-thru",
        "span_id": 15963238449510269724,
        "trace_id": 10388561587755851075
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:22:56
success: True
trace_id: 10388561587755851075

Scan 5936684

duration: 0:00:14.260920

exit_message:

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

id: 5936684

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/testbasicauth_demotable/2022-06-17/1655479225",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479225/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10082985937530472677,
        "service_name": "drive-thru",
        "span_id": 6651051064923896803,
        "trace_id": 11596535669869837884
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:20:28
success: True
trace_id: 11596535669869837884

Scan 5936682

duration: 0:00:14.299297

exit_message:

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

id: 5936682

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/testbasicauth_demotable/2022-06-17/1655479193",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479193/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10616956003020251543,
        "service_name": "drive-thru",
        "span_id": 1054654750880441764,
        "trace_id": 14920747831458131253
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:20:12
success: True
trace_id: 14920747831458131253

Scan 5936681

duration: 0:00:14.113767

exit_message:

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

id: 5936681

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/testbasicauth_demotable/2022-06-17/1655479120",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479120/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15121713716187015935,
        "service_name": "drive-thru",
        "span_id": 10399371306309755919,
        "trace_id": 5570672442033310757
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:18:43
success: True
trace_id: 5570672442033310757

Scan 5936680

duration: 0:00:14.288267

exit_message:

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

id: 5936680

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/testbasicauth_demotable/2022-06-17/1655479073",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655479073/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13568232409147677993,
        "service_name": "drive-thru",
        "span_id": 16564508452956773710,
        "trace_id": 16389975949327123227
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:18:22
success: True
trace_id: 16389975949327123227

Scan 5936676

duration: 0:00:14.166459

exit_message:

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

id: 5936676

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/testbasicauth_demotable/2022-06-17/1655478948",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655478948/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6428411490655908726,
        "service_name": "drive-thru",
        "span_id": 3081475327260359703,
        "trace_id": 16332073037052354969
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:16:15
success: True
trace_id: 16332073037052354969

Scan 5936675

duration: 0:00:14.268072

exit_message:

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

id: 5936675

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/testbasicauth_demotable/2022-06-17/1655478835",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655478835/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 714864148886370153,
        "service_name": "drive-thru",
        "span_id": 10217348259731710975,
        "trace_id": 9768558697166519434
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:13:58
success: True
trace_id: 9768558697166519434

Scan 5936673

duration: 0:00:14.101267

exit_message:

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

id: 5936673

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/testbasicauth_demotable/2022-06-17/1655478807",
        "key": "raw/testbasicauth_demotable/2022-06-17/1655478807/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8490346139832428576,
        "service_name": "drive-thru",
        "span_id": 10253274868283385042,
        "trace_id": 310341902698317186
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-17 10:13:56
success: True
trace_id: 310341902698317186

Scan 5936576

duration: 0:00:14.119080

exit_message:

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

id: 5936576

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/testbasicauth_demotable/2022-06-16/1655417038",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655417038/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4702533743573612183,
        "service_name": "drive-thru",
        "span_id": 1226734208567756401,
        "trace_id": 4144711751246314501
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 17:04:16
success: True
trace_id: 4144711751246314501

Scan 5936575

duration: 0:00:14.085061

exit_message:

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

id: 5936575

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/testbasicauth_demotable/2022-06-16/1655417003",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655417003/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15289427492428459343,
        "service_name": "drive-thru",
        "span_id": 5088883352832259782,
        "trace_id": 9989773562815306635
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 17:03:35
success: True
trace_id: 9989773562815306635

Scan 5936573

duration: 0:00:14.128117

exit_message:

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

id: 5936573

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/testbasicauth_demotable/2022-06-16/1655416965",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655416965/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17485359652606471791,
        "service_name": "drive-thru",
        "span_id": 17341178332075111497,
        "trace_id": 1614528182251902429
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 17:03:06
success: True
trace_id: 1614528182251902429

Scan 5936559

duration: 0:00:14.147662

exit_message:

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

id: 5936559

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/testbasicauth_demotable/2022-06-16/1655415369",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655415369/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10694095488740125244,
        "service_name": "drive-thru",
        "span_id": 2742530416754693393,
        "trace_id": 5101882879727104346
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 16:36:23
success: True
trace_id: 5101882879727104346

Scan 5936541

duration: 0:00:14.258183

exit_message:

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

id: 5936541

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/testbasicauth_demotable/2022-06-16/1655413134",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655413134/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13200288218182315252,
        "service_name": "drive-thru",
        "span_id": 11739756465791555539,
        "trace_id": 4518512985243603680
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 15:59:00
success: True
trace_id: 4518512985243603680

Scan 5936532

duration: 0:00:16.840388

exit_message:

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

id: 5936532

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/testbasicauth_demotable/2022-06-16/1655412112",
        "key": "raw/testbasicauth_demotable/2022-06-16/1655412112/pets.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.testbasicauth_demotable",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10886311267671085654,
        "service_name": "drive-thru",
        "span_id": 2003118009160128761,
        "trace_id": 8965976555368276967
    }
}

running: False
schema_name_id: 1826
start_time: 2022-06-16 15:42:02
success: True
trace_id: 8965976555368276967

Partitions:

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

Schema:

attributes:

{
    "Animal": "string",
    "Breed": "string",
    "Name": "string",
    "Owner": "string"
}

created: 2022-06-17 10:23:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479416'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-06-16 15:42:02",
        "disabled": false,
        "format": "raw",
        "id": 1826,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "testbasicauth_demotable"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Animal": "string",
            "Breed": "string",
            "Name": "string",
            "Owner": "string"
        },
        "created": "2022-06-17 10:23:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.testbasicauth_demotable`\n(\n `Name`  string , `Animal`  string , `Breed`  string , `Owner`  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/testbasicauth_demotable/2022-06-17/1655479416'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.testbasicauth_demotable`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.testbasicauth_demotable"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}