Skip to main content

Elasticsearch

The Elasticsearch connection talks to Elasticsearch 8.x (or compatible) using either host/port or Elastic Cloud ID, with flexible auth options.

What FunnelStory uses it for​

  • Data models — SQL-style queries run against Elasticsearch-backed virtual tables.

Before you connect​

  • If the cluster only accepts traffic from known IPs, allow FunnelStory’s static egress addresses from Allowed IP addresses.
  • Gather either:
    • host and port (HTTPS URL is built as https://{host}:{port}), or
    • cloud_id for Elastic Cloud.
  • Choose one auth mode:
    • user + password, or
    • api_key, or
    • service_token.

Add the connection in FunnelStory​

  1. Open Configuration → Connections → Add connection, then choose Elasticsearch.

  2. Complete the fields in the connection form (only the combination your cluster needs):

Elasticsearch connection form

FieldDescription
Connection nameDisplay name.
hostCluster hostname (with port).
portHTTPS port (often 9243 or 443).
cloud_idElastic Cloud deployment id (alternative to host/port).
user / passwordBasic authentication.
api_keyBase64-style API key auth.
service_tokenBearer service token when used.
  1. Click Validate, then Add Connection.

After you connect​

Author queries in the model builder and refresh on schedule. For clusters only reachable inside a VPC, use private networking options or an SSH tunnel if your workspace supports it.