Reference

Output columns

Every result table has the same layout: your INPUT_<name> columns, then the tool's columns, then the common columns. Types are Snowflake types: STRING is VARCHAR and INT is NUMBER(38,0). Any tool column can be NULL when Tomba has no value for it.

Common columns

Column	Type	Description
`INPUT_<name>`	`STRING`	Your input values, as text and before cleaning, one column per mapped input (for example `INPUT_DOMAIN` or `INPUT_EMAIL`). Use them to join the results back.
`LOOKUP_STATUS`	`STRING`	`found`, `not_found`, `invalid` (the value can't be used, so it wasn't sent), `error` (failed after retries) or `skipped` (not looked up because the run stopped first).
`CREDITS`	`INT`	Tomba credits the lookup used. When a lookup writes several rows, the first row carries them and the others show 0. Cached results and repeated inputs show 0.
`CREDIT_TYPE`	`STRING`	`search` or `verifier`. NULL when `CREDITS` is 0.
`DATA`	`VARIANT`	The complete Tomba record behind the row: every field, not only the columns.
`ERROR`	`STRING`	Why the row is `invalid`, `error` or `skipped`, and for some `not_found` rows. `claimed` means the person asked Tomba to stop processing their data.
`LOOKED_UP_AT`	`TIMESTAMP_NTZ`	When the row was looked up or read from the cache, in UTC.
`SOURCE`	`STRING`	`api` for a new lookup, or `cache` when a recent result was reused at no charge.

Domain Search, Similar Domains and Companies Search write one row per result, so one input can produce many rows.

Columns per tool

Email Finder

The Email Finder tool adds these columns:

Column	Type	Description
`EMAIL`	`STRING`	The email address.
`SCORE`	`INT`	Tomba's confidence in the address, 0–100.
`VERIFICATION_STATUS`	`STRING`	The result of Tomba's last verification of the address, as a verifier `status` in lowercase (values). NULL if it hasn't been verified.
`FIRST_NAME`	`STRING`	First name.
`LAST_NAME`	`STRING`	Last name.
`FULL_NAME`	`STRING`	Full name.
`POSITION`	`STRING`	Job title.
`DEPARTMENT`	`STRING`	Department. See Department and role.
`COMPANY`	`STRING`	Company name.
`WEBSITE_URL`	`STRING`	Company domain.
`COUNTRY`	`STRING`	The person's two-letter country code.
`LINKEDIN`	`STRING`	LinkedIn profile.
`TWITTER`	`STRING`	Twitter profile.
`EMAIL_TYPE`	`STRING`	`personal` or `generic`. See Email type.
`ACCEPT_ALL`	`BOOLEAN`	The domain's mail server accepts mail for any address (catch-all).
`PHONE_NUMBER`	`BOOLEAN`	Tomba has a phone number for this person. The number isn't in a column: with the `enrich_mobile` option, phones are in `DATA:phone_data`.

Email Verifier

The Email Verifier tool's columns hold the API's response fields; see Email verifier response for what each check means.

Column	Type	Description
`EMAIL`	`STRING`	The address checked. NULL when the domain is disposable.
`STATUS`	`STRING`	The verifier's `status`, in lowercase. See Status values.
`RESULT`	`STRING`	The verifier's `result`, in lowercase. See Result values. NULL when `STATUS` is `disposable`.
`SCORE`	`INT`	Confidence score. Higher means more likely to be deliverable.
`ACCEPT_ALL`	`BOOLEAN`	The mail server accepts mail for any address (catch-all).
`DISPOSABLE`	`BOOLEAN`	The domain belongs to a disposable email provider.
`WEBMAIL`	`BOOLEAN`	The domain belongs to a webmail provider.
`GIBBERISH`	`BOOLEAN`	The part before `@` looks randomly generated.
`BLOCK`	`BOOLEAN`	The mail server blocked or refused the check.
`GREYLISTED`	`BOOLEAN`	The mail server temporarily deferred the check.
`MX_CHECK`	`BOOLEAN`	The domain has MX records.
`SMTP_SERVER`	`BOOLEAN`	Same value as `SMTP_CHECK`.
`SMTP_CHECK`	`BOOLEAN`	Same value as `MX_CHECK`. It doesn't show whether the mailbox exists; use `STATUS`.
`SMTP_PROVIDER`	`STRING`	Mail provider detected from the domain's MX records.

