Schema Info
Schema Name: sfdl_prod_drivethru.netsuite_netsuite_expense_transactions
- created: 2024-10-30 11:45:43
- disabled: False
- format: raw
- id: 1990
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "netsuite_netsuite_expense_transactions" } - type: drivethrujson
Schema Versions: 3
-
Version 1160572
- created: 2025-01-15 19:04:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\n(\n`employee_last_name`STRING,`date_last_modified`STRING,`transaction_line_memo`STRING,`transaction_line_subsidiary`STRING,`transaction_accounting_line_amount`STRING,`type`STRING,`transaction_amount`STRING,`employee_first_name`STRING,`account_name`STRING,`created_by`STRING,`internal_id`STRING,`currency`STRING,`date_created`STRING,`reversal_date`STRING,`account_type`STRING,`document_number_id`STRING,`number`STRING,`posting_period`STRING,`document_number`STRING,`transaction_line_department`STRING,`vendor`STRING,`transaction_line_id`STRING,`transaction_line_product`STRING,`transaction_memo`STRING,`account_full_name`STRING,`date`STRING,`entity_name`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions'\n", "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_expense_transactions" ] - hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions
- id: 1160572
- processed: 1
- raw_data:
{ "account_full_name": "Employee Expenses : Bonuses", "account_name": "Bonuses", "account_type": "Expense", "created_by": "Srikanth Gudla", "currency": "USD", "date": "12/31/2024", "date_created": "1/15/2025 12:23:50 pm", "date_last_modified": "1/15/2025 12:39:06 pm", "document_number": 91357, "document_number_id": "91357", "employee_first_name": null, "employee_last_name": null, "entity_name": null, "internal_id": 12327043, "number": "61250", "posting_period": "Dec 2024", "reversal_date": null, "transaction_accounting_line_amount": -25000, "transaction_amount": null, "transaction_line_department": "116000 - Technical Support", "transaction_line_id": 1, "transaction_line_memo": "Reversal of acquisition-related holdback bonus amounts paid through 01/05 payroll in January 2025 from GL 24050 account", "transaction_line_product": "CallPotential - Uncategorized", "transaction_line_subsidiary": "SpareFoot, Inc", "transaction_memo": "Reversal of acquisition-related holdback bonus amounts paid through 01/05 payroll in January 2025 from GL 24050 account", "type": "Journal", "vendor": null } - schema_attributes:
{ "account_full_name": "string", "account_name": "string", "account_type": "string", "created_by": "string", "currency": "string", "date": "string", "date_created": "string", "date_last_modified": "string", "document_number": "string", "document_number_id": "string", "employee_first_name": "string", "employee_last_name": "string", "entity_name": "string", "internal_id": "string", "number": "string", "posting_period": "string", "reversal_date": "string", "transaction_accounting_line_amount": "string", "transaction_amount": "string", "transaction_line_department": "string", "transaction_line_id": "string", "transaction_line_memo": "string", "transaction_line_product": "string", "transaction_line_subsidiary": "string", "transaction_memo": "string", "type": "string", "vendor": "string" } - schema_name_id: 1990
- schema_scan_id: 135420250
- updated: 2025-01-15 19:04:36
-
Version 1120151
- created: 2024-12-11 13:27:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\n(\n`transaction_memo`STRING,`date_last_modified`STRING,`reversal_date`STRING,`posting_period`STRING,`vendor`STRING,`type`STRING,`employee_first_name`STRING,`currency`STRING,`account_type`STRING,`document_number`STRING,`transaction_line_product`STRING,`employee_last_name`STRING,`number`STRING,`transaction_line_department`STRING,`transaction_line_memo`STRING,`account_full_name`STRING,`transaction_line_id`STRING,`transaction_amount`STRING,`account_name`STRING,`entity_name`STRING,`transaction_accounting_line_amount`STRING,`created_by`STRING,`date`STRING,`transaction_line_subsidiary`STRING,`internal_id`STRING,`date_created`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions'\n", "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_expense_transactions" ] - hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions
- id: 1120151
- processed: 1
- raw_data:
{ "account_full_name": "Employee Expenses : Deferred Commission Contra Expense", "account_name": "Deferred Commission Contra Expense", "account_type": "Expense", "created_by": "Deborah Sparks", "currency": "USD", "date": "11/30/2024", "date_created": "11/14/2024 10:03:17 am", "date_last_modified": "12/10/2024 9:32:27 am", "document_number": 88292, "employee_first_name": null, "employee_last_name": null, "entity_name": null, "internal_id": 11650690, "number": "62300", "posting_period": "Nov 2024", "reversal_date": null, "transaction_accounting_line_amount": -153735.83, "transaction_amount": null, "transaction_line_department": "250000 - Sales", "transaction_line_id": 3, "transaction_line_memo": "October Deferred Commission Actuals", "transaction_line_product": "Product Allocation", "transaction_line_subsidiary": "SpareFoot, Inc", "transaction_memo": "October Deferred Commission Actuals", "type": "Journal", "vendor": null } - schema_attributes:
{ "account_full_name": "string", "account_name": "string", "account_type": "string", "created_by": "string", "currency": "string", "date": "string", "date_created": "string", "date_last_modified": "string", "document_number": "string", "employee_first_name": "string", "employee_last_name": "string", "entity_name": "string", "internal_id": "string", "number": "string", "posting_period": "string", "reversal_date": "string", "transaction_accounting_line_amount": "string", "transaction_amount": "string", "transaction_line_department": "string", "transaction_line_id": "string", "transaction_line_memo": "string", "transaction_line_product": "string", "transaction_line_subsidiary": "string", "transaction_memo": "string", "type": "string", "vendor": "string" } - schema_name_id: 1990
- schema_scan_id: 133438501
- updated: 2024-12-11 13:27:28
-
Version 1068653
- created: 2024-10-30 11:45:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\n(\n`posting_period`STRING,`account_type`STRING,`type`STRING,`document_number`STRING,`internal_id`STRING,`vendor`STRING,`employee_first_name`STRING,`employee_last_name`STRING,`transaction_memo`STRING,`transaction_line_id`STRING,`transaction_line_memo`STRING,`currency`STRING,`transaction_amount`STRING,`transaction_accounting_line_amount`STRING,`transaction_line_department`STRING,`transaction_line_subsidiary`STRING,`number`STRING,`account_full_name`STRING,`account_name`STRING,`transaction_line_product`STRING,`date`STRING,`reversal_date`STRING,`date_last_modified`STRING,`date_created`STRING,`created_by`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions'\n", "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_expense_transactions" ] - hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions
- id: 1068653
- processed: 1
- raw_data:
{ "account_full_name": "Employee Expenses : Benefits - Insurance", "account_name": "Benefits - Insurance", "account_type": "Expense", "created_by": "Intregration Account", "currency": "USD", "date": "9/1/2024", "date_created": "9/18/2024 3:04:44 am", "date_last_modified": "10/4/2024 2:09:16 am", "document_number": 0, "employee_first_name": null, "employee_last_name": null, "internal_id": 11091281, "number": "61400", "posting_period": "Sep 2024", "reversal_date": null, "transaction_accounting_line_amount": 2653.11, "transaction_amount": -2653.11, "transaction_line_department": "510000 - People Department", "transaction_line_id": 1, "transaction_line_memo": "August", "transaction_line_product": "Product Allocation", "transaction_line_subsidiary": "SpareFoot, Inc", "transaction_memo": "Wex_0002019223-IN", "type": "VendBill", "vendor": "Wex" } - schema_attributes:
{ "account_full_name": "string", "account_name": "string", "account_type": "string", "created_by": "string", "currency": "string", "date": "string", "date_created": "string", "date_last_modified": "string", "document_number": "string", "employee_first_name": "string", "employee_last_name": "string", "internal_id": "string", "number": "string", "posting_period": "string", "reversal_date": "string", "transaction_accounting_line_amount": "string", "transaction_amount": "string", "transaction_line_department": "string", "transaction_line_id": "string", "transaction_line_memo": "string", "transaction_line_product": "string", "transaction_line_subsidiary": "string", "transaction_memo": "string", "type": "string", "vendor": "string" } - schema_name_id: 1990
- schema_scan_id: 130546881
- updated: 2024-10-30 11:46:02
Schema Scans: 5
Last at 2026-04-16 19:04:32
-
Scan 162152235
- duration: 0:00:03.830197
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 162152235
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16", "name": "dt", "type": "string", "value": "2026-04-16" }, "s3": { "bucket": "sfdl-drivethrujson-drivethru-prod", "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions", "key": "raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16/netsuite_expense_transactions_part_1_17-01-55-638.json.gz" }, "schema": { "name": "sfdl_prod_drivethru.netsuite_netsuite_expense_transactions", "type": "drivethrujson" }, "trace_context": { "parent_id": 12005870419844362432, "service_name": "drive-thru", "span_id": 16429044564678639270, "trace_id": 4847637704831132866 } } - running: False
- schema_name_id: 1990
- start_time: 2026-04-16 19:04:32
- success: True
- trace_id: 4847637704831132866
-
Scan 162096236
- duration: 0:00:03.907341
- exit_message:
{ "ddl_changed": false, "partitions_applied": true, "success": true } - id: 162096236
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15", "name": "dt", "type": "string", "value": "2026-04-15" }, "s3": { "bucket": "sfdl-drivethrujson-drivethru-prod", "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions", "key": "raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15/netsuite_expense_transactions_part_1_17-01-44-969.json.gz" }, "schema": { "name": "sfdl_prod_drivethru.netsuite_netsuite_expense_transactions", "type": "drivethrujson" }, "trace_context": { "parent_id": 500632043635531606, "service_name": "drive-thru", "span_id": 13931142714549919690, "trace_id": 7955067175606645895 } } - running: False
- schema_name_id: 1990
- start_time: 2026-04-15 19:03:32
- success: True
- trace_id: 7955067175606645895
-
Scan 135420250
- duration: 0:00:18.322719
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 41, "partitions_applied": false, "success": true } - id: 135420250
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-01-15", "name": "dt", "type": "string", "value": "2025-01-15" }, "s3": { "bucket": "sfdl-drivethrujson-drivethru-prod", "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions", "key": "raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-01-15/netsuite_expense_transactions_part_1.json.gz" }, "schema": { "name": "sfdl_prod_drivethru.netsuite_netsuite_expense_transactions", "type": "drivethrujson" }, "trace_context": { "parent_id": 10004376535233728370, "service_name": "drive-thru", "span_id": 116565524838160228, "trace_id": 4173118327832861998 } } - running: False
- schema_name_id: 1990
- start_time: 2025-01-15 19:04:21
- success: True
- trace_id: 4173118327832861998
-
Scan 133438501
- duration: 0:00:15.525694
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 23, "partitions_applied": false, "success": true } - id: 133438501
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2024-12-11", "name": "dt", "type": "string", "value": "2024-12-11" }, "s3": { "bucket": "sfdl-drivethrujson-drivethru-prod", "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions", "key": "raw_incremental/netsuite_netsuite_expense_transactions/dt=2024-12-11/netsuite_expense_transactions_part_1.json.gz" }, "schema": { "name": "sfdl_prod_drivethru.netsuite_netsuite_expense_transactions", "type": "drivethrujson" }, "trace_context": { "parent_id": 3747353903685645928, "service_name": "drive-thru", "span_id": 8446793436931395758, "trace_id": 1209603933705157500 } } - running: False
- schema_name_id: 1990
- start_time: 2024-12-11 13:27:16
- success: True
- trace_id: 1209603933705157500
-
Scan 130546881
- duration: 0:00:22.039716
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1, "partitions_applied": false, "success": true } - id: 130546881
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2024-10-30", "name": "dt", "type": "string", "value": "2024-10-30" }, "s3": { "bucket": "sfdl-drivethrujson-drivethru-prod", "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions", "key": "raw_incremental/netsuite_netsuite_expense_transactions/dt=2024-10-30/netsuite_expense_transactions_part_1.json.gz" }, "schema": { "name": "sfdl_prod_drivethru.netsuite_netsuite_expense_transactions", "type": "drivethrujson" }, "trace_context": { "parent_id": 14389182850198668246, "service_name": "drive-thru", "span_id": 13455130357795987417, "trace_id": 12223626959542670198 } } - running: False
- schema_name_id: 1990
- start_time: 2024-10-30 11:45:43
- success: True
- trace_id: 12223626959542670198
- count: 106
- ddl:
[ "ALTER TABLE\n `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-22/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-25/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-31/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-22/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-28/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-13/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-20/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-17/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-30/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-04/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-11/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566180, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 19:02:23", "last_data": "2025-10-15 19:02:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1568507, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 19:01:58", "last_data": "2025-10-16 19:01:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1595806, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 19:02:38", "last_data": "2025-10-17 19:02:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596069, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 19:02:11", "last_data": "2025-10-18 19:02:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596859, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 19:10:28", "last_data": "2025-10-20 19:10:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597112, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 19:13:34", "last_data": "2025-10-21 19:13:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597347, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 19:29:54", "last_data": "2025-10-22 19:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597835, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 19:12:14", "last_data": "2025-10-24 19:12:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598078, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 19:28:50", "last_data": "2025-10-25 19:28:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598531, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 19:11:07", "last_data": "2025-10-27 19:11:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598774, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 19:17:18", "last_data": "2025-10-28 19:17:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599012, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 19:54:44", "last_data": "2025-10-29 19:54:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599237, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 19:22:40", "last_data": "2025-10-30 19:22:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599481, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 19:33:58", "last_data": "2025-10-31 19:33:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600452, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 19:28:26", "last_data": "2025-11-03 19:28:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600695, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 19:16:27", "last_data": "2025-11-04 19:16:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600919, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 19:21:13", "last_data": "2025-11-05 19:21:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601168, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 19:24:19", "last_data": "2025-11-06 19:24:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601425, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 19:20:43", "last_data": "2025-11-07 19:20:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601658, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 19:13:04", "last_data": "2025-11-08 19:13:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601894, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 19:19:43", "last_data": "2025-11-09 19:19:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602138, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 19:17:46", "last_data": "2025-11-10 19:17:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602376, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 19:16:10", "last_data": "2025-11-11 19:16:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602606, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 19:20:51", "last_data": "2025-11-12 19:20:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602855, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 19:15:47", "last_data": "2025-11-13 19:15:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1603088, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 19:19:54", "last_data": "2025-11-14 19:19:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1603338, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 19:14:18", "last_data": "2025-11-15 19:14:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1605973, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 19:10:51", "last_data": "2025-11-17 19:10:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606242, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 19:12:00", "last_data": "2025-11-18 19:12:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606475, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 19:17:53", "last_data": "2025-11-19 19:17:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606715, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 19:17:08", "last_data": "2025-11-20 19:17:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606980, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 19:23:39", "last_data": "2025-11-21 19:23:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1607744, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 19:16:39", "last_data": "2025-11-22 19:16:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608208, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 19:15:36", "last_data": "2025-11-24 19:15:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608437, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 19:10:52", "last_data": "2025-11-25 19:10:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608674, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-26/", "name": "dt", "value": "2025-11-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 19:13:13", "last_data": "2025-11-26 19:13:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608900, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 19:14:57", "last_data": "2025-11-27 19:14:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609140, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 19:23:11", "last_data": "2025-11-28 19:23:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609590, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 19:23:26", "last_data": "2025-11-30 19:23:26" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609843, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 19:15:00", "last_data": "2025-12-01 19:15:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610087, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 19:17:55", "last_data": "2025-12-02 19:17:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610315, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 19:15:41", "last_data": "2025-12-03 19:15:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610551, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 19:13:08", "last_data": "2025-12-04 19:13:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611065, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 19:13:06", "last_data": "2025-12-05 19:13:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611776, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 19:21:37", "last_data": "2025-12-08 19:21:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612237, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-09/", "name": "dt", "value": "2025-12-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 19:12:20", "last_data": "2025-12-09 19:12:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612477, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-10/", "name": "dt", "value": "2025-12-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 19:09:38", "last_data": "2025-12-10 19:09:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1612733, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 19:09:44", "last_data": "2025-12-11 19:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613012, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-12 19:17:37", "last_data": "2025-12-12 19:17:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613286, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-13/", "name": "dt", "value": "2025-12-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 19:14:19", "last_data": "2025-12-13 19:14:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1613789, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-15/", "name": "dt", "value": "2025-12-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-15 19:17:58", "last_data": "2025-12-15 19:17:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616531, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-16/", "name": "dt", "value": "2025-12-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-16 19:13:49", "last_data": "2025-12-16 19:13:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616753, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-17/", "name": "dt", "value": "2025-12-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-17 19:13:30", "last_data": "2025-12-17 19:13:30" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1616977, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-18/", "name": "dt", "value": "2025-12-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-18 19:16:47", "last_data": "2025-12-18 19:16:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617196, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-19/", "name": "dt", "value": "2025-12-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-19 19:15:20", "last_data": "2025-12-19 19:15:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617402, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 19:11:45", "last_data": "2025-12-20 19:11:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1617868, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-22/", "name": "dt", "value": "2025-12-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-22 19:05:07", "last_data": "2025-12-22 19:05:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618080, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-23/", "name": "dt", "value": "2025-12-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-23 19:04:01", "last_data": "2025-12-23 19:04:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618292, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-24/", "name": "dt", "value": "2025-12-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-24 19:02:40", "last_data": "2025-12-24 19:02:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618505, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-25/", "name": "dt", "value": "2025-12-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-25 19:01:51", "last_data": "2025-12-25 19:01:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618728, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-26/", "name": "dt", "value": "2025-12-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-26 19:03:14", "last_data": "2025-12-26 19:03:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1618940, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-27/", "name": "dt", "value": "2025-12-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-27 19:04:25", "last_data": "2025-12-27 19:04:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619183, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-28/", "name": "dt", "value": "2025-12-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-28 19:04:27", "last_data": "2025-12-28 19:04:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619410, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 19:05:04", "last_data": "2025-12-29 19:05:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619624, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-30/", "name": "dt", "value": "2025-12-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-30 19:04:07", "last_data": "2025-12-30 19:04:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1619835, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-31/", "name": "dt", "value": "2025-12-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-31 19:04:49", "last_data": "2025-12-31 19:04:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620074, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-01/", "name": "dt", "value": "2026-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-01 19:03:50", "last_data": "2026-01-01 19:03:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620289, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-02/", "name": "dt", "value": "2026-01-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-02 19:03:29", "last_data": "2026-01-02 19:03:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620509, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-03/", "name": "dt", "value": "2026-01-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-03 19:07:05", "last_data": "2026-01-03 19:07:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620718, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 19:04:05", "last_data": "2026-01-04 19:04:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1620947, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-05/", "name": "dt", "value": "2026-01-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-05 19:04:43", "last_data": "2026-01-05 19:04:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621166, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-06/", "name": "dt", "value": "2026-01-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 19:12:10", "last_data": "2026-01-06 19:12:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621391, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-07 19:06:43", "last_data": "2026-01-07 19:06:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621617, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-08/", "name": "dt", "value": "2026-01-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-08 19:05:08", "last_data": "2026-01-08 19:05:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1621822, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-09/", "name": "dt", "value": "2026-01-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-09 19:05:11", "last_data": "2026-01-09 19:05:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622050, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-10/", "name": "dt", "value": "2026-01-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-10 19:02:52", "last_data": "2026-01-10 19:02:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622286, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-11/", "name": "dt", "value": "2026-01-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-11 19:05:15", "last_data": "2026-01-11 19:05:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622624, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-12/", "name": "dt", "value": "2026-01-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-12 19:04:45", "last_data": "2026-01-12 19:04:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1622838, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-13/", "name": "dt", "value": "2026-01-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-13 19:04:20", "last_data": "2026-01-13 19:04:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1623060, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 19:04:38", "last_data": "2026-01-14 19:04:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1623328, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-15/", "name": "dt", "value": "2026-01-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-15 19:03:23", "last_data": "2026-01-15 19:03:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1625657, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 19:04:20", "last_data": "2026-01-16 19:04:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626080, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-17/", "name": "dt", "value": "2026-01-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-17 19:05:46", "last_data": "2026-01-17 19:05:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626507, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-19 19:02:58", "last_data": "2026-01-19 19:02:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626754, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-20/", "name": "dt", "value": "2026-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-20 19:03:17", "last_data": "2026-01-20 19:03:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1626974, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-21/", "name": "dt", "value": "2026-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-21 19:03:25", "last_data": "2026-01-21 19:03:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627196, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-22/", "name": "dt", "value": "2026-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-22 19:05:45", "last_data": "2026-01-22 19:05:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627402, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-23/", "name": "dt", "value": "2026-01-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-23 19:03:36", "last_data": "2026-01-23 19:03:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627608, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-24/", "name": "dt", "value": "2026-01-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-24 19:02:37", "last_data": "2026-01-24 19:02:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1627826, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-25/", "name": "dt", "value": "2026-01-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-25 19:02:48", "last_data": "2026-01-25 19:02:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628050, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-26/", "name": "dt", "value": "2026-01-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-26 19:04:46", "last_data": "2026-01-26 19:04:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628265, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-27/", "name": "dt", "value": "2026-01-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-27 19:04:21", "last_data": "2026-01-27 19:04:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628483, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-28/", "name": "dt", "value": "2026-01-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-28 19:05:22", "last_data": "2026-01-28 19:05:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628715, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-29/", "name": "dt", "value": "2026-01-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-29 19:04:52", "last_data": "2026-01-29 19:04:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1628936, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-30/", "name": "dt", "value": "2026-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-30 19:04:14", "last_data": "2026-01-30 19:04:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629593, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-02/", "name": "dt", "value": "2026-02-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-02 19:03:59", "last_data": "2026-02-02 19:03:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1629882, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 19:05:58", "last_data": "2026-02-03 19:05:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1630098, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-04/", "name": "dt", "value": "2026-02-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-04 19:04:34", "last_data": "2026-02-04 19:04:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657314, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-08/", "name": "dt", "value": "2026-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-08 19:04:12", "last_data": "2026-04-08 19:04:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657531, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-09/", "name": "dt", "value": "2026-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-09 19:02:50", "last_data": "2026-04-09 19:02:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657750, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-10/", "name": "dt", "value": "2026-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-10 19:02:05", "last_data": "2026-04-10 19:02:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1657970, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-11/", "name": "dt", "value": "2026-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-11 19:04:49", "last_data": "2026-04-11 19:04:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658387, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-13/", "name": "dt", "value": "2026-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-13 19:02:39", "last_data": "2026-04-13 19:02:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1658577, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-14/", "name": "dt", "value": "2026-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-14 19:03:54", "last_data": "2026-04-14 19:03:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1659055, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15/", "name": "dt", "value": "2026-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-15 19:03:33", "last_data": "2026-04-15 19:03:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1661232, "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16/", "name": "dt", "value": "2026-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-16 19:04:33", "last_data": "2026-04-16 19:04:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "account_full_name": "string", "account_name": "string", "account_type": "string", "created_by": "string", "currency": "string", "date": "string", "date_created": "string", "date_last_modified": "string", "document_number": "string", "document_number_id": "string", "employee_first_name": "string", "employee_last_name": "string", "entity_name": "string", "internal_id": "string", "number": "string", "posting_period": "string", "reversal_date": "string", "transaction_accounting_line_amount": "string", "transaction_amount": "string", "transaction_line_department": "string", "transaction_line_id": "string", "transaction_line_memo": "string", "transaction_line_product": "string", "transaction_line_subsidiary": "string", "transaction_memo": "string", "type": "string", "vendor": "string" } - created: 2025-01-15 19:04:22
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\n(\n`employee_last_name`STRING,`date_last_modified`STRING,`transaction_line_memo`STRING,`transaction_line_subsidiary`STRING,`transaction_accounting_line_amount`STRING,`type`STRING,`transaction_amount`STRING,`employee_first_name`STRING,`account_name`STRING,`created_by`STRING,`internal_id`STRING,`currency`STRING,`date_created`STRING,`reversal_date`STRING,`account_type`STRING,`document_number_id`STRING,`number`STRING,`posting_period`STRING,`document_number`STRING,`transaction_line_department`STRING,`vendor`STRING,`transaction_line_id`STRING,`transaction_line_product`STRING,`transaction_memo`STRING,`account_full_name`STRING,`date`STRING,`entity_name`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_expense_transactions" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-10-30 11:45:43",
"disabled": false,
"format": "raw",
"id": 1990,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "netsuite_netsuite_expense_transactions"
},
"type": "drivethrujson"
},
"partition": {
"count": 106,
"ddl": [
"ALTER TABLE\n `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\nADD\n\n\n PARTITION (dt='2025-10-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-18/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-22/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-25/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-31/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-15/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-22/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-28/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-12/'\n PARTITION (dt='2025-12-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-13/'\n PARTITION (dt='2025-12-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-15/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-16/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-17/'\n PARTITION (dt='2025-12-18') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-18/'\n PARTITION (dt='2025-12-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-19/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-20/'\n PARTITION (dt='2025-12-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-22/'\n PARTITION (dt='2025-12-23') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-23/'\n PARTITION (dt='2025-12-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-24/'\n PARTITION (dt='2025-12-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-25/'\n PARTITION (dt='2025-12-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-26/'\n PARTITION (dt='2025-12-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-27/'\n PARTITION (dt='2025-12-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-28/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-29/'\n PARTITION (dt='2025-12-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-30/'\n PARTITION (dt='2025-12-31') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-31/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-11/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-14/'\n PARTITION (dt='2026-01-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-15/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-16/'\n PARTITION (dt='2026-01-17') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-17/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-19/'\n PARTITION (dt='2026-01-20') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-20/'\n PARTITION (dt='2026-01-21') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-21/'\n PARTITION (dt='2026-01-22') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-22/'\n PARTITION (dt='2026-01-23') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-23/'\n PARTITION (dt='2026-01-24') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-24/'\n PARTITION (dt='2026-01-25') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-25/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-27/'\n PARTITION (dt='2026-01-28') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-28/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-29/'\n PARTITION (dt='2026-01-30') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-30/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-04/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-11/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-13/'\n PARTITION (dt='2026-04-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-14/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566180,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 19:02:23",
"last_data": "2025-10-15 19:02:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1568507,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 19:01:58",
"last_data": "2025-10-16 19:01:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1595806,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 19:02:38",
"last_data": "2025-10-17 19:02:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596069,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 19:02:11",
"last_data": "2025-10-18 19:02:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596859,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 19:10:28",
"last_data": "2025-10-20 19:10:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597112,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 19:13:34",
"last_data": "2025-10-21 19:13:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597347,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 19:29:54",
"last_data": "2025-10-22 19:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597835,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 19:12:14",
"last_data": "2025-10-24 19:12:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598078,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 19:28:50",
"last_data": "2025-10-25 19:28:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598531,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 19:11:07",
"last_data": "2025-10-27 19:11:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598774,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 19:17:18",
"last_data": "2025-10-28 19:17:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599012,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 19:54:44",
"last_data": "2025-10-29 19:54:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599237,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 19:22:40",
"last_data": "2025-10-30 19:22:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599481,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 19:33:58",
"last_data": "2025-10-31 19:33:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600452,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 19:28:26",
"last_data": "2025-11-03 19:28:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600695,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 19:16:27",
"last_data": "2025-11-04 19:16:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600919,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 19:21:13",
"last_data": "2025-11-05 19:21:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601168,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 19:24:19",
"last_data": "2025-11-06 19:24:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601425,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 19:20:43",
"last_data": "2025-11-07 19:20:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601658,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 19:13:04",
"last_data": "2025-11-08 19:13:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601894,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 19:19:43",
"last_data": "2025-11-09 19:19:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602138,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 19:17:46",
"last_data": "2025-11-10 19:17:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602376,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 19:16:10",
"last_data": "2025-11-11 19:16:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602606,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 19:20:51",
"last_data": "2025-11-12 19:20:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602855,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 19:15:47",
"last_data": "2025-11-13 19:15:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1603088,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 19:19:54",
"last_data": "2025-11-14 19:19:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1603338,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 19:14:18",
"last_data": "2025-11-15 19:14:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1605973,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 19:10:51",
"last_data": "2025-11-17 19:10:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606242,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 19:12:00",
"last_data": "2025-11-18 19:12:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606475,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 19:17:53",
"last_data": "2025-11-19 19:17:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606715,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 19:17:08",
"last_data": "2025-11-20 19:17:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606980,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 19:23:39",
"last_data": "2025-11-21 19:23:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1607744,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 19:16:39",
"last_data": "2025-11-22 19:16:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608208,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 19:15:36",
"last_data": "2025-11-24 19:15:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608437,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 19:10:52",
"last_data": "2025-11-25 19:10:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608674,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-26/",
"name": "dt",
"value": "2025-11-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 19:13:13",
"last_data": "2025-11-26 19:13:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608900,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 19:14:57",
"last_data": "2025-11-27 19:14:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609140,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 19:23:11",
"last_data": "2025-11-28 19:23:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609590,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 19:23:26",
"last_data": "2025-11-30 19:23:26"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609843,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 19:15:00",
"last_data": "2025-12-01 19:15:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610087,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 19:17:55",
"last_data": "2025-12-02 19:17:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610315,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 19:15:41",
"last_data": "2025-12-03 19:15:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610551,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 19:13:08",
"last_data": "2025-12-04 19:13:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611065,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 19:13:06",
"last_data": "2025-12-05 19:13:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611776,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 19:21:37",
"last_data": "2025-12-08 19:21:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612237,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-09/",
"name": "dt",
"value": "2025-12-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 19:12:20",
"last_data": "2025-12-09 19:12:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612477,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-10/",
"name": "dt",
"value": "2025-12-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 19:09:38",
"last_data": "2025-12-10 19:09:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1612733,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 19:09:44",
"last_data": "2025-12-11 19:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613012,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-12 19:17:37",
"last_data": "2025-12-12 19:17:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613286,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-13/",
"name": "dt",
"value": "2025-12-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 19:14:19",
"last_data": "2025-12-13 19:14:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1613789,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-15/",
"name": "dt",
"value": "2025-12-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-15 19:17:58",
"last_data": "2025-12-15 19:17:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616531,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-16/",
"name": "dt",
"value": "2025-12-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-16 19:13:49",
"last_data": "2025-12-16 19:13:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616753,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-17/",
"name": "dt",
"value": "2025-12-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-17 19:13:30",
"last_data": "2025-12-17 19:13:30"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1616977,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-18/",
"name": "dt",
"value": "2025-12-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-18 19:16:47",
"last_data": "2025-12-18 19:16:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617196,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-19/",
"name": "dt",
"value": "2025-12-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-19 19:15:20",
"last_data": "2025-12-19 19:15:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617402,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 19:11:45",
"last_data": "2025-12-20 19:11:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1617868,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-22/",
"name": "dt",
"value": "2025-12-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-22 19:05:07",
"last_data": "2025-12-22 19:05:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618080,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-23/",
"name": "dt",
"value": "2025-12-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-23 19:04:01",
"last_data": "2025-12-23 19:04:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618292,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-24/",
"name": "dt",
"value": "2025-12-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-24 19:02:40",
"last_data": "2025-12-24 19:02:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618505,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-25/",
"name": "dt",
"value": "2025-12-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-25 19:01:51",
"last_data": "2025-12-25 19:01:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618728,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-26/",
"name": "dt",
"value": "2025-12-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-26 19:03:14",
"last_data": "2025-12-26 19:03:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1618940,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-27/",
"name": "dt",
"value": "2025-12-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-27 19:04:25",
"last_data": "2025-12-27 19:04:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619183,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-28/",
"name": "dt",
"value": "2025-12-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-28 19:04:27",
"last_data": "2025-12-28 19:04:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619410,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 19:05:04",
"last_data": "2025-12-29 19:05:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619624,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-30/",
"name": "dt",
"value": "2025-12-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-30 19:04:07",
"last_data": "2025-12-30 19:04:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1619835,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2025-12-31/",
"name": "dt",
"value": "2025-12-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-31 19:04:49",
"last_data": "2025-12-31 19:04:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620074,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-01/",
"name": "dt",
"value": "2026-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-01 19:03:50",
"last_data": "2026-01-01 19:03:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620289,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-02/",
"name": "dt",
"value": "2026-01-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-02 19:03:29",
"last_data": "2026-01-02 19:03:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620509,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-03/",
"name": "dt",
"value": "2026-01-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-03 19:07:05",
"last_data": "2026-01-03 19:07:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620718,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 19:04:05",
"last_data": "2026-01-04 19:04:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1620947,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-05/",
"name": "dt",
"value": "2026-01-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-05 19:04:43",
"last_data": "2026-01-05 19:04:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621166,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-06/",
"name": "dt",
"value": "2026-01-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 19:12:10",
"last_data": "2026-01-06 19:12:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621391,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-07 19:06:43",
"last_data": "2026-01-07 19:06:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621617,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-08/",
"name": "dt",
"value": "2026-01-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-08 19:05:08",
"last_data": "2026-01-08 19:05:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1621822,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-09/",
"name": "dt",
"value": "2026-01-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-09 19:05:11",
"last_data": "2026-01-09 19:05:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622050,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-10/",
"name": "dt",
"value": "2026-01-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-10 19:02:52",
"last_data": "2026-01-10 19:02:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622286,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-11/",
"name": "dt",
"value": "2026-01-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-11 19:05:15",
"last_data": "2026-01-11 19:05:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622624,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-12/",
"name": "dt",
"value": "2026-01-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-12 19:04:45",
"last_data": "2026-01-12 19:04:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1622838,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-13/",
"name": "dt",
"value": "2026-01-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-13 19:04:20",
"last_data": "2026-01-13 19:04:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1623060,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 19:04:38",
"last_data": "2026-01-14 19:04:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1623328,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-15/",
"name": "dt",
"value": "2026-01-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-15 19:03:23",
"last_data": "2026-01-15 19:03:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1625657,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 19:04:20",
"last_data": "2026-01-16 19:04:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626080,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-17/",
"name": "dt",
"value": "2026-01-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-17 19:05:46",
"last_data": "2026-01-17 19:05:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626507,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-19 19:02:58",
"last_data": "2026-01-19 19:02:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626754,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-20/",
"name": "dt",
"value": "2026-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-20 19:03:17",
"last_data": "2026-01-20 19:03:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1626974,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-21/",
"name": "dt",
"value": "2026-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-21 19:03:25",
"last_data": "2026-01-21 19:03:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627196,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-22/",
"name": "dt",
"value": "2026-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-22 19:05:45",
"last_data": "2026-01-22 19:05:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627402,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-23/",
"name": "dt",
"value": "2026-01-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-23 19:03:36",
"last_data": "2026-01-23 19:03:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627608,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-24/",
"name": "dt",
"value": "2026-01-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-24 19:02:37",
"last_data": "2026-01-24 19:02:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1627826,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-25/",
"name": "dt",
"value": "2026-01-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-25 19:02:48",
"last_data": "2026-01-25 19:02:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628050,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-26/",
"name": "dt",
"value": "2026-01-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-26 19:04:46",
"last_data": "2026-01-26 19:04:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628265,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-27/",
"name": "dt",
"value": "2026-01-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-27 19:04:21",
"last_data": "2026-01-27 19:04:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628483,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-28/",
"name": "dt",
"value": "2026-01-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-28 19:05:22",
"last_data": "2026-01-28 19:05:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628715,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-29/",
"name": "dt",
"value": "2026-01-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-29 19:04:52",
"last_data": "2026-01-29 19:04:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1628936,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-01-30/",
"name": "dt",
"value": "2026-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-30 19:04:14",
"last_data": "2026-01-30 19:04:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629593,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-02/",
"name": "dt",
"value": "2026-02-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-02 19:03:59",
"last_data": "2026-02-02 19:03:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1629882,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 19:05:58",
"last_data": "2026-02-03 19:05:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1630098,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-02-04/",
"name": "dt",
"value": "2026-02-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-04 19:04:34",
"last_data": "2026-02-04 19:04:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657314,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-08/",
"name": "dt",
"value": "2026-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-08 19:04:12",
"last_data": "2026-04-08 19:04:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657531,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-09/",
"name": "dt",
"value": "2026-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-09 19:02:50",
"last_data": "2026-04-09 19:02:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657750,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-10/",
"name": "dt",
"value": "2026-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-10 19:02:05",
"last_data": "2026-04-10 19:02:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1657970,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-11/",
"name": "dt",
"value": "2026-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-11 19:04:49",
"last_data": "2026-04-11 19:04:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658387,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-13/",
"name": "dt",
"value": "2026-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-13 19:02:39",
"last_data": "2026-04-13 19:02:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1658577,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-14/",
"name": "dt",
"value": "2026-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-14 19:03:54",
"last_data": "2026-04-14 19:03:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1659055,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-15/",
"name": "dt",
"value": "2026-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-15 19:03:33",
"last_data": "2026-04-15 19:03:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1661232,
"location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions/dt=2026-04-16/",
"name": "dt",
"value": "2026-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-16 19:04:33",
"last_data": "2026-04-16 19:04:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"account_full_name": "string",
"account_name": "string",
"account_type": "string",
"created_by": "string",
"currency": "string",
"date": "string",
"date_created": "string",
"date_last_modified": "string",
"document_number": "string",
"document_number_id": "string",
"employee_first_name": "string",
"employee_last_name": "string",
"entity_name": "string",
"internal_id": "string",
"number": "string",
"posting_period": "string",
"reversal_date": "string",
"transaction_accounting_line_amount": "string",
"transaction_amount": "string",
"transaction_line_department": "string",
"transaction_line_id": "string",
"transaction_line_memo": "string",
"transaction_line_product": "string",
"transaction_line_subsidiary": "string",
"transaction_memo": "string",
"type": "string",
"vendor": "string"
},
"created": "2025-01-15 19:04:22",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`\n(\n`employee_last_name`STRING,`date_last_modified`STRING,`transaction_line_memo`STRING,`transaction_line_subsidiary`STRING,`transaction_accounting_line_amount`STRING,`type`STRING,`transaction_amount`STRING,`employee_first_name`STRING,`account_name`STRING,`created_by`STRING,`internal_id`STRING,`currency`STRING,`date_created`STRING,`reversal_date`STRING,`account_type`STRING,`document_number_id`STRING,`number`STRING,`posting_period`STRING,`document_number`STRING,`transaction_line_department`STRING,`vendor`STRING,`transaction_line_id`STRING,`transaction_line_product`STRING,`transaction_memo`STRING,`account_full_name`STRING,`date`STRING,`entity_name`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_expense_transactions'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_expense_transactions`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_expense_transactions"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}