> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# MakeLine

The **MakeLine** function constructs a LineString from a series of Point or LineString data.

This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

## Syntax

```
MakeLine(geo1, geo2, ...)
```

Function arguments:

<dl>
  <dt>
    geo1
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    A valid point or line value that can be located on the Earth's sphere; must comply with the 

    <a href="https://en.wikipedia.org/wiki/Geographic_coordinate_system" target="_self">Geographic Coordinate System</a>
  </dd>

  <dt>
    geo2
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    A valid point or line value that can be located on the Earth's sphere; must comply with the 

    <a href="https://en.wikipedia.org/wiki/Geographic_coordinate_system" target="_self">Geographic Coordinate System</a>
  </dd>

  <dt>
    geo3 through geoN
  </dt>

  <dd>
    Optional
  </dd>

  <dd>
    A valid point or line value that can be located on the Earth's sphere; must comply with the 

    <a href="https://en.wikipedia.org/wiki/Geographic_coordinate_system" target="_self">Geographic Coordinate System</a>
  </dd>
</dl>

## Notes

* On BigQuery, Databricks, and Snowflake connections, arguments can be either points or lines. On Starburst connections, arguments must be points.

* When using line segments in arguments, Sigma treats the terminal points of the line as separate points, in order. For example, the following expressions are identical:

  ```
  MakeLine(point1, MakeLine(point2, point3), MakeLine(point4, point5, point6))
  ```

  ```
  MakeLine(point1, point2, point3, point4, point5, point6)
  ```

## Examples

### Example 1

```
MakeLine([Point], MakePoint(-74.044502, 40.689247))
```

Creates lines between the points in the **Point** column, and the location of the Statue of Liberty at coordinates (`-74.044502`, `40.689247`)

### Example 2

```
MakeLine(MakePoint(2.294481, 48.85837), [Point], MakePoint(-74.044502, 40.689247))
```

Creates lines between the location of the Eiffel Tower (`2.294481`, `48.85837`), the **Point** column, and the location of the Statue of Liberty (`-74.044502`, `40.689247`)

### Example 3

```
MakeLine(MakeLine(MakePoint(48.85837, 2.294481), MakePoint(-0.075278, 51.505554)), [Point], MakeLine(MakePoint(40.689247, -74.044502), MakePoint(-77.050636, 38.889248)))
```

Creates lines between the line between the Eiffel Tower (`2.294481`, `48.85837`) and the Tower Bridge ( `-0.075278`, `51.505554`), the **Point** column, and the line between the Empire State building (`-73.985428`, `40.748817`) and the Lincoln Memorial (`-77.050636`, `38.889248`).

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/dfbf2e65d7d1d775f15df57e713a3206b47bce45e61078003056f01df9fac226/assets/docs-images/642f5e7-function-makeline-example.png)

## Related resources

* [MakePoint](/docs/makepoint)
* [Geography functions](/docs/geography-functions)