Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsqbo_syncs

created: 2023-02-07 01:45:36
disabled: False
format: raw
id: 1441
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "stellar_imsqbo_syncs"
}

type: drivethrucsv

Schema Versions: 15

Version 1717970

created: 2026-04-17 04:57:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-17/1776419650
id: 1717970
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 162169308
updated: 2026-04-17 04:57:14

Version 1716789

created: 2026-04-16 05:19:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-16/1776334551'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-16/1776334551
id: 1716789
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 162114462
updated: 2026-04-16 05:19:59

Version 1715471

created: 2026-04-15 03:40:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-15/1776242364'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-15/1776242364
id: 1715471
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 162056354
updated: 2026-04-15 03:40:44

Version 1714373

created: 2026-04-14 05:03:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-14/1776160760'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-14/1776160760
id: 1714373
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 162003094
updated: 2026-04-14 05:03:52

Version 1713131

created: 2026-04-13 05:09:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-13/1776074805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-13/1776074805
id: 1713131
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161945337
updated: 2026-04-13 05:09:40

Version 1711980

created: 2026-04-12 05:08:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-12/1775988162'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-12/1775988162
id: 1711980
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161896442
updated: 2026-04-12 05:08:40

Version 1710772

created: 2026-04-11 05:20:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-11/1775902578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-11/1775902578
id: 1710772
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161843994
updated: 2026-04-11 05:20:24

Version 1709581

created: 2026-04-10 05:03:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-10/1775815221
id: 1709581
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161788628
updated: 2026-04-10 05:03:47

Version 1708392

created: 2026-04-09 05:02:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-09/1775728840'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-09/1775728840
id: 1708392
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161732949
updated: 2026-04-09 05:02:19

Version 1707175

created: 2026-04-08 05:11:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-08/1775642990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-08/1775642990
id: 1707175
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161678334
updated: 2026-04-08 05:11:14

Version 1706016

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-07/1775556859
id: 1706016
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161622094
updated: 2026-04-07 05:16:25

Version 1704819

created: 2026-04-06 05:18:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-06/1775470535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-06/1775470535
id: 1704819
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161564295
updated: 2026-04-06 05:18:47

Version 1703563

created: 2026-04-05 04:57:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-05/1775382947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-05/1775382947
id: 1703563
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161516545
updated: 2026-04-05 04:57:24

Version 1702426

created: 2026-04-04 04:56:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-04/1775296466
id: 1702426
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161462126
updated: 2026-04-04 04:56:34

Version 1701248

created: 2026-04-03 05:13:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-03/1775211037
id: 1701248
processed: 1

raw_data:

{
    "access_token": 5,
    "company_name": 4,
    "connection_status": 7,
    "created_at": 13,
    "id": 1,
    "last_inbound_date": 9,
    "last_inbound_result": 10,
    "last_outbound_date": 11,
    "last_outbound_result": 12,
    "location_id": 2,
    "realm_id": 3,
    "refresh_token": 6,
    "sync_status": 8,
    "tenant": 0,
    "updated_at": 14
}

schema_attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1441
schema_scan_id: 161404847
updated: 2026-04-03 05:13:19

Schema Scans: 15

Last at 2026-04-17 04:56:59

Scan 162169308

duration: 0:00:14.665750

exit_message:

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

id: 162169308

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-17/1776419650",
        "key": "raw/stellar_imsqbo_syncs/2026-04-17/1776419650/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1422760027938786707,
        "service_name": "drive-thru",
        "span_id": 8277214992960784737,
        "trace_id": 5750297040365229564
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-17 04:56:59
success: True
trace_id: 5750297040365229564

Scan 162114462

duration: 0:00:14.340715

exit_message:

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

id: 162114462

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-16/1776334551",
        "key": "raw/stellar_imsqbo_syncs/2026-04-16/1776334551/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9254313739035635324,
        "service_name": "drive-thru",
        "span_id": 18164885904226385736,
        "trace_id": 15796346179947933004
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-16 05:19:45
success: True
trace_id: 15796346179947933004

Scan 162056354

duration: 0:00:12.019954

exit_message:

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

id: 162056354

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-15/1776242364",
        "key": "raw/stellar_imsqbo_syncs/2026-04-15/1776242364/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13867813102406696094,
        "service_name": "drive-thru",
        "span_id": 17616070934701445813,
        "trace_id": 3592558081247040645
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-15 03:40:32
success: True
trace_id: 3592558081247040645

Scan 162003094

duration: 0:00:11.859138

exit_message:

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

id: 162003094

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-14/1776160760",
        "key": "raw/stellar_imsqbo_syncs/2026-04-14/1776160760/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11048154640583311084,
        "service_name": "drive-thru",
        "span_id": 14085245964486683411,
        "trace_id": 15177842382362895803
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-14 05:03:40
success: True
trace_id: 15177842382362895803

Scan 161945337

duration: 0:00:14.396274

exit_message:

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

id: 161945337

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-13/1776074805",
        "key": "raw/stellar_imsqbo_syncs/2026-04-13/1776074805/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8485260161358385411,
        "service_name": "drive-thru",
        "span_id": 17916264311105358848,
        "trace_id": 7596936065349188715
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-13 05:09:25
success: True
trace_id: 7596936065349188715

Scan 161896442

duration: 0:00:14.445246

exit_message:

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

