Schema Info

Schema Name: sfdl_prod_drivethru.auctions_sa_states

created: 2025-10-15 19:05:32
disabled: False
format: raw
id: 4286
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "auctions_sa_states"
}

type: drivethrucsv

Schema Versions: 15

Version 1717285

created: 2026-04-16 19:09:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-16/1776384538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-16/1776384538
id: 1717285
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 162152405
updated: 2026-04-16 19:09:16

Version 1716057

created: 2026-04-15 19:09:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-15/1776298124'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-15/1776298124
id: 1716057
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 162096396
updated: 2026-04-15 19:09:14

Version 1714852

created: 2026-04-14 19:08:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-14/1776211735'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-14/1776211735
id: 1714852
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 162040877
updated: 2026-04-14 19:09:13

Version 1713652

created: 2026-04-13 19:09:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-13/1776125332'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-13/1776125332
id: 1713652
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161985265
updated: 2026-04-13 19:09:19

Version 1712438

created: 2026-04-12 19:09:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-12/1776038943'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-12/1776038943
id: 1712438
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161928043
updated: 2026-04-12 19:09:42

Version 1711245

created: 2026-04-11 19:09:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-11/1775952559'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-11/1775952559
id: 1711245
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161879315
updated: 2026-04-11 19:09:34

Version 1710035

created: 2026-04-10 19:10:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-10/1775866122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-10/1775866122
id: 1710035
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161826429
updated: 2026-04-10 19:11:00

Version 1708902

created: 2026-04-09 19:09:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-09/1775779750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-09/1775779750
id: 1708902
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161770547
updated: 2026-04-09 19:09:45

Version 1707757

created: 2026-04-08 19:08:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-08/1775693309'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-08/1775693309
id: 1707757
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161715261
updated: 2026-04-08 19:08:52

Version 1706530

created: 2026-04-07 19:08:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-07/1775606908'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-07/1775606908
id: 1706530
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161660069
updated: 2026-04-07 19:08:46

Version 1705354

created: 2026-04-06 19:09:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-06/1775520536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-06/1775520536
id: 1705354
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161603832
updated: 2026-04-06 19:09:36

Version 1704123

created: 2026-04-05 19:08:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-05/1775434117'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-05/1775434117
id: 1704123
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161546877
updated: 2026-04-05 19:09:08

Version 1702937

created: 2026-04-04 19:09:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-04/1775347750'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-04/1775347750
id: 1702937
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161500655
updated: 2026-04-04 19:09:33

Version 1701762

created: 2026-04-03 19:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-03/1775261334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-03/1775261334
id: 1701762
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161444678
updated: 2026-04-03 19:09:25

Version 1700551

created: 2026-04-02 19:08:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-02/1775174909'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-02/1775174909
id: 1700551
processed: 1

raw_data:

{
    "country_id": 3,
    "created_at": 6,
    "created_by": 5,
    "id": 0,
    "is_deleted": 8,
    "name": 1,
    "state_name": 2,
    "status": 4,
    "updated_at": 7
}

schema_attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

schema_name_id: 4286
schema_scan_id: 161386067
updated: 2026-04-02 19:08:47

Schema Scans: 15

Last at 2026-04-16 19:09:02

Scan 162152405

duration: 0:00:14.231113

exit_message:

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

id: 162152405

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-16/1776384538",
        "key": "raw/auctions_sa_states/2026-04-16/1776384538/sa_states_1776384002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18058321703996965156,
        "service_name": "drive-thru",
        "span_id": 2515580668346301480,
        "trace_id": 6835754189020794243
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-16 19:09:02
success: True
trace_id: 6835754189020794243

Scan 162096396

duration: 0:00:14.284014

exit_message:

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

id: 162096396

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-15/1776298124",
        "key": "raw/auctions_sa_states/2026-04-15/1776298124/sa_states_1776297601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17009548347595830302,
        "service_name": "drive-thru",
        "span_id": 7909534774185629007,
        "trace_id": 9406725295527749964
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-15 19:09:00
success: True
trace_id: 9406725295527749964

Scan 162040877

duration: 0:00:14.417537

exit_message:

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

id: 162040877

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-14/1776211735",
        "key": "raw/auctions_sa_states/2026-04-14/1776211735/sa_states_1776211201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10147877661379936734,
        "service_name": "drive-thru",
        "span_id": 10616278397788922882,
        "trace_id": 4523503618493275972
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-14 19:08:58
success: True
trace_id: 4523503618493275972

Scan 161985265

duration: 0:00:14.310342

exit_message:

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

id: 161985265

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-13/1776125332",
        "key": "raw/auctions_sa_states/2026-04-13/1776125332/sa_states_1776124802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18004306467580239649,
        "service_name": "drive-thru",
        "span_id": 11752520404749094700,
        "trace_id": 1144400056510931937
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-13 19:09:05
success: True
trace_id: 1144400056510931937

Scan 161928043

duration: 0:00:14.433794

exit_message:

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

id: 161928043

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-12/1776038943",
        "key": "raw/auctions_sa_states/2026-04-12/1776038943/sa_states_1776038402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13771141797708745657,
        "service_name": "drive-thru",
        "span_id": 5690709775376306585,
        "trace_id": 8663938711209341216
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-12 19:09:28
success: True
trace_id: 8663938711209341216

