Neo4j ETL & Snowflake

[lpfrnk]

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.

[davidrsetti]

Any updates for this issue. I am using the ETL UI and cannot connect to snowflake using JDBC.
I tried the same command and I have the same error.

[davidrsetti]

The connection now worked using jdbc, and without providing the name of the database on the URL.
David