Schema Info

Schema Name: sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions
  • created: 2024-10-30 11:58:38
  • disabled: False
  • format: raw
  • id: 2003
  • is_partitioned: True
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "netsuite_netsuite_revenue_transactions"
}
  • type: drivethrujson
Schema Versions: 1
    • created: 2024-10-30 11:58:45
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`\n(\n`posting_period`STRING,`account_type`STRING,`type`STRING,`document_number`STRING,`internal_id`STRING,`customer_internal_id`STRING,`customer_company_name`STRING,`transaction_memo`STRING,`id`STRING,`transaction_line_memo`STRING,`currency`STRING,`total_amount_transaction_currency`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_revenue_transactions'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions
    • id: 1068667
    • processed: 1
    • raw_data: 
      {
    "account_full_name": "Website Services and Support : SEMS Pro Service Fees",
    "account_name": "SEMS Pro Service Fees",
    "account_type": "Income",
    "created_by": "Rukmini  Mahalingappa",
    "currency": "USD",
    "customer_company_name": "101 Storage Center",
    "customer_internal_id": 1736503,
    "date": "9/30/2024",
    "date_created": "10/7/2024 9:51:52 am",
    "date_last_modified": "10/7/2024 9:51:52 am",
    "document_number": 86269,
    "id": 19,
    "internal_id": 11263258,
    "number": "44002",
    "posting_period": "Sep 2024",
    "reversal_date": null,
    "total_amount_transaction_currency": null,
    "transaction_accounting_line_amount": -195.5,
    "transaction_line_department": null,
    "transaction_line_memo": "Rev Rec Destination",
    "transaction_line_product": "Web",
    "transaction_line_subsidiary": "Rednova Labs, Inc.",
    "transaction_memo": null,
    "type": "Journal"
}
    • schema_attributes: 
      {
    "account_full_name": "string",
    "account_name": "string",
    "account_type": "string",
    "created_by": "string",
    "currency": "string",
    "customer_company_name": "string",
    "customer_internal_id": "string",
    "date": "string",
    "date_created": "string",
    "date_last_modified": "string",
    "document_number": "string",
    "id": "string",
    "internal_id": "string",
    "number": "string",
    "posting_period": "string",
    "reversal_date": "string",
    "total_amount_transaction_currency": "string",
    "transaction_accounting_line_amount": "string",
    "transaction_line_department": "string",
    "transaction_line_memo": "string",
    "transaction_line_product": "string",
    "transaction_line_subsidiary": "string",
    "transaction_memo": "string",
    "type": "string"
}
    • schema_name_id: 2003
    • schema_scan_id: 130548334
    • updated: 2024-10-30 11:58:56
Schema Scans: 3
Last at 2026-04-16 19:04:45
    • duration: 0:00:03.789692
    • exit_message: 
      {
    "ddl_changed": false,
    "partitions_applied": true,
    "success": true
}
    • id: 162152265
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "partition": {
        "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_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_revenue_transactions",
        "key": "raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-16/netsuite_revenue_transactions_part_1_17-02-11-537.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5125467146139528058,
        "service_name": "drive-thru",
        "span_id": 12227392596152815953,
        "trace_id": 17580272302830783739
    }
}
    • running: False
    • schema_name_id: 2003
    • start_time: 2026-04-16 19:04:45
    • success: True
    • trace_id: 17580272302830783739
    • duration: 0:00:03.832929
    • exit_message: 
      {
    "ddl_changed": false,
    "partitions_applied": true,
    "success": true
}
    • id: 162096281
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "partition": {
        "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_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_revenue_transactions",
        "key": "raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-15/netsuite_revenue_transactions_part_1_17-01-55-727.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9695217246157419576,
        "service_name": "drive-thru",
        "span_id": 9245428522654408470,
        "trace_id": 13102023215190474368
    }
}
    • running: False
    • schema_name_id: 2003
    • start_time: 2026-04-15 19:03:54
    • success: True
    • trace_id: 13102023215190474368
    • duration: 0:00:20.615873
    • exit_message: 
      {
    "ddl_changed": true,
    "ingested_partitions": 1,
    "partitions_applied": false,
    "success": true
}
    • id: 130548334
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "partition": {
        "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_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_revenue_transactions",
        "key": "raw_incremental/netsuite_netsuite_revenue_transactions/dt=2024-10-30/netsuite_revenue_transactions_part_8.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7545049046033380736,
        "service_name": "drive-thru",
        "span_id": 13250567987120781747,
        "trace_id": 5271175703501146464
    }
}
    • running: False
    • schema_name_id: 2003
    • start_time: 2024-10-30 11:58:38
    • success: True
    • trace_id: 5271175703501146464
Partitions:
  • count: 66
  • ddl: 
    [
    "ALTER TABLE\n    `sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`\nADD\n\n\n PARTITION (dt='2025-11-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-01/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-07/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-12/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-10/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-10/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-14/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-27/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-06/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-13/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-16/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-07/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-11/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-03/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-13/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-16/'\n;"
]
  • name: dt
  • state: 
    [
    {
        "info": {
            "id": 1599914,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-01/",
            "name": "dt",
            "value": "2025-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-01 19:48:26",
                "last_data": "2025-11-01 19:48:26"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1600447,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-03/",
            "name": "dt",
            "value": "2025-11-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-03 19:24:36",
                "last_data": "2025-11-03 19:24:36"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1600686,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-04/",
            "name": "dt",
            "value": "2025-11-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-04 19:13:26",
                "last_data": "2025-11-04 19:13:26"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1600925,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-05/",
            "name": "dt",
            "value": "2025-11-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-05 19:26:32",
                "last_data": "2025-11-05 19:26:32"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1601172,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-06/",
            "name": "dt",
            "value": "2025-11-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-06 19:27:45",
                "last_data": "2025-11-06 19:27:45"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1601437,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-07/",
            "name": "dt",
            "value": "2025-11-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-07 19:25:20",
                "last_data": "2025-11-07 19:25:20"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1602136,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-10/",
            "name": "dt",
            "value": "2025-11-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-10 19:17:03",
                "last_data": "2025-11-10 19:17:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1602377,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-11/",
            "name": "dt",
            "value": "2025-11-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-11 19:16:31",
                "last_data": "2025-11-11 19:16:31"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1602609,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-12/",
            "name": "dt",
            "value": "2025-11-12"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-12 19:24:45",
                "last_data": "2025-11-12 19:24:45"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1609845,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-01/",
            "name": "dt",
            "value": "2025-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-01 19:15:58",
                "last_data": "2025-12-01 19:15:58"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1610081,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-02/",
            "name": "dt",
            "value": "2025-12-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-02 19:14:13",
                "last_data": "2025-12-02 19:14:13"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1610318,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-03/",
            "name": "dt",
            "value": "2025-12-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-03 19:16:34",
                "last_data": "2025-12-03 19:16:34"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1610556,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-04/",
            "name": "dt",
            "value": "2025-12-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-04 19:16:09",
                "last_data": "2025-12-04 19:16:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1611063,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-05/",
            "name": "dt",
            "value": "2025-12-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-05 19:12:07",
                "last_data": "2025-12-05 19:12:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1611764,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-08/",
            "name": "dt",
            "value": "2025-12-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-08 19:12:56",
                "last_data": "2025-12-08 19:12:56"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1612241,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-09/",
            "name": "dt",
            "value": "2025-12-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-09 19:12:54",
                "last_data": "2025-12-09 19:12:54"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1612489,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-10/",
            "name": "dt",
            "value": "2025-12-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-10 19:14:45",
                "last_data": "2025-12-10 19:14:45"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1620081,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-01/",
            "name": "dt",
            "value": "2026-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-01 19:05:19",
                "last_data": "2026-01-01 19:05:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1620293,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-02/",
            "name": "dt",
            "value": "2026-01-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-02 19:04:16",
                "last_data": "2026-01-02 19:04:16"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1620502,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-03/",
            "name": "dt",
            "value": "2026-01-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-03 19:04:35",
                "last_data": "2026-01-03 19:04:35"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1620721,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-04/",
            "name": "dt",
            "value": "2026-01-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-04 19:04:48",
                "last_data": "2026-01-04 19:04:48"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1620948,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-05/",
            "name": "dt",
            "value": "2026-01-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-05 19:04:56",
                "last_data": "2026-01-05 19:04:56"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1621167,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-06/",
            "name": "dt",
            "value": "2026-01-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-06 19:12:26",
                "last_data": "2026-01-06 19:12:26"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1621400,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-07/",
            "name": "dt",
            "value": "2026-01-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-07 19:09:09",
                "last_data": "2026-01-07 19:09:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1621614,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-08/",
            "name": "dt",
            "value": "2026-01-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-08 19:04:35",
                "last_data": "2026-01-08 19:04:35"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1621823,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-09/",
            "name": "dt",
            "value": "2026-01-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-09 19:05:12",
                "last_data": "2026-01-09 19:05:12"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1622058,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-10/",
            "name": "dt",
            "value": "2026-01-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-10 19:03:48",
                "last_data": "2026-01-10 19:03:48"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1622616,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-12/",
            "name": "dt",
            "value": "2026-01-12"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-12 19:02:52",
                "last_data": "2026-01-12 19:02:52"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1622846,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-13/",
            "name": "dt",
            "value": "2026-01-13"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-13 19:05:51",
                "last_data": "2026-01-13 19:05:51"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1623057,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-14/",
            "name": "dt",
            "value": "2026-01-14"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-14 19:04:10",
                "last_data": "2026-01-14 19:04:10"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1628051,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-26/",
            "name": "dt",
            "value": "2026-01-26"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-26 19:04:49",
                "last_data": "2026-01-26 19:04:49"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1628263,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-27/",
            "name": "dt",
            "value": "2026-01-27"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-27 19:04:00",
                "last_data": "2026-01-27 19:04:00"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1629375,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-01/",
            "name": "dt",
            "value": "2026-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-01 19:04:24",
                "last_data": "2026-02-01 19:04:24"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1629594,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-02/",
            "name": "dt",
            "value": "2026-02-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-02 19:04:04",
                "last_data": "2026-02-02 19:04:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1629880,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-03/",
            "name": "dt",
            "value": "2026-02-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-03 19:04:41",
                "last_data": "2026-02-03 19:04:41"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1630094,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-04/",
            "name": "dt",
            "value": "2026-02-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-04 19:04:25",
                "last_data": "2026-02-04 19:04:25"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1630317,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-05/",
            "name": "dt",
            "value": "2026-02-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-05 19:03:53",
                "last_data": "2026-02-05 19:03:53"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1630539,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-06/",
            "name": "dt",
            "value": "2026-02-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-06 20:59:43",
                "last_data": "2026-02-06 20:59:43"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1630970,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-08/",
            "name": "dt",
            "value": "2026-02-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-08 19:07:27",
                "last_data": "2026-02-08 19:07:27"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1631190,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-09/",
            "name": "dt",
            "value": "2026-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-09 19:04:17",
                "last_data": "2026-02-09 19:04:17"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1631420,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-10/",
            "name": "dt",
            "value": "2026-02-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-10 19:22:40",
                "last_data": "2026-02-10 19:22:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1631731,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-11/",
            "name": "dt",
            "value": "2026-02-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-11 19:04:12",
                "last_data": "2026-02-11 19:04:12"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1631949,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-12/",
            "name": "dt",
            "value": "2026-02-12"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-12 19:03:09",
                "last_data": "2026-02-12 19:03:09"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1632256,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-13/",
            "name": "dt",
            "value": "2026-02-13"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-13 19:03:38",
                "last_data": "2026-02-13 19:03:38"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1635034,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-16/",
            "name": "dt",
            "value": "2026-02-16"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-16 19:03:18",
                "last_data": "2026-02-16 19:03:18"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1641561,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-01/",
            "name": "dt",
            "value": "2026-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-01 19:07:03",
                "last_data": "2026-03-01 19:07:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1641749,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-02/",
            "name": "dt",
            "value": "2026-03-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-02 19:04:24",
                "last_data": "2026-03-02 19:04:24"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1641994,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-03/",
            "name": "dt",
            "value": "2026-03-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-03 21:23:40",
                "last_data": "2026-03-03 21:23:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1642208,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-04/",
            "name": "dt",
            "value": "2026-03-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-04 19:04:49",
                "last_data": "2026-03-04 19:04:49"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1642436,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-05/",
            "name": "dt",
            "value": "2026-03-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-05 19:07:07",
                "last_data": "2026-03-05 19:07:07"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1642647,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-06/",
            "name": "dt",
            "value": "2026-03-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-06 19:04:01",
                "last_data": "2026-03-06 19:04:01"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1642862,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-07/",
            "name": "dt",
            "value": "2026-03-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-07 19:03:04",
                "last_data": "2026-03-07 19:03:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1643860,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-09/",
            "name": "dt",
            "value": "2026-03-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-09 19:04:01",
                "last_data": "2026-03-09 19:04:01"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1644932,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-10/",
            "name": "dt",
            "value": "2026-03-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-10 19:02:44",
                "last_data": "2026-03-10 19:02:44"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1645151,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-11/",
            "name": "dt",
            "value": "2026-03-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-11 19:03:28",
                "last_data": "2026-03-11 19:03:28"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1652161,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-01/",
            "name": "dt",
            "value": "2026-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-01 19:05:02",
                "last_data": "2026-04-01 19:05:02"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1652529,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-02/",
            "name": "dt",
            "value": "2026-04-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-02 19:03:04",
                "last_data": "2026-04-02 19:03:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1652742,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-03/",
            "name": "dt",
            "value": "2026-04-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-03 19:02:50",
                "last_data": "2026-04-03 19:02:50"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1656692,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-06/",
            "name": "dt",
            "value": "2026-04-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-06 19:06:04",
                "last_data": "2026-04-06 19:06:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1656918,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-07/",
            "name": "dt",
            "value": "2026-04-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-07 19:08:46",
                "last_data": "2026-04-07 19:08:46"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1657311,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-08/",
            "name": "dt",
            "value": "2026-04-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-08 19:03:05",
                "last_data": "2026-04-08 19:03:05"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1657534,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-09/",
            "name": "dt",
            "value": "2026-04-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-09 19:03:15",
                "last_data": "2026-04-09 19:03:15"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1657753,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-10/",
            "name": "dt",
            "value": "2026-04-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-10 19:02:40",
                "last_data": "2026-04-10 19:02:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1658390,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-13/",
            "name": "dt",
            "value": "2026-04-13"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-13 19:02:49",
                "last_data": "2026-04-13 19:02:49"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1659060,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-15/",
            "name": "dt",
            "value": "2026-04-15"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-15 19:03:55",
                "last_data": "2026-04-15 19:03:55"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": false
            }
        }
    },
    {
        "info": {
            "id": 1661235,
            "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-16/",
            "name": "dt",
            "value": "2026-04-16"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-16 19:04:46",
                "last_data": "2026-04-16 19:04:46"
            },
            "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",
    "customer_company_name": "string",
    "customer_internal_id": "string",
    "date": "string",
    "date_created": "string",
    "date_last_modified": "string",
    "document_number": "string",
    "id": "string",
    "internal_id": "string",
    "number": "string",
    "posting_period": "string",
    "reversal_date": "string",
    "total_amount_transaction_currency": "string",
    "transaction_accounting_line_amount": "string",
    "transaction_line_department": "string",
    "transaction_line_memo": "string",
    "transaction_line_product": "string",
    "transaction_line_subsidiary": "string",
    "transaction_memo": "string",
    "type": "string"
}
  • created: 2024-10-30 11:58:45
  • 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_revenue_transactions`\n(\n`posting_period`STRING,`account_type`STRING,`type`STRING,`document_number`STRING,`internal_id`STRING,`customer_internal_id`STRING,`customer_company_name`STRING,`transaction_memo`STRING,`id`STRING,`transaction_line_memo`STRING,`currency`STRING,`total_amount_transaction_currency`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_revenue_transactions'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2024-10-30 11:58:38",
        "disabled": false,
        "format": "raw",
        "id": 2003,
        "is_partitioned": true,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "netsuite_netsuite_revenue_transactions"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 66,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`\nADD\n\n\n PARTITION (dt='2025-11-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-01/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-07/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-12/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-05/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-10/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-10/'\n PARTITION (dt='2026-01-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-12/'\n PARTITION (dt='2026-01-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-13/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-14/'\n PARTITION (dt='2026-01-26') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-26/'\n PARTITION (dt='2026-01-27') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-27/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-06/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-11/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-13/'\n PARTITION (dt='2026-02-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-16/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-07/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-11/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-03/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-10/'\n PARTITION (dt='2026-04-13') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-13/'\n PARTITION (dt='2026-04-15') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-15/'\n PARTITION (dt='2026-04-16') location 's3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-16/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1599914,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-01/",
                    "name": "dt",
                    "value": "2025-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-01 19:48:26",
                        "last_data": "2025-11-01 19:48:26"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1600447,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-03/",
                    "name": "dt",
                    "value": "2025-11-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-03 19:24:36",
                        "last_data": "2025-11-03 19:24:36"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1600686,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-04/",
                    "name": "dt",
                    "value": "2025-11-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-04 19:13:26",
                        "last_data": "2025-11-04 19:13:26"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1600925,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-05/",
                    "name": "dt",
                    "value": "2025-11-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-05 19:26:32",
                        "last_data": "2025-11-05 19:26:32"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1601172,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-06/",
                    "name": "dt",
                    "value": "2025-11-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-06 19:27:45",
                        "last_data": "2025-11-06 19:27:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1601437,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-07/",
                    "name": "dt",
                    "value": "2025-11-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-07 19:25:20",
                        "last_data": "2025-11-07 19:25:20"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1602136,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-10/",
                    "name": "dt",
                    "value": "2025-11-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-10 19:17:03",
                        "last_data": "2025-11-10 19:17:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1602377,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-11/",
                    "name": "dt",
                    "value": "2025-11-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-11 19:16:31",
                        "last_data": "2025-11-11 19:16:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1602609,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-11-12/",
                    "name": "dt",
                    "value": "2025-11-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-12 19:24:45",
                        "last_data": "2025-11-12 19:24:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1609845,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-01/",
                    "name": "dt",
                    "value": "2025-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-01 19:15:58",
                        "last_data": "2025-12-01 19:15:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1610081,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-02/",
                    "name": "dt",
                    "value": "2025-12-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-02 19:14:13",
                        "last_data": "2025-12-02 19:14:13"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1610318,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-03/",
                    "name": "dt",
                    "value": "2025-12-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-03 19:16:34",
                        "last_data": "2025-12-03 19:16:34"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1610556,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-04/",
                    "name": "dt",
                    "value": "2025-12-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-04 19:16:09",
                        "last_data": "2025-12-04 19:16:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1611063,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-05/",
                    "name": "dt",
                    "value": "2025-12-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-05 19:12:07",
                        "last_data": "2025-12-05 19:12:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1611764,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-08/",
                    "name": "dt",
                    "value": "2025-12-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-08 19:12:56",
                        "last_data": "2025-12-08 19:12:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1612241,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-09/",
                    "name": "dt",
                    "value": "2025-12-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-09 19:12:54",
                        "last_data": "2025-12-09 19:12:54"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1612489,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2025-12-10/",
                    "name": "dt",
                    "value": "2025-12-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-10 19:14:45",
                        "last_data": "2025-12-10 19:14:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1620081,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-01/",
                    "name": "dt",
                    "value": "2026-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-01 19:05:19",
                        "last_data": "2026-01-01 19:05:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1620293,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-02/",
                    "name": "dt",
                    "value": "2026-01-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-02 19:04:16",
                        "last_data": "2026-01-02 19:04:16"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1620502,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-03/",
                    "name": "dt",
                    "value": "2026-01-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-03 19:04:35",
                        "last_data": "2026-01-03 19:04:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1620721,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-04/",
                    "name": "dt",
                    "value": "2026-01-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-04 19:04:48",
                        "last_data": "2026-01-04 19:04:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1620948,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-05/",
                    "name": "dt",
                    "value": "2026-01-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-05 19:04:56",
                        "last_data": "2026-01-05 19:04:56"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1621167,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-06/",
                    "name": "dt",
                    "value": "2026-01-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-06 19:12:26",
                        "last_data": "2026-01-06 19:12:26"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1621400,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-07/",
                    "name": "dt",
                    "value": "2026-01-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-07 19:09:09",
                        "last_data": "2026-01-07 19:09:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1621614,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-08/",
                    "name": "dt",
                    "value": "2026-01-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-08 19:04:35",
                        "last_data": "2026-01-08 19:04:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1621823,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-09/",
                    "name": "dt",
                    "value": "2026-01-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-09 19:05:12",
                        "last_data": "2026-01-09 19:05:12"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1622058,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-10/",
                    "name": "dt",
                    "value": "2026-01-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-10 19:03:48",
                        "last_data": "2026-01-10 19:03:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1622616,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-12/",
                    "name": "dt",
                    "value": "2026-01-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-12 19:02:52",
                        "last_data": "2026-01-12 19:02:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1622846,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-13/",
                    "name": "dt",
                    "value": "2026-01-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-13 19:05:51",
                        "last_data": "2026-01-13 19:05:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1623057,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-14/",
                    "name": "dt",
                    "value": "2026-01-14"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-14 19:04:10",
                        "last_data": "2026-01-14 19:04:10"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1628051,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-26/",
                    "name": "dt",
                    "value": "2026-01-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-26 19:04:49",
                        "last_data": "2026-01-26 19:04:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1628263,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-01-27/",
                    "name": "dt",
                    "value": "2026-01-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-27 19:04:00",
                        "last_data": "2026-01-27 19:04:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1629375,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-01/",
                    "name": "dt",
                    "value": "2026-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-01 19:04:24",
                        "last_data": "2026-02-01 19:04:24"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1629594,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-02/",
                    "name": "dt",
                    "value": "2026-02-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-02 19:04:04",
                        "last_data": "2026-02-02 19:04:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1629880,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-03/",
                    "name": "dt",
                    "value": "2026-02-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-03 19:04:41",
                        "last_data": "2026-02-03 19:04:41"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1630094,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-04/",
                    "name": "dt",
                    "value": "2026-02-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-04 19:04:25",
                        "last_data": "2026-02-04 19:04:25"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1630317,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-05/",
                    "name": "dt",
                    "value": "2026-02-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-05 19:03:53",
                        "last_data": "2026-02-05 19:03:53"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1630539,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-06/",
                    "name": "dt",
                    "value": "2026-02-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-06 20:59:43",
                        "last_data": "2026-02-06 20:59:43"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1630970,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-08/",
                    "name": "dt",
                    "value": "2026-02-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-08 19:07:27",
                        "last_data": "2026-02-08 19:07:27"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1631190,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-09/",
                    "name": "dt",
                    "value": "2026-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-09 19:04:17",
                        "last_data": "2026-02-09 19:04:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1631420,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-10/",
                    "name": "dt",
                    "value": "2026-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-10 19:22:40",
                        "last_data": "2026-02-10 19:22:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1631731,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-11/",
                    "name": "dt",
                    "value": "2026-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-11 19:04:12",
                        "last_data": "2026-02-11 19:04:12"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1631949,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-12/",
                    "name": "dt",
                    "value": "2026-02-12"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-12 19:03:09",
                        "last_data": "2026-02-12 19:03:09"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1632256,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-13/",
                    "name": "dt",
                    "value": "2026-02-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-13 19:03:38",
                        "last_data": "2026-02-13 19:03:38"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1635034,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-02-16/",
                    "name": "dt",
                    "value": "2026-02-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-16 19:03:18",
                        "last_data": "2026-02-16 19:03:18"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1641561,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-01/",
                    "name": "dt",
                    "value": "2026-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-01 19:07:03",
                        "last_data": "2026-03-01 19:07:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1641749,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-02/",
                    "name": "dt",
                    "value": "2026-03-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-02 19:04:24",
                        "last_data": "2026-03-02 19:04:24"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1641994,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-03/",
                    "name": "dt",
                    "value": "2026-03-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-03 21:23:40",
                        "last_data": "2026-03-03 21:23:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1642208,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-04/",
                    "name": "dt",
                    "value": "2026-03-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-04 19:04:49",
                        "last_data": "2026-03-04 19:04:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1642436,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-05/",
                    "name": "dt",
                    "value": "2026-03-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-05 19:07:07",
                        "last_data": "2026-03-05 19:07:07"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1642647,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-06/",
                    "name": "dt",
                    "value": "2026-03-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-06 19:04:01",
                        "last_data": "2026-03-06 19:04:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1642862,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-07/",
                    "name": "dt",
                    "value": "2026-03-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-07 19:03:04",
                        "last_data": "2026-03-07 19:03:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1643860,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-09/",
                    "name": "dt",
                    "value": "2026-03-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-09 19:04:01",
                        "last_data": "2026-03-09 19:04:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1644932,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-10/",
                    "name": "dt",
                    "value": "2026-03-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-10 19:02:44",
                        "last_data": "2026-03-10 19:02:44"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1645151,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-03-11/",
                    "name": "dt",
                    "value": "2026-03-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-11 19:03:28",
                        "last_data": "2026-03-11 19:03:28"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1652161,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-01/",
                    "name": "dt",
                    "value": "2026-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-01 19:05:02",
                        "last_data": "2026-04-01 19:05:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1652529,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-02/",
                    "name": "dt",
                    "value": "2026-04-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-02 19:03:04",
                        "last_data": "2026-04-02 19:03:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1652742,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-03/",
                    "name": "dt",
                    "value": "2026-04-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-03 19:02:50",
                        "last_data": "2026-04-03 19:02:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1656692,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-06/",
                    "name": "dt",
                    "value": "2026-04-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-06 19:06:04",
                        "last_data": "2026-04-06 19:06:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1656918,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-07/",
                    "name": "dt",
                    "value": "2026-04-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-07 19:08:46",
                        "last_data": "2026-04-07 19:08:46"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1657311,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-08/",
                    "name": "dt",
                    "value": "2026-04-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-08 19:03:05",
                        "last_data": "2026-04-08 19:03:05"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1657534,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-09/",
                    "name": "dt",
                    "value": "2026-04-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-09 19:03:15",
                        "last_data": "2026-04-09 19:03:15"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1657753,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-10/",
                    "name": "dt",
                    "value": "2026-04-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-10 19:02:40",
                        "last_data": "2026-04-10 19:02:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1658390,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-13/",
                    "name": "dt",
                    "value": "2026-04-13"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-13 19:02:49",
                        "last_data": "2026-04-13 19:02:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1659060,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-15/",
                    "name": "dt",
                    "value": "2026-04-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-15 19:03:55",
                        "last_data": "2026-04-15 19:03:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": false
                    }
                }
            },
            {
                "info": {
                    "id": 1661235,
                    "location": "s3://sfdl-drivethrujson-drivethru-prod/raw_incremental/netsuite_netsuite_revenue_transactions/dt=2026-04-16/",
                    "name": "dt",
                    "value": "2026-04-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-16 19:04:46",
                        "last_data": "2026-04-16 19:04:46"
                    },
                    "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",
            "customer_company_name": "string",
            "customer_internal_id": "string",
            "date": "string",
            "date_created": "string",
            "date_last_modified": "string",
            "document_number": "string",
            "id": "string",
            "internal_id": "string",
            "number": "string",
            "posting_period": "string",
            "reversal_date": "string",
            "total_amount_transaction_currency": "string",
            "transaction_accounting_line_amount": "string",
            "transaction_line_department": "string",
            "transaction_line_memo": "string",
            "transaction_line_product": "string",
            "transaction_line_subsidiary": "string",
            "transaction_memo": "string",
            "type": "string"
        },
        "created": "2024-10-30 11:58:45",
        "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_revenue_transactions`\n(\n`posting_period`STRING,`account_type`STRING,`type`STRING,`document_number`STRING,`internal_id`STRING,`customer_internal_id`STRING,`customer_company_name`STRING,`transaction_memo`STRING,`id`STRING,`transaction_line_memo`STRING,`currency`STRING,`total_amount_transaction_currency`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_revenue_transactions'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.netsuite_netsuite_revenue_transactions"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform