Skip to content
New issue

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

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

Already on GitHub? # to your account

Can't denote DuckDB table with custom schema using %sqlplot #854

Closed
alexlowellmartin opened this issue Sep 1, 2023 · 2 comments · Fixed by #855
Closed

Can't denote DuckDB table with custom schema using %sqlplot #854

alexlowellmartin opened this issue Sep 1, 2023 · 2 comments · Fixed by #855
Assignees

Comments

@alexlowellmartin
Copy link

alexlowellmartin commented Sep 1, 2023

I've not been able to execute %sqlplot referencing a DuckDB table or view with a custom schema.

Ideally tables and views within a custom schemas could be referenced either automatically with schema_name.table_name syntax or with the addition of a --schema argument. (Or both)

Table with custom schema:
image

@alexlowellmartin alexlowellmartin changed the title Can't denote DuckDB table with custom schema %sqlplot Can't denote DuckDB table with custom schema using %sqlplot Sep 1, 2023
@edublancas
Copy link

hey @bbeat2782 this is similar to the PR we just merged, essentially --table schema.table should work, and --table table --schema schema as well

@bbeat2782
Copy link

Acceptance Criteria

  1. Make sure --table schema.table and --schema schema --table table works for all plots in %sqlplot
  2. Add test functions

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

Successfully merging a pull request may close this issue.

3 participants