In BigQuery, . are not allowed in column names. The default dplyr join behavior is to distinguish identical column names with the .x and .y suffix. This breaks dplyr joins in BigQuery.
The user could certainly update the suffix argument to join calls so that joins work (for example, suffix = c("_x", "_y") works). However, it would be nice if dbplyr contained a translation layer for BigQuery that took care of this.
BigQuery ODBC connections have class BigQuery
In BigQuery,
.are not allowed in column names. The defaultdplyrjoin behavior is to distinguish identical column names with the.xand.ysuffix. This breaksdplyrjoins in BigQuery.The user could certainly update the
suffixargument to join calls so that joins work (for example,suffix = c("_x", "_y")works). However, it would be nice ifdbplyrcontained a translation layer for BigQuery that took care of this.BigQuery ODBC connections have class
BigQuery