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_countwhere domain = 'tomba.io';
Find the total number of emails in executive and sales department
select department ->> 'executive' as executive, department ->> 'sales' as salesfrom tomba_countwhere domain = 'clearbit.com';
Schema for tomba_count
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
department | jsonb | The Total email on department _key_name_. | |
domain | text | = | The Domain name from which you want to find the email addresses. For example, `stripe.com`. |
generic_emails | bigint | The total generic email on the domain. | |
personal_emails | bigint | The total personal email on the domain. | |
seniority | jsonb | The Total email on seniority _key_name_. | |
total | bigint | The total email on the domain. |