Data Types
Data types recognized by DuckDB and how they appear in ExploreMyData.
| Type | Examples | Explorer Card |
|---|---|---|
VARCHAR (text) | "hello", "2024-01-01", "true" | Value counts with bar chart |
INTEGER / BIGINT | 42, -7, 1000000 | Histogram |
DOUBLE (decimal) | 3.14, -0.5, 99.99 | Histogram |
BOOLEAN | true, false | Value counts |
DATE | 2024-01-15 | Time-series chart |
TIMESTAMP | 2024-01-15 10:30:00 | Time-series chart |
Type Detection
DuckDB automatically detects column types when loading your file. It samples the data and chooses the most specific type that fits all values.
Type Conversion
Use the Convert Type operation to change column types. DuckDB uses TRY_CAST which returns null instead of erroring on invalid values.