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 datasource definition for this driver requires the following information:
{
"type" : "snowflake",
"host" : "HIYSSHM-TEAM_GRAPH_INTELLIGENCE_ENGINE.snowflakecomputing.com",
"database" : "MOVIES",
"schema" : "V2",
"warehouse" : "DEFAULT_WAREHOUSE",
"role" : "movie_admin"
}
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.