Google Cloud BigQuery vs AWS Redshift (and AWS Athena)

Related video: AWS Athena: • AWS Athena Overview - ...
Comparison of Goolge BigQuery vs AWS Redshift (and AWS Athena)
- Understand AWS Options: AWS Redshift + AWS Redshift Spectrum + AWS Athena
- BigQuery Architecture vs Redshift Architecture
- Compare BigQuery Vs Redshift
Comparison along parameters:
Simplicity
•Project & team velocity
•Manageability
Performance
•Tunable vs Blackbox
•Overhead in managing system and skills
Cost
•Idle time
•Spikey workloads vs Steady workload. Data caching
Ecosystem
•Development tools
•Integration with 3rd party BI vendors
•Broader data management in the vendors cloud offering
Related video: AWS Athena Overview: • AWS Athena Overview - ...

[@akin242002]

I'm more familiar with Google BigQuery, but it is interesting hearing about AWS Redshift. Both are the big dogs for Big data analysis and warehouse storage.

[@clintonchikwata4049]

This is very clear and well detailed Thanks

[@andresfeliperiostamayo7307]

Gracias, muy clara y detallada la info.

[@nomadicabhishek2563]

Amazing work Sir, thanks for sharing your knowledge. I am planning to use BigQuery for one of my client's DMP.
But I have a question, what are the best BI tools for BigQuery (like AWS has Quicksight)?
I am looking for cost-effective and easy to integrate BI tool for the big query, If you have some recommendation, it will be a big help.

[@melvinl5797]

Start exploring with google data studio and Looker(google acquired them so should have strong integration with big query) see this link for more medium.com/google-cloud/which-bi-tool-for-big-query-d9eb838ff7ad

[@ankitlakum1]

@@melvinl5797 thanks 😊

[@seleldjdfmn221]

Amazing work. What app is That? #great xD

[@akashn1891]

i can hardly hear you

[@user-jy2sz1jr9p]

You should try speaking more softly or moving the microphone away - it's still possible to hear some of the stuff you say.