Thanks. I took that approach to create view and then queried it using SQL from R:

%r

rd=as.data.frame(sql("select * from CNTRY_FLOWS"))

...not sure if there's a more direct route. I was unsure what the equivalent to python spark.read.table() for R was.