Snowflake connector failure

1

Hi, I’m evaluating use of Dremio to connect to Snowflake. I’ve downloaded the snowflake connector, and modified the dremio-oss docker build to copy that jar into the /opt/dremio/jars folder. However when I attempt to start the container I get the following error

java.lang.NoClassDefFoundError: com/dremio/exec/store/jdbc/dialect/JdbcDremioSqlDialect
	at java.lang.Class.forName0(Native Method) ~[na:1.8.0_332]
	at java.lang.Class.forName(Class.java:264) ~[na:1.8.0_332]
	at com.dremio.common.scanner.persistence.ScanResult.getAnnotatedClasses(ScanResult.java:175) ~[dremio-common-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.exec.catalog.ConnectionReaderImpl.getCandidateSources(ConnectionReaderImpl.java:87) ~[dremio-sabot-kernel-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.exec.catalog.ConnectionReaderImpl.makeReader(ConnectionReaderImpl.java:68) ~[dremio-sabot-kernel-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_332]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_332]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_332]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_332]
	at com.dremio.exec.catalog.ConnectionReader.of(ConnectionReader.java:69) ~[dremio-sabot-kernel-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.dac.daemon.DACDaemonModule.build(DACDaemonModule.java:224) ~[dremio-dac-backend-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.dac.daemon.DACDaemon.<init>(DACDaemon.java:167) ~[dremio-dac-backend-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.dac.daemon.DACDaemon.newDremioDaemon(DACDaemon.java:267) ~[dremio-dac-backend-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
	at com.dremio.dac.daemon.DremioDaemon.main(DremioDaemon.java:108) ~[dremio-dac-daemon-3.0.1-201811132128360291-804fe82.jar:3.0.1-201811132128360291-804fe82]
Caused by: java.lang.ClassNotFoundException: com.dremio.exec.store.jdbc.dialect.JdbcDremioSqlDialect
	at java.net.URLClassLoader.findClass(URLClassLoader.java:387) ~[na:1.8.0_332]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418) ~[na:1.8.0_332]
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:352) ~[na:1.8.0_332]
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ~[na:1.8.0_332]

Can you advise if I need an additional jar or whether the connector is out-of-step with dremio-oss?

Kind Regards,
Mike Smith

2

This turned out to be an issue with my Dockerfile, I had cloned the dremio-oss dockerfile and adjusted, my colleague performed the same basic steps but extended the dremio-oss docker image and that worked perfectly.