Neo4j and Snowflake Cloud Database

Trying to get Neo4j ETL to function with Snowflake. Is the source code available? or can the connection be evaluated? The system is unable to read the tables. It is able to identify the available schemas.

  • 90.9% - 00:00:00.010 -

  • 9.1% - 00:00:00.001 -

  • Crawling tables

  • Retrieving tables

  • Retrieving tables for schema <xxx.LXPRDUSRF>

  • 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.TableRetriever.retrieveTablesFromMetadata(TableRetriever.java:242)
    at schemacrawler.crawl.TableRetriever.retrieveTables(TableRetriever.java:118)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$17(SchemaCrawler.java:585)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:582)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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 33 rows for

  • Retrieved 33 tables

  • Retrieving table columns

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)

  • 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.TableColumnRetriever.retrieveColumnsFromMetadata(TableColumnRetriever.java:304)
    at schemacrawler.crawl.TableColumnRetriever.retrieveColumns(TableColumnRetriever.java:107)
    at schemacrawler.crawl.SchemaCrawler.lambda$crawlTables$18(SchemaCrawler.java:603)
    at sf.util.StopWatch.time(StopWatch.java:185)
    at schemacrawler.crawl.SchemaCrawler.crawlTables(SchemaCrawler.java:600)
    at schemacrawler.crawl.SchemaCrawler.crawl(SchemaCrawler.java:817)
    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)