No reviews yetBe the first to leave a review for Cluvio
As a minimalist, I really like the clear interface. But could you elaborate on why exactly you committed yourself to R? And am I able to use this tool productively without any background knowledge on R?
@zcei_ger Hey Stephan,
we chose to build the integration with R to provide additional expressivity for data transformations that are harder to do in SQL and very easy in R. One example would be adding a column of running totals, which is a little bit complicated in SQL while being a one-liner in R.
You can definitely use Cluvio without any background knowledge in R.
The use of R on SQL results is completely optional and reports can be build using only SQL.
Best,
Marius
@philipp_zentner
Hey Philipp,
good question!
The main advantages of Cluvio over accessing your database via the commandline are:
1. With the "Almanach" you can easily see the structure of your database with its tables, column and column types, while you are assembling the SQL query. No more 'SELECT * from USERS' just to get the exact name of a specific column. The almanach also suggests queries based on the structure of your database.
2. With one click you can download the results of a SQL query as a CSV file to further analyze it. No need to pipe into a tmp.csv file or do copy&paste.
3. Our custom grammar on top of SQL simplifies common expressions. For instance in Cluvio you can write '{created_at:week}', which would then automatically get translated to the correct syntax for your database, e.g. 'date_trunc('week', (created_at)::timestamp)::date' for Postgres.
4. Cluvio makes it very easy to visualize the results of the query by analyzing the structure of the results and intelligently recommending visualizations depending on it.
5. You can easily make SQL queries parametrized, which allows to configure them from the 'outside' and for instance select a specific timerange using our dashboard filters.
You can use Cluvio with AWS RDS with the following database engines:
- Amazon Aurora
- Postgres
- MySQL
- MariaDB
We also support AWS Redshift.
Best,
Marius
@philipp_zentner You can definitely connect to the primary database, we have 2 things in place that help keep the database load under control:
- the query results are cached on our side for 2 hours, so accessing a dashboard would not re-run all the queries unless the cached data already expired
- we allow to specify max number of queries to run in parallel for a datasource - for primary databases this can be set to lower value to reduce the load - any queries that need to be executed would just wait for an available slot to execute
Hey, I'm Marius, one of the founders of Cluvio.
Cluvio allows you to run SQL queries against your database, visualize the results as beautiful dashboards and share these dashboards within your company.
We have integrated an R engine in the pipeline, so you can run custom R script on the sql results to get combined power of SQL and R.
After working on Cluvio for 18 months, we launch today and would love to hear the feedback of the PH community.
Hi guys, we just launched a new set of plans that make Cluvio accessible to everyone!
Cluvio pricing now starts with a completely free plan, "Cluvio Forever Free", which enables you to analyze your business data and use most of the awesome features of our platform.
The next step up is a Cluvio Starter plan, also brand new, which targets single analysts that want to have a powerful tool to analyze and visualize data, but do not need to share the results with others. The Starter plan has unlimited query executions and allows to use Sql Alerts and more dashboards.
Cluvio Pro, already existing, and a new Cluvio Business plan together target the teams that create analytics to share, with internal users or externally.
Just sign up to a free 14-day trial of our Business plan.
Let me know if you have any questions, comments and feedback!
Report
Great SQL editor for queries
Pros:
Pricing, Quick setup of data sources and easy to share dashboards. Nice UI
Cluvio
CryptoPixels
CryptoPixels
Cluvio
CryptoPixels
Cluvio
Cluvio
Cluvio
Great SQL editor for queries
Pros:Pricing, Quick setup of data sources and easy to share dashboards. Nice UI
Cons:No machine learning