Schema Info

Schema Name: sfdl_prod_drivethru.authsso_organization_migration_status

created: 2025-12-18 01:10:14
disabled: False
format: raw
id: 4302
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717531

created: 2026-04-17 02:02:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-17/1776409282'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-17/1776409282
id: 1717531
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:3386",
    "organizationId": "ffd27d8d-64bd-47cd-9466-4b0d0a113c3f",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 162166349
updated: 2026-04-17 02:02:46

Version 1716297

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-16/1776322865'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-16/1776322865
id: 1716297
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CQDRA",
    "organizationId": "ffe17202-0c46-4eec-8953-0b16407d2a0f",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 162110468
updated: 2026-04-16 02:02:20

Version 1715106

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-15/1776236461'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-15/1776236461
id: 1715106
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:10890",
    "organizationId": "fff7687d-8637-4b5b-810c-190e4eb317f6",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 162054632
updated: 2026-04-15 02:02:27

Version 1713917

created: 2026-04-14 02:02:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-14/1776150057'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-14/1776150057
id: 1713917
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CCJLA",
    "organizationId": "fffd71ad-9a35-4433-b61a-c689b5d3dbfb",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161998942
updated: 2026-04-14 02:02:17

Version 1712674

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-13/1776063656'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-13/1776063656
id: 1712674
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CEEB",
    "organizationId": "ff4238d2-6211-4863-ab5f-35d8bb1daa62",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161941289
updated: 2026-04-13 02:02:11

Version 1711477

created: 2026-04-12 02:02:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-12/1775977276'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-12/1775977276
id: 1711477
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CEEB",
    "organizationId": "ff4238d2-6211-4863-ab5f-35d8bb1daa62",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161891888
updated: 2026-04-12 02:02:42

Version 1710286

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-11/1775890860'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-11/1775890860
id: 1710286
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:2281",
    "organizationId": "ff42c0ba-bc3b-463a-9ba2-485ff98babf8",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161839903
updated: 2026-04-11 02:02:08

Version 1709126

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-10/1775804459'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-10/1775804459
id: 1709126
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:13740",
    "organizationId": "ff4dc847-ecb6-4d68-b8ab-dedd6728a91a",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161784459
updated: 2026-04-10 02:02:12

Version 1707985

created: 2026-04-09 02:02:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-09/1775718062'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-09/1775718062
id: 1707985
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:10251",
    "organizationId": "ff5ffeab-9b54-4364-ace6-fd4ce4abaa5a",
    "productAlias": "ess",
    "status": "NOTIFY"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161729213
updated: 2026-04-09 02:02:17

Version 1706774

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-08/1775631697'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-08/1775631697
id: 1706774
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:4788",
    "organizationId": "ff8de10f-fb51-4af6-87dd-ad667abc5c48",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161674140
updated: 2026-04-08 02:02:55

Version 1705595

created: 2026-04-07 02:02:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-07/1775545260'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-07/1775545260
id: 1705595
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:15113",
    "organizationId": "ff9cbc97-ed5a-4d16-824b-b827ca450fe6",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161618103
updated: 2026-04-07 02:02:27

Version 1704369

created: 2026-04-06 02:02:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-06/1775458859'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-06/1775458859
id: 1704369
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:14381",
    "organizationId": "ffa9f646-6add-4ce0-89dd-b3a33e255b1f",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161560214
updated: 2026-04-06 02:02:19

Version 1703171

created: 2026-04-05 02:02:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-05/1775372483'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-05/1775372483
id: 1703171
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:14381",
    "organizationId": "ffa9f646-6add-4ce0-89dd-b3a33e255b1f",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161513634
updated: 2026-04-05 02:02:37

Version 1702002

created: 2026-04-04 02:03:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-04/1775286063'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-04/1775286063
id: 1702002
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:14919",
    "organizationId": "ffa89f05-7e4a-4221-a69c-b274ff366ffe",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161458931
updated: 2026-04-04 02:03:17

Version 1700789

created: 2026-04-03 02:02:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-03/1775199663'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-03/1775199663
id: 1700789
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:2943",
    "organizationId": "ffb5c9f0-3737-4fc1-bcac-0deeaa5d6196",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

schema_name_id: 4302
schema_scan_id: 161400030
updated: 2026-04-03 02:02:20

Schema Scans: 15

Last at 2026-04-17 02:02:32

Scan 162166349

duration: 0:00:14.224054

exit_message:

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

id: 162166349

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-17/1776409282",
        "key": "raw/authsso_organization_migration_status/2026-04-17/1776409282/part-00306.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14650758623086397175,
        "service_name": "drive-thru",
        "span_id": 12443803284942834401,
        "trace_id": 3352979515911020911
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-17 02:02:32
success: True
trace_id: 3352979515911020911

Scan 162110468

duration: 0:00:14.180671

exit_message:

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

id: 162110468

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-16/1776322865",
        "key": "raw/authsso_organization_migration_status/2026-04-16/1776322865/part-00306.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15561401560209339051,
        "service_name": "drive-thru",
        "span_id": 9670375953758465678,
        "trace_id": 14960875055101007591
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-16 02:02:05
success: True
trace_id: 14960875055101007591

Scan 162054632

duration: 0:00:11.540604

exit_message:

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

id: 162054632

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-15/1776236461",
        "key": "raw/authsso_organization_migration_status/2026-04-15/1776236461/part-00306.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14347789216403341138,
        "service_name": "drive-thru",
        "span_id": 3319848059767391863,
        "trace_id": 13985666234520854361
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-15 02:02:16
success: True
trace_id: 13985666234520854361

Scan 161998942

duration: 0:00:11.648145

exit_message:

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

