Mock Data Generator for Snowflake

Overview

Snowflake makes it easy to spin up test environments — but populating those tables with realistic, type-correct data is still manual work. MetaDataLoop generates rows that honor NUMBER(p,s), TIMESTAMP_NTZ, BOOLEAN, and VARCHAR length declarations from your DDL, ready to paste or COPY INTO from a staged file.

What you get

Example

CREATE TABLE events (
    event_id   NUMBER(38,0),
    user_id    NUMBER(38,0),
    event_name VARCHAR(64),
    amount     NUMBER(10,2),
    occurred_at TIMESTAMP_NTZ
);

INSERT INTO events (event_id, user_id, event_name, amount, occurred_at) VALUES
  (1, 42, 'signup',   0.00,  '2024-03-15 09:30:00'),
  (2, 42, 'purchase', 29.99, '2024-03-15 14:01:00'),
  (3, 99, 'login',    0.00,  '2024-03-15 14:05:22');

Frequently asked questions

Try it now

No signup, no install — runs entirely in your browser.