Looker database connection limits

[augustoMSM]

Hi! I would like to know if is there any query or table size limits when connecting Looker to PostgreSQL databases? In Looker Studio there's a 150K rows limit, for instance. Also, an additional (less important) question: if I migrate from Looker Studio to Looker can I keep my dashboards (transfer them from Looker Studio to Looker)?Thanks!

[karol_tdutra]

Hi Augusto, I'm looking forward to this answer. I've used a connection with a query with more than 150k rows, and everything looks to work well. I'm wondering if this limitation is out of date. Have you tried? I'm worried about using it with a client and that some errors can occur.

[augustoMSM]

Hi, Karol! I appreciate your comments. We still have the same limitation problem. If you create a report table with all the columns available in your DB table you should see the limitation where it shows the number of elements in the report table. For instance, with 100 elements per table page, you would see "100/150000" when visualizing the first page. Probably, we are moving to another tool soon. The Looker Pro also has this limitation. Thank you!

[karol_tdutra]

Oh, ok! Thank you for share this!! 🙏