Using schema instead of file paths in SQLs #168
Unanswered
siripurapugopi
asked this question in
Q&A
Replies: 1 comment
-
This is out of the scope of this plugin. It might be better to discuss this idea in the Trino Slack first. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Is it possible to provide schema of files(csv, tsv, txt...etc) and use these for running SQLs.
Instead of running
select * from storage.csv."/tmp/sales.csv"
, I want to run something likeselect * from storage.my_db.sales
;I tried creating a json file (etc/storage/sales.json, same attached as json.csv here) similar to what is mentioned under resources ([https://github.com/snowlift/trino-storage/blob/master/src/test/resources/example-data/example-metadata.json]). However I don't see any schema, table showing in Superset.
sales.csv
Beta Was this translation helpful? Give feedback.
All reactions