Schema Info

Schema Name: sfdl_prod_csv.salesforce_dlar__shares

created: 2025-05-19 09:34:00
disabled: False
format: raw
id: 3894
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_csv",
    "table": "salesforce_dlar__shares"
}

type: csv

Schema Versions: 15

Version 1718075

created: 2026-04-17 07:05:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-17/1776427505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-17/1776427505
id: 1718075
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 162173043
updated: 2026-04-17 07:05:53

Version 1716842

created: 2026-04-16 07:05:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-16/1776341105'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-16/1776341105
id: 1716842
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 162117317
updated: 2026-04-16 07:05:46

Version 1715626

created: 2026-04-15 07:05:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-15/1776254714'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-15/1776254714
id: 1715626
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 162061758
updated: 2026-04-15 07:05:37

Version 1714472

created: 2026-04-14 07:06:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-14/1776168295'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-14/1776168295
id: 1714472
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 162006389
updated: 2026-04-14 07:07:07

Version 1713213

created: 2026-04-13 07:04:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-13/1776081871'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-13/1776081871
id: 1713213
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161948284
updated: 2026-04-13 07:04:59

Version 1712048

created: 2026-04-12 07:07:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-12/1775995643'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-12/1775995643
id: 1712048
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161899530
updated: 2026-04-12 07:07:47

Version 1710847

created: 2026-04-11 07:05:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-11/1775909038'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-11/1775909038
id: 1710847
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161846856
updated: 2026-04-11 07:06:05

Version 1709677

created: 2026-04-10 07:06:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-10/1775822742'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-10/1775822742
id: 1709677
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161792075
updated: 2026-04-10 07:06:45

Version 1708541

created: 2026-04-09 07:07:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-09/1775736318'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-09/1775736318
id: 1708541
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161736277
updated: 2026-04-09 07:07:41

Version 1707355

created: 2026-04-08 07:07:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-08/1775649934'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-08/1775649934
id: 1707355
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161681419
updated: 2026-04-08 07:07:33

Version 1706155

created: 2026-04-07 07:06:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-07/1775563521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-07/1775563521
id: 1706155
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161625196
updated: 2026-04-07 07:07:06

Version 1704959

created: 2026-04-06 07:11:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-06/1775477132'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-06/1775477132
id: 1704959
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161567376
updated: 2026-04-06 07:11:58

Version 1703698

created: 2026-04-05 07:05:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-05/1775390668'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-05/1775390668
id: 1703698
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161519979
updated: 2026-04-05 07:05:48

Version 1702576

created: 2026-04-04 07:09:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-04/1775304423'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-04/1775304423
id: 1702576
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161466450
updated: 2026-04-04 07:10:01

Version 1701352

created: 2026-04-03 07:05:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-03/1775217854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-03/1775217854
id: 1701352
processed: 1

raw_data:

{
    "AccessLevel": 3,
    "Id": 0,
    "IsDeleted": 7,
    "LastModifiedById": 6,
    "LastModifiedDate": 5,
    "ParentId": 1,
    "RowCause": 4,
    "UserOrGroupId": 2
}

schema_attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

schema_name_id: 3894
schema_scan_id: 161408558
updated: 2026-04-03 07:05:32

Schema Scans: 15

Last at 2026-04-17 07:05:38

Scan 162173043

duration: 0:00:14.287507

exit_message:

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

id: 162173043

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-17/1776427505",
        "key": "raw/dlar__shares/2026-04-17/1776427505/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5208545393314636236,
        "service_name": "drive-thru",
        "span_id": 8736120407783691713,
        "trace_id": 14798823480463469238
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-17 07:05:38
success: True
trace_id: 14798823480463469238

Scan 162117317

duration: 0:00:14.654659

exit_message:

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

id: 162117317

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-16/1776341105",
        "key": "raw/dlar__shares/2026-04-16/1776341105/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9563471529095669037,
        "service_name": "drive-thru",
        "span_id": 11423495991344549532,
        "trace_id": 17999194507559908627
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-16 07:05:32
success: True
trace_id: 17999194507559908627

Scan 162061758

duration: 0:00:11.708210

exit_message:

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

id: 162061758

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-15/1776254714",
        "key": "raw/dlar__shares/2026-04-15/1776254714/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13733472318476464223,
        "service_name": "drive-thru",
        "span_id": 3572672785200032973,
        "trace_id": 5288445331189873308
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-15 07:05:26
success: True
trace_id: 5288445331189873308

Scan 162006389

duration: 0:00:14.360445

exit_message:

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

id: 162006389

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-14/1776168295",
        "key": "raw/dlar__shares/2026-04-14/1776168295/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10159051963045021827,
        "service_name": "drive-thru",
        "span_id": 15728552224309107493,
        "trace_id": 9409817008390422677
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-14 07:06:53
success: True
trace_id: 9409817008390422677

Scan 161948284

duration: 0:00:11.605545

exit_message:

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

id: 161948284

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-13/1776081871",
        "key": "raw/dlar__shares/2026-04-13/1776081871/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1274656821560820930,
        "service_name": "drive-thru",
        "span_id": 13753285459889029429,
        "trace_id": 9709065509150177813
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-13 07:04:48
success: True
trace_id: 9709065509150177813

