Schema Info

Schema Name: sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings

created: 2025-12-18 01:11:38
disabled: False
format: raw
id: 4303
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717533

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606
id: 1717533
processed: 1

raw_data:

{
    "accountId": "ff8674d4-b6b5-494c-a915-e3e9ce1aa8bb",
    "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: 4303
schema_scan_id: 162166368
updated: 2026-04-17 02:08:08

Version 1716301

created: 2026-04-16 02:09:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776323292'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776323292
id: 1716301
processed: 1

raw_data:

{
    "accountId": "ff94e524-1ffb-4435-8523-dc380b37bb7a",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 162110497
updated: 2026-04-16 02:09:39

Version 1715109

created: 2026-04-15 02:03:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236533'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236533
id: 1715109
processed: 1

raw_data:

{
    "accountId": "ffa59cac-9f6f-4b07-99dc-b3e05a74455e",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 162054641
updated: 2026-04-15 02:03:35

Version 1713921

created: 2026-04-14 02:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150134'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150134
id: 1713921
processed: 1

raw_data:

{
    "accountId": "ffaa4dd3-fcd8-4149-a434-bd2646d4e966",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161999020
updated: 2026-04-14 02:03:25

Version 1712677

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776064111'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776064111
id: 1712677
processed: 1

raw_data:

{
    "accountId": "ffb79df6-59ca-4174-b519-5f2beac94c97",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161941309
updated: 2026-04-13 02:09:57

Version 1711481

created: 2026-04-12 02:09:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977693'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977693
id: 1711481
processed: 1

raw_data:

{
    "accountId": "ffb79df6-59ca-4174-b519-5f2beac94c97",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161891911
updated: 2026-04-12 02:09:40

Version 1710289

created: 2026-04-11 02:09:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775891281'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775891281
id: 1710289
processed: 1

raw_data:

{
    "accountId": "ffbaee65-65ed-48a9-a4cb-4a350b74532b",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161839940
updated: 2026-04-11 02:09:24

Version 1709129

created: 2026-04-10 02:03:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804532'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804532
id: 1709129
processed: 1

raw_data:

{
    "accountId": "ffcb2937-4184-4c6e-b13e-bac4153753f8",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161784468
updated: 2026-04-10 02:03:28

Version 1707989

created: 2026-04-09 02:09:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718482'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718482
id: 1707989
processed: 1

raw_data:

{
    "accountId": "ffd9e70b-bcd9-4682-9789-a7186b485487",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161729235
updated: 2026-04-09 02:09:17

Version 1706778

created: 2026-04-08 02:09:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775632082'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775632082
id: 1706778
processed: 1

raw_data:

{
    "accountId": "ffe8057c-3b58-436c-8041-ed33b9aa25a3",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161674152
updated: 2026-04-08 02:09:34

Version 1705598

created: 2026-04-07 02:09:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545681'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545681
id: 1705598
processed: 1

raw_data:

{
    "accountId": "fff7795f-9dba-4447-b6a8-ca2b1cef368f",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161618154
updated: 2026-04-07 02:09:20

Version 1704372

created: 2026-04-06 02:09:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775459274'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775459274
id: 1704372
processed: 1

raw_data:

{
    "accountId": "ff5e91ea-3c42-4d9a-8c7a-a334cacc7edd",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161560248
updated: 2026-04-06 02:09:23

Version 1703172

created: 2026-04-05 02:09:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372893'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372893
id: 1703172
processed: 1

raw_data:

{
    "accountId": "ff5e91ea-3c42-4d9a-8c7a-a334cacc7edd",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161513639
updated: 2026-04-05 02:09:30

Version 1702003

created: 2026-04-04 02:09:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286472'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286472
id: 1702003
processed: 1

raw_data:

{
    "accountId": "ff5e91ea-3c42-4d9a-8c7a-a334cacc7edd",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161458946
updated: 2026-04-04 02:09:15

Version 1700791

created: 2026-04-03 02:03:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199718'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199718
id: 1700791
processed: 1

raw_data:

{
    "accountId": "ff687cc3-05cc-4060-a34f-1384e37bf3d6",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 20160,
    "oktaVerifyFactorEnabled": true,
    "otpFactorEnabled": true,
    "smsFactorEnabled": true
}

schema_attributes:

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

schema_name_id: 4303
schema_scan_id: 161400034
updated: 2026-04-03 02:03:26

Schema Scans: 15

Last at 2026-04-17 02:07:57

Scan 162166368

duration: 0:00:11.837981

exit_message:

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

id: 162166368

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5473482176710645303,
        "service_name": "drive-thru",
        "span_id": 16355708568862222229,
        "trace_id": 5380826266468009384
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-17 02:07:57
success: True
trace_id: 5380826266468009384

Scan 162110497

duration: 0:00:11.845233

exit_message:

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

id: 162110497

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776323292",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776323292/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2422611193458127211,
        "service_name": "drive-thru",
        "span_id": 12460251330993556771,
        "trace_id": 16674788643614174707
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-16 02:09:27
success: True
trace_id: 16674788643614174707

Scan 162054641

duration: 0:00:11.636998

exit_message:

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

id: 162054641

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236533",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236533/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7571422973850849971,
        "service_name": "drive-thru",
        "span_id": 3662236901098785777,
        "trace_id": 18236463083500953023
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-15 02:03:23
success: True
trace_id: 18236463083500953023

Scan 161999020

duration: 0:00:11.785631

exit_message:

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

id: 161999020

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150134",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150134/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18250691787940218970,
        "service_name": "drive-thru",
        "span_id": 3614545720855242472,
        "trace_id": 8954300468402988220
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-14 02:03:14
success: True
trace_id: 8954300468402988220

Scan 161941309

duration: 0:00:14.291726

exit_message:

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

id: 161941309

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776064111",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776064111/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14387040345412472931,
        "service_name": "drive-thru",
        "span_id": 1403629422595595977,
        "trace_id": 17278934358232554317
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-13 02:09:43
success: True
trace_id: 17278934358232554317

Scan 161891911

duration: 0:00:14.264488

exit_message:

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

id: 161891911

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977693",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977693/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2022806894284966187,
        "service_name": "drive-thru",
        "span_id": 6184298615672490975,
        "trace_id": 10857873729080359490
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-12 02:09:26
success: True
trace_id: 10857873729080359490

Scan 161839940

duration: 0:00:11.833934

exit_message:

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

id: 161839940

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775891281",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775891281/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6795433226718605797,
        "service_name": "drive-thru",
        "span_id": 12256170725039760316,
        "trace_id": 4541105221001891897
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-11 02:09:12
success: True
trace_id: 4541105221001891897

Scan 161784468

duration: 0:00:14.278798

exit_message:

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

id: 161784468

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804532",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804532/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10848632269246590606,
        "service_name": "drive-thru",
        "span_id": 2619585897037987993,
        "trace_id": 16809329177688929370
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-10 02:03:14
success: True
trace_id: 16809329177688929370

Scan 161729235

duration: 0:00:11.782738

exit_message:

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

id: 161729235

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718482",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718482/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1212422511654663400,
        "service_name": "drive-thru",
        "span_id": 14901927407439260413,
        "trace_id": 2067435555377329863
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-09 02:09:06
success: True
trace_id: 2067435555377329863

Scan 161674152

duration: 0:00:11.726485

exit_message:

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

id: 161674152

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775632082",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775632082/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6723964308439050212,
        "service_name": "drive-thru",
        "span_id": 6485636042916864906,
        "trace_id": 3189558106361861993
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-08 02:09:22
success: True
trace_id: 3189558106361861993

Scan 161618154

duration: 0:00:14.279206

exit_message:

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

id: 161618154

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545681",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545681/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12788051830061970960,
        "service_name": "drive-thru",
        "span_id": 17285496283540685263,
        "trace_id": 4983232008425241973
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-07 02:09:05
success: True
trace_id: 4983232008425241973

Scan 161560248

duration: 0:00:11.732963

exit_message:

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

id: 161560248

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775459274",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775459274/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12693200944962266275,
        "service_name": "drive-thru",
        "span_id": 6483653692095697568,
        "trace_id": 2818794854021919384
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-06 02:09:12
success: True
trace_id: 2818794854021919384

Scan 161513639

duration: 0:00:11.717201

exit_message:

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

id: 161513639

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372893",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372893/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15058790654953989691,
        "service_name": "drive-thru",
        "span_id": 13560880430055438160,
        "trace_id": 9369799914740379525
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-05 02:09:18
success: True
trace_id: 9369799914740379525

Scan 161458946

duration: 0:00:14.508745

exit_message:

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

id: 161458946

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286472",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286472/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3147159785716133144,
        "service_name": "drive-thru",
        "span_id": 15485658351418901501,
        "trace_id": 13788708182980430949
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-04 02:09:01
success: True
trace_id: 13788708182980430949

Scan 161400034

duration: 0:00:11.911690

exit_message:

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

id: 161400034

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199718",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199718/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4659036285728486204,
        "service_name": "drive-thru",
        "span_id": 4492666178681712639,
        "trace_id": 16329094426539013717
    }
}

running: False
schema_name_id: 4303
start_time: 2026-04-03 02:03:14
success: True
trace_id: 16329094426539013717

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:07:57

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-12-18 01:11:38",
        "disabled": false,
        "format": "raw",
        "id": 4303,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_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:07:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409606'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_okta_mfa_enrollment_settings"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}