Paste a CSV sample, get a Snowflake-dialect DDL with NUMBER, TIMESTAMP_NTZ, and VARCHAR types.
Open the Schema Inferrer →Snowflake doesn't enforce VARCHAR length the way Postgres or MySQL do — but defining sensible lengths still helps with COPY validation and downstream tools. MetaDataLoop emits a Snowflake CREATE TABLE with NUMBER(p,s) for decimals, BOOLEAN for true/false, TIMESTAMP_NTZ for naive timestamps, and VARCHAR(N) bucketed lengths inferred from your sample.
Sample values and the dialect-native type they map to.
| Sample value | Inferred type |
|---|---|
| 100, 9999 | NUMBER(38,0) |
| 12.345 | NUMBER(10,3) |
| 3.14159e-5 | FLOAT |
| true, false | BOOLEAN |
| 2024-03-15 | DATE |
| 2024-03-15 09:30:00 | TIMESTAMP_NTZ |
| 2024-03-15T09:30:00+05:30 | TIMESTAMP_TZ |
| "event_name" | VARCHAR(128) |
event_id,user_id,event_name,amount,occurred_at 1,42,signup,0.00,2024-03-15 09:30:00 2,42,purchase,29.99,2024-03-15 14:01:00
CREATE TABLE events (
event_id NUMBER(38,0) NOT NULL,
user_id NUMBER(38,0) NOT NULL,
event_name VARCHAR(64) NOT NULL,
amount NUMBER(10,2) NOT NULL,
occurred_at TIMESTAMP_NTZ NOT NULL
);
No signup, no install — runs entirely in your browser.
Open the Schema Inferrer →