Schema Info

Schema Name: sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings

created: 2025-12-12 01:01:56
disabled: False
format: raw
id: 2253
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_drivethru",
    "table": "authsso_okta_mfa_enrollment_settings"
}

type: drivethrujson

Schema Versions: 15

Version 906603

created: 2026-04-17 02:02:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-17/1776409317'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409317
id: 906603
processed: 1

raw_data:

{
    "accountId": "fe9eb1f9-1d19-4947-9d7f-8e781811608d",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6415179
updated: 2026-04-17 02:02:58

Version 906386

created: 2026-04-16 02:03:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-16/1776322938'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322938
id: 906386
processed: 1

raw_data:

{
    "accountId": "fe9eb1f9-1d19-4947-9d7f-8e781811608d",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6414632
updated: 2026-04-16 02:03:14

Version 906173

created: 2026-04-15 02:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-15/1776236534'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236534
id: 906173
processed: 1

raw_data:

{
    "accountId": "feaf9c45-ce16-4498-a383-740f0e3c3988",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6414145
updated: 2026-04-15 02:03:07

Version 905959

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-14/1776150083'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150083
id: 905959
processed: 1

raw_data:

{
    "accountId": "feaf9c45-ce16-4498-a383-740f0e3c3988",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6413638
updated: 2026-04-14 02:02:11

Version 905744

created: 2026-04-13 02:02:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-13/1776063682'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063682
id: 905744
processed: 1

raw_data:

{
    "accountId": "fed012c1-83e5-47da-a927-997f4de9291a",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6413096
updated: 2026-04-13 02:02:23

Version 905542

created: 2026-04-12 02:01:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-12/1775977279'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977279
id: 905542
processed: 1

raw_data:

{
    "accountId": "fedd0923-ca9b-4553-a6d3-b8442697b32a",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6412702
updated: 2026-04-12 02:02:06

Version 905340

created: 2026-04-11 02:02:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-11/1775890937'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890937
id: 905340
processed: 1

raw_data:

{
    "accountId": "fedd0923-ca9b-4553-a6d3-b8442697b32a",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6412321
updated: 2026-04-11 02:03:08

Version 905126

created: 2026-04-10 02:02:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-10/1775804531'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804531
id: 905126
processed: 1

raw_data:

{
    "accountId": "fedeefaa-a2ed-412d-84cd-ce60400551c2",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6411823
updated: 2026-04-10 02:03:03

Version 904912

created: 2026-04-09 02:02:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-09/1775718103'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718103
id: 904912
processed: 1

raw_data:

{
    "accountId": "fedeefaa-a2ed-412d-84cd-ce60400551c2",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6411309
updated: 2026-04-09 02:02:36

Version 904698

created: 2026-04-08 02:03:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-08/1775631734'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631734
id: 904698
processed: 1

raw_data:

{
    "accountId": "ff00f3be-a8e1-48ad-9038-3259c3383957",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6410816
updated: 2026-04-08 02:03:15

Version 904484

created: 2026-04-07 02:02:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-07/1775545304'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545304
id: 904484
processed: 1

raw_data:

{
    "accountId": "ff056ca7-3772-4532-863b-cfb60c335684",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6410304
updated: 2026-04-07 02:02:31

Version 904270

created: 2026-04-06 02:03:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-06/1775458932'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458932
id: 904270
processed: 1

raw_data:

{
    "accountId": "ff279f5f-6a47-4a9c-8a18-ee02f52570ae",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6409758
updated: 2026-04-06 02:03:19

Version 904068

created: 2026-04-05 02:02:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-05/1775372501'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372501
id: 904068
processed: 1

raw_data:

{
    "accountId": "ff279f5f-6a47-4a9c-8a18-ee02f52570ae",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6409372
updated: 2026-04-05 02:02:28

Version 903866

created: 2026-04-04 02:02:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-04/1775286132'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286132
id: 903866
processed: 1

raw_data:

{
    "accountId": "ff279f5f-6a47-4a9c-8a18-ee02f52570ae",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6408991
updated: 2026-04-04 02:03:07

Version 903652

created: 2026-04-03 02:02:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-03/1775199731'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199731
id: 903652
processed: 1

raw_data:

{
    "accountId": "ff357e73-f18d-4df4-a41c-d65c2d484a09",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": false
}

schema_attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

schema_name_id: 2253
schema_scan_id: 6408499
updated: 2026-04-03 02:03:11

Schema Scans: 15

Last at 2026-04-17 02:02:47

Scan 6415179

duration: 0:00:11.805000

exit_message:

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

id: 6415179

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409317",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409317/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6949764896057734861,
        "service_name": "drive-thru",
        "span_id": 11392645233571994665,
        "trace_id": 10456878404141816681
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-17 02:02:47
success: True
trace_id: 10456878404141816681

Scan 6414632

duration: 0:00:12.117292

exit_message:

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

id: 6414632

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322938",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322938/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1632453248965109919,
        "service_name": "drive-thru",
        "span_id": 4132812021728717289,
        "trace_id": 16774847873889960676
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-16 02:03:01
success: True
trace_id: 16774847873889960676

Scan 6414145

duration: 0:00:11.920116

exit_message:

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

id: 6414145

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236534",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236534/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4489152748506997400,
        "service_name": "drive-thru",
        "span_id": 8815891075279820972,
        "trace_id": 16458537552009149053
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-15 02:02:56
success: True
trace_id: 16458537552009149053

Scan 6413638

duration: 0:00:14.359960

exit_message:

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

id: 6413638

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150083",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150083/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4016873282242374097,
        "service_name": "drive-thru",
        "span_id": 6213059962057896039,
        "trace_id": 16712720035584348763
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-14 02:01:57
success: True
trace_id: 16712720035584348763

Scan 6413096

duration: 0:00:14.402681

exit_message:

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

id: 6413096

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063682",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063682/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5408509075838212867,
        "service_name": "drive-thru",
        "span_id": 1750495167812058719,
        "trace_id": 16582794507769536044
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-13 02:02:08
success: True
trace_id: 16582794507769536044

Scan 6412702

duration: 0:00:14.308343

exit_message:

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

id: 6412702

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977279",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977279/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10626405534420304766,
        "service_name": "drive-thru",
        "span_id": 10368559588600038953,
        "trace_id": 14370031891215444964
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-12 02:01:52
success: True
trace_id: 14370031891215444964

Scan 6412321

duration: 0:00:14.502797

exit_message:

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

id: 6412321

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890937",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890937/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15865225940601113400,
        "service_name": "drive-thru",
        "span_id": 6747986120048170474,
        "trace_id": 16119496575705484967
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-11 02:02:53
success: True
trace_id: 16119496575705484967

Scan 6411823

duration: 0:00:11.774699

exit_message:

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

id: 6411823

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804531",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804531/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15551503138572916274,
        "service_name": "drive-thru",
        "span_id": 13701439044985930304,
        "trace_id": 4863662049176104377
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-10 02:02:52
success: True
trace_id: 4863662049176104377

Scan 6411309

duration: 0:00:14.494437

exit_message:

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

id: 6411309

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718103",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718103/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11139070209753209013,
        "service_name": "drive-thru",
        "span_id": 5689675508336580139,
        "trace_id": 15837737233834357563
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-09 02:02:21
success: True
trace_id: 15837737233834357563

Scan 6410816

duration: 0:00:11.866990

exit_message:

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

id: 6410816

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631734",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631734/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2098284494866730668,
        "service_name": "drive-thru",
        "span_id": 6577641686559988580,
        "trace_id": 3314205753768281256
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-08 02:03:03
success: True
trace_id: 3314205753768281256

Scan 6410304

duration: 0:00:14.269837

exit_message:

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

id: 6410304

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545304",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545304/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3677527875334222562,
        "service_name": "drive-thru",
        "span_id": 10194605499308034226,
        "trace_id": 16908248527996383309
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-07 02:02:16
success: True
trace_id: 16908248527996383309

Scan 6409758

duration: 0:00:11.798653

exit_message:

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

id: 6409758

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458932",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458932/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9365795756684989369,
        "service_name": "drive-thru",
        "span_id": 7200439531325561706,
        "trace_id": 7843522946453491932
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-06 02:03:08
success: True
trace_id: 7843522946453491932

Scan 6409372

duration: 0:00:11.790261

exit_message:

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

id: 6409372

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372501",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372501/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 247854022781221637,
        "service_name": "drive-thru",
        "span_id": 16628416721323892571,
        "trace_id": 17230417835522387626
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-05 02:02:16
success: True
trace_id: 17230417835522387626

Scan 6408991

duration: 0:00:14.276273

exit_message:

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

id: 6408991

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286132",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286132/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14103537104748990135,
        "service_name": "drive-thru",
        "span_id": 6743757996353835615,
        "trace_id": 10172805627632157193
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-04 02:02:53
success: True
trace_id: 10172805627632157193

Scan 6408499

duration: 0:00:14.451933

exit_message:

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

id: 6408499

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "emailFactorEnabled": "string",
        "fidoFactorEnabled": "string",
        "mfaEnabled": "string",
        "mfaRefreshIntervalMinutes": "bigint",
        "oktaVerifyFactorEnabled": "string",
        "otpFactorEnabled": "string",
        "smsFactorEnabled": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199731",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199731/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8922965337994866608,
        "service_name": "drive-thru",
        "span_id": 14774451194508176542,
        "trace_id": 9633994178249403239
    }
}

running: False
schema_name_id: 2253
start_time: 2026-04-03 02:02:57
success: True
trace_id: 9633994178249403239

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "accountId": "string",
    "emailFactorEnabled": "string",
    "fidoFactorEnabled": "string",
    "mfaEnabled": "string",
    "mfaRefreshIntervalMinutes": "bigint",
    "oktaVerifyFactorEnabled": "string",
    "otpFactorEnabled": "string",
    "smsFactorEnabled": "string"
}

created: 2026-04-17 02:02:47

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-17/1776409317'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-12-12 01:01:56",
        "disabled": false,
        "format": "raw",
        "id": 2253,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "authsso_okta_mfa_enrollment_settings"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accountId": "string",
            "emailFactorEnabled": "string",
            "fidoFactorEnabled": "string",
            "mfaEnabled": "string",
            "mfaRefreshIntervalMinutes": "bigint",
            "oktaVerifyFactorEnabled": "string",
            "otpFactorEnabled": "string",
            "smsFactorEnabled": "string"
        },
        "created": "2026-04-17 02:02:47",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`\n(\n`accountId`string,`mfaEnabled`string,`mfaRefreshIntervalMinutes`bigint,`emailFactorEnabled`string,`smsFactorEnabled`string,`oktaVerifyFactorEnabled`string,`otpFactorEnabled`string,`fidoFactorEnabled`string\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_okta_mfa_enrollment_settings/2026-04-17/1776409317'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_okta_mfa_enrollment_settings"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}