sparklyr spark_read_table from a specific database

Solution 1:

You need to use tbl_change_db function to change current database:

tbl_change_db(sc, "marketing")
data <- spark_read_table(sc, "scv_tbl")