Schema Info

Schema Name: sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings

created: 2025-12-09 01:01:05
disabled: False
format: raw
id: 3132
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773324

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409260
id: 4773324
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6867627
updated: 2026-04-17 02:01:24

Version 4773267

created: 2026-04-16 02:02:18

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322870
id: 4773267
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6867368
updated: 2026-04-16 02:02:29

Version 4773204

created: 2026-04-15 02:01:50

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236454
id: 4773204
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6867103
updated: 2026-04-15 02:02:01

Version 4773142

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150030
id: 4773142
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6866839
updated: 2026-04-14 02:01:15

Version 4773085

created: 2026-04-13 02:02:35

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063664
id: 4773085
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6866533
updated: 2026-04-13 02:02:48

Version 4773030

created: 2026-04-12 02:00:57

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977252
id: 4773030
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6866352
updated: 2026-04-12 02:01:11

Version 4772982

created: 2026-04-11 02:00:58

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890830
id: 4772982
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6866180
updated: 2026-04-11 02:01:12

Version 4772925

created: 2026-04-10 02:01:58

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804452
id: 4772925
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6865911
updated: 2026-04-10 02:02:10

Version 4772858

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718027
id: 4772858
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6865636
updated: 2026-04-09 02:01:14

Version 4772797

created: 2026-04-08 02:00:47

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631629
id: 4772797
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6865367
updated: 2026-04-08 02:01:01

Version 4772742

created: 2026-04-07 02:01:23

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545230
id: 4772742
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6865104
updated: 2026-04-07 02:01:44

Version 4772675

created: 2026-04-06 02:00:30

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458823
id: 4772675
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6864777
updated: 2026-04-06 02:00:44

Version 4772630

created: 2026-04-05 02:01:35

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372449
id: 4772630
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6864608
updated: 2026-04-05 02:01:49

Version 4772583

created: 2026-04-04 02:01:29

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286028
id: 4772583
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6864437
updated: 2026-04-04 02:01:40

Version 4772516

created: 2026-04-03 02:00:44

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199623
id: 4772516
processed: 1

raw_data:

