Schema Info

Schema Name: sfdl_dev_drivethru.authsso_organization_migration_status

created: 2025-12-12 01:01:13
disabled: False
format: raw
id: 3134
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773327

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-17/1776409259
id: 4773327
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6867630
updated: 2026-04-17 02:01:47

Version 4773266

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-16/1776322869
id: 4773266
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6867367
updated: 2026-04-16 02:02:18

Version 4773202

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-15/1776236457
id: 4773202
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6867101
updated: 2026-04-15 02:01:49

Version 4773146

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-14/1776150023
id: 4773146
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6866843
updated: 2026-04-14 02:01:41

Version 4773078

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

ddl:

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

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

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6866526
updated: 2026-04-13 02:01:53

Version 4773035

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-12/1775977246
id: 4773035
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6866357
updated: 2026-04-12 02:01:51

Version 4772986

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-11/1775890831
id: 4772986
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6866184
updated: 2026-04-11 02:01:50

Version 4772924

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-10/1775804447
id: 4772924
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "c11aec3a-c0e7-4f2d-aa0a-be3503eafa12",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6865910
updated: 2026-04-10 02:02:06

Version 4772863

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-09/1775718031
id: 4772863
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6865641
updated: 2026-04-09 02:01:51

Version 4772801

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-08/1775631652
id: 4772801
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6865371
updated: 2026-04-08 02:01:54

Version 4772743

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

ddl:

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

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

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6865105
updated: 2026-04-07 02:01:41

Version 4772677

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-06/1775458827
id: 4772677
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6864779
updated: 2026-04-06 02:01:00

Version 4772628

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

ddl:

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

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

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6864606
updated: 2026-04-05 02:01:31

Version 4772577

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-04/1775286024
id: 4772577
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6864431
updated: 2026-04-04 02:00:58

Version 4772520

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-03/1775199627
id: 4772520
processed: 1

raw_data:

{
    "organizationAlias": "pal:organization:se:00000000-0000-0000-0000-000000000000",
    "organizationId": "bff5a4e6-337d-47dd-8046-b9ebccb2c3f9",
    "productAlias": "se",
    "status": "NOTIFY"
}

schema_attributes:

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

schema_name_id: 3134
schema_scan_id: 6864166
updated: 2026-04-03 02:01:21

Schema Scans: 15

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

Scan 6867630

duration: 0:00:11.612954

exit_message:

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

id: 6867630

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-17/1776409259",
        "key": "raw/authsso_organization_migration_status/2026-04-17/1776409259/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13164980348646739882,
        "service_name": "drive-thru",
        "span_id": 11909135858303278027,
        "trace_id": 13867218269660906698
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-17 02:01:36
success: True
trace_id: 13867218269660906698

Scan 6867367

duration: 0:00:11.626098

exit_message:

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

id: 6867367

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-16/1776322869",
        "key": "raw/authsso_organization_migration_status/2026-04-16/1776322869/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1232069176635712371,
        "service_name": "drive-thru",
        "span_id": 10846250137125116083,
        "trace_id": 3505917521027953306
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-16 02:02:06
success: True
trace_id: 3505917521027953306

Scan 6867101

duration: 0:00:14.164310

exit_message:

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

id: 6867101

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-15/1776236457",
        "key": "raw/authsso_organization_migration_status/2026-04-15/1776236457/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9836274118127644912,
        "service_name": "drive-thru",
        "span_id": 4322641533874929704,
        "trace_id": 5773815803978690481
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-15 02:01:35
success: True
trace_id: 5773815803978690481

Scan 6866843

duration: 0:00:11.937327

exit_message:

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

id: 6866843

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-14/1776150023",
        "key": "raw/authsso_organization_migration_status/2026-04-14/1776150023/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8934440726173725749,
        "service_name": "drive-thru",
        "span_id": 2334536639264529569,
        "trace_id": 15481244367297443466
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-14 02:01:29
success: True
trace_id: 15481244367297443466

Scan 6866526

duration: 0:00:14.223402

exit_message:

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

id: 6866526

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-13/1776063663",
        "key": "raw/authsso_organization_migration_status/2026-04-13/1776063663/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15846619880041444567,
        "service_name": "drive-thru",
        "span_id": 7316753953132393571,
        "trace_id": 12139262562249230400
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-13 02:01:39
success: True
trace_id: 12139262562249230400

Scan 6866357

duration: 0:00:14.276068

exit_message:

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

