Neo4j ETL & Snowflake

Any suggestions on getting NEO4J ETl to read snowflake tables?

COMMAND: java -cp "C:\Users\xxx.Neo4jDesktop\graphApps_global\neo4j-etl-ui/dist/neo4j-etl.jar;C:\Users\xxxx\Downloads\snowflake-jdbc-3.8.5.jar" org.neo4j.etl.NeoIntegrationCli generate-metadata-mapping --rdbms:url "jdbc:snowflake://xxxxx.snowflakecomputing.com" --rdbms:password "xxxxx" --rdbms:user "neo4j" --schema "xxxxx" --output-mapping-file "C:\xxxxx.Neo4jDesktop\neo4jDatabases\database-044ce08b-9ec3-4542-8575-f9fd9a69b25a\installation-3.5.6/import/jdbc_xxx_LXPRDUSRF_mapping.json"

  • Skipping reading import options from file because file doesn't exist.

  • Creating RDBMS to CSV mappings...
    Available schema: INFORMATION_SCHEMA
    Available schema: xxxxx
    Available schema: INFORMATION_SCHEMA
    Available schema: PUBLIC
    Available schema: TPCDS_SF100TCL
    Available schema: TPCDS_SF10TCL
    Available schema: TPCH_SF001
    Available schema: TPCH_SF1
    Available schema: TPCH_SF10
    Available schema: TPCH_SF100
    Available schema: TPCH_SF1000
    Available schema: TPCH_SF10000
    Available schema: WEATHER

  • Using database plugin for

  • Crawling schemas

  • Retrieving all schemas

  • Retrieving all catalogs

  • Could not log SQL warnings for result set
    net.snowflake.client.jdbc.SnowflakeSQLException: Result set has been closed.
    at net.snowflake.client.jdbc.SnowflakeBaseResultSet.raiseSQLExceptionIfResultSetIsClosed(SnowflakeBaseResultSet.java:74)
    at net.snowflake.client.jdbc.SnowflakeBaseResultSet.getWarnings(SnowflakeBaseResultSet.java:286)
    at sf.util.DatabaseUtility.logSQLWarnings(DatabaseUtility.java:248)
    at schemacrawler.crawl.MetadataResultSet.next(MetadataResultSet.java:485)
    at schemacrawler.crawl.SchemaRetriever.retrieveAllSchemas(SchemaRetriever.java:181)
    at schemacrawler.crawl.SchemaRetriever.retrieveSchemas(SchemaRetriever.java:98)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlSchemas$11(SchemaCrawler.java:391)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlSchemas(SchemaCrawler.java:390)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:814)
    at schemacrawler.utility.SchemaCrawlerUtility.getCatalog(SchemaCrawlerUtility.java:75)
    at org.neo4j.etl.sql.DatabaseClient.getCatalog(DatabaseClient.java:148)
    at org.neo4j.etl.sql.DatabaseCatalog.(DatabaseCatalog.java:81)
    at org.neo4j.etl.sql.metadata.TableInfoAssembler.(TableInfoAssembler.java:35)
    at org.neo4j.etl.commands.DatabaseInspector.buildSchemaExport(DatabaseInspector.java:35)
    at org.neo4j.etl.commands.rdbms.GenerateMetadataMapping.call(GenerateMetadataMapping.java:110)
    at org.neo4j.etl.commands.rdbms.GenerateMetadataMapping.call(GenerateMetadataMapping.java:31)
    at org.neo4j.etl.cli.rdbms.GenerateMetadataMappingCli.run(GenerateMetadataMappingCli.java:118)
    at org.neo4j.etl.util.CliRunner.run(CliRunner.java:42)
    at org.neo4j.etl.util.CliRunner.run(CliRunner.java:35)
    at org.neo4j.etl.NeoIntegrationCli.main(NeoIntegrationCli.java:43)

  • Processed 13 rows for

  • Retrieved 0 schemas

  • Total time taken for - 00:00:00.397 hours
    -100.0% - 00:00:00.397 -

  • 0.0% - 00:00:00.000 -

  • Command failed due to error (SQLException: No matching schemas found). Rerun with --debug flag for detailed diagnostic information.