Schema Info

Schema Name: sfdl_dev_drivethru.authsso_identity_providers

created: 2026-01-02 15:00:41
disabled: False
format: raw
id: 3136
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773325

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-17/1776409227
id: 4773325
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6867628
updated: 2026-04-17 02:01:35

Version 4773262

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-16/1776322863
id: 4773262
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6867363
updated: 2026-04-16 02:01:52

Version 4773206

created: 2026-04-15 02:02:02

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-15/1776236459
id: 4773206
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6867105
updated: 2026-04-15 02:02:16

Version 4773144

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-14/1776150028
id: 4773144
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6866841
updated: 2026-04-14 02:01:29

Version 4773081

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-13/1776063663
id: 4773081
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6866529
updated: 2026-04-13 02:02:08

Version 4773032

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-12/1775977251
id: 4773032
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6866354
updated: 2026-04-12 02:01:25

Version 4772985

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-11/1775890833
id: 4772985
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6866183
updated: 2026-04-11 02:01:43

Version 4772926

created: 2026-04-10 02:02:07

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-10/1775804453
id: 4772926
processed: 1

raw_data:

{
    "accountDomainId": "9067beb3-5472-4ad5-9c26-12da5020ebaf",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-04-09T18:09:28.554Z",
    "deletedAt": null,
    "identityProviderId": "80249a10-0f6e-4391-aad9-c3d54b0f63d2",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-04-09T18:09:28.554Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6865912
updated: 2026-04-10 02:02:21

Version 4772859

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-09/1775718033
id: 4772859
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6865637
updated: 2026-04-09 02:01:22

Version 4772798

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-08/1775631648
id: 4772798
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6865368
updated: 2026-04-08 02:01:28

Version 4772741

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-07/1775545231
id: 4772741
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6865103
updated: 2026-04-07 02:01:27

Version 4772679

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-06/1775458830
id: 4772679
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6864781
updated: 2026-04-06 02:01:12

Version 4772632

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-05/1775372451
id: 4772632
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6864610
updated: 2026-04-05 02:02:04

Version 4772579

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

ddl:

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

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

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6864433
updated: 2026-04-04 02:01:17

Version 4772518

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_identity_providers/2026-04-03/1775199626
id: 4772518
processed: 1

raw_data:

{
    "accountDomainId": "565027ff-c431-446b-a9f3-15c0f0abad10",
    "accountId": "00000000-0000-0000-0000-000000000001",
    "createdAt": "2026-03-30T16:18:31.682Z",
    "deletedAt": null,
    "identityProviderId": "1c5e5655-c455-44ee-9ab3-13de56663cc3",
    "revokedAt": null,
    "status": "Valid",
    "verifiedAt": "2026-03-30T16:18:31.682Z"
}

schema_attributes:

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

schema_name_id: 3136
schema_scan_id: 6864164
updated: 2026-04-03 02:01:08

Schema Scans: 15

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

Scan 6867628

duration: 0:00:14.254280

exit_message:

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

id: 6867628

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

running: False
schema_name_id: 3136
start_time: 2026-04-17 02:01:21
success: True
trace_id: 13071375987611971652

Scan 6867363

duration: 0:00:14.481210

exit_message:

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

id: 6867363

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

running: False
schema_name_id: 3136
start_time: 2026-04-16 02:01:37
success: True
trace_id: 161918274902778427

Scan 6867105

duration: 0:00:14.337214

exit_message:

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

id: 6867105

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

running: False
schema_name_id: 3136
start_time: 2026-04-15 02:02:01
success: True
trace_id: 16307667580674056186

Scan 6866841

duration: 0:00:14.252575

exit_message:

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

id: 6866841

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

running: False
schema_name_id: 3136
start_time: 2026-04-14 02:01:15
success: True
trace_id: 2171777991485791296

Scan 6866529

duration: 0:00:14.338604

exit_message:

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

id: 6866529

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

running: False
schema_name_id: 3136
start_time: 2026-04-13 02:01:54
success: True
trace_id: 6450503357642766834

Scan 6866354

duration: 0:00:14.276954

exit_message:

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

id: 6866354

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

running: False
schema_name_id: 3136
start_time: 2026-04-12 02:01:11
success: True
trace_id: 8407025889463717954

Scan 6866183

duration: 0:00:14.206253

exit_message:

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

id: 6866183

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

running: False
schema_name_id: 3136
start_time: 2026-04-11 02:01:28
success: True
trace_id: 11613756187708963566

Scan 6865912

duration: 0:00:14.429375

exit_message:

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

id: 6865912

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

running: False
schema_name_id: 3136
start_time: 2026-04-10 02:02:06
success: True
trace_id: 9924039808760620963

Scan 6865637

duration: 0:00:11.867174

exit_message:

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

id: 6865637

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

running: False
schema_name_id: 3136
start_time: 2026-04-09 02:01:10
success: True
trace_id: 14094426979704911761

Scan 6865368

duration: 0:00:11.834443

exit_message:

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

id: 6865368

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

running: False
schema_name_id: 3136
start_time: 2026-04-08 02:01:16
success: True
trace_id: 15766206085719275949

Scan 6865103

duration: 0:00:11.980440

exit_message:

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

id: 6865103

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

running: False
schema_name_id: 3136
start_time: 2026-04-07 02:01:15
success: True
trace_id: 14012064775580037917

Scan 6864781

duration: 0:00:11.804980

exit_message:

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

id: 6864781

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

running: False
schema_name_id: 3136
start_time: 2026-04-06 02:01:00
success: True
trace_id: 9136311975344146070

Scan 6864610

duration: 0:00:14.275375

exit_message:

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

id: 6864610

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

running: False
schema_name_id: 3136
start_time: 2026-04-05 02:01:49
success: True
trace_id: 9034373533858857368

Scan 6864433

duration: 0:00:11.697389

exit_message:

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

id: 6864433

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

running: False
schema_name_id: 3136
start_time: 2026-04-04 02:01:05
success: True
trace_id: 17020807624293944562

Scan 6864164

duration: 0:00:11.834684

exit_message:

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

id: 6864164

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

running: False
schema_name_id: 3136
start_time: 2026-04-03 02:00:56
success: True
trace_id: 8976710896550076476

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2026-01-02 15:00:41",
        "disabled": false,
        "format": "raw",
        "id": 3136,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "authsso_identity_providers"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accountDomainId": "string",
            "accountId": "string",
            "createdAt": "date",
            "deletedAt": "date",
            "identityProviderId": "string",
            "revokedAt": "string",
            "status": "string",
            "verifiedAt": "string"
        },
        "created": "2026-04-17 02:01:22",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_identity_providers/2026-04-17/1776409227'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_identity_providers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_identity_providers"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}