r4ntix commented on issue #6763:
URL:
https://github.com/apache/arrow-datafusion/issues/6763#issuecomment-1606108019
The current datafusion-cli has the ability to execute sql file and format
the output:
```shell
$ echo 'show tables;' > sql.txt
$ ./target/debug/datafusion-cli --file sql.txt --format json
DataFusion CLI v26.0.0
[{"table_catalog":"datafusion","table_name":"tables","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"views","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"columns","table_schema":"information_schema","table_type":"VIEW"},{"table_catalog":"datafusion","table_name":"df_settings","table_schema":"information_schema","table_type":"VIEW"}]
4 rows in set. Query took 0.045 seconds.
```
I don't know if this will work for you? 🤔️
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]