Scan 161899530

duration: 0:00:14.349951

exit_message:

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

id: 161899530

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-12/1775995643",
        "key": "raw/dlar__shares/2026-04-12/1775995643/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13936294244578536167,
        "service_name": "drive-thru",
        "span_id": 13421275090597525131,
        "trace_id": 114239010182298102
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-12 07:07:33
success: True
trace_id: 114239010182298102

Scan 161846856

duration: 0:00:11.644285

exit_message:

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

id: 161846856

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-11/1775909038",
        "key": "raw/dlar__shares/2026-04-11/1775909038/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1096111695979834557,
        "service_name": "drive-thru",
        "span_id": 4627273336529471804,
        "trace_id": 3134438425799933106
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-11 07:05:53
success: True
trace_id: 3134438425799933106

Scan 161792075

duration: 0:00:11.697464

exit_message:

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

id: 161792075

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-10/1775822742",
        "key": "raw/dlar__shares/2026-04-10/1775822742/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17867002365130916574,
        "service_name": "drive-thru",
        "span_id": 14620825737233515461,
        "trace_id": 4486858210837931916
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-10 07:06:33
success: True
trace_id: 4486858210837931916

Scan 161736277

duration: 0:00:11.606705

exit_message:

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

id: 161736277

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-09/1775736318",
        "key": "raw/dlar__shares/2026-04-09/1775736318/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 11771984485539146628,
        "service_name": "drive-thru",
        "span_id": 16093426114224214938,
        "trace_id": 3561188900574235859
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-09 07:07:30
success: True
trace_id: 3561188900574235859

Scan 161681419

duration: 0:00:11.590275

exit_message:

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

id: 161681419

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-08/1775649934",
        "key": "raw/dlar__shares/2026-04-08/1775649934/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8363397518062049216,
        "service_name": "drive-thru",
        "span_id": 5144921046655318723,
        "trace_id": 4815607500022149410
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-08 07:07:21
success: True
trace_id: 4815607500022149410

Scan 161625196

duration: 0:00:14.244443

exit_message:

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

id: 161625196

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-07/1775563521",
        "key": "raw/dlar__shares/2026-04-07/1775563521/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7203930393274839490,
        "service_name": "drive-thru",
        "span_id": 6473547857195422458,
        "trace_id": 2897984885705901877
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-07 07:06:52
success: True
trace_id: 2897984885705901877

Scan 161567376

duration: 0:00:11.613223

exit_message:

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

id: 161567376

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-06/1775477132",
        "key": "raw/dlar__shares/2026-04-06/1775477132/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10186690660053358367,
        "service_name": "drive-thru",
        "span_id": 4883523613089709099,
        "trace_id": 6610272015538843777
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-06 07:11:47
success: True
trace_id: 6610272015538843777

Scan 161519979

duration: 0:00:14.328956

exit_message:

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

id: 161519979

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-05/1775390668",
        "key": "raw/dlar__shares/2026-04-05/1775390668/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 1325488185713614791,
        "service_name": "drive-thru",
        "span_id": 6995995060115149560,
        "trace_id": 525641580865892321
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-05 07:05:34
success: True
trace_id: 525641580865892321

Scan 161466450

duration: 0:00:11.738948

exit_message:

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

id: 161466450

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-04/1775304423",
        "key": "raw/dlar__shares/2026-04-04/1775304423/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2736394592956992185,
        "service_name": "drive-thru",
        "span_id": 3766616933410498392,
        "trace_id": 15533184049620864743
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-04 07:09:50
success: True
trace_id: 15533184049620864743

Scan 161408558

duration: 0:00:14.349846

exit_message:

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

id: 161408558

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-03/1775217854",
        "key": "raw/dlar__shares/2026-04-03/1775217854/dlar__shares.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_dlar__shares",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 4511961612257668432,
        "service_name": "drive-thru",
        "span_id": 17405623957490657353,
        "trace_id": 16266425407552740007
    }
}

running: False
schema_name_id: 3894
start_time: 2026-04-03 07:05:17
success: True
trace_id: 16266425407552740007

Partitions:

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

Schema:

attributes:

{
    "AccessLevel": "string",
    "Id": "string",
    "IsDeleted": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "ParentId": "string",
    "RowCause": "string",
    "UserOrGroupId": "string"
}

created: 2026-04-17 07:05:39

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-17/1776427505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
}

Server:

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

Raw:

{
    "name": {
        "created": "2025-05-19 09:34:00",
        "disabled": false,
        "format": "raw",
        "id": 3894,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_dlar__shares"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccessLevel": "string",
            "Id": "string",
            "IsDeleted": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "ParentId": "string",
            "RowCause": "string",
            "UserOrGroupId": "string"
        },
        "created": "2026-04-17 07:05:39",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_dlar__shares`\n(\n `Id`  string , `ParentId`  string , `UserOrGroupId`  string , `AccessLevel`  string , `RowCause`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `IsDeleted`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/dlar__shares/2026-04-17/1776427505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_dlar__shares`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_dlar__shares"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}