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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
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
Raw:
{
    "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"
    }
}