steampipe plugin install tomba-io/tomba

Table: tomba_count

Get detailed information about an total email addresses we have for one domain.

The tomba_count table requires the domain field to be specified in all queries, defining the Domain to lookup.

Examples

Info about an Email Count

select
total as "Total Emails",
personal_emails as "Total Personal Emails",
generic_emails as "Total Generic Emails"
from
tomba_count
where
domain = 'tomba.io';

Find the total number of emails in executive and sales department

select
department ->> 'executive' as executive,
department ->> 'sales' as sales
from
tomba_count
where
domain = 'clearbit.com';

Schema for tomba_count

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
departmentjsonbThe Total email on department _key_name_.
domaintext=The Domain name from which you want to find the email addresses. For example, `stripe.com`.
generic_emailsbigintThe total generic email on the domain.
personal_emailsbigintThe total personal email on the domain.
seniorityjsonbThe Total email on seniority _key_name_.
totalbigintThe total email on the domain.