Skip to content

Support Snowflake in the SQL language server #31

Description

@Artmann

Add Snowflake support to the SQL language server so Snowflake SQL blocks in the Deepnote VS Code extension get table and column completions and diagnostics.

Current state

packages/server/src/database_libs has clients for BigQuery, MySQL, Postgres and SQLite (BigqueryClient.ts, MysqlClient.ts, PostgresClient.ts, Sqlite3Client.ts). There is no Snowflake client, so a Snowflake integration in the extension gets no schema-aware completions.

Needed

  • A SnowflakeClient implementing AbstractClient (schema, table and column introspection, likely via snowflake-sdk or INFORMATION_SCHEMA queries).
  • Connection configuration for Snowflake in getDatabaseClient and the settings schema (account, warehouse, database, schema, role, auth method).
  • Dialect handling for Snowflake-specific syntax where the parser needs it.

The extension side is a dependency bump plus mapping its Snowflake integration config onto the new connection settings. It was originally filed as #31.

Activity

  1. coderabbitai commented on Dec 1, 2025

    @coderabbitai

    Duplicate Detection

    ℹ️ This issue may be similar to deepnote/vscode-deepnote#231.

    Related Issues

    Suggested Issue Assignees

    • Artmann

    Actions

    • 📝 Generate an implementation plan for this issue

    ℹ️ Note: Issue enrichment is currently in early access.

    Disable automatic issue enrichment

    To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

    issue_enrichment:
      auto_enrich:
        enabled: false
  2. added theissue type on Dec 5, 2025
  3. jamesbhobbs commented on Sep 10, 2026

    @jamesbhobbs

    Filled in the empty description and transferring this to deepnote/sql-language-server, where the work lives. The language server the extension bundles is that fork, and it currently ships BigQuery, MySQL, Postgres and SQLite clients but no Snowflake client. Once a Snowflake client exists, the extension change is a version bump plus mapping its Snowflake integration config onto the new connection settings, which can be a small follow-up here.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions