Schema Info

Schema Name: sfdl_dev_drivethru.authsso_accounts

created: 2025-08-11 14:41:22
disabled: False
format: raw
id: 3130
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrujson

Schema Versions: 15

Version 4773322

created: 2026-04-17 02:00:58

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-17/1776409232
id: 4773322
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6867625
updated: 2026-04-17 02:01:12

Version 4773265

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-16/1776322868
id: 4773265
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6867366
updated: 2026-04-16 02:02:19

Version 4773203

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-15/1776236453
id: 4773203
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6867102
updated: 2026-04-15 02:01:53

Version 4773141

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-14/1776150027
id: 4773141
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6866838
updated: 2026-04-14 02:01:03

Version 4773080

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

ddl:

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

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

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6866528
updated: 2026-04-13 02:02:07

Version 4773031

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-12/1775977223
id: 4773031
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6866353
updated: 2026-04-12 02:01:24

Version 4772981

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-11/1775890826
id: 4772981
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6866179
updated: 2026-04-11 02:00:58

Version 4772919

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-10/1775804453
id: 4772919
processed: 1

raw_data:

{
    "createdAt": "2026-04-09T18:09:28.300Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6865905
updated: 2026-04-10 02:01:26

Version 4772860

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-09/1775718027
id: 4772860
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6865638
updated: 2026-04-09 02:01:28

Version 4772804

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

ddl:

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

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

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6865374
updated: 2026-04-08 02:02:13

Version 4772737

created: 2026-04-07 02:00:52

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-07/1775545228
id: 4772737
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6865099
updated: 2026-04-07 02:01:03

Version 4772680

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-06/1775458823
id: 4772680
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6864782
updated: 2026-04-06 02:01:22

Version 4772626

created: 2026-04-05 02:00:53

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-05/1775372446
id: 4772626
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6864604
updated: 2026-04-05 02:01:05

Version 4772584

created: 2026-04-04 02:01:38

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-04/1775286029
id: 4772584
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6864438
updated: 2026-04-04 02:01:49

Version 4772521

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

ddl:

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

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/authsso_accounts/2026-04-03/1775199644
id: 4772521
processed: 1

raw_data:

{
    "createdAt": "2026-03-30T16:18:31.178Z",
    "deletedAt": null,
    "id": "00000000-0000-0000-0000-000000000001",
    "initializedAt": null,
    "name": "Storable Local Dev Test Account"
}

schema_attributes:

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

schema_name_id: 3130
schema_scan_id: 6864167
updated: 2026-04-03 02:01:33

Schema Scans: 15

Last at 2026-04-17 02:00:58

Scan 6867625

duration: 0:00:14.300310

exit_message:

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

id: 6867625

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

running: False
schema_name_id: 3130
start_time: 2026-04-17 02:00:58
success: True
trace_id: 6290187729063380805

Scan 6867366

duration: 0:00:14.223319

exit_message:

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

id: 6867366

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

running: False
schema_name_id: 3130
start_time: 2026-04-16 02:02:05
success: True
trace_id: 14206832964104681906

Scan 6867102

duration: 0:00:11.741135

exit_message:

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

id: 6867102

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

running: False
schema_name_id: 3130
start_time: 2026-04-15 02:01:41
success: True
trace_id: 16921600831381673898

Scan 6866838

duration: 0:00:14.718832

exit_message:

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

id: 6866838

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

running: False
schema_name_id: 3130
start_time: 2026-04-14 02:00:48
success: True
trace_id: 11872291077074262127

Scan 6866528

duration: 0:00:14.292177

exit_message:

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

id: 6866528

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

running: False
schema_name_id: 3130
start_time: 2026-04-13 02:01:53
success: True
trace_id: 7198147003916696517

Scan 6866353

duration: 0:00:14.248492

exit_message:

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

id: 6866353

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

running: False
schema_name_id: 3130
start_time: 2026-04-12 02:01:10
success: True
trace_id: 9496487041439566588

Scan 6866179

duration: 0:00:11.709979

exit_message:

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

id: 6866179

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

running: False
schema_name_id: 3130
start_time: 2026-04-11 02:00:47
success: True
trace_id: 685437500925088440

Scan 6865905

duration: 0:00:14.264189

exit_message:

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

id: 6865905

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

running: False
schema_name_id: 3130
start_time: 2026-04-10 02:01:11
success: True
trace_id: 1786934844748404309

Scan 6865638

duration: 0:00:14.314807

exit_message:

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

id: 6865638

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

running: False
schema_name_id: 3130
start_time: 2026-04-09 02:01:14
success: True
trace_id: 15596062495404547156

Scan 6865374

duration: 0:00:14.253583

exit_message:

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

id: 6865374

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

running: False
schema_name_id: 3130
start_time: 2026-04-08 02:01:58
success: True
trace_id: 9136990074368924203

Scan 6865099

duration: 0:00:11.686133

exit_message:

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

id: 6865099

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

running: False
schema_name_id: 3130
start_time: 2026-04-07 02:00:51
success: True
trace_id: 2545889950247474471

Scan 6864782

duration: 0:00:14.195461

exit_message:

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

id: 6864782

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

running: False
schema_name_id: 3130
start_time: 2026-04-06 02:01:08
success: True
trace_id: 15440397863984361478

Scan 6864604

duration: 0:00:11.658317

exit_message:

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

id: 6864604

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

running: False
schema_name_id: 3130
start_time: 2026-04-05 02:00:53
success: True
trace_id: 3340858369195394939

Scan 6864438

duration: 0:00:11.664960

exit_message:

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

id: 6864438

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

running: False
schema_name_id: 3130
start_time: 2026-04-04 02:01:37
success: True
trace_id: 13463367869899479540

Scan 6864167

duration: 0:00:11.926030

exit_message:

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

id: 6864167

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

running: False
schema_name_id: 3130
start_time: 2026-04-03 02:01:21
success: True
trace_id: 10859993324705157452

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:00:58

ddl:

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

Server:

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

Raw:

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