Schema Info

Schema Name: sfdl_stage_drivethru.authsso_organizations

created: 2025-08-08 11:12:14
disabled: False
format: raw
id: 2249
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906600

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

ddl:

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

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

raw_data:

{
    "createdAt": "2024-12-27T00:01:10.489Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CDRN",
    "organizationId": "ffa40e3f-feeb-49fa-93ca-ff3e6b02b7c8",
    "organizationName": "Northside Self Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6415176
updated: 2026-04-17 02:01:34

Version 906385

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-16/1776322846
id: 906385
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:10.489Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CDRN",
    "organizationId": "ffa40e3f-feeb-49fa-93ca-ff3e6b02b7c8",
    "organizationName": "Northside Self Storage",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6414631
updated: 2026-04-16 02:01:35

Version 906172

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-15/1776236447
id: 906172
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:40.018Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:C902",
    "organizationId": "ffa5c6c3-a828-49d3-91f3-e702b2a9c020",
    "organizationName": "Storage LLC",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6414144
updated: 2026-04-15 02:01:40

Version 905958

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-14/1776150047
id: 905958
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:40.018Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:C902",
    "organizationId": "ffa5c6c3-a828-49d3-91f3-e702b2a9c020",
    "organizationName": "Storage LLC",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6413637
updated: 2026-04-14 02:01:40

Version 905743

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-13/1776063645
id: 905743
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:45.924Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CPAV",
    "organizationId": "ffbd04b9-ab6b-49ff-91e0-868fd647c4b1",
    "organizationName": "Space Village Self Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6413095
updated: 2026-04-13 02:01:38

Version 905541

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-12/1775977248
id: 905541
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:30:52.982Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:se:7af6f66b-4fe0-42fa-ad03-ccbfb9176847",
    "organizationId": "ffbe6028-41d6-4330-881f-de60e3048228",
    "organizationName": "Adams Storage Group",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6412701
updated: 2026-04-12 02:01:40

Version 905339

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-11/1775890848
id: 905339
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:30:52.982Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:se:7af6f66b-4fe0-42fa-ad03-ccbfb9176847",
    "organizationId": "ffbe6028-41d6-4330-881f-de60e3048228",
    "organizationName": "Adams Storage Group",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6412320
updated: 2026-04-11 02:01:38

Version 905125

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-10/1775804448
id: 905125
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:31.807Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:C471",
    "organizationId": "ffc9aad6-0105-4a94-aeaf-180102e7c31a",
    "organizationName": "ASD Properties Management LLC",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6411822
updated: 2026-04-10 02:01:37

Version 904911

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

ddl:

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

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

raw_data:

{
    "createdAt": "2024-12-27T00:00:31.807Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:C471",
    "organizationId": "ffc9aad6-0105-4a94-aeaf-180102e7c31a",
    "organizationName": "ASD Properties Management LLC",
    "totalActiveFacilities": 1
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6411308
updated: 2026-04-09 02:01:37

Version 904697

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-08/1775631648
id: 904697
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:07.581Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CDGD",
    "organizationId": "ffe9af48-59b5-4f01-8a77-ea0b7a519123",
    "organizationName": "Mini Storage of America",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6410815
updated: 2026-04-08 02:01:43

Version 904482

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-07/1775545247
id: 904482
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:25:48.539Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:se:6fd564c9-016e-4659-a44a-b1b84c0d3f2d",
    "organizationId": "ffea9399-eafb-4246-9bdc-8eedbbb2f75a",
    "organizationName": "Stuff Self Storage",
    "totalActiveFacilities": 2
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6410302
updated: 2026-04-07 02:01:39

Version 904268

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-06/1775458847
id: 904268
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:02:21.187Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CZSP",
    "organizationId": "fe80496d-2d3b-4f65-8843-51f005d73983",
    "organizationName": "Trucker's Retreat",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6409756
updated: 2026-04-06 02:01:47

Version 904067

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-05/1775372447
id: 904067
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:02:21.187Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CZSP",
    "organizationId": "fe80496d-2d3b-4f65-8843-51f005d73983",
    "organizationName": "Trucker's Retreat",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6409371
updated: 2026-04-05 02:01:37

Version 903865

created: 2026-04-04 02:01:28

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-04/1775286047
id: 903865
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:02:21.187Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CZSP",
    "organizationId": "fe80496d-2d3b-4f65-8843-51f005d73983",
    "organizationName": "Trucker's Retreat",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6408990
updated: 2026-04-04 02:01:41

Version 903651

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-03/1775199646
id: 903651
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:47.375Z",
    "deletedAt": null,
    "organizationAlias": "pal:organization:sl:CPEQ",
    "organizationId": "fe867041-4963-4f83-9701-136e20d22365",
    "organizationName": "Airport Road Mini Storage, LLC",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 2249
schema_scan_id: 6408498
updated: 2026-04-03 02:01:48

Schema Scans: 15

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

Scan 6415176

duration: 0:00:14.272629

exit_message:

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

id: 6415176

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-17/1776409245",
        "key": "raw/authsso_organizations/2026-04-17/1776409245/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3576562025250736967,
        "service_name": "drive-thru",
        "span_id": 11413082303772270787,
        "trace_id": 15388627633169951789
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-17 02:01:19
success: True
trace_id: 15388627633169951789

Scan 6414631

duration: 0:00:14.333674

exit_message:

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

id: 6414631

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-16/1776322846",
        "key": "raw/authsso_organizations/2026-04-16/1776322846/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1228879347274363134,
        "service_name": "drive-thru",
        "span_id": 12173974526367457364,
        "trace_id": 15591138818769915039
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-16 02:01:21
success: True
trace_id: 15591138818769915039

Scan 6414144

duration: 0:00:14.468430

exit_message:

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

id: 6414144

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-15/1776236447",
        "key": "raw/authsso_organizations/2026-04-15/1776236447/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1724074072628977064,
        "service_name": "drive-thru",
        "span_id": 13171438828787517249,
        "trace_id": 10485790577128231711
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-15 02:01:26
success: True
trace_id: 10485790577128231711

Scan 6413637

duration: 0:00:11.755048

exit_message:

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

id: 6413637

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-14/1776150047",
        "key": "raw/authsso_organizations/2026-04-14/1776150047/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 559201034437304912,
        "service_name": "drive-thru",
        "span_id": 7946391884334508780,
        "trace_id": 3263894064221281046
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-14 02:01:28
success: True
trace_id: 3263894064221281046

Scan 6413095

duration: 0:00:14.332963

exit_message:

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

id: 6413095

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-13/1776063645",
        "key": "raw/authsso_organizations/2026-04-13/1776063645/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12017563157731018044,
        "service_name": "drive-thru",
        "span_id": 1220227894310613785,
        "trace_id": 5876254175073990975
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-13 02:01:24
success: True
trace_id: 5876254175073990975

Scan 6412701

duration: 0:00:11.776789

exit_message:

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

id: 6412701

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-12/1775977248",
        "key": "raw/authsso_organizations/2026-04-12/1775977248/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11611178579653856139,
        "service_name": "drive-thru",
        "span_id": 5769660715106296068,
        "trace_id": 10872150121424366797
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-12 02:01:28
success: True
trace_id: 10872150121424366797

Scan 6412320

duration: 0:00:14.280064

exit_message:

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

id: 6412320

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-11/1775890848",
        "key": "raw/authsso_organizations/2026-04-11/1775890848/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3188463469776417743,
        "service_name": "drive-thru",
        "span_id": 2480435125262890519,
        "trace_id": 9298505459737185147
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-11 02:01:24
success: True
trace_id: 9298505459737185147

Scan 6411822

duration: 0:00:14.213931

exit_message:

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

id: 6411822

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-10/1775804448",
        "key": "raw/authsso_organizations/2026-04-10/1775804448/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12537282612784358151,
        "service_name": "drive-thru",
        "span_id": 4307947625157615902,
        "trace_id": 13695062261055306092
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-10 02:01:22
success: True
trace_id: 13695062261055306092

Scan 6411308

duration: 0:00:14.267484

exit_message:

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

id: 6411308

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-09/1775718048",
        "key": "raw/authsso_organizations/2026-04-09/1775718048/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12604513018352132784,
        "service_name": "drive-thru",
        "span_id": 13889928591766049018,
        "trace_id": 1317340428165520379
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-09 02:01:23
success: True
trace_id: 1317340428165520379

Scan 6410815

duration: 0:00:11.957152

exit_message:

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

id: 6410815

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-08/1775631648",
        "key": "raw/authsso_organizations/2026-04-08/1775631648/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 357278467247170517,
        "service_name": "drive-thru",
        "span_id": 7977382683175422899,
        "trace_id": 1045011283806947070
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-08 02:01:31
success: True
trace_id: 1045011283806947070

Scan 6410302

duration: 0:00:14.211088

exit_message:

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

id: 6410302

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-07/1775545247",
        "key": "raw/authsso_organizations/2026-04-07/1775545247/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9459449289486449585,
        "service_name": "drive-thru",
        "span_id": 593598505057507687,
        "trace_id": 9012658834960470904
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-07 02:01:25
success: True
trace_id: 9012658834960470904

Scan 6409756

duration: 0:00:11.755503

exit_message:

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

id: 6409756

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-06/1775458847",
        "key": "raw/authsso_organizations/2026-04-06/1775458847/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5965771750183980584,
        "service_name": "drive-thru",
        "span_id": 7644095704689953390,
        "trace_id": 6375205892497256240
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-06 02:01:36
success: True
trace_id: 6375205892497256240

Scan 6409371

duration: 0:00:14.235754

exit_message:

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

id: 6409371

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-05/1775372447",
        "key": "raw/authsso_organizations/2026-04-05/1775372447/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 188609247475214329,
        "service_name": "drive-thru",
        "span_id": 8913439363183489519,
        "trace_id": 14891982684038596410
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-05 02:01:23
success: True
trace_id: 14891982684038596410

Scan 6408990

duration: 0:00:14.285712

exit_message:

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

id: 6408990

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-04/1775286047",
        "key": "raw/authsso_organizations/2026-04-04/1775286047/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8318499825721271692,
        "service_name": "drive-thru",
        "span_id": 1587990828190914715,
        "trace_id": 16171326968580111387
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-04 02:01:27
success: True
trace_id: 16171326968580111387

Scan 6408498

duration: 0:00:14.256564

exit_message:

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

id: 6408498

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-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_organizations/2026-04-03/1775199646",
        "key": "raw/authsso_organizations/2026-04-03/1775199646/part-00164.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18060878822620816402,
        "service_name": "drive-thru",
        "span_id": 8459421858175619871,
        "trace_id": 3736167920143005578
    }
}

running: False
schema_name_id: 2249
start_time: 2026-04-03 02:01:33
success: True
trace_id: 3736167920143005578

Partitions:

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

Schema:

attributes:

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

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

ddl:

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

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-08-08 11:12:14",
        "disabled": false,
        "format": "raw",
        "id": 2249,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "authsso_organizations"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "alias": "string",
            "createdAt": "date",
            "deletedAt": "date",
            "id": "string",
            "name": "string",
            "organizationAlias": "string",
            "organizationId": "string",
            "organizationName": "string",
            "totalActiveFacilities": "bigint"
        },
        "created": "2026-04-17 02:01:20",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/authsso_organizations/2026-04-17/1776409245'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_organizations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_organizations"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}