Domain Search

The Domain Search tool writes one row per email found at the domain.

Column	Type	Description
`EMAIL`	`STRING`	The email address.
`FIRST_NAME`	`STRING`	First name.
`LAST_NAME`	`STRING`	Last name.
`FULL_NAME`	`STRING`	Full name.
`POSITION`	`STRING`	Job title.
`DEPARTMENT`	`STRING`	Department. See Department and role.
`SENIORITY`	`STRING`	`junior`, `senior` or `executive`.
`EMAIL_TYPE`	`STRING`	`personal` or `generic`. See Email type.
`SCORE`	`INT`	Tomba's confidence in the address, 0–100.
`VERIFICATION_STATUS`	`STRING`	The result of Tomba's last verification of the address, as a verifier `status` in lowercase (values). NULL if it hasn't been verified.
`COUNTRY`	`STRING`	The person's two-letter country code.
`LINKEDIN`	`STRING`	LinkedIn profile URL.
`TWITTER`	`STRING`	Twitter profile URL.
`PHONE_NUMBER`	`BOOLEAN`	Tomba has a phone number for this person. With the `enrich_mobile` option, phones are in `DATA:phone_data`.
`ORGANIZATION`	`STRING`	Company name.
`INDUSTRIES`	`STRING`	Company industry.
`COMPANY_SIZE`	`STRING`	Company size.
`COMPANY_TYPE`	`STRING`	Company type.
`ORGANIZATION_COUNTRY`	`STRING`	Company country.

Email Enrichment

The Email Enrichment tool has the same columns as Email Finder.

Person Enrichment

The Person Enrichment tool adds these columns:

Column	Type	Description
`EMAIL`	`STRING`	The email address.
`FULL_NAME`	`STRING`	Full name.
`FIRST_NAME`	`STRING`	First name.
`LAST_NAME`	`STRING`	Last name.
`TITLE`	`STRING`	Job title.
`ROLE`	`STRING`	Department. See Department and role.
`SENIORITY`	`STRING`	Seniority.
`COMPANY_NAME`	`STRING`	Company name.
`COMPANY_DOMAIN`	`STRING`	Company domain.
`LOCATION`	`STRING`	The person's location, as a two-letter country code.
`CITY`	`STRING`	City.
`COUNTRY`	`STRING`	Country name, such as `Germany`.
`LINKEDIN_HANDLE`	`STRING`	LinkedIn profile.
`TWITTER_HANDLE`	`STRING`	Twitter profile.
`GITHUB_HANDLE`	`STRING`	GitHub profile.

The Person Enrichment API doesn't return seniority, city or GitHub profile, so SENIORITY, CITY and GITHUB_HANDLE are NULL.

Company Enrichment

The Company Enrichment tool adds these columns:

Column	Type	Description
`NAME`	`STRING`	Company name.
`LEGAL_NAME`	`STRING`	Legal name. The API returns the same value as `NAME`.
`DOMAIN`	`STRING`	Company domain.
`DESCRIPTION`	`STRING`	Company description.
`INDUSTRY`	`STRING`	Industry.
`SECTOR`	`STRING`	Sector.
`EMPLOYEES`	`STRING`	Company size (employees), as text.
`ANNUAL_REVENUE`	`STRING`	Annual revenue, as text.
`FOUNDED_YEAR`	`STRING`	Year founded, as text.
`COMPANY_TYPE`	`STRING`	Company type.
`CITY`	`STRING`	City.
`COUNTRY`	`STRING`	Country name, such as `United States`.
`COUNTRY_CODE`	`STRING`	Two-letter country code.
`LINKEDIN_HANDLE`	`STRING`	LinkedIn page.
`TWITTER_HANDLE`	`STRING`	Twitter profile.
`LOGO`	`STRING`	Logo.

The Company Enrichment API doesn't return industry, sector or logo, so INDUSTRY, SECTOR and LOGO are NULL.

