Schema Info

Schema Name: sfdl_stage_drivethru.authsso_account_domains

created: 2026-01-03 01:00:53
disabled: False
format: raw
id: 2255
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906596

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-17/1776409232'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-17/1776409232
id: 906596
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6415172
updated: 2026-04-17 02:01:01

Version 906381

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-16/1776322833'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-16/1776322833
id: 906381
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6414627
updated: 2026-04-16 02:01:09

Version 906167

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-15/1776236431'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-15/1776236431
id: 906167
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6414139
updated: 2026-04-15 02:00:51

Version 905954

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-14/1776150033'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-14/1776150033
id: 905954
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6413633
updated: 2026-04-14 02:01:09

Version 905738

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-13/1776063632'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-13/1776063632
id: 905738
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6413090
updated: 2026-04-13 02:01:01

Version 905536

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-12/1775977232'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-12/1775977232
id: 905536
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6412696
updated: 2026-04-12 02:01:03

Version 905335

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-11/1775890833'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-11/1775890833
id: 905335
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6412315
updated: 2026-04-11 02:01:20

Version 905120

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-10/1775804433'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-10/1775804433
id: 905120
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6411817
updated: 2026-04-10 02:01:16

Version 904906

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-09/1775718033'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-09/1775718033
id: 904906
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6411303
updated: 2026-04-09 02:01:08

Version 904692

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-08/1775631631'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-08/1775631631
id: 904692
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6410810
updated: 2026-04-08 02:01:01

Version 904477

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-07/1775545230'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-07/1775545230
id: 904477
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6410297
updated: 2026-04-07 02:00:55

Version 904264

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-06/1775458832'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-06/1775458832
id: 904264
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6409752
updated: 2026-04-06 02:00:56

Version 904061

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-05/1775372432'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-05/1775372432
id: 904061
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6409365
updated: 2026-04-05 02:00:59

Version 903861

created: 2026-04-04 02:00:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-04/1775286033'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-04/1775286033
id: 903861
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6408986
updated: 2026-04-04 02:01:10

Version 903646

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-03/1775199629'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-03/1775199629
id: 903646
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": "date",
    "status": "string",
    "verifiedAt": "date"
}

schema_name_id: 2255
schema_scan_id: 6408493
updated: 2026-04-03 02:01:03

Schema Scans: 15

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

Scan 6415172

duration: 0:00:14.377517

exit_message:

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

id: 6415172

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-17/1776409232",
        "key": "raw/authsso_account_domains/2026-04-17/1776409232/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18230801710438142588,
        "service_name": "drive-thru",
        "span_id": 16336340468810336817,
        "trace_id": 6492855432581868317
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-17 02:00:47
success: True
trace_id: 6492855432581868317

Scan 6414627

duration: 0:00:11.896888

exit_message:

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

id: 6414627

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-16/1776322833",
        "key": "raw/authsso_account_domains/2026-04-16/1776322833/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11469511893023555815,
        "service_name": "drive-thru",
        "span_id": 6660714143452027671,
        "trace_id": 15522955959214016623
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-16 02:00:57
success: True
trace_id: 15522955959214016623

Scan 6414139

duration: 0:00:11.792178

exit_message:

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

id: 6414139

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-15/1776236431",
        "key": "raw/authsso_account_domains/2026-04-15/1776236431/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17467413800374936057,
        "service_name": "drive-thru",
        "span_id": 10760817820908462919,
        "trace_id": 12558941302621263639
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-15 02:00:40
success: True
trace_id: 12558941302621263639

Scan 6413633

duration: 0:00:14.441318

exit_message:

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

id: 6413633

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-14/1776150033",
        "key": "raw/authsso_account_domains/2026-04-14/1776150033/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6442678092507468501,
        "service_name": "drive-thru",
        "span_id": 4350184602847877467,
        "trace_id": 6923515856949552908
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-14 02:00:55
success: True
trace_id: 6923515856949552908

Scan 6413090

duration: 0:00:14.416284

exit_message:

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

id: 6413090

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-13/1776063632",
        "key": "raw/authsso_account_domains/2026-04-13/1776063632/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12302593228674680175,
        "service_name": "drive-thru",
        "span_id": 3534623494088070758,
        "trace_id": 11056692156432927259
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-13 02:00:47
success: True
trace_id: 11056692156432927259

Scan 6412696

duration: 0:00:11.850976

exit_message:

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

id: 6412696

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-12/1775977232",
        "key": "raw/authsso_account_domains/2026-04-12/1775977232/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9169842964367776389,
        "service_name": "drive-thru",
        "span_id": 4961712029336913545,
        "trace_id": 3252749785245872305
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-12 02:00:51
success: True
trace_id: 3252749785245872305

