Query BigQuery throws error: Error in strsplit(name, ".", fixed = TRUE) : non-character argument
Lately I tried to query BigQuery using bigrquery
. Unfortunately I got an error:
Error in strsplit(name, ".", fixed = TRUE) : non-character argument
Lately I tried to query BigQuery using bigrquery
. Unfortunately I got an error:
Error in strsplit(name, ".", fixed = TRUE) : non-character argument
Lately I wanted to play around with nflfastR. That’s a great package giving you access to NFL’s play-by-play data since 1999. It let’s you download all the data and store it in several different databases.
Unfortunately I ran into trouble when I tried to import the data to Google’s BigQuery.
This blogpost is mainly a reminder for myself where I can delete this information.
But what’s all about?
Recently I installed bigrquery
and ran queries
against Google’s BigQuery cloud-database before I had installed gcloud
(and did the authorization as
described at https://docs.getdbt.com/reference/warehouse-setups/bigquery-setup#local-oauth-gcloud-setup).
So R asked me to authorize the session in a browser. So far so good.
But every time I started a new R session I was asked if I want to use the well known account or another one.
So I was wondering where this account information was stored and how I could delete this information.
After upgrading my local R version to version 4.2.1 I always got an annoying warning after loading my own package. This only occurred using RStudio.
pkgdown is a great tool for generating a website with documentation for an R package.
Unfortunately, pkgdown uses CDNs (content delivery networks) like Cloudflare to embed often used JavaScript libraries into the generated website. Also, fonts are included in such a way. That’s a good idea when these files are cached over websites away.
But in Germany due to GDPR, it’s only allowed to do so after the user has given his consent.