SmartQueryTools

Manage Columns in Arrow Files Online

Drop or select specific columns from Arrow files directly in your browser. No upload required.

How to manage Columns in Arrow files

  1. Drop your file onto the upload area. Every column is listed as a chip with its detected type, and all are selected to start with.
  2. Click a chip to deselect a column you want to drop. It turns grey with a line through it. Click again to bring it back.
  3. Use Deselect all and then click the few columns you need when you only want to keep a handful.
  4. Click Apply to preview the result, then Download to save it in the same format you uploaded.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

An HR analyst needs to send a headcount list to a facilities team, without salary or national ID numbers.

Input (Arrow)

Arrow IPC file (binary, columnar) — shown as a table with its schema

emp_idnamedeptsalarynational_id
2041Maria KeaneFinance68000KX 44 91 02 C
2042Dev PatelOperations54500LM 20 17 88 A
2043Sofia BrandtFinance71200PR 63 05 19 D

Schema: emp_id BIGINT, name VARCHAR, dept VARCHAR, salary BIGINT, national_id VARCHAR

Settings

  • Deselected: salary, national_id
  • Kept: emp_id, name, dept

Result

emp_idnamedept
2041Maria KeaneFinance
2042Dev PatelOperations
2043Sofia BrandtFinance

The two sensitive columns are removed entirely, not blanked, so they are absent from the downloaded file. The three kept columns stay in their original left-to-right order with their original types. Every row is kept, and no values change.

Frequently Asked Questions

Can I reorder columns with this tool?

No. Kept columns stay in their original left-to-right order. To change the order, use the SQL Query tool and list the columns in the order you want.

Does selecting columns change any values or types?

No. Kept columns are copied exactly, with the same types. Only the dropped columns are removed.

Can I drop every column?

No. At least one column must stay selected, and Apply is disabled until one is.

Related Tools