Skip to content

Snowflake Protocol Compatibility

HeliosDB provides Snowflake SQL API compatibility, enabling seamless integration with Snowflake-native applications and tools.

Overview

Property Value
Protocol HTTP/REST (Snowflake SQL API)
Port 443
Status Production
Compatibility 90%+
Test Coverage 90%+

Quick Start

Python (snowflake-connector-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)

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

Last Updated: January 2026