Astrato

Start working with Data in Astrato, whitelist Astrato, setup authentication and RBAC/RLS.

Data Connections - Getting Started in Astrato

Use the Semantic Layer Editor (SLE) to select your data and add customized SQL, fields, dimensions, and measures in your Astrato workbooks.

Getting started with the Semantic Layer Editor

Use Astrato's smart joins features to connect your tables and build your data model effectively.

Define the Data Model in Astrato

Create a Custom Field (custom-calculated column) to add and test out new useful fields- without affecting your source data.

Creating custom SQL fields (calculated columns)

No coding is required to write expressions using Astrato's measures in the Data Explorer.

Creating Measures in the Semantic Layer Editor

No code creation of buckets and drill through dimensions

Creating Dimensions in the Semantic Layer Editor

The Data-Explorer is a powerful data analytics exploration tool and no-code query builder.

Using The Data-Explorer

Quickly and easily set a dynamic range of dates to filter your results.

Predefined time periods in Astrato

Use USS & Astrato's data engine to solve the most challengin problems of data modeling that occur in Business Intelligence (BI)

Astrato's Data Engine

Understanding Join direction and quality

Formatting dates and numbers in Astrato, including solving for viewing across timezones.

Number & Date Formatting

Astrato's technical architecture diagrams for Snowflake, AWS Privatelink and other data connections.

Astrato Technical Architecture

Break down Databricks pricing, calculate total costs, and use our Excel cost calculator to optimize your data platform spending.

Databricks Pricing Breakdown: Understanding Your Cloud Analytics Spend

This article explains how to create a flag that identifies the first weekday of each month using Astrato's custom SQL functionality in the semantic layer.

How do I create a custom flag field in Astrato?

You can find information on working with Astrato Data here

Data

How to change/swap data views in Astrato workbooks

Workbook Editor - change the Semantic Layer connected of a workbook

How to set a private connection between Astrato and sources in AWS.

AWS Private Connection

AWS Privatelink Connection

Data Connections

Connecting to and using PostgreSQL as a data source

Connecting to PostgreSQL

Connect Astrato to a Snowflake database in just a few quick steps

Connecting to Snowflake

Connecting to Google BigQuery (OAuth, JWT)

Connecting to Dremio Cloud

Connect your Astrato workspace to Google Sheets in just a few quick steps.

Connecting to Google Sheets

Connecting to Amazon Redshift

Connecting to Databricks

Connecting Astrato to Clickhouse (via PostgreSQL interface)

Astrato’s live connector enables instant querying of ClickHouse data. You no longer have to wait for batch updates or build data pipelines.

Creating a Connection to ClickHouse

Initial setup for connecting to your data warehouse / data lake

Connecting Data Sources

Call Supabase Edge Functions directly from Astrato. Learn how Edge Functions work, how to enable pg_net, grant permissions, store HTTP calls in Astrato SQL variables, and execute them to trigger…

Working with Supabase Edge Functions

View Astrato adoption & user activity dashboards, directly using PostgreSQL logs.

Performance & Usage Telemetry: Store Astrato activity in PostgreSQL/Supabase

Astrato connects to Supabase for low-cost, scalable analytics in the cloud, using a managed PostgreSQL service.

Connecting Supabase to Astrato Analytics

This guide walks through connecting Supabase to Astrato and building a dashboard from scratch using live query.

Getting Started with Astrato & Supabase

Supabase specific guides for Astrato workspaces

Supabase

Find out about Snowflake supported features in Astrato

Snowflake Supported Features

Stop wasting time on inefficient queries using Astrato's data Query Profile Insights  Snowflake's GET_QUERY_OPERATOR_STATS

Creating efficient queries using data Query Profile Insights

A reference of the Snowflake functions used in Astrato

Snowflake Functions in Astrato

Optimizing Snowflake for balanced cost and performance in live query analytics

Astrato for Snowflake: Optimizing Snowflake Warehouses for cost & performance

Astrato supports Snowflake accounts utilizing MFA for enhanced secuirty and governance.

Using Snowflake MFA with Astrato

Using Snowflake Key-pair Authentication with Astrato (Using a Snowflake service account with Astrato)

Snowflake’s unique architecture for efficient data visualization. Utilize scalable compute to adapt dynamically to varying data demands.

Optimizing Snowflake ❄: 11 Best Practices

View Astrato adoption & user activity dashboards, directly using Snowflake's logs.

Performance & Usage Telemetry: Store Astrato activity in Snowflake + Setup Astrato Activity Workbook

Astrato is a trusted Snowflake Technology Partner. These articles provide details of Snowflake support features. 

Snowflake

This solution leverages BigQuery’s job metadata to create a persistent query history dataset, enabling teams to analyse performance, cost, and analytics usage at the level of users, dashboards, and business…

Performance & Usage Telemetry: Store Astrato activity in Google BigQuery

Astrato is a trusted Google Technology Partner. These articles provide details of BigQuery support features. 

BigQuery

Create a custom design with text, images, and links

astrato.io

⭐ Demo Gallery

🧑‍🎓Training Videos

🆕 What's new

Find answers and get help from Intercom Support and Community Experts

This site employs cookies and other technologies that we and our third party vendors use to monitor and record personal information about you and your interactions with the site (including content viewed, cursor movements, screen recordings, and chat contents) for the purposes described in our Cookie Policy. By continuing to visit our site, you agree to our {websiteTermsLink}, {privacyPolicyLink} and {cookiePolicyLink}.

This site uses cookies and similar technologies ("cookies") as strictly necessary for site operation. We and our partners also would like to set additional cookies to enable site performance analytics, functionality, advertising and social media features. See our {cookiePolicyLink} for details. You can change your cookie preferences in our Cookie Settings.

We use cookies to make our site work and also for analytics and advertising purposes. You can enable or disable optional cookies as desired. See our {cookiePolicyLink} for more details.

Advertising cookies are set by our advertising partners to collect information about your use of the site, our communications, and other online services over time and with different browsers and devices. They use this information to show you ads online that they think will interest you and measure the ads' performance. Social media cookies are set by social media platforms to enable you to share content on those platforms, and are capable of tracking information about your activity across other online services for use as described in their privacy policies.

These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.

These cookies are necessary for the website to function and cannot be switched off in our systems.

These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site.

You have the right to opt out of the sale of your personal information. See our {cookiePolicyLink} for more details about how we use your data.

Your Privacy Choices

We use cookies to enhance your experience. You can customize your cookie preferences below. See our {cookiePolicyLink} for more details.

Cookie Settings

Empty Help Center

Uh oh. That page doesn’t exist.

Home

Search

Disappointed

Neutral

Smiley

Thinking...

Searching through sources...

Analyzing...

Tickets submitted through the messenger or by a support agent in your conversation will appear here.