id: 6866357

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-12/1775977246",
        "key": "raw/authsso_organization_migration_status/2026-04-12/1775977246/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5361066740558344,
        "service_name": "drive-thru",
        "span_id": 10707491274973482328,
        "trace_id": 10256255044898043160
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-12 02:01:37
success: True
trace_id: 10256255044898043160

Scan 6866184

duration: 0:00:14.157373

exit_message:

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

id: 6866184

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-11/1775890831",
        "key": "raw/authsso_organization_migration_status/2026-04-11/1775890831/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5353939666742198033,
        "service_name": "drive-thru",
        "span_id": 14962420083618682830,
        "trace_id": 10348201068095666792
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-11 02:01:36
success: True
trace_id: 10348201068095666792

Scan 6865910

duration: 0:00:14.193886

exit_message:

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

id: 6865910

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-10/1775804447",
        "key": "raw/authsso_organization_migration_status/2026-04-10/1775804447/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1302040542771834593,
        "service_name": "drive-thru",
        "span_id": 7676995941636634541,
        "trace_id": 4385267704504623484
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-10 02:01:52
success: True
trace_id: 4385267704504623484

Scan 6865641

duration: 0:00:14.363322

exit_message:

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

id: 6865641

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-09/1775718031",
        "key": "raw/authsso_organization_migration_status/2026-04-09/1775718031/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 415096700065360368,
        "service_name": "drive-thru",
        "span_id": 1508159537403268666,
        "trace_id": 15524701052224212193
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-09 02:01:37
success: True
trace_id: 15524701052224212193

Scan 6865371

duration: 0:00:14.171317

exit_message:

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

id: 6865371

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-08/1775631652",
        "key": "raw/authsso_organization_migration_status/2026-04-08/1775631652/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5409608510594706744,
        "service_name": "drive-thru",
        "span_id": 8705060031701761063,
        "trace_id": 1971241773366387711
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-08 02:01:40
success: True
trace_id: 1971241773366387711

Scan 6865105

duration: 0:00:14.180553

exit_message:

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

id: 6865105

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-07/1775545231",
        "key": "raw/authsso_organization_migration_status/2026-04-07/1775545231/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12761121792738221138,
        "service_name": "drive-thru",
        "span_id": 11411855849679134656,
        "trace_id": 2930973233245403774
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-07 02:01:27
success: True
trace_id: 2930973233245403774

Scan 6864779

duration: 0:00:14.163153

exit_message:

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

id: 6864779

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-06/1775458827",
        "key": "raw/authsso_organization_migration_status/2026-04-06/1775458827/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5256193570390059134,
        "service_name": "drive-thru",
        "span_id": 17959110718650809930,
        "trace_id": 13633990685129844212
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-06 02:00:46
success: True
trace_id: 13633990685129844212

Scan 6864606

duration: 0:00:11.625998

exit_message:

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

id: 6864606

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-05/1775372451",
        "key": "raw/authsso_organization_migration_status/2026-04-05/1775372451/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8130652748664090470,
        "service_name": "drive-thru",
        "span_id": 1834986959809214680,
        "trace_id": 1633216814136842165
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-05 02:01:20
success: True
trace_id: 1633216814136842165

Scan 6864431

duration: 0:00:11.718819

exit_message:

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

id: 6864431

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-04/1775286024",
        "key": "raw/authsso_organization_migration_status/2026-04-04/1775286024/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8225747290059321695,
        "service_name": "drive-thru",
        "span_id": 4258307658885990038,
        "trace_id": 2783036836198171772
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-04 02:00:47
success: True
trace_id: 2783036836198171772

Scan 6864166

duration: 0:00:11.728773

exit_message:

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

id: 6864166

payload:

{
    "datatype_dict": {
        "organizationAlias": "string",
        "organizationId": "string",
        "productAlias": "string",
        "status": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organization_migration_status/2026-04-03/1775199627",
        "key": "raw/authsso_organization_migration_status/2026-04-03/1775199627/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organization_migration_status",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4113473166357245167,
        "service_name": "drive-thru",
        "span_id": 16575322347087747275,
        "trace_id": 1736979713726223991
    }
}

running: False
schema_name_id: 3134
start_time: 2026-04-03 02:01:09
success: True
trace_id: 1736979713726223991

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

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2025-12-12 01:01:13",
        "disabled": false,
        "format": "raw",
        "id": 3134,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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:01:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/authsso_organization_migration_status/2026-04-17/1776409259'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.authsso_organization_migration_status`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.authsso_organization_migration_status"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}