Schema Info

Schema Name: sfdl_stage_drivethru.authsso_accounts

created: 2025-08-07 14:24:00
disabled: False
format: raw
id: 2248
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 906602

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-17/1776409270'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-17/1776409270
id: 906602
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:28.229Z",
    "deletedAt": null,
    "id": "ffd8851e-47f3-4b47-89dc-0a5379a8af62",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6415178
updated: 2026-04-17 02:02:07

Version 906384

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-16/1776322839'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-16/1776322839
id: 906384
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:28.229Z",
    "deletedAt": null,
    "id": "ffd8851e-47f3-4b47-89dc-0a5379a8af62",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6414630
updated: 2026-04-16 02:01:28

Version 906171

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-15/1776236439'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-15/1776236439
id: 906171
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:10:53.745Z",
    "deletedAt": null,
    "id": "ffe7977d-5600-42ab-bb74-dc7ce787b14b",
    "initializedAt": null,
    "name": "Petromax Brazos do not use - for testing import bugs"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6414143
updated: 2026-04-15 02:01:36

Version 905957

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-14/1776150040'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-14/1776150040
id: 905957
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:10:53.745Z",
    "deletedAt": null,
    "id": "ffe7977d-5600-42ab-bb74-dc7ce787b14b",
    "initializedAt": null,
    "name": "Petromax Brazos do not use - for testing import bugs"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6413636
updated: 2026-04-14 02:01:28

Version 905741

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-13/1776063640'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-13/1776063640
id: 905741
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:37.152Z",
    "deletedAt": null,
    "id": "fff9de03-1a62-4bb5-a2d6-dd1dc63b13cf",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6413093
updated: 2026-04-13 02:01:31

Version 905539

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-12/1775977239'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-12/1775977239
id: 905539
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:44.681Z",
    "deletedAt": null,
    "id": "fe9656c8-aa73-4789-a61b-71549b926c48",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6412699
updated: 2026-04-12 02:01:29

Version 905337

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-11/1775890840'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-11/1775890840
id: 905337
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:00:44.681Z",
    "deletedAt": null,
    "id": "fe9656c8-aa73-4789-a61b-71549b926c48",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6412318
updated: 2026-04-11 02:01:34

Version 905123

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-10/1775804440'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-10/1775804440
id: 905123
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:00.218Z",
    "deletedAt": null,
    "id": "fea3a2ad-bdd4-4dad-b8d9-59d266cce0a1",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6411820
updated: 2026-04-10 02:01:28

Version 904909

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-09/1775718039'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-09/1775718039
id: 904909
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:00.218Z",
    "deletedAt": null,
    "id": "fea3a2ad-bdd4-4dad-b8d9-59d266cce0a1",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6411306
updated: 2026-04-09 02:01:24

Version 904696

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-08/1775631639'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-08/1775631639
id: 904696
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:17.142Z",
    "deletedAt": null,
    "id": "febfbffb-5247-4889-99f6-2f9911d12030",
    "initializedAt": null,
    "name": ""
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6410814
updated: 2026-04-08 02:01:38

Version 904481

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-07/1775545239'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-07/1775545239
id: 904481
processed: 1

raw_data:

