enigmagi-sigma | Stripe Developers | Page 1

astral templeBOT Oct 6, 2022, 11:58 PM

#

keen canopy Oct 7, 2022, 12:04 AM

#

enigmagi-sigma

#

@violet locust we don't know much about Sigma here sorry. We usually recommend asking our support team for help instead: https://support.stripe.com/contact

mellow plinth Oct 7, 2022, 12:20 AM

#

I use it a lot @violet locust.

violet locust Oct 7, 2022, 12:20 AM

#

that's awesome.

#

would you be interested in trying out an AI slackbot that will generate the queries from natural language?
example:
you type in "how many customers did we churn this month?" and get

WITH customer_month AS (
  SELECT DISTINCT customer_id, DATE_TRUNC('month', created) as month
  FROM charges
  WHERE customer_id IS NOT NULL
    AND captured
),
customer_retention AS (
  SELECT
    customer_id,
    month,
    CASE
      WHEN month + INTERVAL '1' MONTH = LEAD(month) OVER(PARTITION BY customer_id ORDER BY month) THEN true
      ELSE false
    END AS retained
  FROM customer_month
)
SELECT
  COUNT(customer_id) AS churned_customers
FROM customer_retention
WHERE month = DATE_TRUNC('month', NOW() - INTERVAL '1' MONTH)
AND NOT retained

mellow plinth Oct 7, 2022, 12:24 AM

#

I personally probably wouldn't use it, but it does seem like it could be valuable for some that aren't as familiar with the data model/SQL/Sigma.

#enigmagi-sigma