Skip to main content

Data

You can find information on working with Astrato Data here

Data Connections - Getting Started in AstratoStart working with Data in Astrato, whitelist Astrato, setup authentication and RBAC/RLS.
Getting started with the Semantic Layer EditorUse the Semantic Layer Editor (SLE) to select your data and add customized SQL, fields, dimensions, and measures in your Astrato workbooks.
Define the Data Model in AstratoUse Astrato's smart joins features to connect your tables and build your data model effectively.
Creating custom fields (calculated columns)Create a Custom Field (custom-calculated column) to add and test out new useful fields- without affecting your source data.
Creating Measures in the Semantic Layer EditorNo coding is required to write expressions using Astrato's measures in the Data Explorer.
Creating Dimensions in the Semantic Layer EditorNo code creation of buckets and drill through dimensions
Using The Data-ExplorerThe Data-Explorer is a powerful data analytics exploration tool and no-code query builder.
Predefined time periods in AstratoQuickly and easily set a dynamic range of dates to filter your results.
Astrato's Data EngineUse USS & Astrato's data engine to solve the most challengin problems of data modeling that occur in Business Intelligence (BI)
Understanding Join direction and quality
Number & Date FormattingFormatting dates and numbers in Astrato, including solving for viewing across timezones.
Astrato Technical ArchitectureAstrato's technical architecture diagrams for Snowflake, AWS Privatelink and other data connections.
Databricks Pricing Breakdown: Understanding Your Cloud Analytics SpendBreak down Databricks pricing, calculate total costs, and use our Excel cost calculator to optimize your data platform spending.
How do I create a custom flag field in Astrato?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.