> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/integrations/diagnose-spark-connectivity.md).

# Diagnose Spark connectivity

{% hint style="info" %}
If you are unsure about the `environment` parameter for your Spark to the Spark APIs, please see [FAQ](/support/faq.md#what-is-the-link-to-my-environment).
{% endhint %}

## Check server status

Every Spark environment has a health check endpoint. This can be accessed by visiting the address `https://excel.{environment}.coherent.global/health` in your web browser. If the environment is up, you should see the following response.

```json
{"status":"UP"}
```

## Time your connection to the Spark servers

To help diagnose any potential firewall or connectivity issues, you can use these [curl](https://curl.se/docs/manpage.html) commands to time the connection to Spark to see if there are significant lags or connectivity issues.

### Sample request

{% hint style="warning" %}
Make sure to replace `{environment}` with the environment that you are using.
{% endhint %}

<table><thead><tr><th>Bash</th><th>PowerShell</th></tr></thead><tbody><tr><td><pre class="language-sh" data-overflow="wrap"><code class="lang-sh">curl --silent --write-out "\n\n---Coherent Spark connection details---\nhttp_code: %{http_code}\nlocal_ip: %{local_ip}\nlocal_port: %{local_port}\nnum_connects: %{num_connects}\nnum_redirects: %{num_redirects}\nproxy_ssl_verify_result: %{proxy_ssl_verify_result}\nremote_ip: %{remote_ip}\nremote_port: %{remote_port}\nresponse_code: %{response_code}\nsize_download: %{size_download} B\nsize_header: %{size_header} B\nsize_request: %{size_request} B\nsize_upload: %{size_upload} B\nspeed_download: %{speed_download} Bps\nspeed_up: %{speed_upload} Bps\n---Coherent Spark connection time---\ntime_appconnect: %{time_appconnect}\ntime_connect: %{time_connect}\ntime_namelookup: %{time_namelookup}\ntime_pretransfer: %{time_pretransfer}\ntime_redirect: %{time_redirect}\ntime_starttransfer: %{time_starttransfer}\n---\ntime_total: %{time_total}\n" --location 'https://excel.{environment}.coherent.global/health'
</code></pre></td><td><pre class="language-powershell" data-overflow="wrap"><code class="lang-powershell">curl.exe --silent --write-out "\n\n---Coherent Spark connection details---\nhttp_code: %{http_code}\nlocal_ip: %{local_ip}\nlocal_port: %{local_port}\nnum_connects: %{num_connects}\nnum_redirects: %{num_redirects}\nproxy_ssl_verify_result: %{proxy_ssl_verify_result}\nremote_ip: %{remote_ip}\nremote_port: %{remote_port}\nresponse_code: %{response_code}\nsize_download: %{size_download} B\nsize_header: %{size_header} B\nsize_request: %{size_request} B\nsize_upload: %{size_upload} B\nspeed_download: %{speed_download} Bps\nspeed_up: %{speed_upload} Bps\n---Coherent Spark connection time---\ntime_appconnect: %{time_appconnect}\ntime_connect: %{time_connect}\ntime_namelookup: %{time_namelookup}\ntime_pretransfer: %{time_pretransfer}\ntime_redirect: %{time_redirect}\ntime_starttransfer: %{time_starttransfer}\n---\ntime_total: %{time_total}\n" --location 'https://excel.{environment}.coherent.global/health'
</code></pre></td></tr><tr><td></td><td>Note when using PowerShell, make sure you are using <code>curl.exe</code> and not <code>curl</code> which uses the <code>Invoke-WebRequest</code> command.</td></tr></tbody></table>

### Sample response

```sh
{"status":"UP"}

---Coherent Spark connection details---
http_code: 200
local_ip: 192.168.1.107
local_port: 59899
num_connects: 1
num_redirects: 0
proxy_ssl_verify_result: 0
remote_ip: 172.26.35.63
remote_port: 443
response_code: 200
size_download: 15 B
size_header: 204 B
size_request: 0 B
size_upload: 0 B
speed_download: 51 Bps
speed_up: 0 Bps
---Coherent Spark connection time---
time_appconnect: 0.229670
time_connect: 0.080042
time_namelookup: 0.021973
time_pretransfer: 0.229767
time_redirect: 0.000000
time_starttransfer: 0.288606
---
time_total: 0.289149
```