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

R query - issue with running table names - fully-qualified vs scoped queries? #4

Open
imathews opened this issue Feb 4, 2022 · 0 comments
Assignees

Comments

@imathews
Copy link
Member

imathews commented Feb 4, 2022

Discussed in redivis/meta#185

Originally posted by lgraham333 February 1, 2022
According to the Redivis documentation's (linked here) second example for R code states in the code comments

"We don't need to include fully-qualified table names if we scope our query to the appropriate dataset or project".

When I run the given example code in R ...
data <- ( redivis::organization("Demo") $dataset("CMS 2014 Medicare Data") $query(" SELECT provider_name, average_total_payments FROM nursing_facilities INNER JOIN outpatient_charges USING (provider_id) WHERE state = 'CA' ") $to_tibble() )

I get the error ...

Error in make_request(method = "POST", path = "/queries", payload = payload) : Cannot look up unqualified table (nursing_facilities). Must be of the form "owner_name.project|dataset_name.table_name". Or perhaps you meant to set a default project?

Can someone help explain what is going on? (The other examples work from this webpage when I run them in R.)

Thank you!

@imathews imathews self-assigned this Feb 4, 2022
@imathews imathews transferred this issue from redivis/meta Feb 4, 2022
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

1 participant