Schema Info

Schema Name: sfdl_prod_drivethru.authsso_identity_providers

created: 2026-01-09 01:00:52
disabled: False
format: raw
id: 4309
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717526

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-17/1776409261
id: 1717526
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 162166257
updated: 2026-04-17 02:01:27

Version 1716293

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-16/1776322829
id: 1716293
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 162110398
updated: 2026-04-16 02:01:13

Version 1715102

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-15/1776236426
id: 1715102
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 162054587
updated: 2026-04-15 02:01:10

Version 1713919

created: 2026-04-14 02:02:23

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-14/1776150029
id: 1713919
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161998972
updated: 2026-04-14 02:02:34

Version 1712672

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-13/1776063651
id: 1712672
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161941278
updated: 2026-04-13 02:01:30

Version 1711475

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-12/1775977237
id: 1711475
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161891847
updated: 2026-04-12 02:01:56

Version 1710285

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-11/1775890827
id: 1710285
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161839892
updated: 2026-04-11 02:01:53

Version 1709123

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-10/1775804428
id: 1709123
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161784360
updated: 2026-04-10 02:01:09

Version 1707981

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-09/1775718030
id: 1707981
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161729149
updated: 2026-04-09 02:01:23

Version 1706771

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-08/1775631631
id: 1706771
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161674090
updated: 2026-04-08 02:01:21

Version 1705593

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-07/1775545230
id: 1705593
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161618069
updated: 2026-04-07 02:01:43

Version 1704364

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-06/1775458826
id: 1704364
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161560023
updated: 2026-04-06 02:00:44

Version 1703166

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-05/1775372443
id: 1703166
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161513612
updated: 2026-04-05 02:00:58

Version 1702000

created: 2026-04-04 02:02:40

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-04/1775286030
id: 1702000
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161458869
updated: 2026-04-04 02:02:54

Version 1700784

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-03/1775199625
id: 1700784
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",
    "id": "string",
    "identityProviderId": "string",
    "revokedAt": "string",
    "status": "string",
    "useOktaMfa": "string",
    "verifiedAt": "string"
}

schema_name_id: 4309
schema_scan_id: 161399878
updated: 2026-04-03 02:00:40

Schema Scans: 15

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

Scan 162166257

duration: 0:00:11.700202

exit_message:

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

id: 162166257

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-17/1776409261",
        "key": "raw/authsso_identity_providers/2026-04-17/1776409261/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6541046898872132695,
        "service_name": "drive-thru",
        "span_id": 6594179093666310662,
        "trace_id": 17936354992803852039
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-17 02:01:16
success: True
trace_id: 17936354992803852039

Scan 162110398

duration: 0:00:14.263746

exit_message:

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

id: 162110398

payload:

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

running: False
schema_name_id: 4309
start_time: 2026-04-16 02:00:59
success: True
trace_id: 9627066918309458710

Scan 162054587

duration: 0:00:14.290675

exit_message:

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

id: 162054587

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-15/1776236426",
        "key": "raw/authsso_identity_providers/2026-04-15/1776236426/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16930669872168194073,
        "service_name": "drive-thru",
        "span_id": 18290869868439709294,
        "trace_id": 17461130776887245121
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-15 02:00:56
success: True
trace_id: 17461130776887245121

Scan 161998972

duration: 0:00:11.727395

exit_message:

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

id: 161998972

payload:

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

running: False
schema_name_id: 4309
start_time: 2026-04-14 02:02:23
success: True
trace_id: 4844363274095635665

Scan 161941278

duration: 0:00:11.823944

exit_message:

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

id: 161941278

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-13/1776063651",
        "key": "raw/authsso_identity_providers/2026-04-13/1776063651/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9116320121130606450,
        "service_name": "drive-thru",
        "span_id": 5682809174704605659,
        "trace_id": 3043995433899034710
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-13 02:01:18
success: True
trace_id: 3043995433899034710

Scan 161891847

duration: 0:00:14.154638

exit_message:

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

id: 161891847

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-12/1775977237",
        "key": "raw/authsso_identity_providers/2026-04-12/1775977237/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9153173444662982369,
        "service_name": "drive-thru",
        "span_id": 14787640724651864751,
        "trace_id": 13683481729218584147
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-12 02:01:42
success: True
trace_id: 13683481729218584147

Scan 161839892

duration: 0:00:11.772606

exit_message:

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