id: 161896442

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-12/1775988162",
        "key": "raw/stellar_imsqbo_syncs/2026-04-12/1775988162/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12133269655285245068,
        "service_name": "drive-thru",
        "span_id": 16953092031439872313,
        "trace_id": 13499068474217047895
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-12 05:08:25
success: True
trace_id: 13499068474217047895

Scan 161843994

duration: 0:00:14.424520

exit_message:

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

id: 161843994

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-11/1775902578",
        "key": "raw/stellar_imsqbo_syncs/2026-04-11/1775902578/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11089987200550385735,
        "service_name": "drive-thru",
        "span_id": 7152097108765596803,
        "trace_id": 4225907313620406831
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-11 05:20:09
success: True
trace_id: 4225907313620406831

Scan 161788628

duration: 0:00:11.884821

exit_message:

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

id: 161788628

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-10/1775815221",
        "key": "raw/stellar_imsqbo_syncs/2026-04-10/1775815221/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13450257730924183571,
        "service_name": "drive-thru",
        "span_id": 6449532877596589174,
        "trace_id": 6907069135702288837
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-10 05:03:35
success: True
trace_id: 6907069135702288837

Scan 161732949

duration: 0:00:14.425319

exit_message:

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

id: 161732949

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-09/1775728840",
        "key": "raw/stellar_imsqbo_syncs/2026-04-09/1775728840/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7146986549191633334,
        "service_name": "drive-thru",
        "span_id": 17866357933409637311,
        "trace_id": 16682117492929922262
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-09 05:02:04
success: True
trace_id: 16682117492929922262

Scan 161678334

duration: 0:00:14.676525

exit_message:

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

id: 161678334

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-08/1775642990",
        "key": "raw/stellar_imsqbo_syncs/2026-04-08/1775642990/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13851351484821895643,
        "service_name": "drive-thru",
        "span_id": 5629736214180486254,
        "trace_id": 12458378592509425641
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-08 05:10:59
success: True
trace_id: 12458378592509425641

Scan 161622094

duration: 0:00:14.513127

exit_message:

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

id: 161622094

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-07/1775556859",
        "key": "raw/stellar_imsqbo_syncs/2026-04-07/1775556859/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3302910845501628105,
        "service_name": "drive-thru",
        "span_id": 15939626328770271977,
        "trace_id": 5327467845673852787
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-07 05:16:11
success: True
trace_id: 5327467845673852787

Scan 161564295

duration: 0:00:14.415910

exit_message:

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

id: 161564295

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-06/1775470535",
        "key": "raw/stellar_imsqbo_syncs/2026-04-06/1775470535/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4467023057524548936,
        "service_name": "drive-thru",
        "span_id": 15882495240032927047,
        "trace_id": 11545661773863561533
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-06 05:18:32
success: True
trace_id: 11545661773863561533

Scan 161516545

duration: 0:00:14.455556

exit_message:

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

id: 161516545

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-05/1775382947",
        "key": "raw/stellar_imsqbo_syncs/2026-04-05/1775382947/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4259494925521921311,
        "service_name": "drive-thru",
        "span_id": 2151383787292244549,
        "trace_id": 16831887136568883869
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-05 04:57:10
success: True
trace_id: 16831887136568883869

Scan 161462126

duration: 0:00:11.835638

exit_message:

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

id: 161462126

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-04/1775296466",
        "key": "raw/stellar_imsqbo_syncs/2026-04-04/1775296466/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11602370802362963748,
        "service_name": "drive-thru",
        "span_id": 15361849721874399396,
        "trace_id": 17325560378589150393
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-04 04:56:22
success: True
trace_id: 17325560378589150393

Scan 161404847

duration: 0:00:11.786586

exit_message:

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

id: 161404847

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-03/1775211037",
        "key": "raw/stellar_imsqbo_syncs/2026-04-03/1775211037/qbo_syncs.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsqbo_syncs",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8982964826745084638,
        "service_name": "drive-thru",
        "span_id": 12753812378804128754,
        "trace_id": 15639798706001944227
    }
}

running: False
schema_name_id: 1441
start_time: 2026-04-03 05:13:07
success: True
trace_id: 15639798706001944227

Partitions:

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

Schema:

attributes:

{
    "access_token": "string",
    "company_name": "string",
    "connection_status": "string",
    "created_at": "string",
    "id": "string",
    "last_inbound_date": "string",
    "last_inbound_result": "string",
    "last_outbound_date": "string",
    "last_outbound_result": "string",
    "location_id": "string",
    "realm_id": "string",
    "refresh_token": "string",
    "sync_status": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:57:00

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:45:36",
        "disabled": false,
        "format": "raw",
        "id": 1441,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsqbo_syncs"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "access_token": "string",
            "company_name": "string",
            "connection_status": "string",
            "created_at": "string",
            "id": "string",
            "last_inbound_date": "string",
            "last_inbound_result": "string",
            "last_outbound_date": "string",
            "last_outbound_result": "string",
            "location_id": "string",
            "realm_id": "string",
            "refresh_token": "string",
            "sync_status": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:57:00",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsqbo_syncs`\n(\n `tenant`  string , `id`  string , `location_id`  string , `realm_id`  string , `company_name`  string , `access_token`  string , `refresh_token`  string , `connection_status`  string , `sync_status`  string , `last_inbound_date`  string , `last_inbound_result`  string , `last_outbound_date`  string , `last_outbound_result`  string , `created_at`  string , `updated_at`  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-drivethrucsv-drivethru-prod/raw/stellar_imsqbo_syncs/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsqbo_syncs`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsqbo_syncs"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}