Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsaccounting_integrations

created: 2025-09-17 05:16:42
disabled: False
format: raw
id: 4277
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717929

created: 2026-04-17 04:55:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-17/1776419644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-17/1776419644
id: 1717929
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 162169265
updated: 2026-04-17 04:55:31

Version 1716744

created: 2026-04-16 05:17:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-16/1776334546'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-16/1776334546
id: 1716744
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 162114413
updated: 2026-04-16 05:18:12

Version 1715470

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-15/1776242355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-15/1776242355
id: 1715470
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 162056353
updated: 2026-04-15 03:40:45

Version 1714312

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-14/1776160757
id: 1714312
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 162002953
updated: 2026-04-14 05:01:04

Version 1713091

created: 2026-04-13 05:07:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-13/1776074797
id: 1713091
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161945297
updated: 2026-04-13 05:08:11

Version 1711969

created: 2026-04-12 05:07:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-12/1775988154'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-12/1775988154
id: 1711969
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161896427
updated: 2026-04-12 05:07:46

Version 1710688

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-11/1775902571'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-11/1775902571
id: 1710688
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161843907
updated: 2026-04-11 05:17:08

Version 1709562

created: 2026-04-10 05:02:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-10/1775815219
id: 1709562
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161788603
updated: 2026-04-10 05:03:01

Version 1708358

created: 2026-04-09 05:00:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-09/1775728830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-09/1775728830
id: 1708358
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161732911
updated: 2026-04-09 05:00:58

Version 1707200

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-08/1775642997'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-08/1775642997
id: 1707200
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161678360
updated: 2026-04-08 05:12:51

Version 1706063

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-07/1775556857
id: 1706063
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161622145
updated: 2026-04-07 05:18:13

Version 1704781

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-06/1775470528
id: 1704781
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161564252
updated: 2026-04-06 05:17:18

Version 1703536

created: 2026-04-05 04:56:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-05/1775382939'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-05/1775382939
id: 1703536
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161516500
updated: 2026-04-05 04:56:18

Version 1702453

created: 2026-04-04 04:57:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-04/1775296468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-04/1775296468
id: 1702453
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161462155
updated: 2026-04-04 04:57:38

Version 1701200

created: 2026-04-03 05:11:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-03/1775211030'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsaccounting_integrations/2026-04-03/1775211030
id: 1701200
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 4277
schema_scan_id: 161404798
updated: 2026-04-03 05:11:29

Schema Scans: 15

Last at 2026-04-17 04:55:19

Scan 162169265

duration: 0:00:11.786323

exit_message:

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

id: 162169265

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_imsaccounting_integrations/2026-04-17/1776419644",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-17/1776419644/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14488995395037024811,
        "service_name": "drive-thru",
        "span_id": 1646803373545378256,
        "trace_id": 9306972822368560509
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-17 04:55:19
success: True
trace_id: 9306972822368560509

Scan 162114413

duration: 0:00:14.411447

exit_message:

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

id: 162114413

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_imsaccounting_integrations/2026-04-16/1776334546",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-16/1776334546/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17643905045887684420,
        "service_name": "drive-thru",
        "span_id": 494769037781281859,
        "trace_id": 13042797909713198002
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-16 05:17:58
success: True
trace_id: 13042797909713198002

Scan 162056353

duration: 0:00:14.414797

exit_message:

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

id: 162056353

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_imsaccounting_integrations/2026-04-15/1776242355",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-15/1776242355/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1620220323947698452,
        "service_name": "drive-thru",
        "span_id": 826483443530350977,
        "trace_id": 2441733456128475857
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-15 03:40:31
success: True
trace_id: 2441733456128475857

Scan 162002953

duration: 0:00:11.886530

exit_message:

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

id: 162002953

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_imsaccounting_integrations/2026-04-14/1776160757",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-14/1776160757/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5603274398977078464,
        "service_name": "drive-thru",
        "span_id": 3769599107735560840,
        "trace_id": 13582286361755029816
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-14 05:00:52
success: True
trace_id: 13582286361755029816

Scan 161945297

duration: 0:00:14.411756

exit_message:

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

id: 161945297

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_imsaccounting_integrations/2026-04-13/1776074797",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-13/1776074797/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11482492619251612363,
        "service_name": "drive-thru",
        "span_id": 4184697479146479383,
        "trace_id": 13987229566473591918
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-13 05:07:57
success: True
trace_id: 13987229566473591918

