Table: tomba_author

Get detailed information of email address from a blog post url.

The tomba_author table requires the url field to be specified in all queries, defining the URL to lookup.

Examples

Info about an Author Finder

select
  email,
  first_name,
  last_name
from
  tomba_author
where
  url = 'https://clearbit.com/blog/company-name-to-domain-api';

Find the email sources of the Author Finder

select
  p ->> 'uri' as uri,
  p ->> 'extracted_on' as extracted_on,
  p ->> 'still_on_page' as still_on_page
from
  tomba_author,
  jsonb_array_elements(sources) as p
where
  url = 'https://clearbit.com/blog/company-name-to-domain-api';

select
  email,
  first_name,
  last_name,
  twitter,
  linkedin
from
  tomba_author
where
  url = 'https://clearbit.com/blog/company-name-to-domain-api';

Schema for tomba_author

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
company	text		The Name of company (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).
url	text	=	The URL of the article. For example, `https://clearbit.com/blog/company-name-to-domain-api`.
website_url	text		The Domain of company’s website.

Table: tomba_author

Examples

Info about an Author Finder

Find the email sources of the Author Finder

Get the social media handles of the author

Schema for tomba_author