Troubleshooting

Common issues and their solutions.

File won't load

• Encoding issues: Save your file as UTF-8 and try again.
• Malformed CSV: Check for unescaped quotes or inconsistent column counts.
• File too large: Try converting to Parquet format for better performance.

Columns have wrong types

DuckDB auto-detects column types. If a column is detected as text when it should be numeric, use the Convert Type operation to cast it.

Filter returns no results

Check for null values. Use IS NOT NULL in your condition, or use Fill Missing first.

SQL error in custom query

Make sure your table name matches the one shown in the file tab. DuckDB SQL is PostgreSQL-compatible. See the SQL Reference.

Browser running slow

• Close other tabs to free memory
• Use Parquet format for large files
• Reduce the number of pipeline steps
• Select only the columns you need

Dark mode looks wrong

Toggle dark mode using the sun/moon icon in the header. The setting persists across sessions.