Generator summary
Tonic Fabricate offers generators to create the following categories of column values.
The following is an alphabetical list of the available generators, with links to the details for configuring the generator from the Fabricate application and from the Fabricate API.
Populates the column with a number intended to represent the elevation where an airport is located.
Populates the column with an airport code from the International Civil Aviation Organization (ICAO) code. For example, LFPG or KJFK.
Populates the column with the name of a city or metropolitan area where an airport is located.
Populates the column with the name of an airport. For example, John F Kennedy Airport or Heathrow Airport.
Populates the column with a 2-character code to represent the region where the airport is located.
Populates the column with the name of an animal. For example, dog or cat.
Populates the column with the scientific name of an animal. For example, canis lupus familaris or felis catus.
Populates the column with a 2-character country code. For example, ES, FR, US.
Populates the column with a bank Register of Institutions and Affiliates Data (RIAD) code.
Populates the column with the model of a car. For example, Mustang or Accord.
Populates a column with a value that uses a specific pattern. The pattern can include both random characters of a specific type and specific characters.
Populates the column with values from a column in a different table.
Populates the column with the domain name for a company. For example, apple.com or tonic.ai.
Populates the column with a company industry. For example, Consumer Electronics or Computer Software.
Populates the column with a year to represent when the company IPO occurred.
Populates the column with a monetary value to represent the amount of the company's most recent sale. For example 150.25.
Populates the column with the stock exchange where the company stock is traded. For example, NASDAQ or NYSE.
Populates the column with the market cap for the company. For example, 1.5B.
Populates the column with the sector that the company belongs to. For example, Technology.
Populates the column with the URL where the company's stock quote can be found. For example, https://www.nasdaq.com/market-activity/stocks/aapl.
Populates the column with the ticker symbol for the company. For example, aapl.
Populates the column with the name of a country from anywhere in the world.
Populates the column with a 3-character country code for a country from anywhere in the world. For example, FRA, ESP, USA.
Populates the column with a 2-character country code for a country from anywhere in the world. For example, FR, ES, US.
Populates the column with the 2-character country code for the United States - US.
Populates the column with a country telephone code from anywhere around the world.
Populates the column with the country telephone code for the United States.
Populates the column with a credit card type. For example, Visa, MasterCard, American Express.
Populates the column with a 3-character currency code for a currency from anywhere in the world. For example, EUR, AUD, JPY.
Populates the column with the 3-character currency code for the United States, USD.
Populates the column with the name of a currency from anywhere in the world. For example, Euro, Mexican Peso, Yen.
Populates the column with the name of a pharmaceutical company. For example, Pfizer.
Populates the column with valid United States employer identification number (EIN).
Populates the column with a file extension. For example, .txt or .docx.
Populates the column with a file MIME type. For example, text/plain or image/jpeg.
Populates the column with the name of a commercial airline. For example, Delta Airlines or Lufthansa.
Populates the column with a timestamp in 24-hour format. For example, for 1:15 PM, the generated value would be 13:15.
Populates the column with a decimal number to indicate the number of hours in a flight. For example, 2.5.
Populates the column with a value representing a flight number. For example, LH1234.
Makes the column a foreign key to another table.
For example, a product-id column might be a foreign key to a products table.
Populates the column with a full mailing address from anywhere in the world.
Populates the column with a full mailing address from within the United States.
Produces a full name (given name and family name), such as John Smith and Mary Jones.
Populates the column with a code from the Healthcare Common Procedure Coding System.
Populates the column with a name from the Healthcare Common Procedure Coding System.
Populates the column with the National Provider Identifier for a hospital.
Populates the column with a long description of a diagnosis from ICD-10.
Populates the column with a short description of a diagnosis from ICD-10.
Populates the column with the long description of a procedure from ICD-10.
Populates the column with the short description of a procedure from ICD-10.
Populates the column with the long description of a diagnosis from ICD-9.
Populates the column with the short description of a diagnosis from ICD-9.
Populates the column with the long description of a procedure in ICD-9.
Populates the column with the short description of a procedure in ICD-9.
Populates the column with an IP address. For example, 192.168.1.100 or 2001:0db8:0000:0000:0000:0000:1a2b:3c4d.
Produces a value that describes the area of expertise for a job. For example, Security or Quality.
Produces a value that describes a general descriptor of the job hierarchy level. For example, Senior or Lead.
Produces a job title. For example, Senior Security Engineer or Principal Program Manager.
Produces a value that describes the type of job or type of work that the job entails. For example, Engineer or Manager.
Populates the column with the name of a spoken language. For example, French, Spanish, English.
Populates the column with the 2-character code for a spoken language. For example, fr, es, en.
Populates the column with a latitude value from anywhere in the world.
Populates the column with a latitude value from within the United States.
Populates the column with a longitude value from anywhere in the world.
Populates the column with a longitude value from within the United States.
Produces a name from the same set as the First Name generator. The middle name is always different from the first name.
Populates the column with a movie genre. For example, Horror, Romantic Comedy.
Populates the column with the title of a movie. For example, Gone With the Wind.
Populates the column with a JSON object. You configure the list of fields in the object. For each field, you select and configure the generator to use to populate the field.
Produces a random passport number that matches the country name or code that is in another column of the table.
Produces a name suffix. The possible suffixes are Jr., Sr., and III.
Produces a name title. The possible titles are Mr., Mrs., Ms., and Dr..
Populates the column with a telephone number from anywhere in the world.
Populates the column with the name of a plant. For example, dandelion.
Populates the column with the name of a plant family. For example, asteraceae.
Populates the column with the scientific name of a plant. For example, taraxacum officinale.
Populates the column with a postal code from anywhere in the world.
Populates the column with a 5-digit postal code from within the United States.
Populates the column with a category of product. For example, Health or Electronics.
Populates the column with the subcategory that the product belongs to. For example, Oral Care and Hygiene.
Assigns a rank value based on the values in 2 other columns. It partitions the data by the values in one column, then orders the values based on the value in the other column.
Produces a value that matches a regular expression that you provide. It uses the Peri-compatible regular expression syntax.
Uses a SQL expression to generate the value. The expression can refer to other columns and other tables.
Populates the column with the name of a state or province from any country in the world. For example, Normandy or Ontario.
Populates the column with the name of a state in the United States. For example, Montana or New York.
Populates the column with the postal abbreviation of a state or province from anywhere in the world. For example, NOR or ONT.
Populates the column with the postal abbreviation of a state in the United States. For example, MN or NY.
Populates the column with a street address from anywhere in the world. For example, 10 Rue Morgue.
Populates the column with a street address from within the United States. For example, 15 Main Street.
Populates a column with the sum of column values from rows in another table. To identify the rows to include, you provide join criteria.
Adds together the values of a specified numeric column in rows that are before the current row.
Populates the column with the name of a time zone from anywhere in the world. For example, Europe/Paris.
Populates the column with the name of a time zone that occurs in the United States. For example, US/Central.
Populates the column with the 2-character country code for the university location. For example, ES, FR, US.
Populates the column with the name of a university. For example, Harvard.
Populates the column with the URL for the university website. For example, harvard.edu.
Uses an LLM to populate a column with unstructured data, such as text or JSON, that can include values from other columns in the table.
Populates the column with a user agent value. For example, Mozilla/5.0 (Windows NT 10.0; Win64; rv:110.0.
Populates a column with a value or values from another column in the previous row or rows.
Last updated