Passing Storage Name while connecting to Apache Drill

Database Support
#1

Hello Helical Insight,

I am using Helical Insight 4.0. I am connecting to my MongoDB via Apache Drill. I have multiple storages created on Apache Drill. Is there a way to specify which storage I want to connect to?

Thank You,
Jam.

#2

Hello Jam,

Apache Drill connection string accepts the storage name as one of the parameters. This can be passed in Helical Insight using “Advanced” option while creating the connection.

image

In the “Other Options” you can provide the string

;schema=

Where is the name of the storage that you want to connect to. This will be appended in the URL.

Thank You,
Helical Insight.