Faker Methods Reference

Faker Methods Reference

The faker strategy uses the Bogus library to generate realistic fake data. All values are generated per-row via SQL expressions.

Usage

- name: "email"
  strategy: "faker"
  faker: "email"

Available Methods

Names

Method	Example Output
first_name	John
last_name	Smith
full_name	John Smith

Contact

Method	Example Output
email	john.smith@example.com
user_name	john.smith42
phone	+1-555-867-5309

Address

Method	Example Output
address	123 Main St, Springfield, IL 62701
street_address	123 Main St
city	Springfield
country	United States
zip_code	62701

Business

Method	Example Output
company	Acme Corporation

Text

Method	Example Output
lorem	Lorem ipsum dolor sit amet
paragraph	Lorem ipsum... (multi-sentence)
url	https://example.com/path

Network

Method	Example Output
ip_address	192.168.1.42

Identifiers

Method	Example Output
uuid	550e8400-e29b-41d4-a716-446655440000
ssn	123-45-6789

Numbers

Method	Column Type	Example Output
random_number	integer	42837
random_double	numeric/float	3.14159
digits_as_integer	integer	78234

Numeric methods will produce a validation warning if used on a text column.

Dates

Method	Example Output
date	2024-03-15
datetime	2024-03-15T14:23:00

Commerce

Method	Example Output
color	Cornflower Blue
product	Ergonomic Steel Keyboard
price	49.99

Finance

Method	Example Output
iban	GB29NWBK60161331926819
credit_card	4111 1111 1111 1111

Notes

• All faker values are non-deterministic — each run produces different values.
• For consistent, reproducible pseudonymization use the hash strategy instead.
• Faker does not preserve referential integrity across tables. Use hash or template if FK relationships must be consistent.