How to sql select in RStudio to Databricks

There a multiple way to connect to different datasource. When running RStudio Server inside Databricks you can use the SparkR library and do a SparkR sql with normal sql select statements like this

# init Spark for R


# save select statement to dataframe
df <- SparkR::sql("SELECT * FROM default.my_table")

# display dataframe

In the terminal you’ll be able to display the result.