This article contains Frequently Asked Questions (FAQ) relating to Astrato and covers a range of general and technical topics.

General FAQ

Technical FAQ

Unlike traditional BI tools, Astrato goes beyond read-only dashboards.

Customers use Astrato to build Data Products and deploy full Data Apps — not just to visualize, but to take action.

With native support for live connections to modern cloud platforms like Snowflake, BigQuery, and Databricks, Astrato makes it easy to:

All from one canvas — no context switching, no exports, just decisions, made smarter.

Traditional BI can be very dashboard-focused and offer limited data reporting functionality. Users of modern BI tools can also encounter limitations, such as

Astrato is a SaaS software solution sitting on top of your data cloud, using live data in real-time to “play the data where it lives” and includes these great features.

Back to Top

Dashboards primarily focus on showing historical data such as KPIs and high-level trends - showing the audience “what” happened.

With analytics, the focus is more on drilling down and iterating on the data to learn “why” something happened. Results in analytics are ad-hoc, and can generate new insights to understand and improve business performance, performing actions like joining data, running formulas, and calculations, and making projections.

Back to Top

Astrato is a SaaS solution accessed via a simple URL, which means you can take full advantage of cloud-based scale and efficiency savings. We are not “on-premise” and we have no plans to move there.

Back to Top

Astrato’s user permissions allow for real flexibility, you can invite users to your workspace and select from a variety of user roles to define the level of interaction you want them to have.

Back to Top

Astrato does share some features with spreadsheets - business users can:

But as Astrato connects directly to all your live data held in the CDW, there are no scaling limitations, you always query on accurate and live data, and you can enjoy enhanced access control (enforcing permissions from a single connection point) and easily share and re-use the results of your analysis.

Back to Top

Astrato workbooks offer a wide range of data objects - customizable visualizations and controls to visualize the results of your data analysis and share them with other users.

Back to Top

It could be within minutes. As Astrato is a SaaS product you can connect to your CDW tables in seconds, and data can be modeled in Astrato using the Data View editor.

So within minutes, you could see new customers running queries on live data. There are other factors, such as your use case requirements for analytics, or the quantity and quality of the data held in the CDW. If you have any questions, we’re always happy to hear them and help.

Back to Top

Astrato is not impacted by the Java Spring Framework vulnerability in any way because we don’t use the Java Spring Framework in Astrato.

We monitor all relevant vulnerability reports and are ready to fix any critical risks quickly.

Back to Top

As Astrato is designed as a no-code data visualization and analytics solution with live access to your data cloud, it can definitely be used as the single BI and analytics product in an organization, especially if there’s a requirement to build a modern data stack from scratch. But it can also be used to complement traditional BI tools in areas like ease of use, live data manipulation, and collaboration between users and teams.

Back to Top

No data is stored. With every data interaction in your visualization, the Astrato data engine generates an SQL query and the visualization displays the updated results instantly. This really is “playing the data where it lives”, running queries with greater accuracy, speed and minimizing the security/governance risks, as data is never extracted to a spreadsheet or held on a desktop.

Back to Top

As Astrato updates are driven by pushing SQL queries to your data cloud (Snowflake, Google BigQuery, Databricks etc), we can leverage the cloud platform’s nearly unlimited scale and speed. If sized correctly, the CDW makes scale limitations a thing of the past, with none of the limits on performance or storage you can find with Excel or “on-premise” BI tools.

Back to Top

Astrato has a variety of permission levels to control access to your workspace, held in the People settings of the Administration module. User permissions are organized around CRUD functions (Create, Read, Update and Delete), and there’s also a Publish permission for workbooks.

In terms of general access, users have to be invited to create an account or log in using Google or LinkedIn. Organizations using an Identity provider (IdP) for centralized user management can take advantage of enterprise authentication integrations with Google Workspace, Open ID Connect, and OKTA.

Back to Top

To grant Astrato access to the copy and paste function, you'll need to allow Astrato to access your clipboard.

This is a change that you'll make in the browser.

Right-click on the padlock icon beside the Astrato URL

Beside the Clipboard option, move the slider to the right to grant Astrato access to the copy-and-paste function.

Back to Top

Astrato allows the creation of custom fields using both our UI and also SQL.

You can create a custom field in the semantic layer using a calculated expression. For example:

Back to Top

To apply a global filter across all visuals:

This will apply the filter to all visuals using that dataset across the workbook.

Back to Top