Description:
Hello everyone,
I'm currently facing an issue when trying to import a large(or not) table into Looker Studio. The table in question is a same db in the other works fine dashboard, which contains approximately 239,145 rows. I have successfully imported larger tables in same db at same server into Looker Studio before, but for some reason, this particular table is causing problems.
And the same time other tables in same db same server is works well and I checked user to login ,it has same privileges as other table
Here are the details of my setup and the steps I've taken:
Table privileges:
SELECT * FROM information_schema.TABLE_PRIVILEGES
WHERE TABLE_SCHEMA = 'Mintgral' AND TABLE_NAME = 'tablename'
NO DATA
Query Plan:
When I run EXPLAIN SELECT * FROM #tablename#, the result shows a full table scan with no index usage:
EXPLAIN SELECT * FROM tablename
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE tablename NULL ALL NULL NULL NULL NULL 282392 100.00 NULL
Attempts Made:
- I have created a new data source specifically for this table.
- I've added composite indexes on stat_date, stat_time, country, and ad_unit fields.
- I've tried limiting the query to SELECT * FROM tablename LIMIT 1000, which works fine.
Error:
When trying to import the full table into Looker Studio, I encounter a timeout or error, despite having successfully imported larger tables in the past.
Question:
Has anyone experienced a similar issue with Looker Studio when importing some tables? Any suggestions on how to resolve this problem would be greatly appreciated.
Thank you!
LinkedIn
Twitter
