Schema Info
Schema Name: sfdl_dev_drivethru.authsso_account_app_user_aggregates
- created: 2026-03-31 02:01:26
- disabled: False
- format: raw
- id: 3138
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_drivethru", "table": "authsso_account_app_user_aggregates" } - type: drivethrujson
Schema Versions: 15
-
Version 4773328
- created: 2026-04-17 02:01:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-17/1776409231'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-17/1776409231
- id: 4773328
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6867631
- updated: 2026-04-17 02:01:52
-
Version 4773261
- created: 2026-04-16 02:01:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-16/1776322867'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-16/1776322867
- id: 4773261
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6867362
- updated: 2026-04-16 02:01:37
-
Version 4773200
- created: 2026-04-15 02:01:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-15/1776236457'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-15/1776236457
- id: 4773200
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6867099
- updated: 2026-04-15 02:01:35
-
Version 4773139
- created: 2026-04-14 02:00:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-14/1776150028'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-14/1776150028
- id: 4773139
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6866836
- updated: 2026-04-14 02:00:45
-
Version 4773082
- created: 2026-04-13 02:02:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-13/1776063662'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-13/1776063662
- id: 4773082
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6866530
- updated: 2026-04-13 02:02:23
-
Version 4773033
- created: 2026-04-12 02:01:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-12/1775977227'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-12/1775977227
- id: 4773033
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6866355
- updated: 2026-04-12 02:01:38
-
Version 4772980
- created: 2026-04-11 02:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-11/1775890832'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-11/1775890832
- id: 4772980
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6866178
- updated: 2026-04-11 02:00:57
-
Version 4772922
- created: 2026-04-10 02:01:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-10/1775804451'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-10/1775804451
- id: 4772922
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "a9f13f23-bee3-49df-8e2a-d66119c10664", "enabledAt": "2026-04-09T18:09:28.310Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6865908
- updated: 2026-04-10 02:01:52
-
Version 4772864
- created: 2026-04-09 02:01:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-09/1775718035'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-09/1775718035
- id: 4772864
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6865642
- updated: 2026-04-09 02:01:52
-
Version 4772800
- created: 2026-04-08 02:01:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-08/1775631649'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-08/1775631649
- id: 4772800
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6865370
- updated: 2026-04-08 02:01:44
-
Version 4772736
- created: 2026-04-07 02:00:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-07/1775545229'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-07/1775545229
- id: 4772736
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6865098
- updated: 2026-04-07 02:00:58
-
Version 4772681
- created: 2026-04-06 02:01:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-06/1775458829'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-06/1775458829
- id: 4772681
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6864783
- updated: 2026-04-06 02:01:24
-
Version 4772627
- created: 2026-04-05 02:01:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-05/1775372447'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-05/1775372447
- id: 4772627
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6864605
- updated: 2026-04-05 02:01:21
-
Version 4772578
- created: 2026-04-04 02:00:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-04/1775286029'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-04/1775286029
- id: 4772578
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6864432
- updated: 2026-04-04 02:01:05
-
Version 4772519
- created: 2026-04-03 02:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`", "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_account_app_user_aggregates/2026-04-03/1775199624'\n", "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" ] - hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-03/1775199624
- id: 4772519
- processed: 1
- raw_data:
{ "accountId": "00000000-0000-0000-0000-000000000001", "applicationId": "af726be1-78d3-4df7-8c42-decb12d68385", "enabledAt": "2026-03-30T16:18:31.195Z", "totalProvisionedUsers": 9 } - schema_attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - schema_name_id: 3138
- schema_scan_id: 6864165
- updated: 2026-04-03 02:01:22
Schema Scans: 15
Last at 2026-04-17 02:01:38
-
Scan 6867631
- duration: 0:00:14.178986
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867631
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-17/1776409231", "key": "raw/authsso_account_app_user_aggregates/2026-04-17/1776409231/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 10354938537953186914, "service_name": "drive-thru", "span_id": 3869854975428754685, "trace_id": 10032618798761002633 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-17 02:01:38
- success: True
- trace_id: 10032618798761002633
-
Scan 6867362
- duration: 0:00:11.722389
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867362
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-16/1776322867", "key": "raw/authsso_account_app_user_aggregates/2026-04-16/1776322867/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 11312495598131597396, "service_name": "drive-thru", "span_id": 16398807523751162719, "trace_id": 9552681828478201267 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-16 02:01:25
- success: True
- trace_id: 9552681828478201267
-
Scan 6867099
- duration: 0:00:14.143333
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867099
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-15/1776236457", "key": "raw/authsso_account_app_user_aggregates/2026-04-15/1776236457/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 14727435142928001838, "service_name": "drive-thru", "span_id": 4438608824487768774, "trace_id": 1916422128765539491 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-15 02:01:21
- success: True
- trace_id: 1916422128765539491
-
Scan 6866836
- duration: 0:00:14.238194
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866836
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-14/1776150028", "key": "raw/authsso_account_app_user_aggregates/2026-04-14/1776150028/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 10068566409014374951, "service_name": "drive-thru", "span_id": 11489758501398083374, "trace_id": 11537823800050475109 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-14 02:00:31
- success: True
- trace_id: 11537823800050475109
-
Scan 6866530
- duration: 0:00:14.183934
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866530
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-13/1776063662", "key": "raw/authsso_account_app_user_aggregates/2026-04-13/1776063662/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 9813794481986254631, "service_name": "drive-thru", "span_id": 2012833076951680426, "trace_id": 4198344318176970149 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-13 02:02:08
- success: True
- trace_id: 4198344318176970149
-
Scan 6866355
- duration: 0:00:14.192833
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866355
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-12/1775977227", "key": "raw/authsso_account_app_user_aggregates/2026-04-12/1775977227/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 8524242311833351388, "service_name": "drive-thru", "span_id": 12221141285591258339, "trace_id": 13359458766272934725 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-12 02:01:24
- success: True
- trace_id: 13359458766272934725
-
Scan 6866178
- duration: 0:00:11.661583
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866178
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-11/1775890832", "key": "raw/authsso_account_app_user_aggregates/2026-04-11/1775890832/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 4801186721556813327, "service_name": "drive-thru", "span_id": 1863985929310593368, "trace_id": 2181409504513411854 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-11 02:00:46
- success: True
- trace_id: 2181409504513411854
-
Scan 6865908
- duration: 0:00:14.233269
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865908
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-10/1775804451", "key": "raw/authsso_account_app_user_aggregates/2026-04-10/1775804451/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 2089032741263533698, "service_name": "drive-thru", "span_id": 2494970168660819358, "trace_id": 737160487007884631 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-10 02:01:38
- success: True
- trace_id: 737160487007884631
-
Scan 6865642
- duration: 0:00:11.727759
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865642
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-09/1775718035", "key": "raw/authsso_account_app_user_aggregates/2026-04-09/1775718035/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 6657317393069632493, "service_name": "drive-thru", "span_id": 2326196623623642670, "trace_id": 18306408075154581113 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-09 02:01:40
- success: True
- trace_id: 18306408075154581113
-
Scan 6865370
- duration: 0:00:11.779709
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865370
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-08/1775631649", "key": "raw/authsso_account_app_user_aggregates/2026-04-08/1775631649/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 16489044513662033251, "service_name": "drive-thru", "span_id": 14211161455653407420, "trace_id": 8315305648017980383 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-08 02:01:32
- success: True
- trace_id: 8315305648017980383
-
Scan 6865098
- duration: 0:00:14.208109
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865098
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-07/1775545229", "key": "raw/authsso_account_app_user_aggregates/2026-04-07/1775545229/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 1474371035320298994, "service_name": "drive-thru", "span_id": 14810671762248813737, "trace_id": 2256238196408856563 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-07 02:00:44
- success: True
- trace_id: 2256238196408856563
-
Scan 6864783
- duration: 0:00:11.659216
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864783
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-06/1775458829", "key": "raw/authsso_account_app_user_aggregates/2026-04-06/1775458829/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 5264921648521866044, "service_name": "drive-thru", "span_id": 16928179066865539847, "trace_id": 6506887740916301098 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-06 02:01:12
- success: True
- trace_id: 6506887740916301098
-
Scan 6864605
- duration: 0:00:14.258526
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864605
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-05/1775372447", "key": "raw/authsso_account_app_user_aggregates/2026-04-05/1775372447/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 15054136452239158435, "service_name": "drive-thru", "span_id": 14695914994291863332, "trace_id": 15229655628264684765 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-05 02:01:06
- success: True
- trace_id: 15229655628264684765
-
Scan 6864432
- duration: 0:00:11.691251
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864432
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-04/1775286029", "key": "raw/authsso_account_app_user_aggregates/2026-04-04/1775286029/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 9471956098171335915, "service_name": "drive-thru", "span_id": 9009496376785832341, "trace_id": 8949738952471591645 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-04 02:00:53
- success: True
- trace_id: 8949738952471591645
-
Scan 6864165
- duration: 0:00:14.233712
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864165
- payload:
{ "datatype_dict": { "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" }, "file_format": "json", "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrujson-drivethru-dev", "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_account_app_user_aggregates/2026-04-03/1775199624", "key": "raw/authsso_account_app_user_aggregates/2026-04-03/1775199624/part-00000.json.gz" }, "schema": { "name": "sfdl_dev_drivethru.authsso_account_app_user_aggregates", "type": "drivethrujson" }, "trace_context": { "parent_id": 5013020799009743864, "service_name": "drive-thru", "span_id": 5146667551192215248, "trace_id": 10397990007996325550 } } - running: False
- schema_name_id: 3138
- start_time: 2026-04-03 02:01:08
- success: True
- trace_id: 10397990007996325550
- attributes:
{ "accountId": "string", "applicationId": "string", "enabledAt": "date", "totalProvisionedUsers": "bigint" } - created: 2026-04-17 02:01:39
- 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_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-dev/raw/authsso_account_app_user_aggregates/2026-04-17/1776409231'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2026-03-31 02:01:26",
"disabled": false,
"format": "raw",
"id": 3138,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_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:39",
"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_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-dev/raw/authsso_account_app_user_aggregates/2026-04-17/1776409231'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_account_app_user_aggregates`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_account_app_user_aggregates"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}