The data analyst that never sleeps
Definite is like working with a data analyst that understands your data and can instantly get you the insight you need.
Get your answers anytime on Slack
Instead of asking your data team for help, just ask Definite.
Text to SQL that actually works
Ask questions in natural language across multiple tables and our engine knows where to join.
Iterate and visualize faster
Ask follow up questions and visualize the results in seconds.
Your data team is drowning
Definite ends the flood of adhoc requests so your data engineers and data scientists can finally have time for deep work.
Show by user the combined number of comments and stories posted after jan 1 2022
SELECT
users.username,
COUNT(comments.id) + COUNT(stories.id) AS total_posts
FROM hacker_news.users AS users
LEFT JOIN hacker_news.comments AS comments ON users.username = comments.by
LEFT JOIN hacker_news.stories AS stories ON users.username = stories.by
WHERE comments.timestamp > '2022-01-01' OR stories.timestamp > '2022-01-01'
GROUP BY users.username
ORDER BY total_posts DESC
LIMIT 10
users.username,
COUNT(comments.id) + COUNT(stories.id) AS total_posts
FROM hacker_news.users AS users
LEFT JOIN hacker_news.comments AS comments ON users.username = comments.by
LEFT JOIN hacker_news.stories AS stories ON users.username = stories.by
WHERE comments.timestamp > '2022-01-01' OR stories.timestamp > '2022-01-01'
GROUP BY users.username
ORDER BY total_posts DESC
LIMIT 10
Set up in minutes (not weeks)
Definite is tightly integrated with the rest of your data stack, making building analytical workflows a breeze.
