Schema Info

Schema Name: sfdl_prod_drivethru.authsso_account_domains

created: 2026-01-09 01:00:49
disabled: False
format: raw
id: 4308
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717528

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-17/1776409262
id: 1717528
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-17T00:02:42.009Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 162166285
updated: 2026-04-17 02:01:42

Version 1716294

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-16/1776322830
id: 1716294
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 162110427
updated: 2026-04-16 02:01:25

Version 1715103

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-15/1776236426
id: 1715103
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 162054588
updated: 2026-04-15 02:01:11

Version 1713913

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-14/1776150030
id: 1713913
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161998815
updated: 2026-04-14 02:01:27

Version 1712671

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-13/1776063652
id: 1712671
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161941272
updated: 2026-04-13 02:01:28

Version 1711474

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-12/1775977238
id: 1711474
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161891750
updated: 2026-04-12 02:01:22

Version 1710283

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-11/1775890828
id: 1710283
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161839715
updated: 2026-04-11 02:00:52

Version 1709125

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-10/1775804429
id: 1709125
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161784422
updated: 2026-04-10 02:01:34

Version 1707982

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-09/1775718030
id: 1707982
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161729171
updated: 2026-04-09 02:01:32

Version 1706770

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-08/1775631632
id: 1706770
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161674080
updated: 2026-04-08 02:01:17

Version 1705591

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-07/1775545231
id: 1705591
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161617973
updated: 2026-04-07 02:01:09

Version 1704365

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-06/1775458826
id: 1704365
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161560167
updated: 2026-04-06 02:01:57

Version 1703167

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-05/1775372443
id: 1703167
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161513613
updated: 2026-04-05 02:01:05

Version 1701998

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-04/1775286031
id: 1701998
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161458804
updated: 2026-04-04 02:02:30

Version 1700785

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-03/1775199625
id: 1700785
processed: 1

raw_data:

{
    "accountDomainId": "3e834904-6ace-487a-9a91-f61f3400160f",
    "accountId": "18b0c8af-da10-44d3-86d1-94345cb59275",
    "createdAt": "2026-02-15T22:03:50.613Z",
    "deletedAt": null,
    "identityProviderId": "3cd22570-2b1d-4e06-909c-a99732b85769",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-17T23:00:50.163Z"
}

schema_attributes:

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

schema_name_id: 4308
schema_scan_id: 161399932
updated: 2026-04-03 02:01:01

Schema Scans: 15

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

Scan 162166285

duration: 0:00:14.257270

exit_message:

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

id: 162166285

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-17/1776409262",
        "key": "raw/authsso_account_domains/2026-04-17/1776409262/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 280792192478182259,
        "service_name": "drive-thru",
        "span_id": 18352477973528836538,
        "trace_id": 2006128752167013255
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-17 02:01:28
success: True
trace_id: 2006128752167013255

Scan 162110427

duration: 0:00:14.349108

exit_message:

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

id: 162110427

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-16/1776322830",
        "key": "raw/authsso_account_domains/2026-04-16/1776322830/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8520273194773137873,
        "service_name": "drive-thru",
        "span_id": 5035532477951922414,
        "trace_id": 2360369612924781769
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-16 02:01:11
success: True
trace_id: 2360369612924781769

Scan 162054588

duration: 0:00:14.352567

exit_message:

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

id: 162054588

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-15/1776236426",
        "key": "raw/authsso_account_domains/2026-04-15/1776236426/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8792776274205547082,
        "service_name": "drive-thru",
        "span_id": 9242985098686250360,
        "trace_id": 2628048690091225578
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-15 02:00:56
success: True
trace_id: 2628048690091225578

Scan 161998815

duration: 0:00:11.813851

exit_message:

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

id: 161998815

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-14/1776150030",
        "key": "raw/authsso_account_domains/2026-04-14/1776150030/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13969653091097743228,
        "service_name": "drive-thru",
        "span_id": 14778981446985158072,
        "trace_id": 11001930353826307804
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-14 02:01:15
success: True
trace_id: 11001930353826307804

Scan 161941272

duration: 0:00:11.710667

exit_message:

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

id: 161941272

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-13/1776063652",
        "key": "raw/authsso_account_domains/2026-04-13/1776063652/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2741006034957967176,
        "service_name": "drive-thru",
        "span_id": 3417967350057927940,
        "trace_id": 7016144981518006087
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-13 02:01:16
success: True
trace_id: 7016144981518006087

