Schema Info

Schema Name: sfdl_dev_drivethru.authsso_organizations

created: 2026-01-02 14:00:57
disabled: False
format: raw
id: 3135
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773323

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-17/1776409227
id: 4773323
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-17T00:00:23.692Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6867626
updated: 2026-04-17 02:01:21

Version 4773264

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-16/1776322863
id: 4773264
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-16T00:00:24.238Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6867365
updated: 2026-04-16 02:02:06

Version 4773207

created: 2026-04-15 02:02:08

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-15/1776236458
id: 4773207
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-15T00:00:26.548Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6867106
updated: 2026-04-15 02:02:21

Version 4773140

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-14/1776150029
id: 4773140
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-14T00:00:52.548Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6866837
updated: 2026-04-14 02:01:00

Version 4773083

created: 2026-04-13 02:02:23

ddl:

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

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

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-13T00:00:23.391Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6866531
updated: 2026-04-13 02:02:34

Version 4773034

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-12/1775977241
id: 4773034
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-12T00:00:24.087Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6866356
updated: 2026-04-12 02:01:37

Version 4772983

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-11/1775890832
id: 4772983
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-11T00:00:25.024Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6866181
updated: 2026-04-11 02:01:24

Version 4772920

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

ddl:

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

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

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.351Z",
    "deletedAt": "2026-04-10T00:00:44.667Z",
    "organizationAlias": "pal:organization:ess:1",
    "organizationId": "356cc42b-932a-4559-bb38-f1de691f8ca8",
    "organizationName": "Easy Storage Solutions Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6865906
updated: 2026-04-10 02:01:37

Version 4772865

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-09/1775718033
id: 4772865
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-09T00:00:24.422Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6865643
updated: 2026-04-09 02:02:06

Version 4772803

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-08/1775631649
id: 4772803
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-08T00:00:25.369Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6865373
updated: 2026-04-08 02:02:08

Version 4772739

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-07/1775545225
id: 4772739
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-07T00:00:48.054Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6865101
updated: 2026-04-07 02:01:15

Version 4772678

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-06/1775458824
id: 4772678
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-06T00:00:35.803Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6864780
updated: 2026-04-06 02:01:08

Version 4772629

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-05/1775372450
id: 4772629
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-05T00:00:21.992Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6864607
updated: 2026-04-05 02:01:35

Version 4772580

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

ddl:

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

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

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-04T00:00:22.336Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6864434
updated: 2026-04-04 02:01:25

Version 4772523

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

ddl:

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

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

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.258Z",
    "deletedAt": "2026-04-03T00:00:22.496Z",
    "organizationAlias": "pal:organization:sl:C001",
    "organizationId": "19fc5282-1e3f-4433-b345-02aa09d158ec",
    "organizationName": "SiteLink Storage",
    "totalActiveFacilities": 0
}

schema_attributes:

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

schema_name_id: 3135
schema_scan_id: 6864169
updated: 2026-04-03 02:01:47

Schema Scans: 15

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

Scan 6867626

duration: 0:00:11.786053

exit_message:

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

id: 6867626

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-17/1776409227",
        "key": "raw/authsso_organizations/2026-04-17/1776409227/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17064534327040904290,
        "service_name": "drive-thru",
        "span_id": 12539463756610006882,
        "trace_id": 8619031408683891083
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-17 02:01:09
success: True
trace_id: 8619031408683891083

Scan 6867365

duration: 0:00:14.378152

exit_message:

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

id: 6867365

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-16/1776322863",
        "key": "raw/authsso_organizations/2026-04-16/1776322863/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 349884421177215292,
        "service_name": "drive-thru",
        "span_id": 8409849507174724008,
        "trace_id": 1250880550741753704
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-16 02:01:52
success: True
trace_id: 1250880550741753704

Scan 6867106

duration: 0:00:14.342679

exit_message:

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

id: 6867106

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-15/1776236458",
        "key": "raw/authsso_organizations/2026-04-15/1776236458/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8189110736442315846,
        "service_name": "drive-thru",
        "span_id": 10956397225591654621,
        "trace_id": 14064323396533600855
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-15 02:02:07
success: True
trace_id: 14064323396533600855

Scan 6866837

duration: 0:00:14.341123

exit_message:

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

id: 6866837

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-14/1776150029",
        "key": "raw/authsso_organizations/2026-04-14/1776150029/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1999202160906098113,
        "service_name": "drive-thru",
        "span_id": 8442091738079081665,
        "trace_id": 1766350311358148406
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-14 02:00:46
success: True
trace_id: 1766350311358148406

Scan 6866531

