Rstudio Clickhouse connection

Question

I need to connect RStudio to ClickHouse and then be able to run SQL queries in R Markdown, generating a pre-formatted table that I can view in the environment instead of a string that needs to be parsed with another function.

I tried to connect with:

   con_click <- clickhouse_http_api(
   host = host,
   port = port,
   user = user,
   password = password,
   dbname =)

but i have this error "Error in clickhouse_http_api(host = host, port = port, user = user, password = password, : could not find function "clickhouse_http_api""

I tried also with: library(httr)

#Config connection
   url <- "http://xxxxxx/"
   user <- "xxxx"
   password <- "xxxxx"

   query <- "select * from aaa.aaa_detail aum LIMIT 10"

#Query execution
   response <- GET(url, authenticate(user, password), query = list(query = query))

This connection works, but the response is a list e not a table.

I would like to create a connection that allows me to use a query like this (in R markdown)

```{sql connection=con_click,  output.var=prova}
   select *
   from aaa.aaa_detail pd 
   limit 10

Someone can help me? Thank you Elisa

Slach · Accepted Answer · 2025-02-19 10:53:46Z

-1

Look examples how to connect properly in https://github.com/IMSMWU/RClickHouse

answered Feb 19 at 10:53

Slach

2,6731 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ely.litta Feb 19 at 16:38

Thank you, but i can't find RClickhouse package, there is an issue in github github.com/IMSMWU/RClickhouse/issues/112

Slach Feb 25 at 7:38

@Ely.litta github.com/IMSMWU/RClickhouse/issues/…

Collectives™ on Stack Overflow

Rstudio Clickhouse connection

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related