Schema Info
Schema Name: sfdl_stage_drivethru.authsso_account_app_user_aggregates
- created: 2026-03-31 02:01:07
- disabled: False
- format: raw
- id: 2260
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_drivethru", "table": "authsso_account_app_user_aggregates" } - type: drivethrujson
Schema Versions: 15
-
Version 906599
- created: 2026-04-17 02:01:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-17/1776409240'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-17/1776409240
- id: 906599
- processed: 1
- raw_data:
{ "accountId": "88530496-767b-4a77-8514-5553d5d5ddfb", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:21.610Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6415175
- updated: 2026-04-17 02:01:23
-
Version 906383
- created: 2026-04-16 02:01:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-16/1776322842'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-16/1776322842
- id: 906383
- processed: 1
- raw_data:
{ "accountId": "88530496-767b-4a77-8514-5553d5d5ddfb", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:21.610Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6414629
- updated: 2026-04-16 02:01:16
-
Version 906170
- created: 2026-04-15 02:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-15/1776236445'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-15/1776236445
- id: 906170
- processed: 1
- raw_data:
{ "accountId": "9224280e-0737-4cc3-b1fc-f05576762a74", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:09:56.507Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6414142
- updated: 2026-04-15 02:01:22
-
Version 905956
- created: 2026-04-14 02:01:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-14/1776150043'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-14/1776150043
- id: 905956
- processed: 1
- raw_data:
{ "accountId": "0fcb636b-e920-4156-b238-6243734e819e", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:11:05.286Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6413635
- updated: 2026-04-14 02:01:17
-
Version 905740
- created: 2026-04-13 02:01:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-13/1776063645'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-13/1776063645
- id: 905740
- processed: 1
- raw_data:
{ "accountId": "0fcb636b-e920-4156-b238-6243734e819e", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:11:05.286Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6413092
- updated: 2026-04-13 02:01:27
-
Version 905538
- created: 2026-04-12 02:01:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-12/1775977244'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-12/1775977244
- id: 905538
- processed: 1
- raw_data:
{ "accountId": "3e82d54c-1b2c-4352-a33e-f78c157e87e1", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.478Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6412698
- updated: 2026-04-12 02:01:30
-
Version 905334
- created: 2026-04-11 02:01:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-11/1775890845'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-11/1775890845
- id: 905334
- processed: 1
- raw_data:
{ "accountId": "3e82d54c-1b2c-4352-a33e-f78c157e87e1", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.478Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6412316
- updated: 2026-04-11 02:01:23
-
Version 905122
- created: 2026-04-10 02:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-10/1775804446'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-10/1775804446
- id: 905122
- processed: 1
- raw_data:
{ "accountId": "3e82d54c-1b2c-4352-a33e-f78c157e87e1", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.478Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6411819
- updated: 2026-04-10 02:01:22
-
Version 904908
- created: 2026-04-09 02:01:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-09/1775718046'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-09/1775718046
- id: 904908
- processed: 1
- raw_data:
{ "accountId": "e38719b2-f89c-4ff8-9708-4a06b93fe48a", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:19.919Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6411305
- updated: 2026-04-09 02:01:23
-
Version 904694
- created: 2026-04-08 02:01:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-08/1775631646'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-08/1775631646
- id: 904694
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6410812
- updated: 2026-04-08 02:01:26
-
Version 904480
- created: 2026-04-07 02:01:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-07/1775545247'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-07/1775545247
- id: 904480
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6410300
- updated: 2026-04-07 02:01:26
-
Version 904266
- created: 2026-04-06 02:01:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-06/1775458845'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-06/1775458845
- id: 904266
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6409754
- updated: 2026-04-06 02:01:36
-
Version 904064
- created: 2026-04-05 02:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-05/1775372445'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-05/1775372445
- id: 904064
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6409368
- updated: 2026-04-05 02:01:19
-
Version 903862
- created: 2026-04-04 02:01:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-04/1775286045'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-04/1775286045
- id: 903862
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6408987
- updated: 2026-04-04 02:01:31
-
Version 903648
- created: 2026-04-03 02:01:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`", "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-03/1775199642'\n", "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-03/1775199642
- id: 903648
- processed: 1
- raw_data:
{ "accountId": "e7f8536d-e3ef-4059-a09b-8860e9638ba4", "applicationId": "70a57f66-bd2a-42db-8b44-92fec8929a4f", "enabledAt": "2025-10-22T22:10:55.506Z", "totalProvisionedUsers": 0 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 2260
- schema_scan_id: 6408495
- updated: 2026-04-03 02:01:19
Schema Scans: 15
Last at 2026-04-17 02:01:09
-
Scan 6415175
- duration: 0:00:14.226850
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415175
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-17/1776409240", "key": "raw/authsso_account_app_user_aggregates/2026-04-17/1776409240/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 14736897797514853233, "service_name": "drive-thru", "span_id": 2128292893981392204, "trace_id": 1228734891809552832 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-17 02:01:09
- success: True
- trace_id: 1228734891809552832
-
Scan 6414629
- duration: 0:00:11.808977
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414629
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-16/1776322842", "key": "raw/authsso_account_app_user_aggregates/2026-04-16/1776322842/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 11064533237863191366, "service_name": "drive-thru", "span_id": 563488538722524384, "trace_id": 12684684269799839589 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-16 02:01:04
- success: True
- trace_id: 12684684269799839589
-
Scan 6414142
- duration: 0:00:14.236105
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414142
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-15/1776236445", "key": "raw/authsso_account_app_user_aggregates/2026-04-15/1776236445/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 14697517805284183001, "service_name": "drive-thru", "span_id": 5364283019560056855, "trace_id": 18434889755680918947 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-15 02:01:08
- success: True
- trace_id: 18434889755680918947
-
Scan 6413635
- duration: 0:00:11.662792
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413635
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-14/1776150043", "key": "raw/authsso_account_app_user_aggregates/2026-04-14/1776150043/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 7005786617483144851, "service_name": "drive-thru", "span_id": 853552706457469156, "trace_id": 11759187286318121667 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-14 02:01:05
- success: True
- trace_id: 11759187286318121667
-
Scan 6413092
- duration: 0:00:11.693418
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413092
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-13/1776063645", "key": "raw/authsso_account_app_user_aggregates/2026-04-13/1776063645/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 14244958739935770162, "service_name": "drive-thru", "span_id": 4584364393060175798, "trace_id": 1581861235750535599 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-13 02:01:16
- success: True
- trace_id: 1581861235750535599
-
Scan 6412698
- duration: 0:00:14.292478
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412698
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-12/1775977244", "key": "raw/authsso_account_app_user_aggregates/2026-04-12/1775977244/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 9120937404509360103, "service_name": "drive-thru", "span_id": 4200971377696655431, "trace_id": 12623192978680942392 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-12 02:01:16
- success: True
- trace_id: 12623192978680942392
-
Scan 6412316
- duration: 0:00:14.234369
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412316
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-11/1775890845", "key": "raw/authsso_account_app_user_aggregates/2026-04-11/1775890845/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 17490385362961041955, "service_name": "drive-thru", "span_id": 4067223119821750005, "trace_id": 9893686810386709210 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-11 02:01:09
- success: True
- trace_id: 9893686810386709210
-
Scan 6411819
- duration: 0:00:14.354444
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411819
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-10/1775804446", "key": "raw/authsso_account_app_user_aggregates/2026-04-10/1775804446/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 13878336396389338194, "service_name": "drive-thru", "span_id": 14889999628307666941, "trace_id": 14537780043459605355 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-10 02:01:08
- success: True
- trace_id: 14537780043459605355
-
Scan 6411305
- duration: 0:00:14.213725
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411305
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-09/1775718046", "key": "raw/authsso_account_app_user_aggregates/2026-04-09/1775718046/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 17459379161773150621, "service_name": "drive-thru", "span_id": 10925834402607514045, "trace_id": 6762809113605593192 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-09 02:01:09
- success: True
- trace_id: 6762809113605593192
-
Scan 6410812
- duration: 0:00:14.383126
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410812
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-08/1775631646", "key": "raw/authsso_account_app_user_aggregates/2026-04-08/1775631646/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 7617610025137646027, "service_name": "drive-thru", "span_id": 4884507685851004860, "trace_id": 13227849613318454958 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-08 02:01:11
- success: True
- trace_id: 13227849613318454958
-
Scan 6410300
- duration: 0:00:14.279217
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410300
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-07/1775545247", "key": "raw/authsso_account_app_user_aggregates/2026-04-07/1775545247/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 12072172488341621208, "service_name": "drive-thru", "span_id": 3519028885473849148, "trace_id": 11968581396586053620 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-07 02:01:11
- success: True
- trace_id: 11968581396586053620
-
Scan 6409754
- duration: 0:00:14.178582
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409754
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-06/1775458845", "key": "raw/authsso_account_app_user_aggregates/2026-04-06/1775458845/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 6711799301158917793, "service_name": "drive-thru", "span_id": 18109829983687968046, "trace_id": 11055894577792428448 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-06 02:01:21
- success: True
- trace_id: 11055894577792428448
-
Scan 6409368
- duration: 0:00:11.667352
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409368
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-05/1775372445", "key": "raw/authsso_account_app_user_aggregates/2026-04-05/1775372445/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 13328112806163666351, "service_name": "drive-thru", "span_id": 17209408352720802951, "trace_id": 10375668802415637800 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-05 02:01:08
- success: True
- trace_id: 10375668802415637800
-
Scan 6408987
- duration: 0:00:11.659456
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408987
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-04/1775286045", "key": "raw/authsso_account_app_user_aggregates/2026-04-04/1775286045/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 16867670099385921348, "service_name": "drive-thru", "span_id": 239014173805710411, "trace_id": 9183756450548257719 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-04 02:01:19
- success: True
- trace_id: 9183756450548257719
-
Scan 6408495
- duration: 0:00:14.270930
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408495
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-stage", "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_app_user_aggregates/2026-04-03/1775199642", "key": "raw/authsso_account_app_user_aggregates/2026-04-03/1775199642/part-00105.json.gz" }, "schema": { "name": "sfdl_stage_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 9847079892031578953, "service_name": "drive-thru", "span_id": 7227355381477657055, "trace_id": 15407448810280422132 } } - running: False
- schema_name_id: 2260
- start_time: 2026-04-03 02:01:05
- success: True
- trace_id: 15407448810280422132
- attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - created: 2026-04-17 02:01:09
- 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_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-17/1776409240'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2026-03-31 02:01:07",
"disabled": false,
"format": "raw",
"id": 2260,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_drivethru",
"table": "authsso_account_app_user_aggregates"
},
"type": "drivethrujson"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"accountId": "string",
"applicationId": "string",
"enabledAt": "date",
"totalProvisionedUsers": "bigint"
},
"created": "2026-04-17 02:01:09",
"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_app_user_aggregates`\n(\n`accountId`string,`applicationId`string,`enabledAt`date,`totalProvisionedUsers`bigint\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_app_user_aggregates/2026-04-17/1776409240'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_app_user_aggregates`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_app_user_aggregates"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}