Being able to query your data in SQL is great. But to be really useful, you need to be able to join many different data sources. For example, if you want to estimate [cost of sales] / [lifetime value], you need to join your Stripe data with your Salesforce data. Thats why companies like mine (Fivetran) exist: to mirror all your data sources in a single SQL warehouse. If you use a ETL-as-a-service provider and a fully-managed warehouse like BigQuery, it's really not that hard to set up your own data warehouse that has all your data in it.
Stripe Sigma
71–80 of 123 posts
Re: Stripe Sigma
#72Anybody else has problems reading the examples on that page? When I click on an example the source code for the example is rendered very blurry :-/
Re: Stripe Sigma
#73I've only glanced at this, but I love the idea of making your API be SQL. I did this recently for a company whose customers have a lot of "power users" who are not professional programmers but use tools like R, Excel, Tableau, or even Python. The customers are very happy with it! We saved a ton of time not building a JSON API, which our customers wouldn't be able to use anyway. Basically we create a customer-specific…
My first reaction to seeing an SQL-based API is 'ugh'. SQL is complex and a little cumbersome, and easy to get wrong. My second reaction is 'oh, thank god'. I'm so tired of having APIs where I have to go through the 'get the list of users', 'iterate over the list to create a map', 'get the list of messages', 'iterate over the list of messages and add the username to the data structure', 'oh wait I have to get the cha…
That's one of the problems that GraphQL is intended to solve, specifically you don't want to write your API queries directly in SQL but you also want the flexibility to chain queries together and specify the exact types of data you require.
Re: Stripe Sigma
#74Really cool! Signed up for the beta, excited to try it. Although at first glance, it looks quite expensive. Having to pay $10 monthly outright even with no charges feels kinda bad. I'm a huge fan of Amazon's free tiers to experiment with; Stripe's test mode is very nice for the same reason. And on top of this, the pricing being per-charge makes it far more expensive for businesses selling cheaper products ($5 subscri…
$10/month is two coffees. Not even worth thinking about if you find the service at all useful.
> $10/month is two coffees.
What?! Where does a single cup of coffee cost five dollars?
For ten dollars, you can brew at least fifty cups of coffee.
Re: Stripe Sigma
#75A couple of people have mentioned that Baremetrics should feel threatened, and that's where my mind went immediately too. I asked Josh Pigford for his reaction, and this is what he said: > We've had beta access to it for a while and have known it was coming. Generally not worried about it at all nor do we view it as any sort of competition in any sense of the word. > It doesn't give access to any new data...it's an S…
For established customers maybe not as there's a cost to switching but I'd be very surprised if this didn't have a hit on their signups going forward (once it's GA).
Re: Stripe Sigma
#76A couple of people have mentioned that Baremetrics should feel threatened, and that's where my mind went immediately too. I asked Josh Pigford for his reaction, and this is what he said: > We've had beta access to it for a while and have known it was coming. Generally not worried about it at all nor do we view it as any sort of competition in any sense of the word. > It doesn't give access to any new data...it's an S…
For established customers maybe not as there's a cost to switching but I'd be very surprised if this didn't have a hit on their signups going forward (once it's GA).
I think you're probably overestimating what Sigma does and underestimating what Baremetrics does. If anything we've just got a bit more work coming for us to explain the differences and intricacies of it all. But, I'm not losing sleep. :)
Re: Stripe Sigma
#77A couple of people have mentioned that Baremetrics should feel threatened, and that's where my mind went immediately too. I asked Josh Pigford for his reaction, and this is what he said: > We've had beta access to it for a while and have known it was coming. Generally not worried about it at all nor do we view it as any sort of competition in any sense of the word. > It doesn't give access to any new data...it's an S…
For established customers maybe not as there's a cost to switching but I'd be very surprised if this didn't have a hit on their signups going forward (once it's GA).
[deleted]
Re: Stripe Sigma
#78Earlier quoted context omitted.
$10/month is two coffees. Not even worth thinking about if you find the service at all useful.
> $10/month is two coffees. What?! Where does a single cup of coffee cost five dollars? For ten dollars, you can brew at least fifty cups of coffee.
I see you are not familiar with Bay Area artisanal pour-overs featuring hand picked organic berries harvested under a blue moon by Fair Trade certified farmers (TM).
The (TM) alone adds $0.50 to the price of a cup.
Re: Stripe Sigma
#79A couple of people have mentioned that Baremetrics should feel threatened, and that's where my mind went immediately too. I asked Josh Pigford for his reaction, and this is what he said: > We've had beta access to it for a while and have known it was coming. Generally not worried about it at all nor do we view it as any sort of competition in any sense of the word. > It doesn't give access to any new data...it's an S…
I'd have to agree with Josh. Sigma looks pretty cool because it would save me from having to write some custom query scripts that I have to do now. However it doesn't appear to be competition for the Baremetrics dashboard as far as I can tell. I'm a happy user of theirs and don't feel lured away by Sigma at all.
Edit: Additionally, the pricing seems a bit much considering that Stripe is already making a good deal of money off of their users transactions and it isn't so much trouble to write your own queries via their api.
Re: Stripe Sigma
#80Is the data freshness a joke? 2 DAYS to get data into the data warehouse? Stitch, Fivetran, Segment, and more can do way better than that without any internal hooks.... :/
> Additional processing time–up to 48 hours–is required to make your account’s transactional data available in Sigma. This means that it does not reflect your account’s most recent data and should be considered a couple days behind. The Sigma interface displays the date and time of the last update to your data.