id: 161998942

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-14/1776150057",
        "key": "raw/authsso_organization_migration_status/2026-04-14/1776150057/part-00306.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8935826153299992901,
        "service_name": "drive-thru",
        "span_id": 481247889222037585,
        "trace_id": 6360012792074395017
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-14 02:02:05
success: True
trace_id: 6360012792074395017

Scan 161941289

duration: 0:00:11.580895

exit_message:

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

id: 161941289

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-13/1776063656",
        "key": "raw/authsso_organization_migration_status/2026-04-13/1776063656/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15219231052186060373,
        "service_name": "drive-thru",
        "span_id": 2963901341591897977,
        "trace_id": 8479420225753106908
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-13 02:01:59
success: True
trace_id: 8479420225753106908

Scan 161891888

duration: 0:00:14.159418

exit_message:

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

id: 161891888

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-12/1775977276",
        "key": "raw/authsso_organization_migration_status/2026-04-12/1775977276/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3108602511650922851,
        "service_name": "drive-thru",
        "span_id": 5965863734983010065,
        "trace_id": 17936585620743364221
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-12 02:02:28
success: True
trace_id: 17936585620743364221

Scan 161839903

duration: 0:00:11.658931

exit_message:

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

id: 161839903

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-11/1775890860",
        "key": "raw/authsso_organization_migration_status/2026-04-11/1775890860/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14758692283565953586,
        "service_name": "drive-thru",
        "span_id": 5486973524138916688,
        "trace_id": 11055758731805098227
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-11 02:01:57
success: True
trace_id: 11055758731805098227

Scan 161784459

duration: 0:00:11.607495

exit_message:

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

id: 161784459

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-10/1775804459",
        "key": "raw/authsso_organization_migration_status/2026-04-10/1775804459/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18142471827710366584,
        "service_name": "drive-thru",
        "span_id": 17913635331469390860,
        "trace_id": 15172391426495171571
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-10 02:02:00
success: True
trace_id: 15172391426495171571

Scan 161729213

duration: 0:00:11.674899

exit_message:

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

id: 161729213

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-09/1775718062",
        "key": "raw/authsso_organization_migration_status/2026-04-09/1775718062/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 843307744528026297,
        "service_name": "drive-thru",
        "span_id": 8569890809121514358,
        "trace_id": 1046647908578680497
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-09 02:02:05
success: True
trace_id: 1046647908578680497

Scan 161674140

duration: 0:00:11.579655

exit_message:

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

id: 161674140

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-08/1775631697",
        "key": "raw/authsso_organization_migration_status/2026-04-08/1775631697/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8313806099031242544,
        "service_name": "drive-thru",
        "span_id": 5858933408029013373,
        "trace_id": 1240733798464022029
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-08 02:02:44
success: True
trace_id: 1240733798464022029

Scan 161618103

duration: 0:00:14.091118

exit_message:

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

id: 161618103

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-07/1775545260",
        "key": "raw/authsso_organization_migration_status/2026-04-07/1775545260/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5666256545414950396,
        "service_name": "drive-thru",
        "span_id": 13365167694179434212,
        "trace_id": 13382805627965751527
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-07 02:02:13
success: True
trace_id: 13382805627965751527

Scan 161560214

duration: 0:00:11.577944

exit_message:

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

id: 161560214

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-06/1775458859",
        "key": "raw/authsso_organization_migration_status/2026-04-06/1775458859/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14123726742601094361,
        "service_name": "drive-thru",
        "span_id": 17856825426797536489,
        "trace_id": 12990570723756935624
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-06 02:02:07
success: True
trace_id: 12990570723756935624

Scan 161513634

duration: 0:00:14.164090

exit_message:

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

id: 161513634

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-05/1775372483",
        "key": "raw/authsso_organization_migration_status/2026-04-05/1775372483/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13640215741064391231,
        "service_name": "drive-thru",
        "span_id": 2838825702558132223,
        "trace_id": 2650410385304532301
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-05 02:02:22
success: True
trace_id: 2650410385304532301

Scan 161458931

duration: 0:00:14.140687

exit_message:

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

id: 161458931

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-04/1775286063",
        "key": "raw/authsso_organization_migration_status/2026-04-04/1775286063/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1449409990080071734,
        "service_name": "drive-thru",
        "span_id": 10474845565631592460,
        "trace_id": 6954121602189597729
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-04 02:03:03
success: True
trace_id: 6954121602189597729

Scan 161400030

duration: 0:00:11.690997

exit_message:

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

id: 161400030

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organization_migration_status/2026-04-03/1775199663",
        "key": "raw/authsso_organization_migration_status/2026-04-03/1775199663/part-00305.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15159894938314048928,
        "service_name": "drive-thru",
        "span_id": 17981997006468501345,
        "trace_id": 4870151791199362344
    }
}

running: False
schema_name_id: 4302
start_time: 2026-04-03 02:02:08
success: True
trace_id: 4870151791199362344

Partitions:

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

Schema:

attributes:

{
    "organizationAlias": "string",
    "organizationId": "string",
    "productAlias": "string",
    "status": "string"
}

created: 2026-04-17 02:02:32

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-17/1776409282'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-12-18 01:10:14",
        "disabled": false,
        "format": "raw",
        "id": 4302,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "authsso_organization_migration_status"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "organizationAlias": "string",
            "organizationId": "string",
            "productAlias": "string",
            "status": "string"
        },
        "created": "2026-04-17 02:02:32",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organization_migration_status`\n(\n`organizationId`string,`organizationAlias`string,`status`string,`productAlias`string\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_organization_migration_status/2026-04-17/1776409282'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organization_migration_status`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organization_migration_status"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}