Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

awsathena driver does not support \d #375

Open
forbesmyester opened this issue Sep 21, 2022 · 4 comments
Open

awsathena driver does not support \d #375

forbesmyester opened this issue Sep 21, 2022 · 4 comments

Comments

@forbesmyester
Copy link

I can connect to Athena using:

$ usql 's3://__S3_STAGING_DIR_NOT_URL_ENCODE_WITH_TRAILING_FORWARDSLASH_ALSO_NOT_ENCODED?WGRemoteCreation=true&accessID=__THE_ACCESS_KEY__&db=__DATABASE_NAME_PROBABLY_URLENCODED_&missingAsEmptyString=true&region=eu-west-2&secretAccessKey=__THE_SECRET_URLENCODED__'

Which does work / can query

However \d does not (not supported by awsathena driver).

s3:__S3_STAGING_DIR_NOT_URL_ENCODE_WITH_TRAILING_FORWARDSLASH_ALSO_NOT_ENCODED=> \d
error: describe commands not supported by awsathena driver
$ usql --version
usql 0.12.13
@nineinchnick
Copy link
Member

I haven't used Athena but it's using Presto/Trino so I hope it's enough to plug in the default informationschema metadata reader, like we do for Trino: https://github.com/xo/usql/blob/master/drivers/trino/trino.go#L58

@forbesmyester
Copy link
Author

I can confirm it does have an information schema... I am unsure if the format conforms to Presto or anything else though.

@abhishekgahlot2
Copy link

abhishekgahlot2 commented Aug 6, 2024

Hi, would you be open to have a PR for this. Not sure if anyone is already working on this

@kenshaw
Copy link
Member

kenshaw commented Aug 6, 2024

@abhishekgahlot2 Yes, absolutely.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants