databricks-sql-cli
databricks-sql-cli copied to clipboard
Feature Request: json should be an output format option
Hello,
I may wish to return this as a json format where each row is a record.
Note this is a current workaround for returning a query in json format
jq --raw-output <<< "$( \
dbsqlcli \
--execute \
'
SELECT * FROM TABLE
' | \
python -c "import pandas as pd; import sys; print(pd.read_csv(sys.stdin).to_json(orient='records'))" \
)"