Schema Info

Schema Name: sfdl_prod_drivethru.authsso_accountapplications

created: 2025-12-10 01:11:38
disabled: False
format: raw
id: 4297
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 8

Version 1576766

created: 2025-12-17 01:11:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-17/1765954833'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-17/1765954833
id: 1576766
processed: 1

raw_data:

{
    "accountId": "55f9313b-b70f-4ba9-b20b-8fc35f48e0c9",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T17:11:29.958Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T17:11:29.958Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155559823
updated: 2025-12-17 01:11:30

Version 1575650

created: 2025-12-16 01:11:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-16/1765868436'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-16/1765868436
id: 1575650
processed: 1

raw_data:

{
    "accountId": "9143f687-6eba-473d-87ed-8ae27a756394",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T17:11:10.988Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T17:11:10.988Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155505067
updated: 2025-12-16 01:12:07

Version 1574548

created: 2025-12-15 01:08:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-15/1765782035'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-15/1765782035
id: 1574548
processed: 1

raw_data:

{
    "accountId": "435fd08b-a43f-4940-ac99-b6f027c58c5d",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:49.166Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:49.166Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155446555
updated: 2025-12-15 01:09:01

Version 1573444

created: 2025-12-14 01:10:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-14/1765695632'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-14/1765695632
id: 1573444
processed: 1

raw_data:

{
    "accountId": "435fd08b-a43f-4940-ac99-b6f027c58c5d",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:49.166Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:49.166Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155397520
updated: 2025-12-14 01:10:26

Version 1572315

created: 2025-12-13 01:08:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-13/1765609233'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-13/1765609233
id: 1572315
processed: 1

raw_data:

{
    "accountId": "9a285ca0-955d-4ccc-a7c2-c7547ab25cbe",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:34.448Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:34.448Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155341925
updated: 2025-12-13 01:08:24

Version 1571177

created: 2025-12-12 01:13:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-12/1765522834'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-12/1765522834
id: 1571177
processed: 1

raw_data:

{
    "accountId": "564e2f36-28f8-493e-a11c-44600cf67738",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:45.532Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:45.532Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155285531
updated: 2025-12-12 01:13:57

Version 1570033

created: 2025-12-11 01:12:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-11/1765436434'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-11/1765436434
id: 1570033
processed: 1

raw_data:

{
    "accountId": "a4e00926-8c45-482a-ab4f-a1b42c0e35f4",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:28.171Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:28.171Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155227304
updated: 2025-12-11 01:12:50

Version 1568894

created: 2025-12-10 01:11:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-10/1765350036'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-10/1765350036
id: 1568894
processed: 1

raw_data:

{
    "accountId": "bc518766-bbf9-4563-8c5f-8b1b35b3fb1f",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:26.180Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:26.180Z"
}

schema_attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

schema_name_id: 4297
schema_scan_id: 155166948
updated: 2025-12-10 01:11:53

Schema Scans: 8

Last at 2025-12-17 01:11:16

Scan 155559823

duration: 0:00:14.321295

exit_message:

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

id: 155559823

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-17/1765954833",
        "key": "raw/authsso_accountapplications/2025-12-17/1765954833/part-00125.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6642043485782563514,
        "service_name": "drive-thru",
        "span_id": 2145163800176293604,
        "trace_id": 8278196554191831832
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-17 01:11:16
success: True
trace_id: 8278196554191831832

Scan 155505067

duration: 0:00:11.736499

exit_message:

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

id: 155505067

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-16/1765868436",
        "key": "raw/authsso_accountapplications/2025-12-16/1765868436/part-00125.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9735553459051548224,
        "service_name": "drive-thru",
        "span_id": 4953802777271928552,
        "trace_id": 9487878028130762598
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-16 01:11:55
success: True
trace_id: 9487878028130762598

Scan 155446555

duration: 0:00:14.339140

exit_message:

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

id: 155446555

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-15/1765782035",
        "key": "raw/authsso_accountapplications/2025-12-15/1765782035/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13608983303575506190,
        "service_name": "drive-thru",
        "span_id": 9882062301869673056,
        "trace_id": 5780407987717436414
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-15 01:08:46
success: True
trace_id: 5780407987717436414

Scan 155397520

duration: 0:00:14.239661

exit_message:

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

id: 155397520

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-14/1765695632",
        "key": "raw/authsso_accountapplications/2025-12-14/1765695632/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2501757821697201959,
        "service_name": "drive-thru",
        "span_id": 3063560799987460393,
        "trace_id": 18259693794222791849
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-14 01:10:12
success: True
trace_id: 18259693794222791849

Scan 155341925

duration: 0:00:14.417725

exit_message:

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

id: 155341925

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-13/1765609233",
        "key": "raw/authsso_accountapplications/2025-12-13/1765609233/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8910767724333777687,
        "service_name": "drive-thru",
        "span_id": 4536443941849027100,
        "trace_id": 4711265716911846211
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-13 01:08:10
success: True
trace_id: 4711265716911846211

Scan 155285531

duration: 0:00:14.270336

exit_message:

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

id: 155285531

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-12/1765522834",
        "key": "raw/authsso_accountapplications/2025-12-12/1765522834/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1603587641312987414,
        "service_name": "drive-thru",
        "span_id": 7585533923816681326,
        "trace_id": 5200708321474204887
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-12 01:13:42
success: True
trace_id: 5200708321474204887

Scan 155227304

duration: 0:00:14.470598

exit_message:

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

id: 155227304

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-11/1765436434",
        "key": "raw/authsso_accountapplications/2025-12-11/1765436434/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4663138547328648203,
        "service_name": "drive-thru",
        "span_id": 5448648850808913954,
        "trace_id": 15719115160127505134
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-11 01:12:36
success: True
trace_id: 15719115160127505134

Scan 155166948

duration: 0:00:14.379048

exit_message:

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

id: 155166948

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "applicationId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "updatedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-10/1765350036",
        "key": "raw/authsso_accountapplications/2025-12-10/1765350036/part-00124.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_accountapplications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10644448673780302777,
        "service_name": "drive-thru",
        "span_id": 5829031981619842176,
        "trace_id": 3086480144041096238
    }
}

running: False
schema_name_id: 4297
start_time: 2025-12-10 01:11:38
success: True
trace_id: 3086480144041096238

Partitions:

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

Schema:

attributes:

{
    "accountId": "string",
    "applicationId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "updatedAt": "date"
}

created: 2025-12-17 01:11:16

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-17/1765954833'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
}

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-12-10 01:11:38",
        "disabled": false,
        "format": "raw",
        "id": 4297,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "authsso_accountapplications"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accountId": "string",
            "applicationId": "string",
            "createdAt": "date",
            "deletedAt": "date",
            "updatedAt": "date"
        },
        "created": "2025-12-17 01:11:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_accountapplications/2025-12-17/1765954833'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_accountapplications`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_accountapplications"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}