Schema Info

Schema Name: sfdl_stage_drivethru.authsso_organization_migration_status

created: 2025-12-12 01:01:21
disabled: False
format: raw
id: 2252
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906664

created: 2026-04-17 07:01:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-17/1776427246'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776427246
id: 906664
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CSXX",
    "organizationId": "fffc7f5f-ad61-4c38-b6e2-79d2fc9bd0f0",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6415262
updated: 2026-04-17 07:01:38

Version 906601

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-17/1776409245'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776409245
id: 906601
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CSXX",
    "organizationId": "fffc7f5f-ad61-4c38-b6e2-79d2fc9bd0f0",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6415177
updated: 2026-04-17 02:01:34

Version 906595

created: 2026-04-17 01:54:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-17/1776408813'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776408813
id: 906595
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CSXX",
    "organizationId": "fffc7f5f-ad61-4c38-b6e2-79d2fc9bd0f0",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6415171
updated: 2026-04-17 01:54:29

Version 905742

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-13/1776063646'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-13/1776063646
id: 905742
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CCMJA",
    "organizationId": "fe85e705-00d1-4090-bf2e-cd3c53a364fd",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6413094
updated: 2026-04-13 02:01:35

Version 905540

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-12/1775977245'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-12/1775977245
id: 905540
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CPEQ",
    "organizationId": "fe867041-4963-4f83-9701-136e20d22365",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6412700
updated: 2026-04-12 02:01:31

Version 905338

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-11/1775890847'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-11/1775890847
id: 905338
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CPEQ",
    "organizationId": "fe867041-4963-4f83-9701-136e20d22365",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6412319
updated: 2026-04-11 02:01:35

Version 905124

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-10/1775804446'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-10/1775804446
id: 905124
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CDSK",
    "organizationId": "fe881449-b9e4-46e4-8cd0-14ef6f32589f",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6411821
updated: 2026-04-10 02:01:32

Version 904910

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-09/1775718048'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-09/1775718048
id: 904910
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CDSK",
    "organizationId": "fe881449-b9e4-46e4-8cd0-14ef6f32589f",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6411307
updated: 2026-04-09 02:01:36

Version 904695

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-08/1775631646'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-08/1775631646
id: 904695
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CBFX",
    "organizationId": "fea06076-db36-422d-b03b-f23d2982c7d6",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6410813
updated: 2026-04-08 02:01:39

Version 904483

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-07/1775545246'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-07/1775545246
id: 904483
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:C191A",
    "organizationId": "fea38a7a-c6bc-4f7f-94a3-78b5f49186e7",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6410303
updated: 2026-04-07 02:01:38

Version 904269

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-06/1775458846'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-06/1775458846
id: 904269
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:C682A",
    "organizationId": "fee0fb36-1525-436e-a90c-2d8be270712c",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6409757
updated: 2026-04-06 02:01:49

Version 904065

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-05/1775372445'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-05/1775372445
id: 904065
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:C682A",
    "organizationId": "fee0fb36-1525-436e-a90c-2d8be270712c",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6409369
updated: 2026-04-05 02:01:34

Version 903863

created: 2026-04-04 02:01:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-04/1775286045'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-04/1775286045
id: 903863
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:ess:268",
    "organizationId": "fede6540-5bc2-44d6-91f9-b75a9dd1bfb6",
    "productAlias": "ess",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6408988
updated: 2026-04-04 02:01:34

Version 903650

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-03/1775199645'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-03/1775199645
id: 903650
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:9cdf207f-9d4d-4350-8487-a473bee51273",
    "organizationId": "fee242bc-797c-4391-ad89-bc1b299c211d",
    "productAlias": "se",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6408497
updated: 2026-04-03 02:01:33

Version 903435

created: 2026-04-02 02:01:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-02/1775113247'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-02/1775113247
id: 903435
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:sl:CBTA",
    "organizationId": "fef69852-1ca3-4881-a863-f1ad3c12d915",
    "productAlias": "sl",
    "status": "OFFER"
}

schema_attributes:

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

schema_name_id: 2252
schema_scan_id: 6407988
updated: 2026-04-02 02:01:41

Schema Scans: 15

Last at 2026-04-17 07:01:24

Scan 6415262

duration: 0:00:14.136527

exit_message:

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

id: 6415262

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776427246",
        "key": "raw/authsso_organization_migration_status/2026-04-17/1776427246/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8738060178443458823,
        "service_name": "drive-thru",
        "span_id": 14476645107026249647,
        "trace_id": 733715560810928841
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-17 07:01:24
success: True
trace_id: 733715560810928841

Scan 6415177

duration: 0:00:14.232490

exit_message:

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

id: 6415177

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776409245",
        "key": "raw/authsso_organization_migration_status/2026-04-17/1776409245/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10854097761343376538,
        "service_name": "drive-thru",
        "span_id": 7672139101872996358,
        "trace_id": 13746116716467531539
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-17 02:01:20
success: True
trace_id: 13746116716467531539

Scan 6415171

duration: 0:00:11.702660

exit_message:

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

id: 6415171

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-17/1776408813",
        "key": "raw/authsso_organization_migration_status/2026-04-17/1776408813/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7201666339122588271,
        "service_name": "drive-thru",
        "span_id": 3529116867631215072,
        "trace_id": 10345402382206207677
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-17 01:54:17
success: True
trace_id: 10345402382206207677

