ACH-debit holds released before scheduled settlementPayments & Transfers

Arguments

title=TP Updated ACH Api Build Plan

Output

success: true
error_message: null
tools_list: null
tool_result:
  results:
    -
      id: 23
      status: current
      title: TP Updated ACH Api Build Plan
      spaceId: 2
      parentId: 22
      parentType: page
      position: 1
      authorId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
      ownerId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
      lastOwnerId: null
      subtype: null
      createdAt: 2025-09-25T09:10:16.493Z
      version:
        createdAt: 2025-09-25T09:10:16.493Z
        message: Imported from PDF export
        number: 1
        minorEdit: false
        authorId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
      body: null
      _links:
        webui: /spaces/2/pages/23
        editui: /spaces/2/pages/23/edit
        tinyui: /x/23
  _links:
    next: null
    base: /wiki/api/v2

Arguments

id=23, body-format=storage

Output

success: true
error_message: null
tools_list: null
tool_result:
  id: 23
  status: current
  title: TP Updated ACH Api Build Plan
  spaceId: 2
  parentId: 22
  parentType: page
  position: 1
  authorId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
  ownerId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
  lastOwnerId: null
  subtype: null
  createdAt: 2025-09-25T09:10:16.493Z
  version:
    createdAt: 2025-09-25T09:10:16.493Z
    message: Imported from PDF export
    number: 1
    minorEdit: false
    authorId: 557058:6d8b9c4e-2f4a-4a8d-9c1d-1b9a3d6e7f12
  body:
    storage:
      representation: storage
      value: <h1>TP Updated ACH Api Build Plan</h1><p>Definitions ach_credit: When sending money from [ORGANIZATION_0001] to a counterparty</p><p>ach_debit: When pulling funds from a counterparty into [ORGANIZATION_0001]</p><p>How the current system works ACH Credit Transfer is created. We process transfers in the sameday or standard batch. At som

… 3,020 more characters of output in the raw trajectory.

Arguments

catalog_name=zeta3, schema_name=rds

Output

tables:
  -
    name: account_applications
    catalog_name: zeta3
    schema_name: rds
    table_type: EXTERNAL
    data_source_format: CSV
    comment: ""
    full_name: zeta3.rds.account_applications
    storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
    properties:
      zeta3.delivery: delivery-2
      zeta3.total_row_count: 37328
      zeta3.sample_row_count: 37328
      zeta3.as_of_enforced: true
    columns:
      -
        name: id
        type_name: INT
        type_text: INT
        position: 0
        nullable: true
        comment: ""
      -
        name: status
        type_name: STRING
        type_text: STRING
        position: 1
        nullable: true
        comment: ""
      -
        name: created_at
        type_name: TIMEST

… 11,022 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT table_name FROM information_schema.tables WHERE table_schema = 'rds' ORDER BY table_name

Output

statement_id: 701e2ec7-0582-498c-8241-7a1b09cb3cfa
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: table_name
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 338
  total_byte_count: 7028
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 338
      byte_count: 7028
result:
  chunk_index: 0
  row_offset: 0
  row_count: 338
  byte_count: 7028
  data_array:
    -
      - accessible_counterparties
    -
      - accessible_counterparties
    -
      - account_applications

… 11,021 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.disbursements

Output

name: disbursements
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: ""
full_name: zeta3.rds.disbursements
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-2
  zeta3.total_row_count: 45003
  zeta3.sample_row_count: 45003
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: INT
    type_text: INT
    position: 0
    nullable: true
    comment: ""
  -
    name: creator_id
    type_name: INT
    type_text: INT
    position: 1
    nullable: true
    comment: ""
  -
    name: effects
    type_name: STRING
    type_text: STRING
    position: 2
    nullable: true
    comment: ""
  -
    name: source_id
    type_name: INT

… 927 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.transfers

Output

