Request for Looker Studio Pro details

Looker Q&A Looker Studio
1

Hi All,

I run a boutique analytics agency. I would like to know if i subscribe to Looker studio pro on our side :

  1. Can we connect with client data systems (PostgreSQL on AWS environment) ?

  2. Can the dashboards be accessible for clients by single sign on & view reports? – Please note that they are on the different domain but uses Google work space?

  3. Does the Performance of the reports generated by Studio Pro is better than normal studio? - Responsiveness & speed?

  4. Do we incur any additional costs from Google Cloud (or) any charges apart from the monthly subscription fee?

  5. Is it better from the performance perspective if we use our Google Cloud environment to clone the database from their AWS environment?

Looking forward to connecting and speaking before i subscribe to the Looker Studio Pro

2

@Naveen_Andey

  1. No difference between LS and LS Pro when connecting to databases.

  2. Yes, exact same like in LS

  3. No. It’s jus theh same. It’s more about how you connect the data. Use BigQuery with BI Engine and materialized tables when facing performance issues

  4. No

5.Yes. Its always better to use OLAP vs OLTP in this case (BigQuery vs AWS hosted Postgres). Also from cost perspective. Consider using Datastream for this.

regards
Arkady Zagdan
Bigglo.pl

1 Like
3

Thank you @ArkadyZagdan ;

On the point number 5, can you please expand “using Datastream”?

4

Refer to https://cloud.google.com/datastream/docs/overview

Its CDC replication from any SQL database.