Generating Test Data with Mockaroo

This is just such a fun tool, I had to post about it.

So we often need to generate some test data to work with - be it for ETL, database or reporting work.  There used to be a generate data tool in SSDT, which was good in that it tested boundary limits, but it did create just a bunch of nonsense.  For example, strings would be random characters covering the full string length, integers would cover the full limit - 2,147,483,647.  If you never get numbers or strings like that in your data, formatting for them in a report, for example, is just silly.

In comes Mockaroo, which, as they say on the site: "...lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats."  What do they mean by realistic?  Lets look at some of the data types (depicted below).  There is email address, street address, country, currency, date, color, sequence, guid, various versions of name including European and Chinese, lat / long, and my favorite - "Naughty String" - because no data behaves properly.



You have the ability to introduce random nulls as well, so you wind up with some very realistic data sets.  When I made a request for SQL output, it generated inserts statements:

insert into MOCK_DATA (id, customer, address1, address2, city, state, zip, phone, email, amount) values (1, 'Donald Palmer', '4381 Carey Alley', '0.00', 'San Diego', null, '92127', '9-(170)359-7581', 'dpalmer0@nhs.uk', null);
insert into MOCK_DATA (id, customer, address1, address2, city, state, zip, phone, email, amount) values (2, 'Larry Murray', '195 Troy Street', '""', 'Fort Lauderdale', 'FL', '33325', '3-(686)166-3237', 'lmurray1@godaddy.com', '$40.86');

insert into MOCK_DATA (id, customer, address1, address2, city, state, zip, phone, email, amount) values (3, 'Paul Harper', '8556 Monica Circle', ' ', 'Valley Forge', 'PA', '19495', '3-(990)383-1034', 'pharper2@fema.gov', '$65.78');...

Here is a view of more of the data, including address2, which is my naughty column:



Great for demo data too - go have fun with it!
www.mockaroo.com

 - Mark

Labels: ,