Looker Studio reports on your Amazon warehouse
Connect Looker Studio to Postgres and choose the tables or SQL queries your reports need.
How it works
Open Google's Postgres connector
Use Google's PostgreSQL connector to connect a table or a custom SQL query.
Configure database access
Use your workspace's read-only database credentials and configure the network access required by Google's connector.
Build the dashboards your team needs
Use Core's schema documentation to choose the tables and fields your reports need.
What you get
Configure data freshness
Looker Studio can reuse stored query results within its data freshness settings. Choose a freshness setting that fits your reports.
Plan reports by workspace
If you keep clients in separate workspaces, you can plan a report for each client's data. Configure each connection with the credentials and access it needs.
Write your own SQL
Use a custom SQL query when a report needs selected fields or aggregates.
No per-query fees
DataBrill Core does not meter SQL queries.
Connection, table, and custom-query guidance: Google PostgreSQL connector. Data freshness and stored query results: Google data freshness. Checked .