Max size for SQL request for segment?

I’m using SQL request to define segments. The given request is working well on console but not on Forest. I’m displayed the “cannot reach your data” message, only on this segment. Btw, the request also work in “Dashbord” while using SELECT COUNT (xxx.id) as value.

The request is a bit long (500 lines), is there a maximum limit for request-length for segment?

Thanks,

Guillaume

Hi @Guillaume,
Welcome to the Forest Admin community!

I am not sure this is a SQL query size limitation. Especially if the same query works to display a chart in a dashboard.

The “cannot reach your data” error message might be due to a request timeout (more than 30 seconds).
But it could come from something else.

Does your Admin API backend generate any error logs?
What is the approximate execution time for your SQL query?

Thanks for your help!