{
    "createdAt": "2024-12-27T00:01:23.986Z",
    "deletedAt": null,
    "id": "fec6e064-ccd3-460e-a195-8d2185007271",
    "initializedAt": null,
    "name": "Anastasi Development (SOS)"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6410301
updated: 2026-04-07 02:01:32

Version 904267

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-06/1775458839'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-06/1775458839
id: 904267
processed: 1

raw_data:

{
    "createdAt": "2025-11-20T06:05:09.183Z",
    "deletedAt": null,
    "id": "feec1895-1821-415c-8ace-8afba9740efc",
    "initializedAt": null,
    "name": "Coffe Stores"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6409755
updated: 2026-04-06 02:01:37

Version 904066

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-05/1775372440'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-05/1775372440
id: 904066
processed: 1

raw_data:

{
    "createdAt": "2025-11-20T06:05:09.183Z",
    "deletedAt": null,
    "id": "feec1895-1821-415c-8ace-8afba9740efc",
    "initializedAt": null,
    "name": "Coffe Stores"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6409370
updated: 2026-04-05 02:01:34

Version 903864

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-04/1775286039'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-04/1775286039
id: 903864
processed: 1

raw_data:

{
    "createdAt": "2025-11-20T06:05:09.183Z",
    "deletedAt": null,
    "id": "feec1895-1821-415c-8ace-8afba9740efc",
    "initializedAt": null,
    "name": "Coffe Stores"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6408989
updated: 2026-04-04 02:01:38

Version 903649

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-03/1775199639'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-03/1775199639
id: 903649
processed: 1

raw_data:

{
    "createdAt": "2024-12-28T00:37:03.234Z",
    "deletedAt": null,
    "id": "ff056ca7-3772-4532-863b-cfb60c335684",
    "initializedAt": null,
    "name": "Waco Self Storage"
}

schema_attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

schema_name_id: 2248
schema_scan_id: 6408496
updated: 2026-04-03 02:01:21

Schema Scans: 15

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

Scan 6415178

duration: 0:00:14.281272

exit_message:

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

id: 6415178

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-17/1776409270",
        "key": "raw/authsso_accounts/2026-04-17/1776409270/part-00166.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6747397214347857331,
        "service_name": "drive-thru",
        "span_id": 13833060729067471519,
        "trace_id": 14721359039341913911
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-17 02:01:53
success: True
trace_id: 14721359039341913911

Scan 6414630

duration: 0:00:14.222778

exit_message:

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

id: 6414630

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-16/1776322839",
        "key": "raw/authsso_accounts/2026-04-16/1776322839/part-00166.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 18191287259928601479,
        "service_name": "drive-thru",
        "span_id": 16467324769044248372,
        "trace_id": 8577074533485306276
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-16 02:01:14
success: True
trace_id: 8577074533485306276

Scan 6414143

duration: 0:00:14.283960

exit_message:

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

id: 6414143

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-15/1776236439",
        "key": "raw/authsso_accounts/2026-04-15/1776236439/part-00166.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12483157394916911254,
        "service_name": "drive-thru",
        "span_id": 8820910262041234145,
        "trace_id": 18072646454310463896
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-15 02:01:22
success: True
trace_id: 18072646454310463896

Scan 6413636

duration: 0:00:14.241266

exit_message:

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

id: 6413636

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-14/1776150040",
        "key": "raw/authsso_accounts/2026-04-14/1776150040/part-00166.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 1256756331850768107,
        "service_name": "drive-thru",
        "span_id": 5860885132763741887,
        "trace_id": 7666715200340327308
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-14 02:01:13
success: True
trace_id: 7666715200340327308

Scan 6413093

duration: 0:00:14.391990

exit_message:

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

id: 6413093

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-13/1776063640",
        "key": "raw/authsso_accounts/2026-04-13/1776063640/part-00166.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10587182896355870206,
        "service_name": "drive-thru",
        "span_id": 8720447969531276529,
        "trace_id": 4302509851735551217
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-13 02:01:16
success: True
trace_id: 4302509851735551217

Scan 6412699

duration: 0:00:11.626814

exit_message:

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

id: 6412699

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-12/1775977239",
        "key": "raw/authsso_accounts/2026-04-12/1775977239/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14966498094830019295,
        "service_name": "drive-thru",
        "span_id": 11715438888421952217,
        "trace_id": 6482437624127224464
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-12 02:01:17
success: True
trace_id: 6482437624127224464

Scan 6412318

duration: 0:00:14.270626

exit_message:

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

id: 6412318

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-11/1775890840",
        "key": "raw/authsso_accounts/2026-04-11/1775890840/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10597822491874964758,
        "service_name": "drive-thru",
        "span_id": 5330362181069990352,
        "trace_id": 12964136637720243571
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-11 02:01:20
success: True
trace_id: 12964136637720243571

Scan 6411820

duration: 0:00:11.819761

exit_message:

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

id: 6411820

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-10/1775804440",
        "key": "raw/authsso_accounts/2026-04-10/1775804440/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3344506637394717405,
        "service_name": "drive-thru",
        "span_id": 12963649469599305945,
        "trace_id": 3011172164802368284
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-10 02:01:16
success: True
trace_id: 3011172164802368284

Scan 6411306

duration: 0:00:11.756996

exit_message:

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

id: 6411306

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-09/1775718039",
        "key": "raw/authsso_accounts/2026-04-09/1775718039/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5587651752005800759,
        "service_name": "drive-thru",
        "span_id": 14237675645097848529,
        "trace_id": 11624831325967316200
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-09 02:01:13
success: True
trace_id: 11624831325967316200

Scan 6410814

duration: 0:00:11.698837

exit_message:

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

id: 6410814

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-08/1775631639",
        "key": "raw/authsso_accounts/2026-04-08/1775631639/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16714188142444039304,
        "service_name": "drive-thru",
        "span_id": 8333733764354161247,
        "trace_id": 10689679865370107037
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-08 02:01:26
success: True
trace_id: 10689679865370107037

Scan 6410301

duration: 0:00:11.682986

exit_message:

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

id: 6410301

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-07/1775545239",
        "key": "raw/authsso_accounts/2026-04-07/1775545239/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 17687674932408748878,
        "service_name": "drive-thru",
        "span_id": 760506792675050685,
        "trace_id": 7518848055086118492
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-07 02:01:21
success: True
trace_id: 7518848055086118492

Scan 6409755

duration: 0:00:11.701024

exit_message:

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

id: 6409755

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-06/1775458839",
        "key": "raw/authsso_accounts/2026-04-06/1775458839/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15200960266507501660,
        "service_name": "drive-thru",
        "span_id": 13205310715311516660,
        "trace_id": 6199518634868624074
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-06 02:01:26
success: True
trace_id: 6199518634868624074

Scan 6409370

duration: 0:00:14.231531

exit_message:

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

id: 6409370

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-05/1775372440",
        "key": "raw/authsso_accounts/2026-04-05/1775372440/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6875535487024857838,
        "service_name": "drive-thru",
        "span_id": 14571506704439727935,
        "trace_id": 6231022345318892174
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-05 02:01:20
success: True
trace_id: 6231022345318892174

Scan 6408989

duration: 0:00:11.969226

exit_message:

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

id: 6408989

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-04/1775286039",
        "key": "raw/authsso_accounts/2026-04-04/1775286039/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 3070874718902374499,
        "service_name": "drive-thru",
        "span_id": 116387703411993268,
        "trace_id": 10595642761564562762
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-04 02:01:26
success: True
trace_id: 10595642761564562762

Scan 6408496

duration: 0:00:11.739425

exit_message:

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

id: 6408496

payload:

{
    "datatype_dict": {
        "createdAt": "date",
        "deletedAt": "date",
        "id": "string",
        "initializedAt": "date",
        "name": "string"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/authsso_accounts/2026-04-03/1775199639",
        "key": "raw/authsso_accounts/2026-04-03/1775199639/part-00165.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.authsso_accounts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9180822869413820239,
        "service_name": "drive-thru",
        "span_id": 7074676939958625596,
        "trace_id": 16406410056013815742
    }
}

running: False
schema_name_id: 2248
start_time: 2026-04-03 02:01:10
success: True
trace_id: 16406410056013815742

Partitions:

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

Schema:

attributes:

{
    "createdAt": "date",
    "deletedAt": "date",
    "id": "string",
    "initializedAt": "date",
    "name": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-17/1776409270'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
}

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-07 14:24:00",
        "disabled": false,
        "format": "raw",
        "id": 2248,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "authsso_accounts"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "createdAt": "date",
            "deletedAt": "date",
            "id": "string",
            "initializedAt": "date",
            "name": "string"
        },
        "created": "2026-04-17 02:01:53",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.authsso_accounts`\n(\n`id`string,`name`string,`createdAt`date,`deletedAt`date,`initializedAt`date\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_accounts/2026-04-17/1776409270'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.authsso_accounts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.authsso_accounts"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}