Schema Info

Schema Name: sfdl_prod_drivethru.authsso_organizations

created: 2026-01-09 01:02:13
disabled: False
format: raw
id: 4310
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 1717532

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-17/1776409289'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-17/1776409289
id: 1717532
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:06:40.373Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:4788",
    "organizationId": "ff8de10f-fb51-4af6-87dd-ad667abc5c48",
    "organizationName": "Hunters Store & Lock ",
    "totalActiveFacilities": 2
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 162166352
updated: 2026-04-17 02:02:47

Version 1716298

created: 2026-04-16 02:02:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-16/1776322868'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-16/1776322868
id: 1716298
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:22:16.868Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:9686",
    "organizationId": "ff9e14d5-30f5-435d-81e3-63b01e8a3f9e",
    "organizationName": "CS Silsbee, LLC",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 162110469
updated: 2026-04-16 02:02:26

Version 1715107

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-15/1776236468'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-15/1776236468
id: 1715107
processed: 1

raw_data:

{
    "createdAt": "2025-07-21T19:42:09.947Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:14381",
    "organizationId": "ffa9f646-6add-4ce0-89dd-b3a33e255b1f",
    "organizationName": "J & C Mini Storage Units",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 162054637
updated: 2026-04-15 02:02:39

Version 1713920

created: 2026-04-14 02:02:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-14/1776150088'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-14/1776150088
id: 1713920
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:05:36.167Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CQTF",
    "organizationId": "ffb201f3-68f5-4a0c-8f97-cad2656ff710",
    "organizationName": "DJ Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161998996
updated: 2026-04-14 02:02:48

Version 1712675

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-13/1776063662'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-13/1776063662
id: 1712675
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:11:44.706Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:11880",
    "organizationId": "ffc65e17-57da-4a74-8fa3-2e47279104db",
    "organizationName": "Hollidays Mini Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161941290
updated: 2026-04-13 02:02:17

Version 1711478

created: 2026-04-12 02:02:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-12/1775977275'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-12/1775977275
id: 1711478
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:11:44.706Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:11880",
    "organizationId": "ffc65e17-57da-4a74-8fa3-2e47279104db",
    "organizationName": "Hollidays Mini Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161891890
updated: 2026-04-12 02:02:45

Version 1710287

created: 2026-04-11 02:02:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-11/1775890864'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-11/1775890864
id: 1710287
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:05:13.029Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CGLC",
    "organizationId": "ffc8e22d-b3dd-474e-bd13-9f85482eace0",
    "organizationName": "Seguin Storage LLC - CORP",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161839907
updated: 2026-04-11 02:02:19

Version 1709127

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-10/1775804463'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-10/1775804463
id: 1709127
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:11:14.945Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:7507",
    "organizationId": "ffcc8963-7905-409c-b190-6ba6743e9a14",
    "organizationName": "Affordable Canadian Movers",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161784460
updated: 2026-04-10 02:02:15

Version 1707986

created: 2026-04-09 02:02:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-09/1775718101'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-09/1775718101
id: 1707986
processed: 1

raw_data:

{
    "createdAt": "2025-06-04T00:13:46.336Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:se:8753182b-19e3-4af0-9f19-0a165062581e",
    "organizationId": "ffdd2f27-bd93-482f-acdc-1e1ca013cc36",
    "organizationName": "At Home Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161729214
updated: 2026-04-09 02:03:05

Version 1706775

created: 2026-04-08 02:02:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-08/1775631702'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-08/1775631702
id: 1706775
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:00:51.789Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CCWN",
    "organizationId": "ffe63916-5295-4c60-ad72-ab7a1e42431b",
    "organizationName": "Barnyard Storage, LLC",
    "totalActiveFacilities": 0
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161674141
updated: 2026-04-08 02:02:59

Version 1705596

created: 2026-04-07 02:02:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-07/1775545267'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-07/1775545267
id: 1705596
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:07:25.811Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:11089",
    "organizationId": "fffe0035-2cb8-44d8-9166-5d47ea53e3ef",
    "organizationName": "Pops Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161618108
updated: 2026-04-07 02:02:35

Version 1704370

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-06/1775458894'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-06/1775458894
id: 1704370
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:07:02.665Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:7898",
    "organizationId": "ff44d717-ba64-4cea-b19c-075d810a3619",
    "organizationName": "Phenix City Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161560229
updated: 2026-04-06 02:03:00

Version 1703170

created: 2026-04-05 02:02:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-05/1775372468'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-05/1775372468
id: 1703170
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:07:02.665Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:7898",
    "organizationId": "ff44d717-ba64-4cea-b19c-075d810a3619",
    "organizationName": "Phenix City Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161513632
updated: 2026-04-05 02:02:22

Version 1702001

created: 2026-04-04 02:02:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-04/1775286100'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-04/1775286100
id: 1702001
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:07:02.665Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:7898",
    "organizationId": "ff44d717-ba64-4cea-b19c-075d810a3619",
    "organizationName": "Phenix City Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161458882
updated: 2026-04-04 02:02:59

Version 1700790

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-03/1775199666'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
]

hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-03/1775199666
id: 1700790
processed: 1

raw_data:

{
    "createdAt": "2024-12-31T00:10:55.947Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:ess:4988",
    "organizationId": "ff557530-0601-4490-a134-bd4f4abea9c9",
    "organizationName": "A & J Garages",
    "totalActiveFacilities": 1
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

schema_name_id: 4310
schema_scan_id: 161400031
updated: 2026-04-03 02:02:20

Schema Scans: 15

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

Scan 162166352

duration: 0:00:11.578164

exit_message:

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

id: 162166352

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-17/1776409289",
        "key": "raw/authsso_organizations/2026-04-17/1776409289/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14941947969788954692,
        "service_name": "drive-thru",
        "span_id": 3862171885287883635,
        "trace_id": 9762013302183253263
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-17 02:02:35
success: True
trace_id: 9762013302183253263

Scan 162110469

duration: 0:00:14.210027

exit_message:

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

id: 162110469

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-16/1776322868",
        "key": "raw/authsso_organizations/2026-04-16/1776322868/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2441010265220207406,
        "service_name": "drive-thru",
        "span_id": 11791522280126558458,
        "trace_id": 9568866229721576724
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-16 02:02:12
success: True
trace_id: 9568866229721576724

Scan 162054637

duration: 0:00:11.666010

exit_message:

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

id: 162054637

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-15/1776236468",
        "key": "raw/authsso_organizations/2026-04-15/1776236468/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3892564725209556798,
        "service_name": "drive-thru",
        "span_id": 2689402352703403726,
        "trace_id": 1387252247283949908
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-15 02:02:27
success: True
trace_id: 1387252247283949908

Scan 161998996

duration: 0:00:14.188802

exit_message:

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

id: 161998996

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-14/1776150088",
        "key": "raw/authsso_organizations/2026-04-14/1776150088/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14431436626281084587,
        "service_name": "drive-thru",
        "span_id": 7775050368274179728,
        "trace_id": 3561420779095892032
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-14 02:02:34
success: True
trace_id: 3561420779095892032

Scan 161941290

duration: 0:00:14.183899

exit_message:

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

id: 161941290

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-13/1776063662",
        "key": "raw/authsso_organizations/2026-04-13/1776063662/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3971317082325775741,
        "service_name": "drive-thru",
        "span_id": 4247381073222907755,
        "trace_id": 8326816919563117751
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-13 02:02:03
success: True
trace_id: 8326816919563117751

Scan 161891890

duration: 0:00:14.174533

exit_message:

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

id: 161891890

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-12/1775977275",
        "key": "raw/authsso_organizations/2026-04-12/1775977275/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11150472844010468663,
        "service_name": "drive-thru",
        "span_id": 12290375283537297721,
        "trace_id": 15867064759860062449
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-12 02:02:31
success: True
trace_id: 15867064759860062449

Scan 161839907

duration: 0:00:14.315422

exit_message:

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

id: 161839907

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-11/1775890864",
        "key": "raw/authsso_organizations/2026-04-11/1775890864/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6454919661060805095,
        "service_name": "drive-thru",
        "span_id": 510967270613255476,
        "trace_id": 17175668523541686165
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-11 02:02:05
success: True
trace_id: 17175668523541686165

Scan 161784460

duration: 0:00:11.632010

exit_message:

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

id: 161784460

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-10/1775804463",
        "key": "raw/authsso_organizations/2026-04-10/1775804463/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12965179764845264181,
        "service_name": "drive-thru",
        "span_id": 7102684552118855546,
        "trace_id": 2384499657765504864
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-10 02:02:04
success: True
trace_id: 2384499657765504864

Scan 161729214

duration: 0:00:14.153472

exit_message:

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

id: 161729214

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-09/1775718101",
        "key": "raw/authsso_organizations/2026-04-09/1775718101/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5895454067848699031,
        "service_name": "drive-thru",
        "span_id": 1213987123628476325,
        "trace_id": 15318216376935602927
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-09 02:02:51
success: True
trace_id: 15318216376935602927

Scan 161674141

duration: 0:00:14.096423

exit_message:

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

id: 161674141

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-08/1775631702",
        "key": "raw/authsso_organizations/2026-04-08/1775631702/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15305546952800360832,
        "service_name": "drive-thru",
        "span_id": 4863566653887384327,
        "trace_id": 2727225393869320728
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-08 02:02:45
success: True
trace_id: 2727225393869320728

Scan 161618108

duration: 0:00:14.208683

exit_message:

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

id: 161618108

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-07/1775545267",
        "key": "raw/authsso_organizations/2026-04-07/1775545267/part-00308.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10644920795766397776,
        "service_name": "drive-thru",
        "span_id": 14675680222709282842,
        "trace_id": 6101358273894751737
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-07 02:02:21
success: True
trace_id: 6101358273894751737

Scan 161560229

duration: 0:00:14.301008

exit_message:

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

id: 161560229

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-06/1775458894",
        "key": "raw/authsso_organizations/2026-04-06/1775458894/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18159583316431661378,
        "service_name": "drive-thru",
        "span_id": 17507520236474686008,
        "trace_id": 8685959915791287928
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-06 02:02:46
success: True
trace_id: 8685959915791287928

Scan 161513632

duration: 0:00:14.128093

exit_message:

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

id: 161513632

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-05/1775372468",
        "key": "raw/authsso_organizations/2026-04-05/1775372468/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17031786792218992059,
        "service_name": "drive-thru",
        "span_id": 12614617630611152046,
        "trace_id": 16676662261631438966
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-05 02:02:08
success: True
trace_id: 16676662261631438966

Scan 161458882

duration: 0:00:14.199989

exit_message:

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

id: 161458882

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-04/1775286100",
        "key": "raw/authsso_organizations/2026-04-04/1775286100/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12245902007068723618,
        "service_name": "drive-thru",
        "span_id": 929076820422784166,
        "trace_id": 15126581737236488124
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-04 02:02:45
success: True
trace_id: 15126581737236488124

Scan 161400031

duration: 0:00:11.728735

exit_message:

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

id: 161400031

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "organizationAlias": "string",
        "organizationId": "string",
        "organizationName": "string",
        "totalActiveFacilities": "bigint"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/authsso_organizations/2026-04-03/1775199666",
        "key": "raw/authsso_organizations/2026-04-03/1775199666/part-00307.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 167050334936854802,
        "service_name": "drive-thru",
        "span_id": 16738205904261819832,
        "trace_id": 16143180853275575659
    }
}

running: False
schema_name_id: 4310
start_time: 2026-04-03 02:02:09
success: True
trace_id: 16143180853275575659

Partitions:

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

Schema:

attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "organizationAlias": "string",
    "organizationId": "string",
    "organizationName": "string",
    "totalActiveFacilities": "bigint"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-17/1776409289'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
}

Server:

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

Raw:

{
    "name": {
        "created": "2026-01-09 01:02:13",
        "disabled": false,
        "format": "raw",
        "id": 4310,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "authsso_organizations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "createdAt": "date",
            "deletedAt": "date",
            "organizationAlias": "string",
            "organizationId": "string",
            "organizationName": "string",
            "totalActiveFacilities": "bigint"
        },
        "created": "2026-04-17 02:02:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.authsso_organizations`\n(\n`organizationId`string,`organizationName`string,`organizationAlias`string,`createdAt`date,`deletedAt`date,`totalActiveFacilities`bigint\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_organizations/2026-04-17/1776409289'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.authsso_organizations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.authsso_organizations"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}