id: 161839892

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-11/1775890827",
        "key": "raw/authsso_identity_providers/2026-04-11/1775890827/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16443064614676299631,
        "service_name": "drive-thru",
        "span_id": 10632013648846769976,
        "trace_id": 14139184709465897677
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-11 02:01:41
success: True
trace_id: 14139184709465897677

Scan 161784360

duration: 0:00:11.762051

exit_message:

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

id: 161784360

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-10/1775804428",
        "key": "raw/authsso_identity_providers/2026-04-10/1775804428/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12993174574032581972,
        "service_name": "drive-thru",
        "span_id": 6626799036199786643,
        "trace_id": 5522821697885536140
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-10 02:00:57
success: True
trace_id: 5522821697885536140

Scan 161729149

duration: 0:00:14.235615

exit_message:

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

id: 161729149

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-09/1775718030",
        "key": "raw/authsso_identity_providers/2026-04-09/1775718030/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5351078662260052975,
        "service_name": "drive-thru",
        "span_id": 17546402684029788037,
        "trace_id": 9805718545597537539
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-09 02:01:09
success: True
trace_id: 9805718545597537539

Scan 161674090

duration: 0:00:14.288597

exit_message:

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

id: 161674090

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-08/1775631631",
        "key": "raw/authsso_identity_providers/2026-04-08/1775631631/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9553662750789978069,
        "service_name": "drive-thru",
        "span_id": 16995517016468649884,
        "trace_id": 15501275166921095639
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-08 02:01:07
success: True
trace_id: 15501275166921095639

Scan 161618069

duration: 0:00:11.729876

exit_message:

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

id: 161618069

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-07/1775545230",
        "key": "raw/authsso_identity_providers/2026-04-07/1775545230/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5137836656288717615,
        "service_name": "drive-thru",
        "span_id": 14948461195381539177,
        "trace_id": 11417972667626148632
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-07 02:01:31
success: True
trace_id: 11417972667626148632

Scan 161560023

duration: 0:00:11.837724

exit_message:

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

id: 161560023

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-06/1775458826",
        "key": "raw/authsso_identity_providers/2026-04-06/1775458826/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17494654204751750491,
        "service_name": "drive-thru",
        "span_id": 13231860652630026932,
        "trace_id": 5265587535838803608
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-06 02:00:32
success: True
trace_id: 5265587535838803608

Scan 161513612

duration: 0:00:11.742114

exit_message:

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

id: 161513612

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-05/1775372443",
        "key": "raw/authsso_identity_providers/2026-04-05/1775372443/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 771581688540320781,
        "service_name": "drive-thru",
        "span_id": 871210874864244970,
        "trace_id": 13726592667079305668
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-05 02:00:46
success: True
trace_id: 13726592667079305668

Scan 161458869

duration: 0:00:14.294133

exit_message:

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

id: 161458869

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-04/1775286030",
        "key": "raw/authsso_identity_providers/2026-04-04/1775286030/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12983972124094743763,
        "service_name": "drive-thru",
        "span_id": 15466607180130122641,
        "trace_id": 8915065432462897988
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-04 02:02:40
success: True
trace_id: 8915065432462897988

Scan 161399878

duration: 0:00:11.946238

exit_message:

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

id: 161399878

payload:

{
    "datatype_dict": {
        "accountId": "string",
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "useOktaMfa": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-03/1775199625",
        "key": "raw/authsso_identity_providers/2026-04-03/1775199625/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_identity_providers",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8688535936117656765,
        "service_name": "drive-thru",
        "span_id": 17640976600035047664,
        "trace_id": 7313528833610659328
    }
}

running: False
schema_name_id: 4309
start_time: 2026-04-03 02:00:28
success: True
trace_id: 7313528833610659328

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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:52",
        "disabled": false,
        "format": "raw",
        "id": 4309,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "authsso_identity_providers"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accountDomainId": "string",
            "accountId": "string",
            "createdAt": "date",
            "deletedAt": "date",
            "id": "string",
            "identityProviderId": "string",
            "revokedAt": "string",
            "status": "string",
            "useOktaMfa": "string",
            "verifiedAt": "string"
        },
        "created": "2026-04-17 02:01:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_identity_providers`\n(\n`accountDomainId`STRING,`accountId`string,`identityProviderId`STRING,`status`STRING,`verifiedAt`STRING,`revokedAt`STRING,`createdAt`date,`deletedAt`date\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/authsso_identity_providers/2026-04-17/1776409261'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_identity_providers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_identity_providers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}