Schema Info

Schema Name: sfdl_stage_drivethru.authsso_identity_providers

created: 2026-01-03 01:00:47
disabled: False
format: raw
id: 2254
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906597

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-17/1776409228'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-17/1776409228
id: 906597
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6415173
updated: 2026-04-17 02:01:09

Version 906380

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-16/1776322829'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-16/1776322829
id: 906380
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6414626
updated: 2026-04-16 02:00:58

Version 906168

created: 2026-04-15 02:00:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-15/1776236428'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-15/1776236428
id: 906168
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6414140
updated: 2026-04-15 02:01:02

Version 905953

created: 2026-04-14 02:00:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-14/1776150029'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-14/1776150029
id: 905953
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6413632
updated: 2026-04-14 02:00:59

Version 905737

created: 2026-04-13 02:00:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-13/1776063628'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-13/1776063628
id: 905737
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6413089
updated: 2026-04-13 02:00:52

Version 905535

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-12/1775977228'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-12/1775977228
id: 905535
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6412695
updated: 2026-04-12 02:01:01

Version 905333

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-11/1775890830'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-11/1775890830
id: 905333
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6412314
updated: 2026-04-11 02:01:09

Version 905119

created: 2026-04-10 02:00:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-10/1775804429'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-10/1775804429
id: 905119
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6411816
updated: 2026-04-10 02:01:02

Version 904905

created: 2026-04-09 02:00:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-09/1775718029'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-09/1775718029
id: 904905
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6411302
updated: 2026-04-09 02:01:04

Version 904691

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-08/1775631628'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-08/1775631628
id: 904691
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6410809
updated: 2026-04-08 02:00:58

Version 904478

created: 2026-04-07 02:00:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-07/1775545229'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-07/1775545229
id: 904478
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6410298
updated: 2026-04-07 02:00:59

Version 904263

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-06/1775458828'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-06/1775458828
id: 904263
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6409751
updated: 2026-04-06 02:00:55

Version 904062

created: 2026-04-05 02:00:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-05/1775372429'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-05/1775372429
id: 904062
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6409366
updated: 2026-04-05 02:01:05

Version 903859

created: 2026-04-04 02:00:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-04/1775286029'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-04/1775286029
id: 903859
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6408984
updated: 2026-04-04 02:01:04

Version 903645

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-03/1775199629'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-03/1775199629
id: 903645
processed: 1

raw_data:

{
    "accountDomainId": "00a993f6-c5d0-4ab1-9af6-b0855b807d4d",
    "accountId": "0ae68973-8f98-4505-ad5c-cad306643ac8",
    "createdAt": "2025-11-10T21:54:21.843Z",
    "deletedAt": null,
    "identityProviderId": "5be9814a-3306-4dd0-8426-9c553fbb05d4",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2025-11-10T21:54:28.619Z"
}

schema_attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

schema_name_id: 2254
schema_scan_id: 6408492
updated: 2026-04-03 02:00:53

Schema Scans: 15

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

Scan 6415173

duration: 0:00:11.769255

exit_message:

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

id: 6415173

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-17/1776409228",
        "key": "raw/authsso_identity_providers/2026-04-17/1776409228/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17976342959442052743,
        "service_name": "drive-thru",
        "span_id": 17093048886950929736,
        "trace_id": 15633574157957656989
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-17 02:00:57
success: True
trace_id: 15633574157957656989

Scan 6414626

duration: 0:00:14.463678

exit_message:

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

id: 6414626

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-16/1776322829",
        "key": "raw/authsso_identity_providers/2026-04-16/1776322829/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2314127524606871663,
        "service_name": "drive-thru",
        "span_id": 1424397967452027229,
        "trace_id": 12273744826783766200
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-16 02:00:44
success: True
trace_id: 12273744826783766200

Scan 6414140

duration: 0:00:11.761323

exit_message:

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

id: 6414140

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-15/1776236428",
        "key": "raw/authsso_identity_providers/2026-04-15/1776236428/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9258522442295534695,
        "service_name": "drive-thru",
        "span_id": 10456505375544327473,
        "trace_id": 16324823265102221356
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-15 02:00:50
success: True
trace_id: 16324823265102221356

Scan 6413632

duration: 0:00:14.358752

exit_message:

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

id: 6413632

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-14/1776150029",
        "key": "raw/authsso_identity_providers/2026-04-14/1776150029/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10932927019936807387,
        "service_name": "drive-thru",
        "span_id": 17376688224491347971,
        "trace_id": 14693780152126394937
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-14 02:00:44
success: True
trace_id: 14693780152126394937

Scan 6413089

duration: 0:00:14.429504

exit_message:

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

id: 6413089

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-13/1776063628",
        "key": "raw/authsso_identity_providers/2026-04-13/1776063628/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17077003872017138817,
        "service_name": "drive-thru",
        "span_id": 746176545696135474,
        "trace_id": 10038667442889176965
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-13 02:00:38
success: True
trace_id: 10038667442889176965

