#derjanni-SQL
valid inlet
Hi! I don't know much about sigma. But have you tried adding a GROUP BY in the subquery, as mentioned in the error message?
devout gyro
Do you have any idea where I can get support for Stripe Sigma?
valid inlet
I would recommend contacting Stripe support direclty: https://support.stripe.com/?contact=true
devout gyro
Hi! I don't know much about sigma. But have you tried adding a GROUP BY in the s...
Yes, I tried. Same error. Presto is unable to identify the function in the aggregate.
I think it only supports SQL 1986.
I guess my assumptions were just false. Sigma is advertised to support SQL and it seems like that's more like SQL from the 80s than current SQL.
valid inlet
That's a good question, I'm not sure which version of SQL this is using. I recommend asking your question to Stripe support directly (to the link I shared earlier).
devout gyro
The only example I found was this one: https://dashboard.stripe.com/sigma/queries/templates/Itemized ending balance reconciliation report
And the Presto SQL docs are extremely limited in what information they provide.
I need to run a couple of scheduled reports on subscriptions and thought Sigma might be a solution since the Stripe Power BI connector was discontinued a couple of years back.