Scan 6413094

duration: 0:00:14.200984

exit_message:

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

id: 6413094

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-13/1776063646",
        "key": "raw/authsso_organization_migration_status/2026-04-13/1776063646/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1522083076488441966,
        "service_name": "drive-thru",
        "span_id": 14505322554175713391,
        "trace_id": 4794509380558009870
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-13 02:01:20
success: True
trace_id: 4794509380558009870

Scan 6412700

duration: 0:00:14.130711

exit_message:

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

id: 6412700

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-12/1775977245",
        "key": "raw/authsso_organization_migration_status/2026-04-12/1775977245/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6794651242049908021,
        "service_name": "drive-thru",
        "span_id": 13010246937441093361,
        "trace_id": 15930863889776171866
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-12 02:01:17
success: True
trace_id: 15930863889776171866

Scan 6412319

duration: 0:00:14.350964

exit_message:

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

id: 6412319

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-11/1775890847",
        "key": "raw/authsso_organization_migration_status/2026-04-11/1775890847/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6280755695786998192,
        "service_name": "drive-thru",
        "span_id": 8068220533821948629,
        "trace_id": 9915652099228167456
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-11 02:01:21
success: True
trace_id: 9915652099228167456

Scan 6411821

duration: 0:00:11.662091

exit_message:

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

id: 6411821

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-10/1775804446",
        "key": "raw/authsso_organization_migration_status/2026-04-10/1775804446/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2021876097371305500,
        "service_name": "drive-thru",
        "span_id": 13637520842774366338,
        "trace_id": 15572346928091835283
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-10 02:01:20
success: True
trace_id: 15572346928091835283

Scan 6411307

duration: 0:00:14.428630

exit_message:

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

id: 6411307

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-09/1775718048",
        "key": "raw/authsso_organization_migration_status/2026-04-09/1775718048/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7806593414609852950,
        "service_name": "drive-thru",
        "span_id": 11428329750498399519,
        "trace_id": 709990897279201233
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-09 02:01:22
success: True
trace_id: 709990897279201233

Scan 6410813

duration: 0:00:14.257765

exit_message:

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

id: 6410813

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-08/1775631646",
        "key": "raw/authsso_organization_migration_status/2026-04-08/1775631646/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17899555864467669882,
        "service_name": "drive-thru",
        "span_id": 1044134311503052096,
        "trace_id": 6503916827061166523
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-08 02:01:25
success: True
trace_id: 6503916827061166523

Scan 6410303

duration: 0:00:11.739200

exit_message:

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

id: 6410303

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-07/1775545246",
        "key": "raw/authsso_organization_migration_status/2026-04-07/1775545246/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9431015062282481797,
        "service_name": "drive-thru",
        "span_id": 7022578513769018176,
        "trace_id": 13770664779988871845
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-07 02:01:26
success: True
trace_id: 13770664779988871845

Scan 6409757

duration: 0:00:11.628654

exit_message:

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

id: 6409757

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-06/1775458846",
        "key": "raw/authsso_organization_migration_status/2026-04-06/1775458846/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10144115331918683655,
        "service_name": "drive-thru",
        "span_id": 10585173592016162663,
        "trace_id": 6317821702764705807
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-06 02:01:37
success: True
trace_id: 6317821702764705807

Scan 6409369

duration: 0:00:14.230248

exit_message:

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

id: 6409369

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-05/1775372445",
        "key": "raw/authsso_organization_migration_status/2026-04-05/1775372445/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1614085534837420203,
        "service_name": "drive-thru",
        "span_id": 5689765614389155923,
        "trace_id": 964671529903906389
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-05 02:01:19
success: True
trace_id: 964671529903906389

Scan 6408988

duration: 0:00:14.135533

exit_message:

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

id: 6408988

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-04/1775286045",
        "key": "raw/authsso_organization_migration_status/2026-04-04/1775286045/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11444747444171112504,
        "service_name": "drive-thru",
        "span_id": 1211990187391501486,
        "trace_id": 4162782528387136487
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-04 02:01:20
success: True
trace_id: 4162782528387136487

Scan 6408497

duration: 0:00:14.256333

exit_message:

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

id: 6408497

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-03/1775199645",
        "key": "raw/authsso_organization_migration_status/2026-04-03/1775199645/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16685957729413911419,
        "service_name": "drive-thru",
        "span_id": 991897134831395974,
        "trace_id": 10229035857530731882
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-03 02:01:19
success: True
trace_id: 10229035857530731882

Scan 6407988

duration: 0:00:14.272929

exit_message:

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

id: 6407988

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organization_migration_status/2026-04-02/1775113247",
        "key": "raw/authsso_organization_migration_status/2026-04-02/1775113247/part-00163.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13645294042025144551,
        "service_name": "drive-thru",
        "span_id": 10658362716745922390,
        "trace_id": 12826663374207968977
    }
}

running: False
schema_name_id: 2252
start_time: 2026-04-02 02:01:27
success: True
trace_id: 12826663374207968977

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 07:01:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-17/1776427246'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-12-12 01:01:21",
        "disabled": false,
        "format": "raw",
        "id": 2252,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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 07:01:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organization_migration_status/2026-04-17/1776427246'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organization_migration_status`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organization_migration_status"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}