Scan 6412695

duration: 0:00:14.352405

exit_message:

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

id: 6412695

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-12/1775977228",
        "key": "raw/authsso_identity_providers/2026-04-12/1775977228/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11120863655124669343,
        "service_name": "drive-thru",
        "span_id": 3661402590124155536,
        "trace_id": 10709248113182757208
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-12 02:00:46
success: True
trace_id: 10709248113182757208

Scan 6412314

duration: 0:00:14.392168

exit_message:

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

id: 6412314

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-11/1775890830",
        "key": "raw/authsso_identity_providers/2026-04-11/1775890830/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17187463038294093879,
        "service_name": "drive-thru",
        "span_id": 1303306968914043842,
        "trace_id": 208851677484424035
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-11 02:00:54
success: True
trace_id: 208851677484424035

Scan 6411816

duration: 0:00:11.993499

exit_message:

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

id: 6411816

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-10/1775804429",
        "key": "raw/authsso_identity_providers/2026-04-10/1775804429/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3425096233225906552,
        "service_name": "drive-thru",
        "span_id": 12198377071714918191,
        "trace_id": 7618521636091670395
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-10 02:00:50
success: True
trace_id: 7618521636091670395

Scan 6411302

duration: 0:00:14.268561

exit_message:

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

id: 6411302

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-09/1775718029",
        "key": "raw/authsso_identity_providers/2026-04-09/1775718029/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11132985336888093579,
        "service_name": "drive-thru",
        "span_id": 633061726406455441,
        "trace_id": 8810439164800998185
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-09 02:00:50
success: True
trace_id: 8810439164800998185

Scan 6410809

duration: 0:00:14.495659

exit_message:

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

id: 6410809

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-08/1775631628",
        "key": "raw/authsso_identity_providers/2026-04-08/1775631628/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7874242565404080504,
        "service_name": "drive-thru",
        "span_id": 6974055923145322756,
        "trace_id": 1372829209082357564
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-08 02:00:44
success: True
trace_id: 1372829209082357564

Scan 6410298

duration: 0:00:14.346744

exit_message:

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

id: 6410298

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-07/1775545229",
        "key": "raw/authsso_identity_providers/2026-04-07/1775545229/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6489640913521244366,
        "service_name": "drive-thru",
        "span_id": 17615168600325463193,
        "trace_id": 3478079566382397550
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-07 02:00:45
success: True
trace_id: 3478079566382397550

Scan 6409751

duration: 0:00:14.369429

exit_message:

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

id: 6409751

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-06/1775458828",
        "key": "raw/authsso_identity_providers/2026-04-06/1775458828/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17520833127383655570,
        "service_name": "drive-thru",
        "span_id": 12603976461160832352,
        "trace_id": 15226883828737591982
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-06 02:00:41
success: True
trace_id: 15226883828737591982

Scan 6409366

duration: 0:00:14.376606

exit_message:

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

id: 6409366

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-05/1775372429",
        "key": "raw/authsso_identity_providers/2026-04-05/1775372429/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1640620627592059075,
        "service_name": "drive-thru",
        "span_id": 10976712167100873686,
        "trace_id": 14579401626252218351
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-05 02:00:50
success: True
trace_id: 14579401626252218351

Scan 6408984

duration: 0:00:14.388132

exit_message:

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

id: 6408984

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-04/1775286029",
        "key": "raw/authsso_identity_providers/2026-04-04/1775286029/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14572732334075662324,
        "service_name": "drive-thru",
        "span_id": 14208505149118733500,
        "trace_id": 12753288764715951941
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-04 02:00:50
success: True
trace_id: 12753288764715951941

Scan 6408492

duration: 0:00:14.269374

exit_message:

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

id: 6408492

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-03/1775199629",
        "key": "raw/authsso_identity_providers/2026-04-03/1775199629/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6952482971122910725,
        "service_name": "drive-thru",
        "span_id": 15898418535220669737,
        "trace_id": 3577025510155065876
    }
}

running: False
schema_name_id: 2254
start_time: 2026-04-03 02:00:39
success: True
trace_id: 3577025510155065876

Partitions:

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

Schema:

attributes:

{
    "accountDomainId": "string",
    "accountId": "string",
    "createdAt": "date",
    "deletedAt": "date",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "verifiedAt": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-17/1776409228'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
}

Server:

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

Raw:

{
    "name": {
        "created": "2026-01-03 01:00:47",
        "disabled": false,
        "format": "raw",
        "id": 2254,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "authsso_identity_providers"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accountDomainId": "string",
            "accountId": "string",
            "createdAt": "date",
            "deletedAt": "date",
            "identityProviderId": "string",
            "revokedAt": "string",
            "status": "string",
            "verifiedAt": "string"
        },
        "created": "2026-04-17 02:00:57",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-stage/raw/authsso_identity_providers/2026-04-17/1776409228'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_identity_providers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_identity_providers"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}