Scan 161879315

duration: 0:00:11.666501

exit_message:

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

id: 161879315

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-11/1775952559",
        "key": "raw/auctions_sa_states/2026-04-11/1775952559/sa_states_1775952002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11151585835748798588,
        "service_name": "drive-thru",
        "span_id": 10478778851170618304,
        "trace_id": 10169885028527280476
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-11 19:09:22
success: True
trace_id: 10169885028527280476

Scan 161826429

duration: 0:00:11.795906

exit_message:

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

id: 161826429

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-10/1775866122",
        "key": "raw/auctions_sa_states/2026-04-10/1775866122/sa_states_1775865602.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14403746087108429605,
        "service_name": "drive-thru",
        "span_id": 15529147269062614850,
        "trace_id": 2110877084022938150
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-10 19:10:48
success: True
trace_id: 2110877084022938150

Scan 161770547

duration: 0:00:14.338770

exit_message:

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

id: 161770547

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-09/1775779750",
        "key": "raw/auctions_sa_states/2026-04-09/1775779750/sa_states_1775779202.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11157142323007986805,
        "service_name": "drive-thru",
        "span_id": 8712792745672061051,
        "trace_id": 6024001464280073279
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-09 19:09:30
success: True
trace_id: 6024001464280073279

Scan 161715261

duration: 0:00:11.767714

exit_message:

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

id: 161715261

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-08/1775693309",
        "key": "raw/auctions_sa_states/2026-04-08/1775693309/sa_states_1775692802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9897845578234274665,
        "service_name": "drive-thru",
        "span_id": 13163946413351282565,
        "trace_id": 18277704692279408329
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-08 19:08:40
success: True
trace_id: 18277704692279408329

Scan 161660069

duration: 0:00:14.397647

exit_message:

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

id: 161660069

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-07/1775606908",
        "key": "raw/auctions_sa_states/2026-04-07/1775606908/sa_states_1775606402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 624498879744744482,
        "service_name": "drive-thru",
        "span_id": 13017487234277995237,
        "trace_id": 5247637751387571596
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-07 19:08:31
success: True
trace_id: 5247637751387571596

Scan 161603832

duration: 0:00:14.529804

exit_message:

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

id: 161603832

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-06/1775520536",
        "key": "raw/auctions_sa_states/2026-04-06/1775520536/sa_states_1775520002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12866485251534506794,
        "service_name": "drive-thru",
        "span_id": 9401537020832883210,
        "trace_id": 7921505224487460135
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-06 19:09:22
success: True
trace_id: 7921505224487460135

Scan 161546877

duration: 0:00:14.269983

exit_message:

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

id: 161546877

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-05/1775434117",
        "key": "raw/auctions_sa_states/2026-04-05/1775434117/sa_states_1775433601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6347289927822679597,
        "service_name": "drive-thru",
        "span_id": 3674751103251226792,
        "trace_id": 17278450156111050229
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-05 19:08:54
success: True
trace_id: 17278450156111050229

Scan 161500655

duration: 0:00:11.713943

exit_message:

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

id: 161500655

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-04/1775347750",
        "key": "raw/auctions_sa_states/2026-04-04/1775347750/sa_states_1775347201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3254732540099952190,
        "service_name": "drive-thru",
        "span_id": 2882800843833669801,
        "trace_id": 16152070471357773876
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-04 19:09:22
success: True
trace_id: 16152070471357773876

Scan 161444678

duration: 0:00:11.841620

exit_message:

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

id: 161444678

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-03/1775261334",
        "key": "raw/auctions_sa_states/2026-04-03/1775261334/sa_states_1775260801.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5428379642446754584,
        "service_name": "drive-thru",
        "span_id": 12211634011241099961,
        "trace_id": 4663388597444639463
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-03 19:09:13
success: True
trace_id: 4663388597444639463

Scan 161386067

duration: 0:00:14.273569

exit_message:

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

id: 161386067

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_states/2026-04-02/1775174909",
        "key": "raw/auctions_sa_states/2026-04-02/1775174909/sa_states_1775174402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_states",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5979048661432084640,
        "service_name": "drive-thru",
        "span_id": 18069997837549464104,
        "trace_id": 16388208662394990575
    }
}

running: False
schema_name_id: 4286
start_time: 2026-04-02 19:08:32
success: True
trace_id: 16388208662394990575

Partitions:

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

Schema:

attributes:

{
    "country_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "is_deleted": "string",
    "name": "string",
    "state_name": "string",
    "status": "string",
    "updated_at": "string"
}

created: 2026-04-16 19:09:03

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-16/1776384538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-10-15 19:05:32",
        "disabled": false,
        "format": "raw",
        "id": 4286,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "auctions_sa_states"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "country_id": "string",
            "created_at": "string",
            "created_by": "string",
            "id": "string",
            "is_deleted": "string",
            "name": "string",
            "state_name": "string",
            "status": "string",
            "updated_at": "string"
        },
        "created": "2026-04-16 19:09:03",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_states`\n(\n `id`  string , `name`  string , `state_name`  string , `country_id`  string , `status`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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-prod/raw/auctions_sa_states/2026-04-16/1776384538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_states`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_states"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}