Is there a way we can query Dremio from VS Code using any of the extensions, there are some extensions like SQLTools which support multiple data sources & Dremio is not one of them, was wondering if someone has ideas
@rdkworld Currently no, Dremio is a query engine and can query your data directly. What files in Dremio are you trying to query?
@rdkworld We’ll be releasing Dremio’s extension for VS Code next month ![]()
It will be able to connect to Dremio Software and Dremio Cloud. You’ll be be able to query your data and there will be an integration with Copilot to converse with data directly from VS Code.
This is awesome update @isha, really looking forward to it and subsequently using it with Github pilot, @balaji.ramaswamy it is to to query any Dremio dataset from a IDE like any Sql clieny
Thanks @lenoyjacob, installed, trying to add Dremio software connection, enter server name with port, then PAT, enter, nothing happens, In VS Code, on bottom left, I see Dremio No Account selected and clicking on it asks to enter Select an account (which I am not sure what it is unless it same as Dremio Software hostname). EDIT - replaced port 947 with 443, moved to next step and can see connection without catalog with this error…
Tried to unwrap Error: Error: maxChildren query parameter must be set to [1,20]
at x (c:\……\extensions\dremio.dremio-vscode-0.0.3\dist\extension.js:52:17462)
at c:\Users\….\extensions\dremio.dremio-vscode-0.0.3\dist\extension.js:57:96118
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async Promise.all (index 0)
at async c:….\dremio.dremio-vscode-0.0.3\dist\extension.js:57:78808
at async c:…..\extensions\dremio.dremio-vscode-0.0.3\dist\extension.js:57:11576