I have built all the node and relationship tables in Snowflake, and I follow the examples on how to run these graph algos following the graph projection in Snowflake without ETL using graph analytics. That is amazing.
Is there a way to run cypher queries simply on Snowflake? I went through the manual but could not find any examples with syntex.
I’m glad to hear you like our Neo4j Graph Analytics for Snowflake offering! Unfortunately it does not support Cypher queries; nor does it provide the full Neo4j database range of functionality, and only experimental support for visualization.
How would you like to use Cypher queries in Snowflake if it were possible?
Project a graph in Neo4j Graph Analytics, compute stuff, and query that graph?
Build a persistent graph in a Neo4j database from your Snowflake tables and query that database?
Or run Cypher directly over your tables?
This is all hypothetical, mind you I’m just curious how our Snowflake users think about using Cypher
@jonatan.jaderberg Thanks for replying.
I currently have a daily ETL schedule between SF and N4j, following that, I run WCC and then a handful of Cypher (aggregation) queries to study our customers’ behaviors with or without the generated WCC ID. Maybe these aggregation using Cypher can be converted to SF sql, but it is definitely easier to write with Cypher if you consider them as nodes and edges. For example, this avoids the need for multiple joins. The syntax is shorter and more natural, and the underlying graph engine is optimized for path traversal instead of join operations.