name: transfers
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: ""
full_name: zeta3.rds.transfers
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-2
  zeta3.total_row_count: 685906
  zeta3.sample_row_count: 685906
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: INT
    type_text: INT
    position: 0
    nullable: true
    comment: ""
  -
    name: from_id
    type_name: INT
    type_text: INT
    position: 1
    nullable: true
    comment: ""
  -
    name: from_type
    type_name: STRING
    type_text: STRING
    position: 2
    nullable: true
    comment: ""
  -
    name: to_id
    type_name: INT
    type_text: INT

… 8,921 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.accounts

Output

{
  "name": "accounts",
  "catalog_name": "zeta3",
  "schema_name": "rds",
  "table_type": "EXTERNAL",
  "data_source_format": "CSV",
  "comment": "Bank accounts: account_number_archive, routing_number_archive, nickname, mask, balances, account holder details",
  "full_name": "zeta3.rds.accounts",
  "storage_location": "file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb",
  "properties": {
    "zeta3.delivery": "delivery-1",
    "zeta3.total_row_count": "17947",
    "zeta3.sample_row_count": "17947",
    "zeta3.as_of_enforced": "true"
  },
  "columns": [
    {
      "name": "id",
      "type_name": "INT",
      "type_text": "INT",
      "position": 0,
      "nullable": true,
      "comment": ""
    },
    {
      "name": "tp_id",
      "type_name": "STRING",
      "type_text": "STRING",
      "position": 1,
      "nullable": true,
      "comment": ""
    },
    {
      "name": "status",
      "type_name": "STRING",
      "type_text": "STRING",
      "position": 2,
      "nullable": tru

… 11,021 more characters of output in the raw trajectory.

Arguments

row_limit=10, catalog=zeta3, statement=SELECT * FROM rds.disbursements LIMIT 10

Output

statement_id: f43c8caa-2c16-490e-941e-fc5a1893a0d1
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 8
    columns:
      -
        name: id
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: creator_id
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: effects
        position: 2
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: source_id
        position: 3

… 4,640 more characters of output in the raw trajectory.

Arguments

statement=SELECT service, COUNT(*) FROM rds.transfers GROUP BY 1, catalog=zeta3

Output

statement_id: 130de82e-cc5e-406e-a88f-94369ffad967
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: service
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 4
  total_byte_count: 85
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 4
      byte_count: 85
result:
  chunk_index: 0

… 650 more characters of output in the raw trajectory.

Arguments

statement=SELECT status, COUNT(*) FROM rds.transfers GROUP BY 1, catalog=zeta3

Output

statement_id: 1fe8f294-b4e5-4c63-b3cb-dfc83d3e0a41
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: status
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 10
  total_byte_count: 212
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 10
      byte_count: 212
result:
  chunk_index: 0

… 962 more characters of output in the raw trajectory.

Arguments

statement=SELECT account_type, COUNT(*) FROM rds.accounts GROUP BY 1, catalog=zeta3

Output

statement_id: 1caa5934-cb52-4826-9a0b-22c1af1dd72c
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: account_type
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 2
  total_byte_count: 44
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 2
      byte_count: 44
result:
  chunk_index: 0

… 554 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT category, COUNT(*) FROM rds.accounts GROUP BY 1

Output

statement_id: 0a0dd55b-53bf-4614-bb1b-cfdb60ae23f0
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: category
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 3
  total_byte_count: 61
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 3
      byte_count: 61
result:
  chunk_index: 0

… 597 more characters of output in the raw trajectory.

Arguments

statement=SELECT product_code, COUNT(*) FROM rds.accounts GROUP BY 1, catalog=zeta3

Output

statement_id: a6b897fd-c168-42cd-a799-9645163c08b3
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: product_code
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 32
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 32
result:
  chunk_index: 0

… 512 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT from_type, to_type, COUNT(*) FROM rds.transfers GROUP BY 1, 2

Output

statement_id: 883c6e2b-21e3-432b-955b-b9ad95a7ed77
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 3
    columns:
      -
        name: from_type
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: to_type
        position: 1
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 2
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1

… 1,952 more characters of output in the raw trajectory.

Arguments

statement=SELECT COUNT(*) FROM rds.transfers t JOIN rds.accounts a ON t.to_id = a.id WHERE t.to_type = 'Account', catalog=zeta3

Output

statement_id: d0f1e81d-a298-4ff1-b076-e0cba19b2ff0
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 12
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 12
result:
  chunk_index: 0
  row_offset: 0
  row_count: 1
  byte_count: 12
  data_array:
    -
      - 232884
  external_links:
    -
      chunk_index: null
      row_offset: null
      row_count: null

… 236 more characters of output in the raw trajectory.

Arguments

statement=SELECT COUNT(*) FROM rds.transfers WHERE to_type = 'Account' AND account_id != to_id, catalog=zeta3

Output

statement_id: bd1cf2dd-01fe-47b4-bd07-d3822dea249f
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 11
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 11
result:
  chunk_index: 0
  row_offset: 0
  row_count: 1
  byte_count: 11
  data_array:
    -
      - 45094
  external_links:
    -
      chunk_index: null
      row_offset: null
      row_count: null

… 235 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT status, COUNT(*) FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' GROUP BY 1

Output

statement_id: 0ab02b7e-f4cc-4846-b18b-35157c194fdf
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: status
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 4
  total_byte_count: 80
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 4
      byte_count: 80
result:
  chunk_index: 0

… 644 more characters of output in the raw trajectory.

Arguments

statement=SELECT COUNT(*), COUNT(scheduled_settlement) FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent', catalog=zeta3

Output

statement_id: 61d41779-5b43-40b5-888f-a6b1b617b8da
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count(scheduled_settlement)
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 20
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 20
result: {}

… 512 more characters of output in the raw trajectory.

Arguments

statement=SELECT service, COUNT(*) FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent' GROUP BY 1, catalog=zeta3

Output

statement_id: 7154b840-678c-4f26-b107-69433d5f107b
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: service
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 3
  total_byte_count: 65
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 3
      byte_count: 65
result:
  chunk_index: 0

… 600 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT service, COUNT(*), COUNT(scheduled_settlement) FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent' GROUP BY 1

Output

statement_id: 5035954d-1294-467d-a2f7-d7c2f35f6976
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 3
    columns:
      -
        name: service
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count(scheduled_settlement)
        position: 2
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1

… 906 more characters of output in the raw trajectory.

Arguments

statement=SELECT 
  CASE WHEN scheduled_settlement IS NULL THEN 'NULL' ELSE 'NOT NULL' END as has_settlement,
  MIN(created_at), MAX(created_at), COUNT(*)
FROM rds.transfers 
WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent'
GROUP BY 1, catalog=zeta3

Output

statement_id: 50abc2bd-bb41-44f0-aa20-ef17c7f499d8
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 4
    columns:
      -
        name: has_settlement
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: min(created_at)
        position: 1
        type_name: TIMESTAMP
        type_text: TIMESTAMP
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: max(created_at)
        position: 2
        type_name: TIMESTAMP
        type_text: TIMESTAMP
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: c

… 1,221 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT COUNT(*) FROM rds.transfers t JOIN rds.accounts a ON t.to_id = a.id WHERE t.from_type = 'Counterparty' AND t.to_type = 'Account' AND t.status = 'sent' AND t.scheduled_settlement IS NOT NULL AND a.demo = false

Output

statement_id: 030f7b36-b52d-402c-a596-d92b46729632
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 11
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 11
result:
  chunk_index: 0
  row_offset: 0
  row_count: 1
  byte_count: 11
  data_array:
    -
      - 12253
  external_links:
    -
      chunk_index: null
      row_offset: null
      row_count: null

… 235 more characters of output in the raw trajectory.

Arguments

statement=SELECT d.source_type, COUNT(*) FROM rds.disbursements d WHERE d.source_id IN (SELECT id FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent' AND scheduled_settlement IS NOT NULL) GROUP BY 1, catalog=zeta3

Output

statement_id: 023de309-b931-436f-8dcb-b7ec118e1a98
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: source_type
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 22
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 22
result:
  chunk_index: 0

… 501 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.ledger_items

Output

name: ledger_items
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: ""
full_name: zeta3.rds.ledger_items
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-2
  zeta3.total_row_count: 1005425
  zeta3.sample_row_count: 1005425
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: INT
    type_text: INT
    position: 0
    nullable: true
    comment: ""
  -
    name: subaccount_id
    type_name: INT
    type_text: INT
    position: 1
    nullable: true
    comment: ""
  -
    name: source_id
    type_name: INT
    type_text: INT
    position: 2
    nullable: true
    comment: ""
  -
    name: source_type
    type_name: STRING

… 1,438 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.pending_disbursements

Output

name: pending_disbursements
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: ""
full_name: zeta3.rds.pending_disbursements
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-2
  zeta3.total_row_count: 2715
  zeta3.sample_row_count: 2715
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: BIGINT
    type_text: BIGINT
    position: 0
    nullable: true
    comment: ""
  -
    name: tran_id
    type_name: BIGINT
    type_text: BIGINT
    position: 1
    nullable: true
    comment: ""
  -
    name: transfer_id
    type_name: BIGINT
    type_text: BIGINT
    position: 2
    nullable: true
    comment: ""
  -
    name: target_type

… 1,793 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.automation_disbursements

Output

name: automation_disbursements
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: ""
full_name: zeta3.rds.automation_disbursements
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-2
  zeta3.total_row_count: 76399
  zeta3.sample_row_count: 76399
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: INT
    type_text: INT
    position: 0
    nullable: true
    comment: ""
  -
    name: source_type
    type_name: STRING
    type_text: STRING
    position: 1
    nullable: true
    comment: ""
  -
    name: source_id
    type_name: INT
    type_text: INT
    position: 2
    nullable: true
    comment: ""
  -
    name: target_type

… 2,104 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT COUNT(*) FROM rds.automation_disbursements WHERE transfer_id IN (SELECT id FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent' AND scheduled_settlement IS NOT NULL)

Output

statement_id: 4169ae18-6942-4e1e-95f0-52faf534a786
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 7
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 7
result:
  chunk_index: 0
  row_offset: 0
  row_count: 1
  byte_count: 7
  data_array:
    -
      - 0
  external_links:
    -
      chunk_index: null
      row_offset: null
      row_count: null

… 228 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT COUNT(*) FROM rds.pending_disbursements WHERE transfer_id IN (SELECT id FROM rds.transfers WHERE from_type = 'Counterparty' AND to_type = 'Account' AND status = 'sent' AND scheduled_settlement IS NOT NULL)

Output

statement_id: 6bbd1685-f78b-44aa-b521-0778ebec4cca
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: count_star()
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 1
  total_byte_count: 7
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 1
      byte_count: 7
result:
  chunk_index: 0
  row_offset: 0
  row_count: 1
  byte_count: 7
  data_array:
    -
      - 0
  external_links:
    -
      chunk_index: null
      row_offset: null
      row_count: null

… 228 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT source_type, COUNT(*) FROM rds.disbursements GROUP BY 1

Output

statement_id: 22286009-a3cc-4375-a481-fcfea7daa2be
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: source_type
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 2
  total_byte_count: 54
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 2
      byte_count: 54
result:
  chunk_index: 0

… 563 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT source_type, COUNT(*) FROM rds.ledger_items GROUP BY 1

Output

statement_id: 4b409574-91f1-4cd3-84c1-7a737f70b985
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: source_type
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 2
  total_byte_count: 47
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 2
      byte_count: 47
result:
  chunk_index: 0

… 556 more characters of output in the raw trajectory.

Arguments

statement=SELECT table_name FROM information_schema.tables WHERE table_schema = 'rds' AND (table_name LIKE '%hold%' OR table_name LIKE '%release%'), catalog=zeta3

Output

statement_id: e12bf047-0d48-4c72-9543-18f133809b23
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: table_name
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 4
  total_byte_count: 74
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 4
      byte_count: 74
result:
  chunk_index: 0
  row_offset: 0
  row_count: 4
  byte_count: 74
  data_array:
    -
      - households
    -
      - household_users
    -
      - households
    -
      - household_users

… 365 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT table_name FROM information_schema.tables WHERE table_schema = 'rds' AND table_name LIKE '%disburs%'

Output

statement_id: 4f536cc2-a387-4fe1-af4f-bfa781ff6bf2
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: table_name
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 6
  total_byte_count: 152
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 6
      byte_count: 152
result:
  chunk_index: 0
  row_offset: 0
  row_count: 6
  byte_count: 152
  data_array:
    -
      - automation_disbursements
    -
      - disbursements
    -
      - pending_disbursements
    -
      - au

… 490 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT table_name FROM information_schema.tables WHERE table_schema = 'rds' AND table_name LIKE '%tran%'

Output

statement_id: 03d865ac-60d4-441b-8231-76343fd6e834
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 1
    columns:
      -
        name: table_name
        position: 0
        type_name: STRING
        type_text: VARCHAR
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 24
  total_byte_count: 514
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 24
      byte_count: 514
result:
  chunk_index: 0
  row_offset: 0
  row_count: 24
  byte_count: 514
  data_array:
    -
      - astra_transfers
    -
      - cx_complaint_trans
    -
      - deferred_transfers
    -
      - extern

… 1,251 more characters of output in the raw trajectory.

Arguments

full_name=zeta3.rds.trans

Output

name: trans
catalog_name: zeta3
schema_name: rds
table_type: EXTERNAL
data_source_format: CSV
comment: Transactions: amounts, merchant names, descriptions, check numbers, merchant locations, card IDs (73 cols, 4M source rows)
full_name: zeta3.rds.trans
storage_location: file:///gyms/zeta3_sql/app/data/zeta3/zeta3.duckdb
properties:
  zeta3.delivery: delivery-1
  zeta3.total_row_count: 4091331
  zeta3.sample_row_count: 4091331
  zeta3.as_of_enforced: true
columns:
  -
    name: id
    type_name: INT
    type_text: INT
    position: 0
    nullable: true
    comment: ""
  -
    name: account_id
    type_name: INT
    type_text: INT
    position: 1
    nullable: true
    comment: ""
  -
    name: occurred_at
    type_name: TIMESTAMP
    type_text: TIMESTAMP
    position: 2

… 8,371 more characters of output in the raw trajectory.

Arguments

catalog=zeta3, statement=SELECT source_id, COUNT(*) FROM rds.disbursements WHERE source_type = 'Transfer' GROUP BY 1 HAVING COUNT(*) > 1 LIMIT 10

Output

statement_id: 03bf60a9-ee66-4b65-847c-722938b537b5
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: source_id
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 0
  total_byte_count: 2
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 0
      byte_count: 2
result:
  chunk_index: 0

… 437 more characters of output in the raw trajectory.

Arguments

statement=SELECT transfer_id, COUNT(*) FROM rds.trans WHERE transfer_id IS NOT NULL GROUP BY 1 HAVING COUNT(*) > 1 LIMIT 10, catalog=zeta3

Output

statement_id: fa85f0e6-46dd-4c3c-aba6-8a7dd1b88860
status:
  state: SUCCEEDED
manifest:
  format: JSON_ARRAY
  schema:
    column_count: 2
    columns:
      -
        name: transfer_id
        position: 0
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
      -
        name: count_star()
        position: 1
        type_name: LONG
        type_text: BIGINT
        type_precision: null
        type_scale: null
        type_interval_type: null
  total_chunk_count: 1
  total_row_count: 10
  total_byte_count: 170
  truncated: false
  chunks:
    -
      chunk_index: 0
      row_offset: 0
      row_count: 10
      byte_count: 170
result:
  chunk_index: 0

… 922 more characters of output in the raw trajectory.