Schema Info

Schema Name: sfdl_dev_drivethru.authsso_account_applications

created: 2025-12-12 01:01:13
disabled: False
format: raw
id: 3133
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773326

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-17/1776409259
id: 4773326
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6867629
updated: 2026-04-17 02:01:38

Version 4773263

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-16/1776322869
id: 4773263
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6867364
updated: 2026-04-16 02:02:05

Version 4773201

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-15/1776236453
id: 4773201
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6867100
updated: 2026-04-15 02:01:41

Version 4773143

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-14/1776150027
id: 4773143
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6866840
updated: 2026-04-14 02:01:29

Version 4773079

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-13/1776063662
id: 4773079
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6866527
updated: 2026-04-13 02:01:54

Version 4773029

created: 2026-04-12 02:00:41

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-12/1775977227
id: 4773029
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6866351
updated: 2026-04-12 02:00:55

Version 4772984

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-11/1775890826
id: 4772984
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6866182
updated: 2026-04-11 02:01:36

Version 4772921

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-10/1775804451
id: 4772921
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6865907
updated: 2026-04-10 02:01:46

Version 4772862

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-09/1775718032
id: 4772862
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6865640
updated: 2026-04-09 02:01:40

Version 4772799

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-08/1775631651
id: 4772799
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6865369
updated: 2026-04-08 02:01:40

Version 4772738

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-07/1775545230
id: 4772738
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6865100
updated: 2026-04-07 02:01:10

Version 4772676

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-06/1775458826
id: 4772676
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6864778
updated: 2026-04-06 02:00:56

Version 4772631

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-05/1775372450
id: 4772631
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6864609
updated: 2026-04-05 02:01:58

Version 4772582

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-04/1775286025
id: 4772582
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6864436
updated: 2026-04-04 02:01:37

Version 4772522

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-03/1775199622
id: 4772522
processed: 1

raw_data:

{
    "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417",
    "applicationId": "20cb2c1b-de88-43b1-b86f-cf9c80301b2b",
    "createdAt": "2025-12-10T20:57:22.024Z",
    "deletedAt": null,
    "updatedAt": "2025-12-10T20:57:22.024Z"
}

schema_attributes:

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

schema_name_id: 3133
schema_scan_id: 6864168
updated: 2026-04-03 02:01:37

Schema Scans: 15

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

Scan 6867629

duration: 0:00:14.166731

exit_message:

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

id: 6867629

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-17/1776409259",
        "key": "raw/authsso_account_applications/2026-04-17/1776409259/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8806609722391992707,
        "service_name": "drive-thru",
        "span_id": 4177470173677899481,
        "trace_id": 10231704954643594841
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-17 02:01:24
success: True
trace_id: 10231704954643594841

Scan 6867364

duration: 0:00:14.225063

exit_message:

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

id: 6867364

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-16/1776322869",
        "key": "raw/authsso_account_applications/2026-04-16/1776322869/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 185255287049210986,
        "service_name": "drive-thru",
        "span_id": 32085533689319980,
        "trace_id": 12149450566339798553
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-16 02:01:51
success: True
trace_id: 12149450566339798553

Scan 6867100

duration: 0:00:14.286715

exit_message:

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

id: 6867100

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-15/1776236453",
        "key": "raw/authsso_account_applications/2026-04-15/1776236453/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16314451984660901034,
        "service_name": "drive-thru",
        "span_id": 14976989921082177287,
        "trace_id": 11400259993851263749
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-15 02:01:26
success: True
trace_id: 11400259993851263749

Scan 6866840

duration: 0:00:14.193586

exit_message:

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

id: 6866840

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-14/1776150027",
        "key": "raw/authsso_account_applications/2026-04-14/1776150027/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18011313812849565046,
        "service_name": "drive-thru",
        "span_id": 12448147086441219808,
        "trace_id": 7742685859734082500
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-14 02:01:15
success: True
trace_id: 7742685859734082500

Scan 6866527

duration: 0:00:14.249889

exit_message:

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

id: 6866527

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-13/1776063662",
        "key": "raw/authsso_account_applications/2026-04-13/1776063662/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2544847477013201464,
        "service_name": "drive-thru",
        "span_id": 5075693157473793997,
        "trace_id": 2590557082592003505
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-13 02:01:40
success: True
trace_id: 2590557082592003505