Combined Enrichment

The Combined Enrichment tool has the Person Enrichment columns, then:

Column	Type	Description
`COMPANY_INDUSTRY`	`STRING`	Company industry.
`COMPANY_EMPLOYEES`	`STRING`	Company size (employees), as text.
`COMPANY_COUNTRY`	`STRING`	Company country name.
`COMPANY_LINKEDIN_HANDLE`	`STRING`	Company LinkedIn page.

COMPANY_NAME and COMPANY_DOMAIN come from the company record when it has them. SENIORITY, CITY, GITHUB_HANDLE and COMPANY_INDUSTRY are NULL: the API doesn't return them.

LinkedIn Finder

The LinkedIn Finder tool has the same columns as Email Finder.

Author Finder

The Author Finder tool has the Email Finder columns, then:

Column	Type	Description
`ARTICLE_TITLE`	`STRING`	Title of the article.
`PUBLISHER_NAME`	`STRING`	Publisher of the article.
`PUBLISH_DATE`	`STRING`	Publication date, as text.

Phone Finder

The Phone Finder tool adds these columns:

Column	Type	Description
`VALID`	`BOOLEAN`	The number is valid for its country.
`E164_FORMAT`	`STRING`	The number in E.164 format, such as `+14155550100`.
`INTL_FORMAT`	`STRING`	International format, such as `+1 415-555-0100`.
`LOCAL_FORMAT`	`STRING`	National format, such as `(415) 555-0100`.
`COUNTRY_CODE`	`STRING`	Two-letter country code of the number, such as `US`.
`LINE_TYPE`	`STRING`	The kind of line. See Line type.
`CARRIER`	`STRING`	Carrier name.
`REGION`	`STRING`	Region of the number.
`TIMEZONES`	`STRING`	Time zones of the number, comma-separated.

Phone Validator

The Phone Validator tool has the same columns as Phone Finder.

Similar Domains

The Similar Domains tool writes one row per similar company.

Column	Type	Description
`SIMILAR_DOMAIN`	`STRING`	Domain of the similar company.
`NAME`	`STRING`	Its name.
`INDUSTRIES`	`STRING`	Its industry.

Companies Search

The Companies Search tool writes one row per company. Instead of one INPUT_<name> column per input, each row starts with INPUT_FILTERS: the filters of the search, as JSON.

Column	Type	Description
`NAME`	`STRING`	Company name.
`WEBSITE_URL`	`STRING`	Company domain.
`INDUSTRY`	`STRING`	Industry.
`COMPANY_SIZE`	`STRING`	Company size.
`COMPANY_TYPE`	`STRING`	Company type.
`FOUNDED`	`STRING`	Year founded.
`REVENUE`	`STRING`	Revenue range.
`COUNTRY`	`STRING`	Country.
`STATE`	`STRING`	State or region.
`CITY`	`STRING`	City.
`TOTAL_EMAILS`	`INT`	Number of email addresses Tomba knows at the company.
`LINKEDIN_URL`	`STRING`	LinkedIn page URL.
`DESCRIPTION`	`STRING`	Company description.

Values

Email type

Value	Meaning
`personal`	The address of a person.
`generic`	A shared or role address, such as `sales@` or `info@`.

Department and role

DEPARTMENT and ROLE take one of these values: accounting, administrative, communication, diversity, education, engineering, executive, facilities, finance, healthcare, hr, it, legal, management, marketing, operations, pr, sales, security, software, support, warehouse.

Line type

Value	Meaning
`MOBILE`	Mobile number.
`FIXED_LINE`	Landline.
`FIXED_LINE_OR_MOBILE`	Landline or mobile: the number itself doesn't tell them apart.
`VOIP`	Voice over IP number.
`TOLL_FREE`	Toll-free number.
`PREMIUM_RATE`	Premium-rate number.
`SHARED_COST`	Shared-cost number.
`PERSONAL_NUMBER`	Personal number, routed to a mobile or a landline.
`PAGER`	Pager.
`UAN`	Universal access number, routed to a company's offices.
`UNKNOWN`	The type couldn't be determined.

Last modified on September 29, 2026

Procedures Settings