# DataLens

> Dashboards on your PostgreSQL or ClickHouse data.

- Page: https://cgt.octabyte.io/templates/datalens/
- Category: Analytics
- Replaces: Tableau, Power BI and Looker
- Ease of use: Some setup. Sign in as admin with the password Cloudgate created, look around the demo workbook, then connect your own database and add your team.
- App price: Free. To run it you need Cloudgate (hosted, or free to install yourself) and a server, which hosted Cloudgate can provide.
- License: Apache-2.0
- Good for: Teams with data in PostgreSQL, ClickHouse or another SQL database who want shared dashboards anyone can open
- Official website: https://datalens.tech
- Documentation: https://datalens.tech/docs/en/
- Source code: https://github.com/datalens-tech/datalens
- Last updated: 2026-11-20

## What is DataLens?

Self-hosted DataLens is an open-source BI tool: connect PostgreSQL, ClickHouse or MySQL and share charts and dashboards with your team.

DataLens is an open-source business intelligence tool, first built at Yandex, that turns the data in your PostgreSQL, ClickHouse or MySQL database into charts and dashboards your whole team can open. Self-hosted DataLens is a free alternative to Tableau and Power BI, with no fee for each person who looks at the numbers.

You connect a database, describe the data once as a dataset, with calculated fields such as profit or average basket, and then build charts by dragging fields onto a wizard. Charts go onto dashboards with filters, tabs and charts that filter each other. A shop owner, for example, could build one dashboard of daily orders, revenue by product and returns by region, and let every manager open it in the browser or on a phone.

DataLens reads your data where it is, so it suits teams whose numbers already sit in a database; there is no spreadsheet upload, scheduled report or alert. Anyone who knows SQL can also chart a query directly.

Cloudgate installs the free Apache-2.0 release of DataLens on a server Cloudgate provides or one you connect, with a demo workbook to explore and a secure web address. You sign in as admin, connect your own database and invite colleagues as viewers or editors.

## What you can do with DataLens

- **Connect the database you already use**: Read data live from PostgreSQL, ClickHouse, MySQL, SQL Server, Oracle, Greenplum, Trino or YDB, without copying it in.
- **Describe your data once**: A dataset names your fields and adds calculated ones, such as profit or average order value, for every chart to reuse.
- **Build charts by drag and drop**: Drop fields onto the chart wizard to make bar and line charts, tables, treemaps, maps and headline numbers.
- **Chart a SQL query**: Anyone who knows SQL can write a query and turn its result straight into a chart.
- **Share interactive dashboards**: Put charts on one page with tabs and filters, and click a chart to filter the others.
- **Open dashboards on a phone**: Dashboards switch to a phone layout in the browser, with a menu for filters and contents.
- **Control who can edit**: New colleagues can view everything but change nothing until you make them an editor.
- **Export data and workbooks**: Download the data behind a chart as Excel or CSV, and move whole workbooks between DataLens servers.

## Replaces Tableau, Power BI and Looker

DataLens does the same job as Tableau, Power BI and Looker. Here is what changes when you switch.

### What you gain

- No licence fee per viewer, so the whole team can open the dashboards
- Every feature is in the one free Apache-2.0 release
- Your dashboards and connection details stay on your own server
- Charts read your database live, so the numbers are always current

### What is different

- Your data must be in a supported database; there is no spreadsheet upload
- No scheduled email reports or alerts
- Fewer design controls and data sources than Tableau or Power BI
- Needs a bigger server than simpler tools such as Metabase

## What happens when you click Deploy?

Deploy link: https://cloudgate.octabyte.app/get-started?template=datalens

1. **Click Deploy and create your account.** Deploy takes you to Cloudgate. Create an account, or log in if you have one. DataLens itself is free.
2. **Choose a server.** No server? Get one from Cloudgate: pick a size and a country, and Cloudgate gets it ready. Already have one? Connect it instead.
3. **Cloudgate sets up DataLens.** It prepares the server, makes the passwords the app needs and starts it. There is nothing to install and nothing to write down.
4. **Open your app and sign in.** Your app gets a free web address to start, without https. Add your own domain, like app.yourshop.com, and Cloudgate secures it with https for you.

## Questions

### Is DataLens free?

Yes, self-hosted DataLens is free under the Apache-2.0 licence, with no limit on users or dashboards. You pay only for your server. The hosted version in Yandex Cloud charges teams per seat; the self-hosted one does not.

### Is DataLens a good alternative to Tableau or Power BI?

Yes, if your data already lives in a SQL database and you mainly need shared charts and dashboards. Tableau and Power BI have more design control, more data sources and file uploads, which DataLens does not match.

### Which databases can DataLens connect to?

DataLens connects to PostgreSQL, ClickHouse, MySQL, Microsoft SQL Server, Oracle, Greenplum, Trino and YDB. It queries them where they are and does not copy the data.

### How is DataLens different from Metabase and Superset?

DataLens is built around datasets with calculated fields and a drag-and-drop chart wizard, and also connects to ClickHouse, Greenplum and YDB. Metabase is simpler and adds alerts, scheduled reports and CSV uploads; Superset offers more than 40 chart types.

### How do I sign in to DataLens the first time?

Sign in to DataLens with the user name admin and the password Cloudgate created for you. A demo workbook is already there to explore, and the admin adds colleagues and decides who may edit.

### What server size do I need for DataLens?

DataLens needs at least 4 GB of memory and 2 processor cores, according to the project. Cloudgate starts it on a large server because it runs several parts; many users or heavy queries need more.

### Does DataLens work on a phone?

Yes, DataLens dashboards adapt to phone screens in the browser. There is no phone app.

### Do I need technical skills to run DataLens?

No. Click Deploy, create your Cloudgate account and choose a server, and Cloudgate sets up DataLens and gives it a web address. You use it in your browser like any other online tool.

### Do I need my own server for DataLens?

No. When you deploy DataLens, hosted Cloudgate can provide a server. If you already rent one, you can connect it instead.

### Can I move my data from Tableau to DataLens?

Most people export from Tableau and import into DataLens. The official guides at datalens.tech walk through it.
