How to run sql from the command line against a dremio instance

Dremio University
1

I am writing software in collaboration with Claude 3.7 using Cline in VS Code. I like to give my assistant access to my local Dremio instance, which works best using the command line. I found the dremio_client project, but that project is archived.
Its cli looked like this:

dremio_client query --sql 'select * from sys.options'

Which would be very helpful to me.

Are there any similar tools I could use; preferably sth that ships with dremio_oss?

2

@serra You can use something like isql using Linux ODBC and run SQL from command line

isql -v ArrowFlightSQLODBCDSN
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| echo [string]                         |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>