Snowflake

This is the public preview documentation of Neo4j Virtual Graph. To provide feedback, please use the feedback form you were granted access to.

During the public preview, we advise you not to use sensitive or production data with Virtual Graph.

This driver is required by data source definitions of type snowflake.

Refer to the Snowflake JDBC Driver documentation. All options can be passed via the datasource.json configuration.

Direct download

curl -O https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/4.3.0/snowflake-jdbc-4.3.0.jar

Maven coordinates

 <dependency>
    <groupId>net.snowflake</groupId>
    <artifactId>snowflake-jdbc</artifactId>
    <version>4.3.0</version>
  </dependency>

Configuration

The data source definition for this driver requires the following information:

{
  "type": "snowflake",
  "host": "sample_url_part.snowflakecomputing.com",
  "database": "sample_database",
  "schema": "sample_schema",
  "warehouse": "sample_warehouse",
  "role": "sample_role"
}

The example uses sample values only. Replace them with your actual connection details before use.

The warehouse and role fields are optional.

Virtual Graph works with a private-key based secret with that configuration.

Limiting the number of fetched rows

Judging from the JDBC driver source code, JDBC fetch size might be supported. However, the Snowflake documentation recommends using the following for restricting either memory pressure or fetch size:

These can be configured under the same names inside additionalProperties.