---
title: "Snowflake Protocol Compatibility"
---

# Snowflake Protocol Compatibility

:::caution[Planned: not in the current release]
Snowflake SQL API compatibility for HeliosDB Full is planned. Today, the HTTP gateway answers `/snowflake/` paths with `501 Not Implemented`. Reach
the same data over the PostgreSQL listener or `POST /api/v1/query` today. This page
describes the planned interface.
:::

Snowflake SQL API compatibility for HeliosDB is planned, for integration with Snowflake-native applications and tools.

## Overview

| Property | Value |
|----------|-------|
| **Protocol** | HTTP/REST (Snowflake SQL API) |
| **Port** | 443 |
| **State** | Planned |
| **Compatibility** | 90%+ |
| **Test Coverage** | 90%+ |

## Quick Start

### Python (snowflake-connector-python)

```python
import snowflake.connector

conn = snowflake.connector.connect(
    host="localhost",
    port=443,
    user="admin",
    password="password",
    account="heliosdb",
    warehouse="compute_wh",
    database="mydb",
    schema="public"
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM users LIMIT 10")
for row in cursor.fetchall():
    print(row)
conn.close()
```

### JavaScript (snowflake-sdk)

```javascript
const snowflake = require('snowflake-sdk');

const connection = snowflake.createConnection({
  host: 'localhost',
  port: 443,
  account: 'heliosdb',
  username: 'admin',
  password: 'password',
  warehouse: 'compute_wh',
  database: 'mydb'
});

connection.connect((err, conn) => {
  if (err) {
    console.error('Connection failed:', err);
    return;
  }
  conn.execute({
    sqlText: 'SELECT * FROM users LIMIT 10',
    complete: (err, stmt, rows) => {
      if (err) {
        console.error('Query failed:', err);
        return;
      }
      console.log('Rows:', rows);
    }
  });
});
```

## Key Features

- Time Travel queries with AT/BEFORE syntax
- VARIANT semi-structured data type
- FLATTEN function for nested data
- Virtual Warehouse management
- COPY INTO for bulk data loading
- Full SQL compatibility

## Documentation

- **[CONFIGURATION.md](https://www.heliosdb.com/docs/full/reference/protocols/snowflake/configuration/)** - Server configuration options
- **[COMPATIBILITY.md](https://www.heliosdb.com/docs/full/reference/protocols/snowflake/compatibility/)** - Feature compatibility matrix
- **[EXAMPLES.md](https://www.heliosdb.com/docs/full/reference/protocols/snowflake/examples/)** - Code examples and patterns

## Related Resources

- [Protocol Quick Starts](/docs/full/quick-starts/protocols/) - Getting started guides
- [HTTP/REST API](/docs/full/reference/protocols/http-rest/) - REST API reference

---