Table: tomba_enrich

Get detailed information person and company data based on an email, For example, you could retrieve a person’s name, location and social handles from an email.

The tomba_enrich table requires the email field to be specified in all queries, defining the Email to lookup.

Examples

Info about an Enrichment

select
  email,
  first_name,
  last_name
from
  tomba_enrich
where
  email = 'b.mohamed@tomba.io';

Find Enrichment Email Sources

select
  p ->> 'uri' as uri,
  p ->> 'extracted_on' as extracted_on,
  p ->> 'still_on_page' as still_on_page
from
  tomba_enrich,
  jsonb_array_elements(sources) as p
where
  email = 'b.mohamed@tomba.io';

select
  email,
  first_name,
  last_name,
  twitter,
  linkedin
from
  tomba_enrich
where
  email = 'b.mohamed@tomba.io';

Schema for tomba_enrich

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
company	text		The company of person (if found)
country	text		The Two letter country code based on location.
email	text	=	The email address.
first_name	text		The First name of person.
gender	text		The person gender.
last_name	text		The Last name of person.
linkedin	text		The LinkedIn handle for the person (if found).
sources	jsonb		The given email address somewhere on the web.
twitter	text		The Twitter handle for the person (if found).
website_url	text		The Company domain.

Table: tomba_enrich

Examples

Info about an Enrichment

Find Enrichment Email Sources

Get the social media handles of an email

Schema for tomba_enrich