Scan 6866351

duration: 0:00:14.241553

exit_message:

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

id: 6866351

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-12/1775977227",
        "key": "raw/authsso_account_applications/2026-04-12/1775977227/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3775272257205193060,
        "service_name": "drive-thru",
        "span_id": 2137657561898265906,
        "trace_id": 10522822736680885000
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-12 02:00:41
success: True
trace_id: 10522822736680885000

Scan 6866182

duration: 0:00:11.663096

exit_message:

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

id: 6866182

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-11/1775890826",
        "key": "raw/authsso_account_applications/2026-04-11/1775890826/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15435733926251794401,
        "service_name": "drive-thru",
        "span_id": 15236450348297566711,
        "trace_id": 9012163577675783300
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-11 02:01:24
success: True
trace_id: 9012163577675783300

Scan 6865907

duration: 0:00:11.683297

exit_message:

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

id: 6865907

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-10/1775804451",
        "key": "raw/authsso_account_applications/2026-04-10/1775804451/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10208429772478779844,
        "service_name": "drive-thru",
        "span_id": 17892451358152865861,
        "trace_id": 15358844450219170931
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-10 02:01:34
success: True
trace_id: 15358844450219170931

Scan 6865640

duration: 0:00:11.761733

exit_message:

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

id: 6865640

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-09/1775718032",
        "key": "raw/authsso_account_applications/2026-04-09/1775718032/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5436081047011249524,
        "service_name": "drive-thru",
        "span_id": 17672656379060334452,
        "trace_id": 4562039015111330438
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-09 02:01:29
success: True
trace_id: 4562039015111330438

Scan 6865369

duration: 0:00:11.687886

exit_message:

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

id: 6865369

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-08/1775631651",
        "key": "raw/authsso_account_applications/2026-04-08/1775631651/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2906498077583460242,
        "service_name": "drive-thru",
        "span_id": 9914023167812765701,
        "trace_id": 8824219180952955785
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-08 02:01:28
success: True
trace_id: 8824219180952955785

Scan 6865100

duration: 0:00:11.788720

exit_message:

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

id: 6865100

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-07/1775545230",
        "key": "raw/authsso_account_applications/2026-04-07/1775545230/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 632364532612096112,
        "service_name": "drive-thru",
        "span_id": 17102458618125822830,
        "trace_id": 2601857061222642465
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-07 02:00:58
success: True
trace_id: 2601857061222642465

Scan 6864778

duration: 0:00:11.989976

exit_message:

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

id: 6864778

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-06/1775458826",
        "key": "raw/authsso_account_applications/2026-04-06/1775458826/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5479412772792690692,
        "service_name": "drive-thru",
        "span_id": 6690539138099136083,
        "trace_id": 1224895268798855579
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-06 02:00:44
success: True
trace_id: 1224895268798855579

Scan 6864609

duration: 0:00:11.617208

exit_message:

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

id: 6864609

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-05/1775372450",
        "key": "raw/authsso_account_applications/2026-04-05/1775372450/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 23483337474681919,
        "service_name": "drive-thru",
        "span_id": 1327698682527991194,
        "trace_id": 582275051012338531
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-05 02:01:47
success: True
trace_id: 582275051012338531

Scan 6864436

duration: 0:00:11.733457

exit_message:

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

id: 6864436

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-04/1775286025",
        "key": "raw/authsso_account_applications/2026-04-04/1775286025/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9637894061887454949,
        "service_name": "drive-thru",
        "span_id": 2180295192605054351,
        "trace_id": 16411541336523871181
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-04 02:01:25
success: True
trace_id: 16411541336523871181

Scan 6864168

duration: 0:00:14.340225

exit_message:

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

id: 6864168

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_applications/2026-04-03/1775199622",
        "key": "raw/authsso_account_applications/2026-04-03/1775199622/part-00001.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_account_applications",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14314772117222271449,
        "service_name": "drive-thru",
        "span_id": 15092693953762634371,
        "trace_id": 2531193335817932281
    }
}

running: False
schema_name_id: 3133
start_time: 2026-04-03 02:01:22
success: True
trace_id: 2531193335817932281

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:24

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2025-12-12 01:01:13",
        "disabled": false,
        "format": "raw",
        "id": 3133,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:24",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_applications/2026-04-17/1776409259'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_applications`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_applications"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}