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.
Connecting to SnowflakeConnect Astrato to a Snowflake database in just a few quick steps
Connecting to Google BigQuery
Connecting to PostgreSQLConnecting to and using PostgreSQL as a data source
Connecting to Dremio Cloud
Connecting to Google SheetsConnect your Astrato workspace to Google Sheets in just a few quick steps.
Connecting to Amazon Redshift
Connecting to Databricks
Workbook Editor - change the Semantic Layer connected of a workbookHow to change/swap data views in Astrato workbooks
Connecting Astrato to Clickhouse (via PostgreSQL interface)
Creating a Connection to ClickHouseAstrato’s live connector enables instant querying of ClickHouse data. You no longer have to wait for batch updates or build data pipelines.
AWS Private ConnectionHow to set a private connection between Astrato and sources in AWS.
AWS Privatelink Connection
Snowflake in Astrato
Astrato is a trusted Snowflake Technology Partner. These articles provide details of Snowflake support features.
Snowflake Supported FeaturesFind out about Snowflake supported features in Astrato
Creating efficient queries using data Query Profile InsightsStop wasting time on inefficient queries using Astrato's data Query Profile Insights Snowflake's GET_QUERY_OPERATOR_STATS
Snowflake Functions in AstratoA reference of the Snowflake functions used in Astrato
Astrato for Snowflake: Optimizing Snowflake warehouses for cost & performanceOptimizing Snowflake for balanced cost and performance in live query analytics
Using Snowflake MFA with AstratoAstrato supports Snowflake accounts utilizing MFA for enhanced secuirty and governance.
Using Snowflake Key-pair Authentication with Astrato (Using a Snowflake service account with Astrato)
Optimizing Snowflake ❄: 11 Best PracticesSnowflake’s unique architecture for efficient data visualization. Utilize scalable compute to adapt dynamically to varying data demands.
Performance & Usage Telemetry: Store Astrato activity in Snowflake + Setup Astrato Activity WorkbookView Astrato adoption & user activity dashboards, directly using Snowflake's logs.