Scan 161891750

duration: 0:00:14.354902

exit_message:

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

id: 161891750

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-12/1775977238",
        "key": "raw/authsso_account_domains/2026-04-12/1775977238/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4463502510387826498,
        "service_name": "drive-thru",
        "span_id": 11107080346384625711,
        "trace_id": 7494561811112330030
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-12 02:01:08
success: True
trace_id: 7494561811112330030

Scan 161839715

duration: 0:00:11.767267

exit_message:

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

id: 161839715

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-11/1775890828",
        "key": "raw/authsso_account_domains/2026-04-11/1775890828/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11668019953719553733,
        "service_name": "drive-thru",
        "span_id": 3810879634595396404,
        "trace_id": 9651243149677759844
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-11 02:00:41
success: True
trace_id: 9651243149677759844

Scan 161784422

duration: 0:00:14.277845

exit_message:

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

id: 161784422

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-10/1775804429",
        "key": "raw/authsso_account_domains/2026-04-10/1775804429/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15196482032329453087,
        "service_name": "drive-thru",
        "span_id": 9377057732353171652,
        "trace_id": 15449546310288573814
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-10 02:01:20
success: True
trace_id: 15449546310288573814

Scan 161729171

duration: 0:00:14.182501

exit_message:

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

id: 161729171

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-09/1775718030",
        "key": "raw/authsso_account_domains/2026-04-09/1775718030/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17635400445155989751,
        "service_name": "drive-thru",
        "span_id": 2123117244675304838,
        "trace_id": 3000689924503868772
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-09 02:01:18
success: True
trace_id: 3000689924503868772

Scan 161674080

duration: 0:00:14.437035

exit_message:

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

id: 161674080

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-08/1775631632",
        "key": "raw/authsso_account_domains/2026-04-08/1775631632/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13560471990243125015,
        "service_name": "drive-thru",
        "span_id": 3402409759761980118,
        "trace_id": 13730332051942707551
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-08 02:01:03
success: True
trace_id: 13730332051942707551

Scan 161617973

duration: 0:00:14.327378

exit_message:

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

id: 161617973

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-07/1775545231",
        "key": "raw/authsso_account_domains/2026-04-07/1775545231/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15497467947866687002,
        "service_name": "drive-thru",
        "span_id": 11173622554467514254,
        "trace_id": 3363042746109750288
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-07 02:00:55
success: True
trace_id: 3363042746109750288

Scan 161560167

duration: 0:00:14.221027

exit_message:

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

id: 161560167

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-06/1775458826",
        "key": "raw/authsso_account_domains/2026-04-06/1775458826/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16459077197525895632,
        "service_name": "drive-thru",
        "span_id": 10625442334369198761,
        "trace_id": 11607017637225130566
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-06 02:01:43
success: True
trace_id: 11607017637225130566

Scan 161513613

duration: 0:00:14.409638

exit_message:

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

id: 161513613

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-05/1775372443",
        "key": "raw/authsso_account_domains/2026-04-05/1775372443/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14820085915240127474,
        "service_name": "drive-thru",
        "span_id": 1780475548175329477,
        "trace_id": 4539253347405158062
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-05 02:00:50
success: True
trace_id: 4539253347405158062

Scan 161458804

duration: 0:00:14.450557

exit_message:

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

id: 161458804

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-04/1775286031",
        "key": "raw/authsso_account_domains/2026-04-04/1775286031/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7694941392975954651,
        "service_name": "drive-thru",
        "span_id": 12004945328124897780,
        "trace_id": 18006757963602106237
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-04 02:02:16
success: True
trace_id: 18006757963602106237

Scan 161399932

duration: 0:00:14.384708

exit_message:

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

id: 161399932

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-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_account_domains/2026-04-03/1775199625",
        "key": "raw/authsso_account_domains/2026-04-03/1775199625/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_account_domains",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14068638085832491596,
        "service_name": "drive-thru",
        "span_id": 11301241663349224403,
        "trace_id": 14025936951687275140
    }
}

running: False
schema_name_id: 4308
start_time: 2026-04-03 02:00:47
success: True
trace_id: 14025936951687275140

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

ddl:

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

Server:

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

Raw:

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