Scan 161896427

duration: 0:00:11.870664

exit_message:

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

id: 161896427

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_imsaccounting_integrations/2026-04-12/1775988154",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-12/1775988154/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3767091457774187300,
        "service_name": "drive-thru",
        "span_id": 2823665184191454977,
        "trace_id": 15408599574277461213
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-12 05:07:34
success: True
trace_id: 15408599574277461213

Scan 161843907

duration: 0:00:11.930933

exit_message:

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

id: 161843907

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_imsaccounting_integrations/2026-04-11/1775902571",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-11/1775902571/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15574206688684162176,
        "service_name": "drive-thru",
        "span_id": 13925781101285237612,
        "trace_id": 5144638197392574477
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-11 05:16:56
success: True
trace_id: 5144638197392574477

Scan 161788603

duration: 0:00:14.478132

exit_message:

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

id: 161788603

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_imsaccounting_integrations/2026-04-10/1775815219",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-10/1775815219/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17320372109323228182,
        "service_name": "drive-thru",
        "span_id": 11757390784309840159,
        "trace_id": 15386262473143779951
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-10 05:02:46
success: True
trace_id: 15386262473143779951

Scan 161732911

duration: 0:00:14.438565

exit_message:

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

id: 161732911

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_imsaccounting_integrations/2026-04-09/1775728830",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-09/1775728830/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10370315234977484260,
        "service_name": "drive-thru",
        "span_id": 6912962538977838508,
        "trace_id": 16398590472627699707
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-09 05:00:43
success: True
trace_id: 16398590472627699707

Scan 161678360

duration: 0:00:14.309371

exit_message:

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

id: 161678360

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_imsaccounting_integrations/2026-04-08/1775642997",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-08/1775642997/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2605042234106308938,
        "service_name": "drive-thru",
        "span_id": 8242724183361525553,
        "trace_id": 807463452345983814
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-08 05:12:37
success: True
trace_id: 807463452345983814

Scan 161622145

duration: 0:00:11.888608

exit_message:

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

id: 161622145

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_imsaccounting_integrations/2026-04-07/1775556857",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-07/1775556857/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13717339269505943570,
        "service_name": "drive-thru",
        "span_id": 98231301086382607,
        "trace_id": 12435166595292350354
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-07 05:18:01
success: True
trace_id: 12435166595292350354

Scan 161564252

duration: 0:00:11.887376

exit_message:

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

id: 161564252

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_imsaccounting_integrations/2026-04-06/1775470528",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-06/1775470528/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10591075374178840956,
        "service_name": "drive-thru",
        "span_id": 3318192601333091598,
        "trace_id": 8718932812862404172
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-06 05:17:06
success: True
trace_id: 8718932812862404172

Scan 161516500

duration: 0:00:11.982893

exit_message:

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

id: 161516500

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_imsaccounting_integrations/2026-04-05/1775382939",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-05/1775382939/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10378662591675222129,
        "service_name": "drive-thru",
        "span_id": 15576261806622165262,
        "trace_id": 7247013767578092846
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-05 04:56:06
success: True
trace_id: 7247013767578092846

Scan 161462155

duration: 0:00:14.418231

exit_message:

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

id: 161462155

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_imsaccounting_integrations/2026-04-04/1775296468",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-04/1775296468/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8721726287316220770,
        "service_name": "drive-thru",
        "span_id": 6972289824653243507,
        "trace_id": 12902719090860936112
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-04 04:57:24
success: True
trace_id: 12902719090860936112

Scan 161404798

duration: 0:00:14.533133

exit_message:

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

id: 161404798

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_imsaccounting_integrations/2026-04-03/1775211030",
        "key": "raw/stellar_imsaccounting_integrations/2026-04-03/1775211030/accounting_integrations.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsaccounting_integrations",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16580434417367311836,
        "service_name": "drive-thru",
        "span_id": 2457352110005597961,
        "trace_id": 13556368166415466361
    }
}

running: False
schema_name_id: 4277
start_time: 2026-04-03 05:11:14
success: True
trace_id: 13556368166415466361

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 04:55:20

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsaccounting_integrations`\n(\n `tenant`  string , `id`  string , `location_id`  string , `integration_type`  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_imsaccounting_integrations/2026-04-17/1776419644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsaccounting_integrations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsaccounting_integrations"
}

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