search

rilldata / rill

Rill is a tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. BI-as-code.
https://www.rilldata.com
Apache License 2.0
1.6k stars 111 forks source link

Error Handling for CH OLAP engine #5199

Open royendo opened 1 month ago

royendo commented 1 month ago

Is your feature request related to a problem? Please describe. Although this might be more of how Clickhouse returns the error message as we just surface it, when using CH as the OLAP engine and the IP address isn't added, the error is a EOF, instead of something more specific. Screenshot 2024-07-08 at 16 11 31

Screenshot 2024-07-08 at 16 08 21

Describe the solution you'd like Possibly, we could add some context for when connections are not working. Such as, have you checked the connectivity between the two servers? In the case of CH, if you have set to "specific IP address", have you added your current IP address?

Describe alternatives you've considered

Additional context In the CH developer course, it suggest to use this approach for security purposes (setting to set IP addresses

royendo commented 1 month ago

Also in the case of the above, if the following is resolved while Rill is running, and you try to resave the connector settings or refresh, it will not attempt to re-connect. will need to restart Rill from CLI.