duration: 0:00:11.667336

exit_message:

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

id: 6866531

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-13/1776063663",
        "key": "raw/authsso_organizations/2026-04-13/1776063663/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2561405108067915714,
        "service_name": "drive-thru",
        "span_id": 12825222525193684786,
        "trace_id": 5249476965629982737
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-13 02:02:22
success: True
trace_id: 5249476965629982737

Scan 6866356

duration: 0:00:11.700648

exit_message:

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

id: 6866356

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-12/1775977241",
        "key": "raw/authsso_organizations/2026-04-12/1775977241/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13582918862429038028,
        "service_name": "drive-thru",
        "span_id": 12479976596398151717,
        "trace_id": 2302933685434162346
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-12 02:01:25
success: True
trace_id: 2302933685434162346

Scan 6866181

duration: 0:00:11.667569

exit_message:

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

id: 6866181

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-11/1775890832",
        "key": "raw/authsso_organizations/2026-04-11/1775890832/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2584442392284941821,
        "service_name": "drive-thru",
        "span_id": 2142797306820370603,
        "trace_id": 14654324671917081079
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-11 02:01:12
success: True
trace_id: 14654324671917081079

Scan 6865906

duration: 0:00:11.699148

exit_message:

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

id: 6865906

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-10/1775804447",
        "key": "raw/authsso_organizations/2026-04-10/1775804447/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10333218736465158860,
        "service_name": "drive-thru",
        "span_id": 12863520195784752367,
        "trace_id": 6456599727635594855
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-10 02:01:26
success: True
trace_id: 6456599727635594855

Scan 6865643

duration: 0:00:14.296590

exit_message:

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

id: 6865643

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-09/1775718033",
        "key": "raw/authsso_organizations/2026-04-09/1775718033/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16075462076087313544,
        "service_name": "drive-thru",
        "span_id": 1048439360214574980,
        "trace_id": 12280658480236280867
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-09 02:01:51
success: True
trace_id: 12280658480236280867

Scan 6865373

duration: 0:00:14.186144

exit_message:

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

id: 6865373

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-08/1775631649",
        "key": "raw/authsso_organizations/2026-04-08/1775631649/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18387315161104101466,
        "service_name": "drive-thru",
        "span_id": 5456055667093288899,
        "trace_id": 15344702691839039731
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-08 02:01:54
success: True
trace_id: 15344702691839039731

Scan 6865101

duration: 0:00:11.668884

exit_message:

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

id: 6865101

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-07/1775545225",
        "key": "raw/authsso_organizations/2026-04-07/1775545225/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15370367818187454805,
        "service_name": "drive-thru",
        "span_id": 13360031669734171963,
        "trace_id": 2357748602284409865
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-07 02:01:03
success: True
trace_id: 2357748602284409865

Scan 6864780

duration: 0:00:11.657823

exit_message:

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

id: 6864780

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-06/1775458824",
        "key": "raw/authsso_organizations/2026-04-06/1775458824/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17195379789374521694,
        "service_name": "drive-thru",
        "span_id": 6110294343174946517,
        "trace_id": 15756004986389596262
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-06 02:00:56
success: True
trace_id: 15756004986389596262

Scan 6864607

duration: 0:00:14.156148

exit_message:

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

id: 6864607

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-05/1775372450",
        "key": "raw/authsso_organizations/2026-04-05/1775372450/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16981453501224968589,
        "service_name": "drive-thru",
        "span_id": 10377794439076952321,
        "trace_id": 18393911861953573012
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-05 02:01:21
success: True
trace_id: 18393911861953573012

Scan 6864434

duration: 0:00:11.729362

exit_message:

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

id: 6864434

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-04/1775286024",
        "key": "raw/authsso_organizations/2026-04-04/1775286024/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5735818760192739286,
        "service_name": "drive-thru",
        "span_id": 6024056882806757384,
        "trace_id": 10268903100588477413
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-04 02:01:14
success: True
trace_id: 10268903100588477413

Scan 6864169

duration: 0:00:14.216996

exit_message:

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

id: 6864169

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-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_organizations/2026-04-03/1775199627",
        "key": "raw/authsso_organizations/2026-04-03/1775199627/part-00000.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.authsso_organizations",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16887519281547163465,
        "service_name": "drive-thru",
        "span_id": 3408163200491960765,
        "trace_id": 6605317995305876615
    }
}

running: False
schema_name_id: 3135
start_time: 2026-04-03 02:01:33
success: True
trace_id: 6605317995305876615

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

ddl:

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

Server:

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

Raw:

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