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

Bigquery with bigrquery . unable to find method for dbGetQuery #534

Open
joscani opened this issue Apr 21, 2024 · 0 comments
Open

Bigquery with bigrquery . unable to find method for dbGetQuery #534

joscani opened this issue Apr 21, 2024 · 0 comments
Assignees

Comments

@joscani
Copy link

joscani commented Apr 21, 2024

Hi. I'm trying to use pointblank with bigquery tables , loaded with bigrquery library and use src_bigquery to get conection

My table looks like this

> tabla3
Job complete
Billed: 0 B
Downloading first chunk of data.
First chunk includes all requested rows.
# Source:   SQL [?? x 41]
# Database: BigQueryConnection
   customerID gender_x SeniorCitizen_x Partner_x Dependents_x tenure_x
   <chr>      <chr>              <int> <lgl>     <lgl>           <int>
 1 9732-OUYRN Female                 0 TRUE      FALSE              49
 2 0661-KQHNK Female                 0 TRUE      TRUE                6
 3 4709-LKHYG Female                 0 TRUE      TRUE               29
 4 9824-QCJPK Male                   0 TRUE      FALSE              36
 5 4716-MRVEN Female                 0 FALSE     FALSE              29
 6 8084-OIVBS Female                 0 FALSE     FALSE              11
 7 4323-ELYYB Male                   0 TRUE      TRUE               13
 8 0967-BMLBD Female                 0 TRUE      TRUE               11
 9 1269-FOYWN Male                   0 TRUE      TRUE               44
10 3556-BVQGL Female                 0 TRUE      FALSE              20
# ℹ more rows
# ℹ 35 more variables: PhoneService_x <lgl>, MultipleLines_x <chr>,
#   InternetService_x <chr>, OnlineSecurity_x <chr>, OnlineBackup_x <chr>,
#   DeviceProtection_x <chr>, TechSupport_x <chr>, StreamingTV_x <chr>,
#   StreamingMovies_x <chr>, Contract_x <chr>, PaperlessBilling_x <lgl>,
#   PaymentMethod_x <chr>, MonthlyCharges_x <dbl>, TotalCharges_x <chr>,
#   Churn_x <lgl>, gender_y <chr>, SeniorCitizen_y <int>, Partner_y <lgl>, …
# ℹ Use `print(n = ...)` to see more rows

I'm trying to use pointblank

agent <- create_agent(
                      tbl = tabla3) %>% 
          col_vals_gt(vars(tenure_x), value = 20) %>%
          interrogate()

and I get the error

Error in (function (classes, fdef, mtable)  : 
  unable to find an inherited method for functiondbGetQueryfor signature"Bi
gQueryConnection", "NULL"

Is a bug o maybe pointblank doesn't support bigquery tables? . It could be fantastic if I can use pointblank with bigquery.
Thanks

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

No branches or pull requests

2 participants