https://community.databricks.com/t5/get-started-discussions/load-gcp-data-to-databricks-using-r/m-p/55068#M1960 <P>I'm working with Databricks and Google Cloud in the same project. I want to load specific datasets stored in GCP into a R notebook in Databricks. I currently can see the datasets in BigQuery. The problem is that using the sparklyr package, I'm not able to see the datasets that I have in GCP. Instead, I see the name of other datasets I was not aware of.&nbsp;</P><P>This is my R code</P><P>&nbsp;</P><LI-CODE lang="python">library(sparklyr) sc &lt;- spark_connect(method = "databricks") # List table names in my spark connection dplyr::src_tbls(sc) # Can't see the tables sotred in GCP # Try (and fail) to load the tables spark_read_table(sc, "my-table-name")</LI-CODE><P>&nbsp;</P><P>How can I access my tables stored in GCP through Databricks notebooks using R?; Is sparklyr the right approach?</P> Mon, 11 Dec 2023 16:58:08 GMT dZegpi 2023-12-11T16:58:08Z https://community.databricks.com/t5/get-started-discussions/load-gcp-data-to-databricks-using-r/m-p/55068#M1960 <P>I'm working with Databricks and Google Cloud in the same project. I want to load specific datasets stored in GCP into a R notebook in Databricks. I currently can see the datasets in BigQuery. The problem is that using the sparklyr package, I'm not able to see the datasets that I have in GCP. Instead, I see the name of other datasets I was not aware of.&nbsp;</P><P>This is my R code</P><P>&nbsp;</P><LI-CODE lang="python">library(sparklyr) sc &lt;- spark_connect(method = "databricks") # List table names in my spark connection dplyr::src_tbls(sc) # Can't see the tables sotred in GCP # Try (and fail) to load the tables spark_read_table(sc, "my-table-name")</LI-CODE><P>&nbsp;</P><P>How can I access my tables stored in GCP through Databricks notebooks using R?; Is sparklyr the right approach?</P> Mon, 11 Dec 2023 16:58:08 GMT https://community.databricks.com/t5/get-started-discussions/load-gcp-data-to-databricks-using-r/m-p/55068#M1960 dZegpi 2023-12-11T16:58:08Z https://community.databricks.com/t5/get-started-discussions/load-gcp-data-to-databricks-using-r/m-p/55139#M1971 <P>Other than library(SparkR), this is the same code I posted. This does not solve my problem.</P> Tue, 12 Dec 2023 12:23:03 GMT https://community.databricks.com/t5/get-started-discussions/load-gcp-data-to-databricks-using-r/m-p/55139#M1971 dZegpi 2023-12-12T12:23:03Z