Schema Info

Schema Name: sfdl_stage_drivethru.authsso_account_applications

created: 2025-08-08 11:20:49
disabled: False
format: raw
id: 2250
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906598

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-17/1776409233
id: 906598
processed: 1

raw_data:

{
    "accountId": "1a365c85-2819-45d4-925e-c939f4ca8638",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:57.191Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:57.191Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6415174
updated: 2026-04-17 02:01:11

Version 906382

created: 2026-04-16 02:00:59

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-16/1776322834
id: 906382
processed: 1

raw_data:

{
    "accountId": "1a365c85-2819-45d4-925e-c939f4ca8638",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:57.191Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:57.191Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6414628
updated: 2026-04-16 02:01:13

Version 906169

created: 2026-04-15 02:00:57

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-15/1776236434
id: 906169
processed: 1

raw_data:

{
    "accountId": "55d9c761-f1cd-4fe6-bae7-78cc121faac4",
    "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f",
    "createdAt": "2025-10-22T22:10:27.235Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:27.235Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6414141
updated: 2026-04-15 02:01:11

Version 905955

created: 2026-04-14 02:00:59

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-14/1776150034
id: 905955
processed: 1

raw_data:

{
    "accountId": "23e6fc4a-3ef1-4747-a323-6a602b0d2706",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T16:23:24.468Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T16:23:24.468Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6413634
updated: 2026-04-14 02:01:10

Version 905739

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-13/1776063635
id: 905739
processed: 1

raw_data:

{
    "accountId": "23e6fc4a-3ef1-4747-a323-6a602b0d2706",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T16:23:24.468Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T16:23:24.468Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6413091
updated: 2026-04-13 02:01:16

Version 905537

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-12/1775977234
id: 905537
processed: 1

raw_data:

{
    "accountId": "9224280e-0737-4cc3-b1fc-f05576762a74",
    "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f",
    "createdAt": "2025-10-22T22:09:56.507Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:09:56.507Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6412697
updated: 2026-04-12 02:01:17

Version 905336

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-11/1775890835
id: 905336
processed: 1

raw_data:

{
    "accountId": "9224280e-0737-4cc3-b1fc-f05576762a74",
    "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f",
    "createdAt": "2025-10-22T22:09:56.507Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:09:56.507Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6412317
updated: 2026-04-11 02:01:23

Version 905121

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-10/1775804435
id: 905121
processed: 1

raw_data:

{
    "accountId": "9224280e-0737-4cc3-b1fc-f05576762a74",
    "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f",
    "createdAt": "2025-10-22T22:09:56.507Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:09:56.507Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6411818
updated: 2026-04-10 02:01:16

Version 904907

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-09/1775718034
id: 904907
processed: 1

raw_data:

{
    "accountId": "8892cfff-c2f2-46b6-b344-6f007feabcca",
    "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f",
    "createdAt": "2025-10-22T22:10:00.746Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:00.746Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6411304
updated: 2026-04-09 02:01:14

Version 904693

created: 2026-04-08 02:00:59

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-08/1775631635
id: 904693
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6410811
updated: 2026-04-08 02:01:10

Version 904479

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-07/1775545234
id: 904479
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6410299
updated: 2026-04-07 02:01:11

Version 904265

created: 2026-04-06 02:00:55

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-06/1775458834
id: 904265
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6409753
updated: 2026-04-06 02:01:06

Version 904063

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-05/1775372435
id: 904063
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6409367
updated: 2026-04-05 02:01:11

Version 903860

created: 2026-04-04 02:00:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_applications`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_account_applications/2026-04-04/1775286034'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_applications"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-04/1775286034
id: 903860
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6408985
updated: 2026-04-04 02:01:12

Version 903647

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-03/1775199634
id: 903647
processed: 1

raw_data:

{
    "accountId": "157ce296-402a-4206-9986-eb2a85d0d42c",
    "applicationId": "3203552b-df51-4b6a-90d3-58d966971d5a",
    "createdAt": "2025-10-22T22:10:39.766Z",
    "deletedAt": null,
    "updatedAt": "2025-10-22T22:10:39.766Z"
}

schema_attributes:

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

schema_name_id: 2250
schema_scan_id: 6408494
updated: 2026-04-03 02:01:14

Schema Scans: 15

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

Scan 6415174

duration: 0:00:12.017787

exit_message:

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

id: 6415174

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-17/1776409233",
        "key": "raw/authsso_account_applications/2026-04-17/1776409233/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17096327879572424108,
        "service_name": "drive-thru",
        "span_id": 749670281269939054,
        "trace_id": 4383909614902639184
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-17 02:01:00
success: True
trace_id: 4383909614902639184

Scan 6414628

duration: 0:00:14.391059

exit_message:

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

id: 6414628

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-16/1776322834",
        "key": "raw/authsso_account_applications/2026-04-16/1776322834/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5874435639011112922,
        "service_name": "drive-thru",
        "span_id": 17187886851448885064,
        "trace_id": 7758036660898410682
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-16 02:00:58
success: True
trace_id: 7758036660898410682

Scan 6414141

duration: 0:00:14.261788

exit_message:

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

id: 6414141

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-15/1776236434",
        "key": "raw/authsso_account_applications/2026-04-15/1776236434/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16938200880584344909,
        "service_name": "drive-thru",
        "span_id": 10951423091760333072,
        "trace_id": 16589921107690509728
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-15 02:00:56
success: True
trace_id: 16589921107690509728

Scan 6413634

duration: 0:00:11.751809

exit_message:

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

id: 6413634

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-14/1776150034",
        "key": "raw/authsso_account_applications/2026-04-14/1776150034/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6423415738127500868,
        "service_name": "drive-thru",
        "span_id": 16695887113129392505,
        "trace_id": 15492457337470300635
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-14 02:00:58
success: True
trace_id: 15492457337470300635

Scan 6413091

duration: 0:00:11.777351

exit_message:

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

id: 6413091

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-13/1776063635",
        "key": "raw/authsso_account_applications/2026-04-13/1776063635/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17949492321957687448,
        "service_name": "drive-thru",
        "span_id": 8971896364905355509,
        "trace_id": 17334367883465590455
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-13 02:01:04
success: True
trace_id: 17334367883465590455

Scan 6412697

duration: 0:00:14.342647

exit_message:

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

id: 6412697

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-12/1775977234",
        "key": "raw/authsso_account_applications/2026-04-12/1775977234/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16418123578596391269,
        "service_name": "drive-thru",
        "span_id": 18111332674231315901,
        "trace_id": 17345651037275803173
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-12 02:01:03
success: True
trace_id: 17345651037275803173

Scan 6412317

duration: 0:00:11.744977

exit_message:

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

id: 6412317

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-11/1775890835",
        "key": "raw/authsso_account_applications/2026-04-11/1775890835/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6995477552691979268,
        "service_name": "drive-thru",
        "span_id": 4974431292789755856,
        "trace_id": 16569488634775116688
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-11 02:01:11
success: True
trace_id: 16569488634775116688

Scan 6411818

duration: 0:00:11.795377

exit_message:

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

id: 6411818

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-10/1775804435",
        "key": "raw/authsso_account_applications/2026-04-10/1775804435/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3913532485128883073,
        "service_name": "drive-thru",
        "span_id": 2489492673194506566,
        "trace_id": 17703752088921116234
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-10 02:01:04
success: True
trace_id: 17703752088921116234

Scan 6411304

duration: 0:00:12.006630

exit_message:

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

id: 6411304

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-09/1775718034",
        "key": "raw/authsso_account_applications/2026-04-09/1775718034/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7888594150986648077,
        "service_name": "drive-thru",
        "span_id": 15964977621764285084,
        "trace_id": 1045778665893280648
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-09 02:01:02
success: True
trace_id: 1045778665893280648

Scan 6410811

duration: 0:00:11.711271

exit_message:

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

id: 6410811

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-08/1775631635",
        "key": "raw/authsso_account_applications/2026-04-08/1775631635/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2556764299590917950,
        "service_name": "drive-thru",
        "span_id": 14188270968610244075,
        "trace_id": 8684013463296262549
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-08 02:00:58
success: True
trace_id: 8684013463296262549

Scan 6410299

duration: 0:00:11.772079

exit_message:

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

id: 6410299

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-07/1775545234",
        "key": "raw/authsso_account_applications/2026-04-07/1775545234/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12001761273220612525,
        "service_name": "drive-thru",
        "span_id": 8077910276090095254,
        "trace_id": 4844996206490524706
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-07 02:01:00
success: True
trace_id: 4844996206490524706

Scan 6409753

duration: 0:00:11.762458

exit_message:

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

id: 6409753

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-06/1775458834",
        "key": "raw/authsso_account_applications/2026-04-06/1775458834/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11397691357373227631,
        "service_name": "drive-thru",
        "span_id": 1744708718569359074,
        "trace_id": 12458169048277347942
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-06 02:00:54
success: True
trace_id: 12458169048277347942

Scan 6409367

duration: 0:00:11.733074

exit_message:

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

id: 6409367

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-05/1775372435",
        "key": "raw/authsso_account_applications/2026-04-05/1775372435/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7135996482464841762,
        "service_name": "drive-thru",
        "span_id": 6574279122036898003,
        "trace_id": 17523231109568069986
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-05 02:00:59
success: True
trace_id: 17523231109568069986

Scan 6408985

duration: 0:00:14.353424

exit_message:

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

id: 6408985

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-04/1775286034",
        "key": "raw/authsso_account_applications/2026-04-04/1775286034/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5294098538157891485,
        "service_name": "drive-thru",
        "span_id": 3680987692380112914,
        "trace_id": 16993329177048956083
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-04 02:00:58
success: True
trace_id: 16993329177048956083

Scan 6408494

duration: 0:00:11.803749

exit_message:

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

id: 6408494

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_applications/2026-04-03/1775199634",
        "key": "raw/authsso_account_applications/2026-04-03/1775199634/part-00105.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17055427170104897488,
        "service_name": "drive-thru",
        "span_id": 16347546763707367577,
        "trace_id": 13652707579184067156
    }
}

running: False
schema_name_id: 2250
start_time: 2026-04-03 02:01:03
success: True
trace_id: 13652707579184067156

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-08-08 11:20:49",
        "disabled": false,
        "format": "raw",
        "id": 2250,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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",
            "id": "string",
            "updatedAt": "date"
        },
        "created": "2026-04-17 02:01:00",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_account_applications/2026-04-17/1776409233'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_applications`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_applications"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}