{
    "accountId": "00000000-0000-0000-0000-000000000001",
    "emailFactorEnabled": true,
    "fidoFactorEnabled": true,
    "mfaEnabled": true,
    "mfaRefreshIntervalMinutes": 129600,
    "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: 3132
schema_scan_id: 6864162
updated: 2026-04-03 02:00:55

Schema Scans: 15

Last at 2026-04-17 02:01:12

Scan 6867627

duration: 0:00:11.918565

exit_message:

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

id: 6867627

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409260",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409260/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3860984538392982461,
        "service_name": "drive-thru",
        "span_id": 6926494659715073989,
        "trace_id": 5205251398568534636
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-17 02:01:12
success: True
trace_id: 5205251398568534636

Scan 6867368

duration: 0:00:11.654541

exit_message:

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

id: 6867368

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322870",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-16/1776322870/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1129293256889458359,
        "service_name": "drive-thru",
        "span_id": 17433390930912853638,
        "trace_id": 11321431518191064914
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-16 02:02:18
success: True
trace_id: 11321431518191064914

Scan 6867103

duration: 0:00:11.906842

exit_message:

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

id: 6867103

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236454",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-15/1776236454/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6410349139766924619,
        "service_name": "drive-thru",
        "span_id": 12026753264198452268,
        "trace_id": 1104595871837692882
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-15 02:01:49
success: True
trace_id: 1104595871837692882

Scan 6866839

duration: 0:00:11.841152

exit_message:

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

id: 6866839

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150030",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-14/1776150030/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8194445623123005867,
        "service_name": "drive-thru",
        "span_id": 1024026944265678232,
        "trace_id": 5007205043215157168
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-14 02:01:03
success: True
trace_id: 5007205043215157168

Scan 6866533

duration: 0:00:14.342122

exit_message:

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

id: 6866533

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063664",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-13/1776063664/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5285598271482794984,
        "service_name": "drive-thru",
        "span_id": 1066917926859118194,
        "trace_id": 7807441080971805695
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-13 02:02:34
success: True
trace_id: 7807441080971805695

Scan 6866352

duration: 0:00:14.360350

exit_message:

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

id: 6866352

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977252",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-12/1775977252/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17379546801513631868,
        "service_name": "drive-thru",
        "span_id": 6054675711064627539,
        "trace_id": 4299670921337169772
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-12 02:00:56
success: True
trace_id: 4299670921337169772

Scan 6866180

duration: 0:00:14.458735

exit_message:

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

id: 6866180

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890830",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-11/1775890830/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16202198488020050718,
        "service_name": "drive-thru",
        "span_id": 4471384496207306729,
        "trace_id": 12668126370432913697
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-11 02:00:58
success: True
trace_id: 12668126370432913697

Scan 6865911

duration: 0:00:11.810078

exit_message:

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

id: 6865911

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804452",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-10/1775804452/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3659574678990690621,
        "service_name": "drive-thru",
        "span_id": 1974412612383538387,
        "trace_id": 15095344635903660093
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-10 02:01:58
success: True
trace_id: 15095344635903660093

Scan 6865636

duration: 0:00:11.864592

exit_message:

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

id: 6865636

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718027",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-09/1775718027/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12987977567175037484,
        "service_name": "drive-thru",
        "span_id": 12558542443419732964,
        "trace_id": 18443897951600482746
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-09 02:01:02
success: True
trace_id: 18443897951600482746

Scan 6865367

duration: 0:00:14.441482

exit_message:

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

id: 6865367

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631629",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-08/1775631629/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 213246828666171673,
        "service_name": "drive-thru",
        "span_id": 12395802263196795840,
        "trace_id": 15122774164599065178
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-08 02:00:47
success: True
trace_id: 15122774164599065178

Scan 6865104

duration: 0:00:22.088252

exit_message:

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

id: 6865104

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545230",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-07/1775545230/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16671705568545080113,
        "service_name": "drive-thru",
        "span_id": 10890392451199155473,
        "trace_id": 12475734854214513368
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-07 02:01:22
success: True
trace_id: 12475734854214513368

Scan 6864777

duration: 0:00:14.295892

exit_message:

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

id: 6864777

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458823",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-06/1775458823/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14285216147743891071,
        "service_name": "drive-thru",
        "span_id": 11948340845762762676,
        "trace_id": 13127640297338011445
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-06 02:00:30
success: True
trace_id: 13127640297338011445

Scan 6864608

duration: 0:00:14.320105

exit_message:

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

id: 6864608

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372449",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-05/1775372449/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2024595977169073386,
        "service_name": "drive-thru",
        "span_id": 9558839611962566272,
        "trace_id": 12739795273064545181
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-05 02:01:35
success: True
trace_id: 12739795273064545181

Scan 6864437

duration: 0:00:11.678487

exit_message:

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

id: 6864437

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286028",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-04/1775286028/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1824204063932332536,
        "service_name": "drive-thru",
        "span_id": 1449434261328250020,
        "trace_id": 11443759055719290100
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-04 02:01:29
success: True
trace_id: 11443759055719290100

Scan 6864162

duration: 0:00:11.952125

exit_message:

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

id: 6864162

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199623",
        "key": "raw/authsso_okta_mfa_enrollment_settings/2026-04-03/1775199623/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17204109566504377187,
        "service_name": "drive-thru",
        "span_id": 9313430845688999862,
        "trace_id": 8037653095341423006
    }
}

running: False
schema_name_id: 3132
start_time: 2026-04-03 02:00:43
success: True
trace_id: 8037653095341423006

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:01:12

ddl:

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

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2025-12-09 01:01:05",
        "disabled": false,
        "format": "raw",
        "id": 3132,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:01:12",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_okta_mfa_enrollment_settings/2026-04-17/1776409260'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_okta_mfa_enrollment_settings"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}