Schema Info

Schema Name: sfdl_prod_drivethru.authsso_account_applications

created: 2025-12-18 01:09:49
disabled: False
format: raw
id: 4301
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717529

created: 2026-04-17 02:01:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-17/1776409264'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-17/1776409264
id: 1717529
processed: 1

raw_data:

{
    "accountId": "cf19f8fb-bf01-4514-97d2-4b481c98e7dd",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:28.196Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:28.196Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 162166309
updated: 2026-04-17 02:01:49

Version 1716295

created: 2026-04-16 02:01:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-16/1776322839'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-16/1776322839
id: 1716295
processed: 1

raw_data:

{
    "accountId": "538e2a9d-ea64-44df-9902-740ba11f8add",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:11.524Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:11.524Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 162110432
updated: 2026-04-16 02:01:24

Version 1715104

created: 2026-04-15 02:01:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-15/1776236437'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-15/1776236437
id: 1715104
processed: 1

raw_data:

{
    "accountId": "bb0311b6-d812-4e56-b32a-bd9f1068425e",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-11-19T22:04:54.441Z",
    "deletedAt": null,
    "updatedAt": "2025-11-19T22:05:10.273Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 162054591
updated: 2026-04-15 02:01:23

Version 1713916

created: 2026-04-14 02:01:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-14/1776150064'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-14/1776150064
id: 1713916
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: 4301
schema_scan_id: 161998924
updated: 2026-04-14 02:02:11

Version 1712673

created: 2026-04-13 02:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-13/1776063656'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-13/1776063656
id: 1712673
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: 4301
schema_scan_id: 161941279
updated: 2026-04-13 02:01:37

Version 1711473

created: 2026-04-12 02:01:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-12/1775977237'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-12/1775977237
id: 1711473
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: 4301
schema_scan_id: 161891744
updated: 2026-04-12 02:01:17

Version 1710284

created: 2026-04-11 02:01:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-11/1775890836'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-11/1775890836
id: 1710284
processed: 1

raw_data:

{
    "accountId": "dfc72fae-ebbb-45d6-bd19-46700b561309",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:14.038Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:14.038Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161839868
updated: 2026-04-11 02:01:43

Version 1709124

created: 2026-04-10 02:01:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-10/1775804438'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-10/1775804438
id: 1709124
processed: 1

raw_data:

{
    "accountId": "af65b412-7ef8-49f0-89d4-8e854b34f0d3",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T17:11:45.316Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T17:11:45.316Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161784402
updated: 2026-04-10 02:01:24

Version 1707983

created: 2026-04-09 02:01:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-09/1775718039'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-09/1775718039
id: 1707983
processed: 1

raw_data:

{
    "accountId": "59f9a8ea-e4b0-4273-92d4-c00577c43de2",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:30.959Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:30.959Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161729182
updated: 2026-04-09 02:01:35

Version 1706772

created: 2026-04-08 02:01:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-08/1775631639'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-08/1775631639
id: 1706772
processed: 1

raw_data:

{
    "accountId": "8a71add1-f1a2-4845-8abe-95784a3cf390",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T22:15:22.994Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:22.994Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161674094
updated: 2026-04-08 02:01:22

Version 1705592

created: 2026-04-07 02:01:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-07/1775545239'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-07/1775545239
id: 1705592
processed: 1

raw_data:

{
    "accountId": "0eab1be8-8504-4d33-b98b-2aaab6fd9afd",
    "applicationId": "20400b75-3dec-43a5-be23-9162c31c1bcf",
    "createdAt": "2025-10-22T17:11:49.235Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T17:11:49.235Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161618006
updated: 2026-04-07 02:01:20

Version 1704366

created: 2026-04-06 02:01:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-06/1775458835'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-06/1775458835
id: 1704366
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: 4301
schema_scan_id: 161560180
updated: 2026-04-06 02:02:03

Version 1703168

created: 2026-04-05 02:01:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-05/1775372438'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-05/1775372438
id: 1703168
processed: 1

raw_data:

{
    "accountId": "d62b472f-5903-41ec-b284-ec7cee3a9161",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T17:11:46.626Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T17:11:46.626Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161513614
updated: 2026-04-05 02:01:19

Version 1701997

created: 2026-04-04 02:01:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-04/1775286038'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-04/1775286038
id: 1701997
processed: 1

raw_data:

{
    "accountId": "e9122dc9-97fe-4433-ba76-cb34aa231cd2",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:44.616Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:44.616Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161458648
updated: 2026-04-04 02:01:37

Version 1700787

created: 2026-04-03 02:01:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-03/1775199635'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_applications/2026-04-03/1775199635
id: 1700787
processed: 1

raw_data:

{
    "accountId": "aec844c5-50f0-49b5-af4d-fc4373150520",
    "applicationId": "4d7c3587-b148-4132-baff-412474d19524",
    "createdAt": "2025-10-22T22:15:05.750Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:15:05.750Z"
}

schema_attributes:

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

schema_name_id: 4301
schema_scan_id: 161399989
updated: 2026-04-03 02:01:23

Schema Scans: 15

Last at 2026-04-17 02:01:37

Scan 162166309

duration: 0:00:11.553807

exit_message:

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

id: 162166309

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_account_applications/2026-04-17/1776409264",
        "key": "raw/authsso_account_applications/2026-04-17/1776409264/part-00141.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3494998416096524963,
        "service_name": "drive-thru",
        "span_id": 2492266809090724057,
        "trace_id": 17725084148270481143
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-17 02:01:37
success: True
trace_id: 17725084148270481143

Scan 162110432

duration: 0:00:11.598729

exit_message:

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

id: 162110432

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_account_applications/2026-04-16/1776322839",
        "key": "raw/authsso_account_applications/2026-04-16/1776322839/part-00141.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2036339410903089039,
        "service_name": "drive-thru",
        "span_id": 9645449820195128137,
        "trace_id": 660906901104702970
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-16 02:01:13
success: True
trace_id: 660906901104702970

Scan 162054591

duration: 0:00:14.199124

exit_message:

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

id: 162054591

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_account_applications/2026-04-15/1776236437",
        "key": "raw/authsso_account_applications/2026-04-15/1776236437/part-00141.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6150467596201675661,
        "service_name": "drive-thru",
        "span_id": 18202229523523644795,
        "trace_id": 5225042506590449129
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-15 02:01:09
success: True
trace_id: 5225042506590449129

Scan 161998924

duration: 0:00:14.294811

exit_message:

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

id: 161998924

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_account_applications/2026-04-14/1776150064",
        "key": "raw/authsso_account_applications/2026-04-14/1776150064/part-00141.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12638573401484529537,
        "service_name": "drive-thru",
        "span_id": 18262566026049532146,
        "trace_id": 15924902070676221146
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-14 02:01:57
success: True
trace_id: 15924902070676221146

Scan 161941279

duration: 0:00:11.715743

exit_message:

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

id: 161941279

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_account_applications/2026-04-13/1776063656",
        "key": "raw/authsso_account_applications/2026-04-13/1776063656/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10448305959024753786,
        "service_name": "drive-thru",
        "span_id": 13909151939291711301,
        "trace_id": 3438644428104226639
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-13 02:01:25
success: True
trace_id: 3438644428104226639

Scan 161891744

duration: 0:00:11.656805

exit_message:

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

id: 161891744

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_account_applications/2026-04-12/1775977237",
        "key": "raw/authsso_account_applications/2026-04-12/1775977237/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6448261116348032320,
        "service_name": "drive-thru",
        "span_id": 3713721020026133203,
        "trace_id": 1667059038382387609
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-12 02:01:06
success: True
trace_id: 1667059038382387609

Scan 161839868

duration: 0:00:11.595254

exit_message:

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

id: 161839868

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_account_applications/2026-04-11/1775890836",
        "key": "raw/authsso_account_applications/2026-04-11/1775890836/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4233001423387079592,
        "service_name": "drive-thru",
        "span_id": 4557449699998671160,
        "trace_id": 11291493293357812915
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-11 02:01:32
success: True
trace_id: 11291493293357812915

Scan 161784402

duration: 0:00:11.690259

exit_message:

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

id: 161784402

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_account_applications/2026-04-10/1775804438",
        "key": "raw/authsso_account_applications/2026-04-10/1775804438/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14336177496884397014,
        "service_name": "drive-thru",
        "span_id": 6003812046113167391,
        "trace_id": 5722777870384431689
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-10 02:01:12
success: True
trace_id: 5722777870384431689

Scan 161729182

duration: 0:00:11.630588

exit_message:

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

id: 161729182

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_account_applications/2026-04-09/1775718039",
        "key": "raw/authsso_account_applications/2026-04-09/1775718039/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13696613801669134093,
        "service_name": "drive-thru",
        "span_id": 12603674489878821389,
        "trace_id": 9812604508583524330
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-09 02:01:23
success: True
trace_id: 9812604508583524330

Scan 161674094

duration: 0:00:14.197029

exit_message:

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

id: 161674094

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_account_applications/2026-04-08/1775631639",
        "key": "raw/authsso_account_applications/2026-04-08/1775631639/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14459270594965146587,
        "service_name": "drive-thru",
        "span_id": 14556125712442319760,
        "trace_id": 7455655156246223048
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-08 02:01:08
success: True
trace_id: 7455655156246223048

Scan 161618006

duration: 0:00:11.657648

exit_message:

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

id: 161618006

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_account_applications/2026-04-07/1775545239",
        "key": "raw/authsso_account_applications/2026-04-07/1775545239/part-00140.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15113482947588670498,
        "service_name": "drive-thru",
        "span_id": 11191086459528347032,
        "trace_id": 7085845473737416029
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-07 02:01:09
success: True
trace_id: 7085845473737416029

Scan 161560180

duration: 0:00:14.138402

exit_message:

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

id: 161560180

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_account_applications/2026-04-06/1775458835",
        "key": "raw/authsso_account_applications/2026-04-06/1775458835/part-00139.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2499794567962392049,
        "service_name": "drive-thru",
        "span_id": 10455044888099098778,
        "trace_id": 6854917821420616316
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-06 02:01:49
success: True
trace_id: 6854917821420616316

Scan 161513614

duration: 0:00:14.098848

exit_message:

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

id: 161513614

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_account_applications/2026-04-05/1775372438",
        "key": "raw/authsso_account_applications/2026-04-05/1775372438/part-00139.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12979281024865614206,
        "service_name": "drive-thru",
        "span_id": 3122077375381075999,
        "trace_id": 6351656286662753299
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-05 02:01:05
success: True
trace_id: 6351656286662753299

Scan 161458648

duration: 0:00:14.228825

exit_message:

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

id: 161458648

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_account_applications/2026-04-04/1775286038",
        "key": "raw/authsso_account_applications/2026-04-04/1775286038/part-00139.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7174714018163843938,
        "service_name": "drive-thru",
        "span_id": 12176434721987142767,
        "trace_id": 2600202021102366680
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-04 02:01:23
success: True
trace_id: 2600202021102366680

Scan 161399989

duration: 0:00:14.300107

exit_message:

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

id: 161399989

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_account_applications/2026-04-03/1775199635",
        "key": "raw/authsso_account_applications/2026-04-03/1775199635/part-00139.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15159757105521727758,
        "service_name": "drive-thru",
        "span_id": 14003915196229885230,
        "trace_id": 13214780119106398667
    }
}

running: False
schema_name_id: 4301
start_time: 2026-04-03 02:01:09
success: True
trace_id: 13214780119106398667

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 02:01:38

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-17/1776409264'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
}

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-18 01:09:49",
        "disabled": false,
        "format": "raw",
        "id": 4301,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "authsso_account_applications"
        },
        "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": "2026-04-17 02:01:38",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_account_applications`\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_account_applications/2026-04-17/1776409264'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_account_applications`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_account_applications"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}