Schema Info
Schema Name: sfdl_dev_drivethru.authsso_accountapplications
- created: 2025-12-08 04:02:53
- disabled: False
- format: raw
- id: 3131
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "authsso_accountapplications" } - type: drivethrujson
Schema Versions: 7
-
Version 4766179
- created: 2025-12-11 01:00:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-11/1765436425'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-11/1765436425
- id: 4766179
- 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: 3131
- schema_scan_id: 6835846
- updated: 2025-12-11 01:01:08
-
Version 4766123
- created: 2025-12-10 01:00:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-10/1765350027'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-10/1765350027
- id: 4766123
- processed: 1
- raw_data:
{ "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417", "applicationId": "d915acd3-d17e-4f72-a30e-e2aab6d5b4a5", "createdAt": "2025-12-09T21:12:35.299Z", "deletedAt": null, "updatedAt": "2025-12-09T21:12:35.299Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835578
- updated: 2025-12-10 01:01:04
-
Version 4766118
- created: 2025-12-09 01:00:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-09/1765263627'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-09/1765263627
- id: 4766118
- processed: 1
- raw_data:
{ "accountId": "c6b9d376-b625-4a01-8bdc-c2a41bad4417", "applicationId": "8df10ef0-dc5d-48c6-8fd4-68922fe59c37", "createdAt": "2025-12-08T15:04:17.742Z", "deletedAt": null, "updatedAt": "2025-12-08T16:27:03.597Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835483
- updated: 2025-12-09 01:01:04
-
Version 4766112
- created: 2025-12-08 04:04:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-06/1765004427'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-06/1765004427
- id: 4766112
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "bdecaa33-9ed6-4322-9116-1652e451d07d", "createdAt": "2025-12-05T21:01:53.638Z", "deletedAt": null, "updatedAt": "2025-12-05T21:01:53.638Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835343
- updated: 2025-12-08 04:04:44
-
Version 4766111
- created: 2025-12-08 04:04:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-08/1765177227'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-08/1765177227
- id: 4766111
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "bdecaa33-9ed6-4322-9116-1652e451d07d", "createdAt": "2025-12-05T21:01:53.638Z", "deletedAt": null, "updatedAt": "2025-12-05T21:01:53.638Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835341
- updated: 2025-12-08 04:04:41
-
Version 4766107
- created: 2025-12-08 04:02:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-07/1765090826'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-07/1765090826
- id: 4766107
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "bdecaa33-9ed6-4322-9116-1652e451d07d", "createdAt": "2025-12-05T21:01:53.638Z", "deletedAt": null, "updatedAt": "2025-12-05T21:01:53.638Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835285
- updated: 2025-12-08 04:03:09
-
Version 4766106
- created: 2025-12-08 04:02:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-04/1764896431'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-04/1764896431
- id: 4766106
- processed: 1
- raw_data:
{ "accountId": "d7a10ac8-329d-4a72-84ee-79c94cf7947f", "applicationId": "68601314-4b76-4ab2-aae3-234d88ee873a", "createdAt": "2025-12-04T22:13:40.768Z", "deletedAt": null, "updatedAt": "2025-12-04T22:13:40.768Z" } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - schema_name_id: 3131
- schema_scan_id: 6835284
- updated: 2025-12-08 04:03:07
Schema Scans: 7
Last at 2025-12-11 01:00:53
-
Scan 6835846
- duration: 0:00:14.300716
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835846
- 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_accountapplications/2025-12-11/1765436425", "key": "raw/authsso_accountapplications/2025-12-11/1765436425/part-00001.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 9826709672865642397, "service_name": "drive-thru", "span_id": 16983873996582823970, "trace_id": 18433014080678541838 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-11 01:00:53
- success: True
- trace_id: 18433014080678541838
-
Scan 6835578
- duration: 0:00:14.442948
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835578
- 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_accountapplications/2025-12-10/1765350027", "key": "raw/authsso_accountapplications/2025-12-10/1765350027/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 14655626098426779645, "service_name": "drive-thru", "span_id": 13540957901699645118, "trace_id": 18445673240502354591 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-10 01:00:50
- success: True
- trace_id: 18445673240502354591
-
Scan 6835483
- duration: 0:00:14.427127
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835483
- 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_accountapplications/2025-12-09/1765263627", "key": "raw/authsso_accountapplications/2025-12-09/1765263627/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 1344040131250918839, "service_name": "drive-thru", "span_id": 9956898986053414355, "trace_id": 9041748121527754479 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-09 01:00:50
- success: True
- trace_id: 9041748121527754479
-
Scan 6835343
- duration: 0:00:14.273270
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835343
- 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_accountapplications/2025-12-06/1765004427", "key": "raw/authsso_accountapplications/2025-12-06/1765004427/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 14190452274325247003, "service_name": "drive-thru", "span_id": 6526621385746458723, "trace_id": 12787504276443542819 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-08 04:04:30
- success: True
- trace_id: 12787504276443542819
-
Scan 6835341
- duration: 0:00:14.444514
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835341
- 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_accountapplications/2025-12-08/1765177227", "key": "raw/authsso_accountapplications/2025-12-08/1765177227/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 14811211778877182064, "service_name": "drive-thru", "span_id": 14877213490774351173, "trace_id": 11435744800170998709 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-08 04:04:26
- success: True
- trace_id: 11435744800170998709
-
Scan 6835285
- duration: 0:00:14.190569
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835285
- 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_accountapplications/2025-12-07/1765090826", "key": "raw/authsso_accountapplications/2025-12-07/1765090826/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 13693440700899360522, "service_name": "drive-thru", "span_id": 15088178038267737307, "trace_id": 7954248254312287054 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-08 04:02:54
- success: True
- trace_id: 7954248254312287054
-
Scan 6835284
- duration: 0:00:14.343457
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6835284
- 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_accountapplications/2025-12-04/1764896431", "key": "raw/authsso_accountapplications/2025-12-04/1764896431/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_accountapplications", "type": "drivethrujson" }, "trace_context": { "parent_id": 8564732454614067881, "service_name": "drive-thru", "span_id": 14976142665874459714, "trace_id": 2503918599933503252 } } - running: False
- schema_name_id: 3131
- start_time: 2025-12-08 04:02:53
- success: True
- trace_id: 2503918599933503252
- attributes:
{ "accountId": "string", "applicationId": "string", "createdAt": "date", "deletedAt": "date", "updatedAt": "date" } - created: 2025-12-11 01:00:54
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-11/1765436425'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2025-12-08 04:02:53",
"disabled": false,
"format": "raw",
"id": 3131,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_drivethru",
"table": "authsso_accountapplications"
},
"type": "drivethrujson"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"accountId": "string",
"applicationId": "string",
"createdAt": "date",
"deletedAt": "date",
"updatedAt": "date"
},
"created": "2025-12-11 01:00:54",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.authsso_accountapplications`\n(\n`applicationId`string,`accountId`string,`createdAt`date,`deletedAt`date,`updatedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accountapplications/2025-12-11/1765436425'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_accountapplications`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_accountapplications"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}