5 ms·

>For next person commenting that it makes sense: it doesn't with 200gb database and super predictable workload, growth and usage. Depends on the company. I've

>For next person commenting that it makes sense: it doesn't with 200gb database and super predictable workload, growth and usage. Depends on the company. I've been working for marketing agencies for the last 15 years and they're generally staffed by, at most, 1 IT person who is in charge of a third-party vendor relationship that offers managed IT services. Those IT resources (internal or vendor) don't specialize in data and often don't know how to deal with it well, predictable workloads or not, and often offer up solutions which are not appropriate (cost or otherwise) whereas there are managed solutions from cloud vendors that do. BigQuery, for example, handles compute and storage for you and rolls it into one reasonable query price. No need to worry about any management of anything there and just sit Data Studio (included) or any other BI tool (Tableau, etc) on top and you're good to go. I get your skepticism and welcome it, but you're being a little rough. We're cloud native at my current company (I did a partial cloud migration at my last which was completed after I left) and it makes my life leading a Data Engineering and Data Science team MUCH easier without upfront hardware/software costs or long-term contracts, which were STAGGERING and left us with much more difficult to maintain, upgrade, etc hardware that took up most of my job as opposed to almost none of it today. YMMV.

i_like_waiting 4y ago
Partially depends but company with 1 IT person that is not data focused, there is low probability that they will have that amount of data. For anything above what we have I think it weirdly depends on country/ salaries. In US, 100k per year is no brainer for cloud as even 1 FTE would cost much more. In non-western Europe, 100k is deal killer as you can hire 2 senior DBAs and you still have enough money for quite a reasonable server.
- garciasn 4y ago
  With extensive experience in this vertical, (marketing agency and analytics), 200GB is a _partial_ day for one datasource, let alone table or total DB size.
  - i_like_waiting 4y ago
    but does team have 1 IT/ data person? Edit: sorry I see that you are the same person I was replying to. Then to understand it better, who is consumer of so vast amount of data?
    - deleted 4y ago
      [deleted]
    - garciasn 4y ago
      The company has 1 IT person and uses a third-party vendor for IT support. We have several data engineers and scientists, but we are not specialists as DBA or cloud infrastructure; it's just one very small part of our work.
      - i_like_waiting 4y ago
        Interesting, thats correct, its segment of the companies that I didn't take into consideration. Thanks
funcDropShadow 4y ago
> 1 IT person who is in charge of a third-party vendor relationship that offers managed IT services That is something completely different from migrating your inhouse applications to the cloud by introducing kubernetes. I think your example show nicely that there is not one solution for everything. As an industry we have to put way more emphasis on deciding tradeoffs by understanding requirements and risks.

i_like_waiting 4y ago

Partially depends but company with 1 IT person that is not data focused, there is low probability that they will have that amount of data. For anything above what we have I think it weirdly depends on country/ salaries. In US, 100k per year is no brainer for cloud as even 1 FTE would cost much more. In non-western Europe, 100k is deal killer as you can hire 2 senior DBAs and you still have enough money for quite a reasonable server.

garciasn 4y ago
With extensive experience in this vertical, (marketing agency and analytics), 200GB is a _partial_ day for one datasource, let alone table or total DB size.
- i_like_waiting 4y ago
  but does team have 1 IT/ data person? Edit: sorry I see that you are the same person I was replying to. Then to understand it better, who is consumer of so vast amount of data?
  - deleted 4y ago
    [deleted]
  - garciasn 4y ago
    The company has 1 IT person and uses a third-party vendor for IT support. We have several data engineers and scientists, but we are not specialists as DBA or cloud infrastructure; it's just one very small part of our work.
    - i_like_waiting 4y ago
      Interesting, thats correct, its segment of the companies that I didn't take into consideration. Thanks

funcDropShadow 4y ago

> 1 IT person who is in charge of a third-party vendor relationship that offers managed IT services That is something completely different from migrating your inhouse applications to the cloud by introducing kubernetes. I think your example show nicely that there is not one solution for everything. As an industry we have to put way more emphasis on deciding tradeoffs by understanding requirements and risks.