Scan 6412315

duration: 0:00:11.809020

exit_message:

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

id: 6412315

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-11/1775890833",
        "key": "raw/authsso_account_domains/2026-04-11/1775890833/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9304885166962089478,
        "service_name": "drive-thru",
        "span_id": 9759460848374293742,
        "trace_id": 15679000344453273118
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-11 02:01:09
success: True
trace_id: 15679000344453273118

Scan 6411817

duration: 0:00:14.391231

exit_message:

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

id: 6411817

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-10/1775804433",
        "key": "raw/authsso_account_domains/2026-04-10/1775804433/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6077654594703982735,
        "service_name": "drive-thru",
        "span_id": 17946211032347589834,
        "trace_id": 976152608319492380
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-10 02:01:02
success: True
trace_id: 976152608319492380

Scan 6411303

duration: 0:00:11.753909

exit_message:

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

id: 6411303

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-09/1775718033",
        "key": "raw/authsso_account_domains/2026-04-09/1775718033/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7567295073637678684,
        "service_name": "drive-thru",
        "span_id": 842334889884772099,
        "trace_id": 11767144478261000255
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-09 02:00:56
success: True
trace_id: 11767144478261000255

Scan 6410810

duration: 0:00:14.312892

exit_message:

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

id: 6410810

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-08/1775631631",
        "key": "raw/authsso_account_domains/2026-04-08/1775631631/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15648861257002760783,
        "service_name": "drive-thru",
        "span_id": 17911475998571759027,
        "trace_id": 15199983112058627357
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-08 02:00:46
success: True
trace_id: 15199983112058627357

Scan 6410297

duration: 0:00:11.915698

exit_message:

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

id: 6410297

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-07/1775545230",
        "key": "raw/authsso_account_domains/2026-04-07/1775545230/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16935246002653783124,
        "service_name": "drive-thru",
        "span_id": 12712864484805451659,
        "trace_id": 11138534035573633469
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-07 02:00:43
success: True
trace_id: 11138534035573633469

Scan 6409752

duration: 0:00:14.306517

exit_message:

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

id: 6409752

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-06/1775458832",
        "key": "raw/authsso_account_domains/2026-04-06/1775458832/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1762850501996338425,
        "service_name": "drive-thru",
        "span_id": 13122106181343692177,
        "trace_id": 12889008006922658205
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-06 02:00:42
success: True
trace_id: 12889008006922658205

Scan 6409365

duration: 0:00:14.328262

exit_message:

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

id: 6409365

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-05/1775372432",
        "key": "raw/authsso_account_domains/2026-04-05/1775372432/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7024945315057371678,
        "service_name": "drive-thru",
        "span_id": 7202874649281562974,
        "trace_id": 7935424186012613957
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-05 02:00:45
success: True
trace_id: 7935424186012613957

Scan 6408986

duration: 0:00:11.764343

exit_message:

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

id: 6408986

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-04/1775286033",
        "key": "raw/authsso_account_domains/2026-04-04/1775286033/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11356632275399140664,
        "service_name": "drive-thru",
        "span_id": 2929839021854938683,
        "trace_id": 11105197177816913982
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-04 02:00:59
success: True
trace_id: 11105197177816913982

Scan 6408493

duration: 0:00:14.424051

exit_message:

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

id: 6408493

payload:

{
    "datatype_dict": {
        "accountDomainId": "string",
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "identityProviderId": "string",
        "revokedAt": "date",
        "status": "string",
        "verifiedAt": "date"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_account_domains/2026-04-03/1775199629",
        "key": "raw/authsso_account_domains/2026-04-03/1775199629/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14408398133212108056,
        "service_name": "drive-thru",
        "span_id": 10915665732311233731,
        "trace_id": 13912211943561634227
    }
}

running: False
schema_name_id: 2255
start_time: 2026-04-03 02:00:48
success: True
trace_id: 13912211943561634227

Partitions:

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

Schema:

attributes:

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

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-17/1776409232'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
}

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:53",
        "disabled": false,
        "format": "raw",
        "id": 2255,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "authsso_account_domains"
        },
        "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": "date",
            "status": "string",
            "verifiedAt": "date"
        },
        "created": "2026-04-17 02:00:47",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_account_domains`\n(\n`accountDomainId`string,`accountId`string,`identityProviderId`string,`status`string,`verifiedAt`date,`revokedAt`date,`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_account_domains/2026-04-17/1776409232'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_account_domains`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_account_domains"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}