The Streamlit app
Open the app from Data Products » Apps » TOMBA. The Tomba app gives you every tool without writing
SQL. It calls the same procedures, so lookups made here are billed and recorded exactly like SQL calls, and
Lookup, Enrich a table and Find companies show the exact CALL they run, ready to paste in a
worksheet.
Use the menu on the left to move between pages, grouped as tools, your data and the app. Below it, a card shows your install (trial or active) and the lookups left today, and the sidebar ends with links to the documentation, the Help Center, the status page and Tomba's terms, privacy policy and DPA.
Overview
- Your install at a glance: whether the Tomba API connection is approved, and whether the install is on a trial or active. Today's lookups left and the app's version are in the sidebar card, on every page.
- Next steps: shown only until setup is done: approve the connection, connect to Tomba (happens on your first lookup), and grant the app your tables.
- Start here: the three tools, with the procedure each one calls. Click a row to open the tool.
- Last 30 days: rows looked up, search and verification credits, charges, a chart of the amount charged per day (once three days have runs), and a table per tool with its hit rate. If you set a monthly credit budget, a bar shows how much of this month's budget is used.
- Run it from SQL: the grants and a first call, to copy into a worksheet.
Lookup
Look up one person, email, phone or company: the request on the left, the response on the right.
- Pick a tool.
- For tools with several input combinations (the Email Finder accepts domain + first/last name, domain + full name, company + names…), choose one under Search by.
- Fill in the fields and click Look up.
The response shows what was found, the credits used and the amount charged, and a note when the answer came
from the cache (free). Switch between Result (the record: the email or phone it's about, its status and
score, then every field), JSON (the full Tomba record) and SQL (the same lookup as a CALL).
Enrich a table
Run a tool over a whole table, in six numbered steps. Each step shows done once it's filled in:
- Tool: pick the tool.
- Input table: click Choose a table (or Choose a view) to share one with the app in Snowsight's
dialog, pick one you already shared, or enter
DATABASE.SCHEMA.TABLE. The app can preview it, or shows theGRANTstatements to run if it can't read it. - Match columns: columns are matched automatically (
EMAIL,COMPANY_DOMAIN,FIRST_NAME, …); change them if needed. - Output: the result table's name (it includes the date and time, so a new run doesn't replace an older result), the maximum number of rows, and the tool's options.
- Cost and run: the most the run can cost, in credits and dollars, a credit limit for the run, Run in the background (recommended for large tables) and the same run as SQL. Tick the confirmation and click Run: the button shows the number of rows and the most the run can cost.
- Keep it enriched (optional): turn on Keep this table enriched on a schedule to create a schedule that looks up the table's new rows every day, week or hour.
A run in the background opens History; a run in the page shows its result: rows found, the hit rate, credits, charges and Open in Results.
Find companies
Build a table of companies from filters, grouped by where (countries, cities), what (industries, keywords, technologies, domains) and size and type (employees, company type, revenue, founding year). The page shows the most the search can cost and the same search as SQL as you set the filters, and its result after it runs. See Companies Search.
Results
Every result table: a preview of its first rows, Export (prepare, then Download CSV: the first 10,000 rows), the SQL to copy the table into your database, and Drop this table, which asks you to confirm first.
History
- Running now: progress for running and queued runs, with Cancel.
- Stopped early: runs that stopped (daily limit, cancel, credit limit, failed lookups), with when and why they stopped, Resume and an Auto-resume switch.
- All runs: the latest runs with their state, credits and charge (a switch shows every run as a sortable table), filters by tool and status, and totals for rows, search and verification credits, and charges.
Schedules
Your schedules: when they run (for example "Every day at 06:00 UTC"), what they enrich,
their last run, Pause/Resume schedule, Run now and Delete, which asks you to confirm. New
schedule opens step 6 of Enrich a table. Changing schedules needs the app_admin role.
Settings
Throughput, limits and cache settings, each with a one-line explanation; large values are spelled out under
their field (for the monthly budget, with what it costs). Everyone can see them; saving needs
app_admin. Save changes is available once you change a value, and Reset puts back the saved values.
Clear the cache is in the Cache card. See the settings reference.
Help & legal
Pricing and the credits each tool uses, who can use the app and what it can read, privacy, the documentation, support and Tomba's legal pages.