# Astrato > Documentation for building on Astrato. Choose relevant pages from this index and reuse documentation already read in the task. Read only the contracts needed for the requested work. ## Documentation Sets - [Astrato documentation](https://docs.astrato.io/_llms-txt/astrato-documentation.txt): Connect your data, define what it means once in a semantic layer, and build Data Apps with the app builder or your own AI assistant. - [A Guide to Creating Effective AI System Prompts in Astrato's AI Insights & Custom Report](https://docs.astrato.io/_llms-txt/a-guide-to-creating-effective-ai-system-prompts-in-astratos-ai-insights--custom-report.txt): A guide explaining how to create custom instructions for your AI models in Astrato, with an inventory management example. - [Account review](https://docs.astrato.io/_llms-txt/account-review.txt): A complete Data App built around one decision: which account to review next. It shows a layout, palette, type and takeaway chosen for that decision, using only documented APIs. - [Action Bar](https://docs.astrato.io/_llms-txt/action-bar.txt): Learn about using the Action Bar in the workbook editor - [Actions - Embed/External Communication](https://docs.astrato.io/_llms-txt/actions---embedexternal-communication.txt): When Astrato is embedded inside another web application, External Communication Actions let the two talk to each other through browser events — the host app can send instructions to Astrato, and Astrato can send information back to the host. - [Administration - Exporting Workspace Data](https://docs.astrato.io/_llms-txt/administration---exporting-workspace-data.txt): Astrato provides ways to export your data and workbooks. - [Administration - Getting Started](https://docs.astrato.io/_llms-txt/administration---getting-started.txt): Learning about Astrato's Administration settings. - [Advanced Analytics - Forecasting](https://docs.astrato.io/_llms-txt/advanced-analytics---forecasting.txt): Forecasting is a technique that uses historical data to determine the direction of future trends. - [Advanced Chart Calculations](https://docs.astrato.io/_llms-txt/advanced-chart-calculations.txt): Advanced chart calculations (advanced operations) are a new feature that allows users to apply Advanced calculations on measures used in a chart. - [Advanced Chart Calculations: Moving Aggregations, Period over Period & More](https://docs.astrato.io/_llms-txt/advanced-chart-calculations-moving-aggregations-period-over-period--more.txt): A guide to Astrato's advanced chart calculations including Moving Aggregations, Period over Period (Value, Difference, Rate, Growth, Correlation, CAGR), Rank, Total, Compare to Total, and Date Ranges Comparison. - [Advanced Chart Calculations: Nested Calculations](https://docs.astrato.io/_llms-txt/advanced-chart-calculations-nested-calculations.txt): Learn how to use Nested Calculations in Astrato — including Nested Time Dimension, Nested Calculation, Nested Ratio, and Nested Correlation — to apply aggregations using internal dimensions independently from chart dimensions. - [Affordability and lending decisions](https://docs.astrato.io/_llms-txt/affordability-and-lending-decisions.txt): Blueprint for a lending dashboard: income and expenses, affordability thresholds on sliders, and a proposal-and-approval workflow, with every figure from the semantic layer. - [AI Admin & Policy (Snowflake Cortex LLM, OpenAI, Google Gemini)](https://docs.astrato.io/_llms-txt/ai-admin--policy-snowflake-cortex-llm-openai-google-gemini.txt): Managing AI providers and toggle AI Capabilities in an your Astrato Workspace. Manage Snowflake Cortex & OpenAI in Astrato. - [AI Natural Language Measure](https://docs.astrato.io/_llms-txt/ai-natural-language-measure.txt): Measures (KPIs) are the basis for data analytics. - [Alberto Cairo](https://docs.astrato.io/_llms-txt/alberto-cairo.txt): Apply Cairo to a Data App: choose the form from the task, guard against misleading scale, aggregation and selection, and annotate in layers. - [Alternative Dimensions and Measures](https://docs.astrato.io/_llms-txt/alternative-dimensions-and-measures.txt): Enhance users' self-service by easily asking the next question by making visualisations more dynamic on published workbooks. - [Alternative Measure in Charts](https://docs.astrato.io/_llms-txt/alternative-measure-in-charts.txt): Switching the active measure (KPI) in one or more visualizations allows users to analyze data from different perspectives using the same dashboard and to dri... - [Andy Kirk](https://docs.astrato.io/_llms-txt/andy-kirk.txt): Apply Kirk to a Data App: decide the brief first, balance trustworthy, accessible and elegant, and choose from the full chart catalogue. - [Apache Ossie export](https://docs.astrato.io/_llms-txt/apache-ossie-export.txt): Export the current Astrato semantic-layer draft as portable Apache Ossie YAML with lossless Astrato metadata. - [API- Get A Visualization Data](https://docs.astrato.io/_llms-txt/api--get-a-visualization-data.txt): The Astrato SQL engine creates optimized queries to load the data into visualizations. - [App limitations](https://docs.astrato.io/_llms-txt/app-limitations.txt): What a Data App cannot do yet with the documented packages: chart settings, visualization types, interaction, filters and dates, and data access. - [Associative filters](https://docs.astrato.io/_llms-txt/associative-filters.txt): Select entities by related records in a Business Question. - [Astrato Action Blocks: automating interactive workflows](https://docs.astrato.io/_llms-txt/astrato-action-blocks-automating-interactive-workflows.txt): Action blocks turn a dashboard from a place where you look at data into a place where you act on it — trigger approvals, send notifications, kick off downstream processes, all from inside Astrato. - [Astrato AI Capabilities | Insights & Copilot](https://docs.astrato.io/_llms-txt/astrato-ai-capabilities--insights--copilot.txt): How Astrato use AI to offer insight-driving and productivity enabling capabilities, direct from your cloud - [Astrato AI Insights Describe object](https://docs.astrato.io/_llms-txt/astrato-ai-insights-describe-object.txt): Generate insights with AI, of your entire dashboard, make comparisons and executive summaries. Available in any language. - [Astrato CLI reference](https://docs.astrato.io/_llms-txt/astrato-cli-reference.txt): Install and use the astrato command for Data App login, configuration, validation, local development, publishing, and publication management. - [Astrato Custom Report](https://docs.astrato.io/_llms-txt/astrato-custom-report.txt): Astrato Custom Report allows business users to explore live data with confidence. Drag and drop - no coding required. - [Astrato default style](https://docs.astrato.io/_llms-txt/astrato-default-style.txt): A neutral treatment for apps that sit beside Workbooks: placeholder colour tokens, panels on a tinted page, the tenant theme palette and the built-in Roboto chart text, with the operations a dark theme needs. - [Astrato for Snowflake: Managing authentication & security](https://docs.astrato.io/_llms-txt/astrato-for-snowflake-managing-authentication--security.txt): For each data connection, there are different ways to connect to Snowflake, these are outlined below. - [Astrato for Snowflake: Optimizing Snowflake Warehouses for cost & performance](https://docs.astrato.io/_llms-txt/astrato-for-snowflake-optimizing-snowflake-warehouses-for-cost--performance.txt): Optimizing Snowflake for balanced cost and performance in live query analytics - [Astrato Map](https://docs.astrato.io/_llms-txt/astrato-map.txt): Our map supports multiple input formats for geo data. - [Astrato Parameters & Variables, and when to use each](https://docs.astrato.io/_llms-txt/astrato-parameters--variables-and-when-to-use-each.txt): This guide explains the difference between variables and parameters in Astrato and how they work together to create dynamic, context-aware analytics. - [Astrato Query Metadata for telemetry - writing back the data](https://docs.astrato.io/_llms-txt/astrato-query-metadata-for-telemetry---writing-back-the-data.txt): Learn how Astrato uses JSON query metadata to provide full observability into your data warehouse, helping you track performance, usage, and costs across users and workbooks, in Snowflake, Databricks, Google BigQuery and more. - [Astrato skills for AI agents](https://docs.astrato.io/_llms-txt/astrato-skills-for-ai-agents.txt): Install the portable Astrato router and task skills, and understand how they use the current documentation. - [Astrato Support - Troubleshooting & Supporting Chart Errors](https://docs.astrato.io/_llms-txt/astrato-support---troubleshooting--supporting-chart-errors.txt): Understand "Oops" and "Unauthorized access" errors on charts. Troubleshoot errors in Astrato, identify issues upstream from the cloud data warehouse and identity providers. - [Astrato Technical Architecture](https://docs.astrato.io/_llms-txt/astrato-technical-architecture.txt): Astrato's technical architecture diagrams for Snowflake, AWS Privatelink and other data connections. - [Astrato terminology](https://docs.astrato.io/_llms-txt/astrato-terminology.txt): Choose whether to create a Workbook, build a Data App, or add Astrato to an app that you host. - [Astrato workbook as code - storing/archiving workbook versions to git](https://docs.astrato.io/_llms-txt/astrato-workbook-as-code---storingarchiving-workbook-versions-to-git.txt): Astrato workbooks can be exported via the REST API as an .astx file. - [Astrato Workbook Theming](https://docs.astrato.io/_llms-txt/astrato-workbook-theming.txt): Theming Dashboards, Reports & Data APps in Astrato. This guide explains how to evolve that into a dynamic, data-driven theming experience. - [Astrato Writeback - Atomic Input Form](https://docs.astrato.io/_llms-txt/astrato-writeback---atomic-input-form.txt): An atomic input form writes all its fields back to your warehouse as a single, all-or-nothing operation — either every field is saved together, or none of them are. - [Astrato Writeback and Actions: Implementing Secure Data Updates](https://docs.astrato.io/_llms-txt/astrato-writeback-and-actions-implementing-secure-data-updates.txt): This article demonstrates implementing authorization workflows using Writeback and Actions for secure data modifications. - [astrato-app-filter-bar operations](https://docs.astrato.io/_llms-txt/astrato-app-filter-bar-operations.txt): Operation names, descriptions and complete JSON payload schemas for astrato-app-filter-bar visualizations. - [Astrato's Data Engine](https://docs.astrato.io/_llms-txt/astratos-data-engine.txt): Use USS & Astrato's data engine to solve the most challengin problems of data modeling that occur in Business Intelligence (BI) - [Auth: OEM API (Web Ticket Authentication)](https://docs.astrato.io/_llms-txt/auth-oem-api-web-ticket-authentication.txt): Setup web ticket authentication in Astrato - [Authentication](https://docs.astrato.io/_llms-txt/authentication.txt): Choose authentication for externally hosted apps, Data Apps, MCP clients, scripts, and browser sessions. - [AWS Private Connection](https://docs.astrato.io/_llms-txt/aws-private-connection.txt): How to set a private connection between Astrato and sources in AWS. - [AWS Privatelink Connection](https://docs.astrato.io/_llms-txt/aws-privatelink-connection.txt): This document describes the steps to connect Astrato and a secured data source in AWS using AWS Privatelink. - [Azure AD / Entra ID & Snowflake Federated Identity Setup Guide](https://docs.astrato.io/_llms-txt/azure-ad--entra-id--snowflake-federated-identity-setup-guide.txt): Step-by-step guide to configure Entra ID for OAuth 2.0 On-Behalf-Of (OBO) flow with Snowflake external OAuth integration, enabling seamless federated identity between Astrato, Entra ID, and Snowflake. - [Bar Chart](https://docs.astrato.io/_llms-txt/bar-chart.txt): Learn about Astrato bar chart data objects - [bar operations](https://docs.astrato.io/_llms-txt/bar-operations.txt): Operation names, descriptions and complete JSON payload schemas for bar visualizations. - [Bento layout](https://docs.astrato.io/_llms-txt/bento-layout.txt): Pack tiles of different sizes into one board with an area map per width tier: tile and side-column variants, with reflow tiers, scrolling thresholds and when to avoid it. - [Bookmarks - Share & Revisit Insights](https://docs.astrato.io/_llms-txt/bookmarks---share--revisit-insights.txt): Bookmarks in Astrato, pick up from where you left off, and share with your colleagues - [Browser Page Freezes: Causes and Prevention](https://docs.astrato.io/_llms-txt/browser-page-freezes-causes-and-prevention.txt): A "Wait or Exit" message indicates the browser is overwhelmed by simultaneous processing demands. - [Build with Astrato](https://docs.astrato.io/_llms-txt/build-with-astrato.txt): Start with governed data, interactive visualizations, and AI-assisted workflows in Astrato. - [Building A chart with Dynamic Measure](https://docs.astrato.io/_llms-txt/building-a-chart-with-dynamic-measure.txt): The document will show how to create a chart that allows end-users to change the measure displayed in the chart. - [Business question YAML reference](https://docs.astrato.io/_llms-txt/business-question-yaml-reference.txt): The V3 Business Question contract: selections, filters, formulas, calculations, output and V2 migration. - [Business questions guide](https://docs.astrato.io/_llms-txt/business-questions-guide.txt): List, read, and execute governed business questions over MCP, and turn one into a chart. - [Card (object frame)](https://docs.astrato.io/_llms-txt/card-object-frame.txt): Frame one chart or table with a title, a subtitle, a host with a definite box, an optional note and an object-menu button, at fixed heights so hosts align across a row. - [Card grid layout](https://docs.astrato.io/_llms-txt/card-grid-layout.txt): Repeat one card design for each metric or item: fixed-set, item-list and grouped-row variants, with column counts, reflow tiers and scrolling thresholds. - [Chart Filters](https://docs.astrato.io/_llms-txt/chart-filters.txt): Chart filters are filters applied to a specific object or visualization. - [Chart switcher](https://docs.astrato.io/_llms-txt/chart-switcher.txt): Show the same data as a bar chart, a line chart or a table from a toggle group in the card's title row: one object per type with only the shown one mounted, or an operation within one type. - [Choose a chart](https://docs.astrato.io/_llms-txt/choose-a-chart.txt): Match a Business Question and verified data to a chart, including less common forms for distributions, relationships, flows and hierarchies. - [Choose a layout](https://docs.astrato.io/_llms-txt/choose-a-layout.txt): Pick a dashboard or free form app layout by reading flow, content and interaction; start with general layouts, then consider specialized pages. - [Choose a style](https://docs.astrato.io/_llms-txt/choose-a-style.txt): Choose a visual treatment for a dashboard or free form app, from the Astrato default to explanatory and editorial styles. - [Choose an expert approach](https://docs.astrato.io/_llms-txt/choose-an-expert-approach.txt): Choose optional design guidance for a dashboard: monitoring, design process, explanation, accurate comparison or dense analysis. - [Choose components](https://docs.astrato.io/_llms-txt/choose-components.txt): Start with page framing and states, then add filters, navigation, explanation and other controls that support the app flow. - [Choose how to build](https://docs.astrato.io/_llms-txt/choose-how-to-build.txt): Decide whether to build a Data App with Astrato App Builder or with your own AI assistant, and when to combine them. - [Collections - Getting Started](https://docs.astrato.io/_llms-txt/collections---getting-started.txt): Group your published workbooks into collections - [Combo Chart](https://docs.astrato.io/_llms-txt/combo-chart.txt): Learn about Astrato combo charts - [combo operations](https://docs.astrato.io/_llms-txt/combo-operations.txt): Operation names, descriptions and complete JSON payload schemas for combo visualizations. - [Compare page](https://docs.astrato.io/_llms-txt/compare-page.txt): Place two to four items side by side with the same charts: item headers, aligned rows, a difference column, selection groups per item, and reflow tiers. - [Compose a dashboard page](https://docs.astrato.io/_llms-txt/compose-a-dashboard-page.txt): Build a storytelling free-form App by default: verify Business Questions, choose a narrative and compose its charts, layout and interactions. - [Configure an MCP client](https://docs.astrato.io/_llms-txt/configure-an-mcp-client.txt): Set the Astrato MCP URL for developer clients such as Codex, VS Code and Claude Code, using OAuth or a personal access token. - [Connect an AI assistant to Astrato MCP](https://docs.astrato.io/_llms-txt/connect-an-ai-assistant-to-astrato-mcp.txt): Set up Claude, ChatGPT, Snowflake CoCo (Cortex Code), VS Code or OpenAI Codex or another AI assistant to read and edit your semantic layer. - [Connect an AI Assistant to Astrato via MCP](https://docs.astrato.io/_llms-txt/connect-an-ai-assistant-to-astrato-via-mcp.txt): Connect Claude, ChatGPT, VS Code, Codex or Cortex Code to Astrato over MCP so an assistant can read and edit your semantic layer. - [Connect Astrato to Google Drive](https://docs.astrato.io/_llms-txt/connect-astrato-to-google-drive.txt): Set up the connection once, and anyone in your workspace can have reports delivered straight into a Google shared drive. - [Connect to Astrato](https://docs.astrato.io/_llms-txt/connect-to-astrato.txt): Once the Add-in is installed, the next step is to connect it to Astrato. A connection authenticates you against your Astrato instance. Until you've authenticated, the panel greets you with **Connect to Astrato**. - [Connecting Astrato to Clickhouse (via PostgreSQL interface)](https://docs.astrato.io/_llms-txt/connecting-astrato-to-clickhouse-via-postgresql-interface.txt): In this article, we show you how to connect your Astrato workspace to Clickhouse via PostgreSQL interface. - [Connecting Supabase to Astrato Analytics](https://docs.astrato.io/_llms-txt/connecting-supabase-to-astrato-analytics.txt): Astrato connects to Supabase for low-cost, scalable analytics in the cloud, using a managed PostgreSQL service. - [Connecting to Amazon Redshift](https://docs.astrato.io/_llms-txt/connecting-to-amazon-redshift.txt): In this article, we show you how to connect your Astrato workspace to Amazon Redshift. - [Connecting to Databricks](https://docs.astrato.io/_llms-txt/connecting-to-databricks.txt): This article shows you how to connect your Astrato workspace to Databricks. - [Connecting to Dremio Cloud](https://docs.astrato.io/_llms-txt/connecting-to-dremio-cloud.txt): In this article, we'll show you how to connect your Astrato workspace to Dremio Cloud with a personal access token. - [Connecting to Google BigQuery (OAuth, JWT)](https://docs.astrato.io/_llms-txt/connecting-to-google-bigquery-oauth-jwt.txt): In this article, we're going to show you how to connect your Astrato workspace to a data source in Google BigQuery. - [Connecting to Google Sheets](https://docs.astrato.io/_llms-txt/connecting-to-google-sheets.txt): Connect your Astrato workspace to Google Sheets in just a few quick steps. - [Connecting to MotherDuck](https://docs.astrato.io/_llms-txt/connecting-to-motherduck.txt): In this article, we show you how to connect your Astrato workspace to MotherDuck. - [Connecting to PostgreSQL](https://docs.astrato.io/_llms-txt/connecting-to-postgresql.txt): Connecting to and using PostgreSQL as a data source - [Connecting to Snowflake](https://docs.astrato.io/_llms-txt/connecting-to-snowflake.txt): Connect Astrato to a Snowflake database in just a few quick steps - [Connecting to Supabase](https://docs.astrato.io/_llms-txt/connecting-to-supabase.txt): In this article, we show you how to connect your Astrato workspace to Supabase. - [Consumption-based licensing](https://docs.astrato.io/_llms-txt/consumption-based-licensing.txt): In addition to seat-based licensing, Astrato offers a consumption-based licensing model measured in usage credits. - [Controls (Triggers)](https://docs.astrato.io/_llms-txt/controls-triggers.txt): In the Control group of the Triggers section, there are blocks that initiate the execution of the connected block stack. - [Create a custom Astrato Login page for your portal](https://docs.astrato.io/_llms-txt/create-a-custom-astrato-login-page-for-your-portal.txt): Create a custom login page for Astrato using the OEM API Web Ticket authentication flow. - [Create a dimension in Business Context](https://docs.astrato.io/_llms-txt/create-a-dimension-in-business-context.txt): Create the dimensions people break your numbers down by: a single field, a drill-through path, buckets, your own custom groups, stored sets, or a time intelligence axis. - [Create a semantic layer](https://docs.astrato.io/_llms-txt/create-a-semantic-layer.txt): Start a semantic layer from the Create menu in Data & AI: an empty layer, a copy of an existing one, a Snowflake semantic view, or a YAML file exported from the editor. - [Create a Snowflake semantic view](https://docs.astrato.io/_llms-txt/create-a-snowflake-semantic-view.txt): Download the SQL that recreates your semantic layer as a Snowflake semantic view. - [Create and manage datasets](https://docs.astrato.io/_llms-txt/create-and-manage-datasets.txt): A dataset is a collection of dimensions and measures from your semantic layer that you import into Excel — build it once, reuse it anytime. - [Creating a Collection](https://docs.astrato.io/_llms-txt/creating-a-collection.txt): Create a collection to organize your Astrato workbooks - [Creating a Connection to ClickHouse](https://docs.astrato.io/_llms-txt/creating-a-connection-to-clickhouse.txt): 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 Workbook](https://docs.astrato.io/_llms-txt/creating-a-workbook.txt): Create an Astrato workbook in a few simple steps - [Creating and managing User Groups in Astrato](https://docs.astrato.io/_llms-txt/creating-and-managing-user-groups-in-astrato.txt): Learn how to setup user groups in Astrato for granting access to workbooks, collections and more. User groups let you define permissions once — on collections, semantic layers, and data connections — grant them instantly to anyone who joins the group. - [Creating custom SQL fields (calculated columns)](https://docs.astrato.io/_llms-txt/creating-custom-sql-fields-calculated-columns.txt): Create a Custom Field (custom-calculated column) to add and test out new useful fields- without affecting your source data. - [Creating Dimensions in the Semantic Layer Editor](https://docs.astrato.io/_llms-txt/creating-dimensions-in-the-semantic-layer-editor.txt): No code creation of buckets and drill through dimensions - [Creating efficient queries using data Query Profile Insights](https://docs.astrato.io/_llms-txt/creating-efficient-queries-using-data-query-profile-insights.txt): Stop wasting time on inefficient queries using Astrato's data Query Profile Insights Snowflake's GET_QUERY_OPERATOR_STATS - [Creating Measures in the Semantic Layer Editor](https://docs.astrato.io/_llms-txt/creating-measures-in-the-semantic-layer-editor.txt): No coding is required to write expressions using Astrato's measures in the Data Explorer. - [Creating variables to use with objects](https://docs.astrato.io/_llms-txt/creating-variables-to-use-with-objects.txt): Create boolean, number and string variables to use with objects on your dashboard. - [Cumulative Waterfall Chart](https://docs.astrato.io/_llms-txt/cumulative-waterfall-chart.txt): Learn when and how to use the cumulative waterfall chart - [Data App developer guide](https://docs.astrato.io/_llms-txt/data-app-developer-guide.txt): Start a Data App, follow the build order, and find the guide for each implementation task. - [Data App runtime reference](https://docs.astrato.io/_llms-txt/data-app-runtime-reference.txt): Bootstrap Data Apps and handle publication changes with automatic reload, loop prevention and the onPublicationChanged hook. - [Data Apps - AI Assistant Quickstart](https://docs.astrato.io/_llms-txt/data-apps---ai-assistant-quickstart.txt): Configure an existing frontend project as a Data App, connect it through the Astrato CLI, use the Data App runtime, and build and publish it. - [Data Apps - Frequently Asked Questions (FAQs)](https://docs.astrato.io/_llms-txt/data-apps---frequently-asked-questions-faqs.txt): Answers to common questions about building, publishing and sharing Astrato Data Apps. - [Data Apps - Nash App Builder UI](https://docs.astrato.io/_llms-txt/data-apps---nash-app-builder-ui.txt): Build a Data App without code by describing it to Nash, preview it live in Astrato, and publish it from the same screen. - [Data connections](https://docs.astrato.io/_llms-txt/data-connections.txt): Create a data connection and choose the source for your semantic layers. - [Data Connections - Getting Started in Astrato](https://docs.astrato.io/_llms-txt/data-connections---getting-started-in-astrato.txt): Start working with Data in Astrato, whitelist Astrato, setup authentication and RBAC/RLS. - [Data connections and CSV imports with MCP](https://docs.astrato.io/_llms-txt/data-connections-and-csv-imports-with-mcp.txt): Create, update and browse data connections and import CSV files through MCP, without sending credentials through the conversation. - [Data dialogs and exports](https://docs.astrato.io/_llms-txt/data-dialogs-and-exports.txt): Display and export app-owned query results as CSV or Excel, and capture dashboard objects as images. - [Data Notification - Setup Guide (BETA)](https://docs.astrato.io/_llms-txt/data-notification---setup-guide-beta.txt): Astrato's Data Notification allows users to share and receive notifications from their Astrato app in their organization messaging platform (Slack, Microsoft... - [Data Object Container properties](https://docs.astrato.io/_llms-txt/data-object-container-properties.txt): Set object name, size, background and borders, create object titles using AI, manage the position and size of Astrato objects. Set variable scopes. - [Data Objects - Getting Started](https://docs.astrato.io/_llms-txt/data-objects---getting-started.txt): Start working with data objects - [Databricks Pricing Breakdown: Understanding Your Cloud Analytics Spend](https://docs.astrato.io/_llms-txt/databricks-pricing-breakdown-understanding-your-cloud-analytics-spend.txt): Break down Databricks pricing, calculate total costs, and use our Excel cost calculator to optimize your data platform spending. - [Date (Operators)](https://docs.astrato.io/_llms-txt/date-operators.txt): Date blocks are essential tools for manipulating and formatting dates and times within a workbook. - [date-picker operations](https://docs.astrato.io/_llms-txt/date-picker-operations.txt): Operation names, descriptions and complete JSON payload schemas for date-picker visualizations. - [Debugging Actions in Astrato](https://docs.astrato.io/_llms-txt/debugging-actions-in-astrato.txt): This guide is for developers. It covers how to enable action logging, read the output in your browser console, and trace which block triggered a given action. - [Define a measure in Business Context](https://docs.astrato.io/_llms-txt/define-a-measure-in-business-context.txt): Define a measure once in Business Context so every workbook reports the same number the same way. - [Define the Data Model in Astrato](https://docs.astrato.io/_llms-txt/define-the-data-model-in-astrato.txt): Use Astrato's smart joins features to connect your tables and build your data model effectively. - [Demo quick track](https://docs.astrato.io/_llms-txt/demo-quick-track.txt): Prepare a demo context and generate a small live dashboard or free form app in one pass, with an under-one-minute timing target. - [Design first: Using manual data](https://docs.astrato.io/_llms-txt/design-first-using-manual-data.txt): Users can build and design dashboards before connecting data, by adding manual mockup data sets. - [Design Responsive Dashboards in Astrato](https://docs.astrato.io/_llms-txt/design-responsive-dashboards-in-astrato.txt): Astrato is fully responsive, meaning dashboards adapt to the screen and browser environment of the end user. This article outlines what developers should know when designing workbooks to look great across devices. - [Designing for Scrollable & Mobile Dashboards in Astrato](https://docs.astrato.io/_llms-txt/designing-for-scrollable--mobile-dashboards-in-astrato.txt): Build clean, mobile-ready dashboards for both iPhone and Android. Learn how to size your sheets for small screens, design inside the editor using a true mobile layout, and automatically route mobile users to pages built specifically for them. - [Detail page](https://docs.astrato.io/_llms-txt/detail-page.txt): Show one item on its own page: the item header, the layouts that suit the body, and how the page scopes its selections. - [Dialog](https://docs.astrato.io/_llms-txt/dialog.txt): Open modal content with a native dialog: showModal, a labelled title, size tiers, a drawer, focus and Escape, and mounting objects only while it is open. - [Dimensions and Measures Custom Labels](https://docs.astrato.io/_llms-txt/dimensions-and-measures-custom-labels.txt): Custom Labels for dimensions and measures allow a dynamic change of the label according to users' interaction with the Astrato app. - [distribution-gauge operations](https://docs.astrato.io/_llms-txt/distribution-gauge-operations.txt): Operation names, descriptions and complete JSON payload schemas for distribution-gauge visualizations. - [dot operations](https://docs.astrato.io/_llms-txt/dot-operations.txt): Operation names, descriptions and complete JSON payload schemas for dot visualizations. - [Dot Plot Chart](https://docs.astrato.io/_llms-txt/dot-plot-chart.txt): This article looks at the Dot Plot chart available in Astrato. - [Drill-down](https://docs.astrato.io/_llms-txt/drill-down.txt): Show levels of detail with hierarchical types, charts that filter each other or a date grain control, and understand the limits of drill menus and grouped dimensions. - [Drill-Down and Drill Through Dimension Actions](https://docs.astrato.io/_llms-txt/drill-down-and-drill-through-dimension-actions.txt): Drill-down and drill-through let users move from a summary number to the detail behind it — without leaving the dashboard or asking the data team for a new report. - [Drill-through](https://docs.astrato.io/_llms-txt/drill-through.txt): Open a detail or compare page for an item from links in your own HTML: routing inside one document, the item as a selection, a breadcrumb, back that keeps the overview's selections, and previous and next. - [Drill-Through dimension in the Workbook](https://docs.astrato.io/_llms-txt/drill-through-dimension-in-the-workbook.txt): Drill-Through dimension allows user to change dashboards display and answer a broad range of data questions. Cycle thrrough dimension groups - [Dynamic Period Over Period Analysis](https://docs.astrato.io/_llms-txt/dynamic-period-over-period-analysis.txt): Comparing periods is an essential part of any analytics process. - [Economist style](https://docs.astrato.io/_llms-txt/economist-style.txt): Style charts after The Economist: a red tag above a finding-as-title, a light subtitle with the unit, few lines, a restrained blue palette and a source line. - [Edward Tufte](https://docs.astrato.io/_llms-txt/edward-tufte.txt): Apply Tufte to a Data App: remove non-data ink, keep scales honest, and use small multiples and sparklines. - [Embedding and sharing interactive analytics](https://docs.astrato.io/_llms-txt/embedding-and-sharing-interactive-analytics.txt): Embed Astrato dashboards into your product, portal, or internal app so customers and teams interact with live warehouse data — without you building a custom analytics stack. - [Enabling multi-domain SCIM (Active Directory) for Astrato, with Azure Entra example](https://docs.astrato.io/_llms-txt/enabling-multi-domain-scim-active-directory-for-astrato-with-azure-entra-example.txt): Astrato Guide: Learn to integrate Azure for SSO and SCIM provisioning, manage users and groups, and configure enterprise applications. - [Enterprise Authentication](https://docs.astrato.io/_llms-txt/enterprise-authentication.txt): Learn about working with enterprise authentication in Astrato - [Enterprise Authentication - AWS Cognito](https://docs.astrato.io/_llms-txt/enterprise-authentication---aws-cognito.txt): Setting UP AWS Cognito with Astrato - [Enterprise Authentication - Azure](https://docs.astrato.io/_llms-txt/enterprise-authentication---azure.txt) - [Enterprise Authentication - Google Workspace Setup](https://docs.astrato.io/_llms-txt/enterprise-authentication---google-workspace-setup.txt): Integrate Astrato enterprise authentication with Google Workspace - [Enterprise Authentication - Keycloak](https://docs.astrato.io/_llms-txt/enterprise-authentication---keycloak.txt) - [Enterprise Authentication - OIDC Sync Groups and Roles](https://docs.astrato.io/_llms-txt/enterprise-authentication---oidc-sync-groups-and-roles.txt): Sync OIDC groups and roles with Astrato - [Enterprise Authentication - Open ID Connect Setup](https://docs.astrato.io/_llms-txt/enterprise-authentication---open-id-connect-setup.txt): Integrate Astrato enterprise authentication with Open ID Connect - [Enterprise Authentication - Ping Identity](https://docs.astrato.io/_llms-txt/enterprise-authentication---ping-identity.txt) - [Events (Triggers)](https://docs.astrato.io/_llms-txt/events-triggers.txt): Event blocks are triggers — they run an action automatically when something specific happens inside your workbook, instead of waiting for the user to click a button. - [Excel functions](https://docs.astrato.io/_llms-txt/excel-functions.txt): The Add-in gives you a few extra Excel functions — they all start with `ASTRATO.` and you type them just like any normal formula. - [Excel reporting (Printing)](https://docs.astrato.io/_llms-txt/excel-reporting-printing.txt): Astrato transforms Excel reporting with its live query capabilities, enabling seamless collaboration on financial data. - [Explainer style](https://docs.astrato.io/_llms-txt/explainer-style.txt): Style charts as part of the prose around them: light ground, clean sans-serif, tabular figures and series named in the text instead of a legend. - [Exporting and printing in Astrato](https://docs.astrato.io/_llms-txt/exporting-and-printing-in-astrato.txt): Export to CSV or XLSX for data objects. For images, copy to Clipboard, or export as PDF, PNG, and JPEG. - [Exporting Asrato charts - Image/PDF, CSV, XLSX](https://docs.astrato.io/_llms-txt/exporting-asrato-charts---imagepdf-csv-xlsx.txt): Export chart data, export chart images in Astrato - [Externally hosted app quickstart](https://docs.astrato.io/_llms-txt/externally-hosted-app-quickstart.txt): Build a governed Astrato chart in an app that you host, deploy, and authenticate outside Astrato. - [Filter bar](https://docs.astrato.io/_llms-txt/filter-bar.txt): Show filter objects in a full-width row under the header, above a fixed-height apply bar, and fold them into a filter panel when the row runs out of width. - [Filter Bar](https://docs.astrato.io/_llms-txt/filter-bar-1.txt): Control the filter bar Display - [Filter Bar - Custom Buttons](https://docs.astrato.io/_llms-txt/filter-bar---custom-buttons.txt): The button helps build interactive guided analytics data apps. - [filter operations](https://docs.astrato.io/_llms-txt/filter-operations.txt): Operation names, descriptions and complete JSON payload schemas for filter visualizations. - [Filter panel](https://docs.astrato.io/_llms-txt/filter-panel.txt): Open filters from one header button in an overlay drawer or a docked panel that pushes the board, and unmount their filter objects while the panel is closed. - [Filters and selections](https://docs.astrato.io/_llms-txt/filters-and-selections.txt): Design filtering for a Data App: one selection group, applying pending selections, filter objects that narrow each other, selections on semantic layer items, and reading selections reliably. - [Filters History](https://docs.astrato.io/_llms-txt/filters-history.txt): Filter history allows users to switch between their defined filters. - [Financial Times style](https://docs.astrato.io/_llms-txt/financial-times-style.txt): Style charts after the Financial Times: a salmon paper ground, a headline that states the finding, a subtitle with the unit, a dark blue and claret palette with few accents, and a source line. - [Find a semantic layer](https://docs.astrato.io/_llms-txt/find-a-semantic-layer.txt): Search, filter and sort the semantic layer list in Data & AI, and read what each column is telling you. - [gauge operations](https://docs.astrato.io/_llms-txt/gauge-operations.txt): Operation names, descriptions and complete JSON payload schemas for gauge visualizations. - [Get started with the Astrato Excel Add-in](https://docs.astrato.io/_llms-txt/get-started-with-the-astrato-excel-add-in.txt): Everything you need to pull your Astrato data into Excel and keep it fresh — from your very first connection to fixing the occasional hiccup. - [Get suggestions from your data](https://docs.astrato.io/_llms-txt/get-suggestions-from-your-data.txt): Let Astrato read your model and propose measures, dimensions and business questions, then review each one before you accept it. - [Getting Started with Astrato & Supabase](https://docs.astrato.io/_llms-txt/getting-started-with-astrato--supabase.txt): This guide walks through connecting Supabase to Astrato and building a dashboard from scratch using live query. - [Getting started with color](https://docs.astrato.io/_llms-txt/getting-started-with-color.txt): Getting the most out of color with your data objects and workbooks in Astrato. - [Getting started with Data Apps](https://docs.astrato.io/_llms-txt/getting-started-with-data-apps.txt): Build your first Data App with the App Builder in Astrato, or with a coding assistant on your own computer. - [Getting started with the Semantic Layer Editor](https://docs.astrato.io/_llms-txt/getting-started-with-the-semantic-layer-editor.txt): 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 Workbooks](https://docs.astrato.io/_llms-txt/getting-started-with-workbooks.txt): How to create your Astrato account, access demo data, and add a workbook. - [Getting Started with Workbooks and Collections](https://docs.astrato.io/_llms-txt/getting-started-with-workbooks-and-collections.txt): Understanding the options with Astrato workbooks and collections. - [Go back to an earlier version](https://docs.astrato.io/_llms-txt/go-back-to-an-earlier-version.txt): Compare two versions of your semantic layer and bring back all of an earlier one, or just the changes you pick. - [Governed objects](https://docs.astrato.io/_llms-txt/governed-objects.txt): Build every chart, table and KPI from a stored business question so each figure comes from the semantic layer: syncing questions into the app, headline figures, period changes, display names, threshold groups and what the app may compute. - [Grouped reducer formulas](https://docs.astrato.io/_llms-txt/grouped-reducer-formulas.txt): Index a business question against a baseline using one calculation over completed grouped values. - [Header](https://docs.astrato.io/_llms-txt/header.txt): Put the brand, page title, scope and page controls in one fixed-height row that sticks with the filter bar: title-only, title + controls, title + tabs and backdrop variants. - [heatMap operations](https://docs.astrato.io/_llms-txt/heatmap-operations.txt): Operation names, descriptions and complete JSON payload schemas for heatMap visualizations. - [histogram operations](https://docs.astrato.io/_llms-txt/histogram-operations.txt): Operation names, descriptions and complete JSON payload schemas for histogram visualizations. - [Historical release notes](https://docs.astrato.io/_llms-txt/historical-release-notes.txt): When working with a big dataset and trying to reduce the population, it's important to see the population size at any step in the way. - [Home and navigation](https://docs.astrato.io/_llms-txt/home-and-navigation.txt): Find, ask and continue from the workspace home, and what each area of the left rail holds for your role. - [How do I create a custom flag field in Astrato?](https://docs.astrato.io/_llms-txt/how-do-i-create-a-custom-flag-field-in-astrato.txt): 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 Snowpark works in Astrato](https://docs.astrato.io/_llms-txt/how-snowpark-works-in-astrato.txt): Astrato is snowpark compatible. Run dynamic forecast, clustering models, sentiment analysis and machine learning from Astrato. - [How to Use Associative Filters](https://docs.astrato.io/_llms-txt/how-to-use-associative-filters.txt): Learn how to ask advanced business questions using associative filters - [How versioning works in the semantic layer](https://docs.astrato.io/_llms-txt/how-versioning-works-in-the-semantic-layer.txt): How the editor keeps a history of your semantic layer, why saving is not publishing, and what happens when a publish is blocked. - [Hub layout](https://docs.astrato.io/_llms-txt/hub-layout.txt): Build a landing page that sends readers to other pages: a cards hub with 3 or 4 linked cards and a cover page, with column counts and query cost. - [Identity Federation in Snowflake using External OAuth](https://docs.astrato.io/_llms-txt/identity-federation-in-snowflake-using-external-oauth.txt): Federated identity simplifies the login process by establishing a trust relationship between services. - [IFrame Object](https://docs.astrato.io/_llms-txt/iframe-object.txt): Embed external web pages, apps or videos inside an Astrato workbook. - [iframe operations](https://docs.astrato.io/_llms-txt/iframe-operations.txt): Operation names, descriptions and complete JSON payload schemas for iframe visualizations. - [image operations](https://docs.astrato.io/_llms-txt/image-operations.txt): Operation names, descriptions and complete JSON payload schemas for image visualizations. - [Import a Snowflake semantic view](https://docs.astrato.io/_llms-txt/import-a-snowflake-semantic-view.txt): Start a semantic layer from a Snowflake semantic view you already have, so its tables, joins, dimensions and measures come across without rebuilding them by hand. - [Importing a Workbook](https://docs.astrato.io/_llms-txt/importing-a-workbook.txt): Import a Workbook from an .astx archive in the Library, choose its data connection and decide whether to create or reuse a semantic layer. - [Information is Beautiful style](https://docs.astrato.io/_llms-txt/information-is-beautiful-style.txt): Vivid categorical colour on a flat dark or neutral page, chart forms chosen for the data, strong type hierarchy and wide spacing: tokens, chrome, chart operations and measured contrast. - [Inputs](https://docs.astrato.io/_llms-txt/inputs.txt): Sliders, number inputs and toggles that feed a what-if: values sent as measure parameters or written as selections, the slider object against a native range input, committing on change, and keyboard steps. - [Insert a dataset as a table](https://docs.astrato.io/_llms-txt/insert-a-dataset-as-a-table.txt): Once a dataset exists, there are two ways to get it into the sheet: click it in from the panel, or type a formula to reference it. Clicking it in is the usual choice, because it brings your number and currency formatting with it. - [Install the Add-in](https://docs.astrato.io/_llms-txt/install-the-add-in.txt): Before Excel can talk to Astrato, you need the Add-in. There are two ways to get it — install it yourself, or have your IT team push it to you. - [Integrate with Astrato](https://docs.astrato.io/_llms-txt/integrate-with-astrato.txt): Choose the right interface for your integration: CLI, App runtime, SDK, MCP or an externally hosted app, with authentication and security in one place. - [Interactivity guide](https://docs.astrato.io/_llms-txt/interactivity-guide.txt): Cross-chart brushing, linking, and filters with SDK selection groups. - [Invitation links](https://docs.astrato.io/_llms-txt/invitation-links.txt): Create, share, edit, and revoke invitations to your Astrato workspace. - [Invite users](https://docs.astrato.io/_llms-txt/invite-users.txt): Invite one person or many to your Astrato workspace by email address or CSV file, with a role, groups and license team. - [Inviting & Managing Users, Roles, Teams & Groups](https://docs.astrato.io/_llms-txt/inviting--managing-users-roles-teams--groups.txt): Administration settings to manage Astrato users and teams - [Item header](https://docs.astrato.io/_llms-txt/item-header.txt): Name the item a detail page shows in a fixed-height strip with an optional breadcrumb, the name and identifying attributes, previous and next, and a link back. - [KPI card](https://docs.astrato.io/_llms-txt/kpi-card.txt): Show one headline number with its change on a comparison period and its trend: variants, fixed rows that make a 96px card, simple value and delta presentation, native number mounting and chart-based trends. - [KPI-led layout](https://docs.astrato.io/_llms-txt/kpi-led-layout.txt): Place KPIs before the charts that explain them: grid, hero, column and subject-column variants, with reflow tiers and scrolling thresholds. - [Layout and responsiveness](https://docs.astrato.io/_llms-txt/layout-and-responsiveness.txt): Fill the available dashboard space, contain detail-table scrolling and adapt layouts with grid, breakpoints and container queries. - [Legend](https://docs.astrato.io/_llms-txt/legend.txt): Name what each colour means with direct labels, the chart's own legend, or an HTML legend for an object you draw yourself. - [Leveraging GenAI with Google BigQuery in Astrato](https://docs.astrato.io/_llms-txt/leveraging-genai-with-google-bigquery-in-astrato.txt): Get the most out of BigQuery ML & AI capabilities with Astrato. - [License and usage](https://docs.astrato.io/_llms-txt/license-and-usage.txt): Check your workspace's license, allocate time to license teams, and read usage by team or user. - [License teams](https://docs.astrato.io/_llms-txt/license-teams.txt): Find license teams and inspect their allocation and users. - [Line Chart](https://docs.astrato.io/_llms-txt/line-chart.txt): Learn about Astrato line charts - [line operations](https://docs.astrato.io/_llms-txt/line-operations.txt): Operation names, descriptions and complete JSON payload schemas for line visualizations. - [Loaders](https://docs.astrato.io/_llms-txt/loaders.txt): Show a boot loader until the Data App runtime is ready, turn it into an error with the request ID when start-up fails, and show loading placeholders that keep each host's size. - [Locked Filters](https://docs.astrato.io/_llms-txt/locked-filters.txt): Locked Filters let you fix important filters in place so viewers can explore data safely without changing key context. - [Long-form layout](https://docs.astrato.io/_llms-txt/long-form-layout.txt): Stack sections on a page read top to bottom: sections, numbered steps, a sticky chart with steps, alternating text and charts, and reveal on scroll, with fixed chart floors and reflow tiers. - [Maintaining a single source of truth through ELT](https://docs.astrato.io/_llms-txt/maintaining-a-single-source-of-truth-through-elt.txt): Improve scalability and disaster recovery by applying business logic to raw data in cloud data warehouses. - [Manage Content Security Policy origins](https://docs.astrato.io/_llms-txt/manage-content-security-policy-origins.txt): Allow external content to load inside Astrato frames. - [Manage Data Apps](https://docs.astrato.io/_llms-txt/manage-data-apps.txt): Publish Data Apps with the CLI or App Builder, and manage access and hosting in the lobby or Nash MCP. - [Manage delivery integrations](https://docs.astrato.io/_llms-txt/manage-delivery-integrations.txt): Add, edit, test and remove the integrations used to deliver reports. - [Manage embed links](https://docs.astrato.io/_llms-txt/manage-embed-links.txt): Review, edit and revoke embedded workbook content in your workspace. - [Manage groups and assignment rules](https://docs.astrato.io/_llms-txt/manage-groups-and-assignment-rules.txt): Manage group membership and automatic assignments in Administration. - [Manage resource access](https://docs.astrato.io/_llms-txt/manage-resource-access.txt): Set profiles or individual permissions for semantic layers and data connections. - [Manage workspace media](https://docs.astrato.io/_llms-txt/manage-workspace-media.txt): Find, upload, organize and delete images and report templates in Administration. - [Managing Collections](https://docs.astrato.io/_llms-txt/managing-collections.txt): Learn how to work with collections - [Managing Licensing and Usage](https://docs.astrato.io/_llms-txt/managing-licensing-and-usage.txt): Overview of Astrato's license types and allocating them by user or team - [Managing Users and Groups with Astrato API](https://docs.astrato.io/_llms-txt/managing-users-and-groups-with-astrato-api.txt): This Article covers an approach to managing users in Astrato using API calls. This is primarily relevant for embedded solutions where the users don't sign in to Astrato directly. - [Managing Workbooks](https://docs.astrato.io/_llms-txt/managing-workbooks.txt): Learn how to manage your Astrato workbooks - [Manually Revoking OAuth Integration Tokens](https://docs.astrato.io/_llms-txt/manually-revoking-oauth-integration-tokens.txt): OAuth tokens are generated when a user uses a workbook or a semantic layer that uses an OAuth connection (Snowflake, Databricks). - [Map](https://docs.astrato.io/_llms-txt/map.txt): Maps in a Data App: no map type is available; what applies if you draw a choropleth yourself from your own query, and when to use a ranked chart instead. - [Map Interactions - Visual Tooltip](https://docs.astrato.io/_llms-txt/map-interactions---visual-tooltip.txt): Tooltips help users learn about the context of the map display. - [Map-led layout](https://docs.astrato.io/_llms-txt/map-led-layout.txt): Make a map the primary object: side-panel, overlay and map-plus-list variants, with a bounded map height on narrow screens and scrolling thresholds. - [Master–detail layout](https://docs.astrato.io/_llms-txt/masterdetail-layout.txt): Pick one item from a list and show its detail beside it: list and detail, and summary band with list and detail variants, with the selection wiring, reflow tiers and scrolling thresholds. - [MCP administration and limits](https://docs.astrato.io/_llms-txt/mcp-administration-and-limits.txt): Update tenant users through MCP, understand exit-node routing, and see what MCP does not cover. - [MCP contract changes](https://docs.astrato.io/_llms-txt/mcp-contract-changes.txt): Version history of the Astrato MCP tool contract, covering tool, argument and scope changes. - [MCP overview](https://docs.astrato.io/_llms-txt/mcp-overview.txt): Connect an AI assistant or coding agent to Astrato over the Model Context Protocol, and find the guide for each part of the setup. - [MCP results and errors](https://docs.astrato.io/_llms-txt/mcp-results-and-errors.txt): Read MCP tool results, handle refusals and transport errors, set query response budgets and capture query replays. - [MCP scopes and permissions](https://docs.astrato.io/_llms-txt/mcp-scopes-and-permissions.txt): What each Astrato MCP OAuth scope allows, how roles limit it, and how to restore missing baseline scopes. - [MCP tool reference](https://docs.astrato.io/_llms-txt/mcp-tool-reference.txt): Every Astrato MCP tool with the scopes it requires and what it does. - [Measure Parameters](https://docs.astrato.io/_llms-txt/measure-parameters.txt): Measure parameters open an opportunity for end-users to change the result of a measure by changing the parameter values. - [Metric switcher](https://docs.astrato.io/_llms-txt/metric-switcher.txt): Change which measure one or more charts show: a segmented control or selectable KPI cards as toggle buttons, one instance per measure with only the pressed one mounted, and what each switch costs in queries. - [Migrating from QlikView / Qlik Sense to Astrato](https://docs.astrato.io/_llms-txt/migrating-from-qlikview--qlik-sense--to-astrato.txt): Exploring the Path to Success: A Comprehensive Guide to Migrating from Qlik to Astrato - [Mini charts (sparklines)](https://docs.astrato.io/_llms-txt/mini-charts-sparklines.txt): Show sparkline trends and bars on each row, for a given measure. Gain extra insight without needing any more than a table. - [Motion and texture](https://docs.astrato.io/_llms-txt/motion-and-texture.txt): Add quiet, brand-led motion to a Data App: decorative navigation layers, ambient backdrops and chart textures that stay low contrast, follow the theme and fall back cleanly. - [Mounting objects](https://docs.astrato.io/_llms-txt/mounting-objects.txt): Compile visualization definitions, check operation results, manage mount lifecycles and configure tables and charts. - [Multi-Factor Authentication (MFA)](https://docs.astrato.io/_llms-txt/multi-factor-authentication-mfa.txt): Multi-factor authentication helps secure access to Astrato tenants. - [Multi-Measures Waterfall Chart](https://docs.astrato.io/_llms-txt/multi-measures-waterfall-chart.txt): This article looks at Astrato's Waterfall visualization. - [Narrative](https://docs.astrato.io/_llms-txt/narrative.txt): State what the numbers show in a sentence built from query results: templates with explicit direction and flat rules, the pinned locale, empty and single-period data, as a page summary, card subtitle or section lead. - [Nash AI - Astrato's Agentic AI Assistant](https://docs.astrato.io/_llms-txt/nash-ai---astratos-agentic-ai-assistant.txt): Nash AI is Astrato's agentic BI assistant. Unlike generic AI tools that generate charts directly, Nash builds and maintains your governed semantic layer first, then creates dashboards, reports and analytics experiences on top of it. - [Nash conversations](https://docs.astrato.io/_llms-txt/nash-conversations.txt): Keep conversations across Astrato and choose where their history is stored. - [Navigation (Workbook)](https://docs.astrato.io/_llms-txt/navigation-workbook.txt): Navigation blocks are essential tools for creating dynamic and interactive workbooks. - [Notifications](https://docs.astrato.io/_llms-txt/notifications.txt): Open your notification inbox, follow notification actions and manage unread items in the new lobby. - [Notifications- Integration Setup- (BETA)](https://docs.astrato.io/_llms-txt/notifications--integration-setup--beta.txt): \ This feature is in BETA status; some settings might change over time\ - [Number (KPI object)](https://docs.astrato.io/_llms-txt/number-kpi-object.txt): Learn about number data objects in Astrato - [Number & Date Formatting](https://docs.astrato.io/_llms-txt/number--date-formatting.txt): Formatting dates and numbers in Astrato, including solving for viewing across timezones. - [number operations](https://docs.astrato.io/_llms-txt/number-operations.txt): Operation names, descriptions and complete JSON payload schemas for number visualizations. - [Object menu](https://docs.astrato.io/_llms-txt/object-menu.txt): Give every object in a Data App a right-click menu: the default items, how to wire one listener for the whole page, scoping by region, and accessible disabled items. - [Object states](https://docs.astrato.io/_llms-txt/object-states.txt): Show loading, no data, error and timeout on the affected object while the rest of the page loads, with clear-filters and retry actions and an unchanged host size. - [Objects (Workbook)](https://docs.astrato.io/_llms-txt/objects-workbook.txt): The Get [Object] [Property] block retrieves specific properties of an object, such as object configuration, layout settings or display options. - [Ops wall layout](https://docs.astrato.io/_llms-txt/ops-wall-layout.txt): Build an always-on screen of live status read at a distance: status grid and status grid with event feed, scaled to one fixed viewport, with what the docs say about refreshing its data. - [Optimizing Snowflake: 11 Best Practices](https://docs.astrato.io/_llms-txt/optimizing-snowflake-11-best-practices.txt): Snowflake’s unique architecture for efficient data visualization. Utilize scalable compute to adapt dynamically to varying data demands. - [Page states](https://docs.astrato.io/_llms-txt/page-states.txt): Show one message when a cause applies to the whole page: an app published against an earlier model, requests Astrato refuses, no data for the current filters, or offline. - [Parameters vs variables](https://docs.astrato.io/_llms-txt/parameters-vs-variables.txt): Both feed dynamic values into your data, but they live in different places and do different jobs. - [Passthrough Authentication - Snowflake](https://docs.astrato.io/_llms-txt/passthrough-authentication---snowflake.txt): 🔒 Extend your Snowflake security into Astrato. Includes RBAC (Role-based access control) and row-level security - [Performance - Creating Snapshots of Views/Queries, pre-calculate your metrics](https://docs.astrato.io/_llms-txt/performance---creating-snapshots-of-viewsqueries-pre-calculate-your-metrics.txt): Learn about using a data mart to optimize Astrato performance levels - [Performance & Usage Telemetry: Store Astrato activity in ClickHouse](https://docs.astrato.io/_llms-txt/performance--usage-telemetry-store-astrato-activity-in-clickhouse.txt): This solution leverages ClickHouse uery logs to create a persistent query history dataset, enabling teams to analyse performance, cost, and analytics usage at the level of users, dashboards, and business context. - [Performance & Usage Telemetry: Store Astrato activity in Databricks](https://docs.astrato.io/_llms-txt/performance--usage-telemetry-store-astrato-activity-in-databricks.txt): This solution leverages Databricks query logs to create a persistent query history dataset, enabling teams to analyse performance, cost, and analytics usage at the level of users, dashboards, and business context. - [Performance & Usage Telemetry: Store Astrato activity in Google BigQuery](https://docs.astrato.io/_llms-txt/performance--usage-telemetry-store-astrato-activity-in-google-bigquery.txt): 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 context. - [Performance & Usage Telemetry: Store Astrato activity in PostgreSQL/Supabase](https://docs.astrato.io/_llms-txt/performance--usage-telemetry-store-astrato-activity-in-postgresqlsupabase.txt): View Astrato adoption & user activity dashboards, directly using PostgreSQL logs. - [Performance & Usage Telemetry: Store Astrato activity in Snowflake + Setup Astrato Activity Workbook](https://docs.astrato.io/_llms-txt/performance--usage-telemetry-store-astrato-activity-in-snowflake--setup-astrato-activity-workbook.txt): View Astrato adoption & user activity dashboards, directly using Snowflake's logs. - [Period axes and comparisons](https://docs.astrato.io/_llms-txt/period-axes-and-comparisons.txt): Use the same calendar-period definition in a reusable dimension and a business question. - [Period picker](https://docs.astrato.io/_llms-txt/period-picker.txt): Let readers choose the period a page shows, month to date through a custom range, with an optional comparison period: a hand-built preset control or a mounted date picker. - [Personal Access Token - (Private Preview)](https://docs.astrato.io/_llms-txt/personal-access-token---private-preview.txt): A personal access token (PAT) allows users to call Astrato API endpoints and perform actions in the Astrato tenant. - [pie operations](https://docs.astrato.io/_llms-txt/pie-operations.txt): Operation names, descriptions and complete JSON payload schemas for pie visualizations. - [Pivot Table](https://docs.astrato.io/_llms-txt/pivot-table.txt): Astrato's Pivot Table allows you to dynamically slice and dice your data, drilling down and through the data in an interactive display. - [Platform metadata exports](https://docs.astrato.io/_llms-txt/platform-metadata-exports.txt): Download platform metadata as CSV and schedule metadata exports to your own data connection. - [PowerPoint reporting (Printing) Public Preview](https://docs.astrato.io/_llms-txt/powerpoint-reporting-printing-public-preview.txt): Astrato transforms PowerPoint reporting with live-query capabilities, automating the workflows teams already rely on. - [Predefined time periods in Astrato](https://docs.astrato.io/_llms-txt/predefined-time-periods-in-astrato.txt): Quickly and easily set a dynamic range of dates to filter your results. - [Progress Chart](https://docs.astrato.io/_llms-txt/progress-chart.txt): Learn about Astrato progress charts - [Promoting Workbooks Between Environments (DEV → UAT → PROD) - Private Preview](https://docs.astrato.io/_llms-txt/promoting-workbooks-between-environments-dev--uat--prod---private-preview.txt): Learn how to publish and promote workbooks across DEV, UAT, and PROD environments, and understand the three semantic layer options available during promotion. - [Properties Panel](https://docs.astrato.io/_llms-txt/properties-panel.txt): Learn how to work with the Astrato properties panel - [Publish your changes](https://docs.astrato.io/_llms-txt/publish-your-changes.txt): Publish your semantic layer to the live model, choose when publishing happens, and clear the issues that hold it back. - [Publish your semantic layer](https://docs.astrato.io/_llms-txt/publish-your-semantic-layer.txt): Release your changes to everyone, choose when publishing happens, and understand why the button is sometimes greyed out. - [Publishing a Workbook](https://docs.astrato.io/_llms-txt/publishing-a-workbook.txt): Publish your Astrato workbook and add it to a collection - [Query governed data with MCP](https://docs.astrato.io/_llms-txt/query-governed-data-with-mcp.txt): Choose the right tier for a data question, from stored questions to raw fields, and read the pages that list them. - [Query performance](https://docs.astrato.io/_llms-txt/query-performance.txt): Keep a multi-tab Data App fast on load and on every selection: a query scheduler around engine.getData, visible-tab-only selection groups, one refresh per selection change, and how to measure load and interaction cost. - [Querying the engine](https://docs.astrato.io/_llms-txt/querying-the-engine.txt): Build the queries a Data App needs beyond its visualizations: finding fields, query shapes for stored and raw items, parameters, what a Data App can and cannot reach, and handling model defects visibly. - [Quick filters](https://docs.astrato.io/_llms-txt/quick-filters.txt): Select values of one field from a row of buttons: toggle buttons or a radio group, values from a query, selections written from your own UI, and what to do when the row runs out of width. - [radar operations](https://docs.astrato.io/_llms-txt/radar-operations.txt): Operation names, descriptions and complete JSON payload schemas for radar visualizations. - [Read documentation for your task](https://docs.astrato.io/_llms-txt/read-documentation-for-your-task.txt): Discover relevant guides through llms.txt and reuse verified context. - [Rebuilding a Workbook](https://docs.astrato.io/_llms-txt/rebuilding-a-workbook.txt): Rebuild a Workbook as an app by inspecting object settings, applying supported options and documenting differences. - [Recurring Nash tasks](https://docs.astrato.io/_llms-txt/recurring-nash-tasks.txt): Ask Nash to revisit a business question each morning and send a text summary to Slack. - [Refreshing and working offline](https://docs.astrato.io/_llms-txt/refreshing-and-working-offline.txt): Your dataset definitions live in the workbook, and so does your cached data — the last data you pulled. That's what makes offline and sharing work. - [Reload when an application update is available](https://docs.astrato.io/_llms-txt/reload-when-an-application-update-is-available.txt): Get an available update in the new Astrato application, or dismiss its notification. - [Reporting and workflows](https://docs.astrato.io/_llms-txt/reporting-and-workflows.txt): Manage scheduled reports, subscriptions and workflows from the lobby. - [Reporting- send a report for a range of dates](https://docs.astrato.io/_llms-txt/reporting--send-a-report-for-a-range-of-dates.txt): This article provides step-by-step instructions for sending a report that includes multiple sheets and applying a filter that selects a range of dates. - [Reporting: Loop through users — run as user](https://docs.astrato.io/_llms-txt/reporting-loop-through-users--run-as-user.txt): Peronalised scheduled reporting per user - [Restore an earlier version of your semantic layer](https://docs.astrato.io/_llms-txt/restore-an-earlier-version-of-your-semantic-layer.txt): Compare your model against an earlier version and bring back all of it, or just the parts you want. - [Reusable demo starter](https://docs.astrato.io/_llms-txt/reusable-demo-starter.txt): Reuse a small dashboard shell with live chart definitions, shared selections, responsive cards, state feedback and serialized mount lifecycles. - [Review access across the workspace](https://docs.astrato.io/_llms-txt/review-access-across-the-workspace.txt): See and change who can open every workbook, collection, semantic layer and data connection from one page. - [Review permission requests](https://docs.astrato.io/_llms-txt/review-permission-requests.txt): Review requested access, approve or reject pending rules, and inspect processed requests. - [Row-Level Data Reduction- Private Preview](https://docs.astrato.io/_llms-txt/row-level-data-reduction--private-preview.txt): Row-Level data reduction restricts access to data based on the characteristics of the person viewing the data. - [Sankey Chart](https://docs.astrato.io/_llms-txt/sankey-chart.txt): This article looks at Astrato's Sankey visualization. - [sankey operations](https://docs.astrato.io/_llms-txt/sankey-operations.txt): Operation names, descriptions and complete JSON payload schemas for sankey visualizations. - [scatter operations](https://docs.astrato.io/_llms-txt/scatter-operations.txt): Operation names, descriptions and complete JSON payload schemas for scatter visualizations. - [Scheduled Dashboard Reporting](https://docs.astrato.io/_llms-txt/scheduled-dashboard-reporting.txt): Scheduled reports, right from Astrato. Generate reports and create action workflows to mimic user journeys, cycling through data. - [SDK reference](https://docs.astrato.io/_llms-txt/sdk-reference.txt): SDK reference for queries, metadata, writeback, stored procedures, selections, variables and events. - [Search](https://docs.astrato.io/_llms-txt/search.txt): Find values of a field with the filter object's own search, or narrow a list you draw with a list search that selects nothing and queries nothing. - [Searching & configuring filters](https://docs.astrato.io/_llms-txt/searching--configuring-filters.txt): Search your cloud data warehouse using wildcards. Astrato search uses pushdown SQL, which runs ultrafast, super flexible and up to date. - [Semantic Layer | AI Context [Draft]](https://docs.astrato.io/_llms-txt/semantic-layer--ai-context-draft.txt): AI Context allows Semantic Layer admins to define shared business context and custom instructions for AI capabilities across Astrato workbooks. - [Semantic layer entity model](https://docs.astrato.io/_llms-txt/semantic-layer-entity-model.txt): Entities, containment, references, and ownership boundaries in the Semantic Layer V3 document. - [Semantic layer issues](https://docs.astrato.io/_llms-txt/semantic-layer-issues.txt): Understand semantic-document, upstream-source, and source-check issues in the editor or over MCP. - [Semantic layer workflows](https://docs.astrato.io/_llms-txt/semantic-layer-workflows.txt): Inspect, author, validate, repair, version, and publish an Astrato semantic layer safely over MCP. - [Send a report to Google Drive](https://docs.astrato.io/_llms-txt/send-a-report-to-google-drive.txt): Have a report delivered into a shared drive — on a schedule, or whenever someone clicks a button in a workbook. - [Setting up a custom domain for Astrato](https://docs.astrato.io/_llms-txt/setting-up-a-custom-domain-for-astrato.txt): Configure a custom domain for Astrato on your own AWS CloudFront or Google Cloud Load Balancer, with manual and Terraform steps, TLS setup, headers, and support handoff. - [Setting up a Databricks Oauth Integration](https://docs.astrato.io/_llms-txt/setting-up-a-databricks-oauth-integration.txt): The article will cover the steps to establish an OAuth integration with Databricks. - [Setting up Gemini with Google BigQuery](https://docs.astrato.io/_llms-txt/setting-up-gemini-with-google-bigquery.txt): 1. - [shape operations](https://docs.astrato.io/_llms-txt/shape-operations.txt): Operation names, descriptions and complete JSON payload schemas for shape visualizations. - [Share a workbook](https://docs.astrato.io/_llms-txt/share-a-workbook.txt): You can share an Astrato workbook with anyone — including people who don't have an Astrato login. They see the figures from your last refresh, and the file stays secure because your credentials never travel with it. - [Showcase layout (stage and roster)](https://docs.astrato.io/_llms-txt/showcase-layout-stage-and-roster.txt): Put one item on a stage with its artwork, key facts and one signature chart, and pick it from a roster of tiles: single and compare variants, one scaled composition, the pick handler, image swaps and the stacking breakpoint. - [Side rail](https://docs.astrato.io/_llms-txt/side-rail.txt): Put navigation, filters and export in a rail on the left: icon-only and labelled variants, a drawer at narrow widths, and adding the rail width to a layout's breakpoints. - [simpleTextObject operations](https://docs.astrato.io/_llms-txt/simpletextobject-operations.txt): Operation names, descriptions and complete JSON payload schemas for simpleTextObject visualizations. - [slider operations](https://docs.astrato.io/_llms-txt/slider-operations.txt): Operation names, descriptions and complete JSON payload schemas for slider visualizations. - [Snowflake Functions in Astrato](https://docs.astrato.io/_llms-txt/snowflake-functions-in-astrato.txt): A reference of the Snowflake functions used in Astrato - [Snowflake Supported Features](https://docs.astrato.io/_llms-txt/snowflake-supported-features.txt): Find out about Snowflake supported features in Astrato - [Stephen Few](https://docs.astrato.io/_llms-txt/stephen-few.txt): Apply Few to a Data App: one-screen monitoring, highlighting exceptions only, and standard chart types. - [Storytelling with data style](https://docs.astrato.io/_llms-txt/storytelling-with-data-style.txt): Grey every baseline measure, give the measure that carries the takeaway a single accent colour, title each chart with its action, and remove what does not help. - [Support portal](https://docs.astrato.io/_llms-txt/support-portal.txt): Ask Nash for help and view the support reports you submit. - [Supported Browsers](https://docs.astrato.io/_llms-txt/supported-browsers.txt): Here's a summary of the browser support available for Astrato. - [System settings](https://docs.astrato.io/_llms-txt/system-settings.txt): Manage workspace appearance, access policies, provisioning, reporting limits and IP restrictions. - [table operations](https://docs.astrato.io/_llms-txt/table-operations.txt): Operation names, descriptions and complete JSON payload schemas for table visualizations. - [Table Visualization](https://docs.astrato.io/_llms-txt/table-visualization.txt): Table visualization is an essential part of any dashboard or data app; tables allow users to see a detailed view of the data and to get to the bottom of insi... - [Table-first layout](https://docs.astrato.io/_llms-txt/table-first-layout.txt): Make one table the page: scorecard, report and KPI-column variants, with table height floors, reflow tiers and scrolling thresholds. - [Tabs](https://docs.astrato.io/_llms-txt/tabs.txt): Switch whole views within a page, or the object inside one card, with ARIA tabs or links, keyboard support and only the selected panel's objects mounted. - [Text (Operators)](https://docs.astrato.io/_llms-txt/text-operators.txt): The Text operators section offers a suite of blocks designed to manipulate and transform text data within your workbook. - [Theme toggle](https://docs.astrato.io/_llms-txt/theme-toggle.txt): Switch between light and dark from the header with a toggle button or a light, dark and system choice, stored and applied before the first paint. - [Theming](https://docs.astrato.io/_llms-txt/theming.txt): Configure light and dark themes, colour tokens, contrast, chart palettes and fonts for a Data App. - [Time Travel](https://docs.astrato.io/_llms-txt/time-travel.txt): Implement Time Travel to enable accessing historical data at any point within a defined period. Includes edited or deleted data. - [Tips and tricks for data-driven user experiences | Actions & more](https://docs.astrato.io/_llms-txt/tips-and-tricks-for-data-driven-user-experiences--actions--more.txt): Get the most out of Astrato, as well as a growing library of resources for working with action blocks. - [Toasts](https://docs.astrato.io/_llms-txt/toasts.txt): Show short, non-blocking notices for background actions such as an export, a copied value or failed refreshes, with live regions and auto-dismiss that pauses on hover and focus. - [Top N Charts Display](https://docs.astrato.io/_llms-txt/top-n-charts-display.txt): Top N analysis helps stakeholders focus their attention and resources on the most significant factors driving success or performance within a given dataset o... - [Top-down funnel layout](https://docs.astrato.io/_llms-txt/top-down-funnel-layout.txt): Go one level deeper per row, from KPIs to breakdown charts to a full-width table: fixed-height and scrolling variants, the table floor, the drill-path line, reflow tiers and scrolling thresholds. - [Tree Chart - KPI Tree & KPI Row](https://docs.astrato.io/_llms-txt/tree-chart---kpi-tree--kpi-row.txt): KPI Tree is a visual that breaks a top metric into its drivers, showing what changed and why. This guide covers how to analyse KPIs, compare performance across dimensions, and use KPI Tree, KPI Trellis, and KPI Rows for clearer, connected reporting. - [tree operations](https://docs.astrato.io/_llms-txt/tree-operations.txt): Operation names, descriptions and complete JSON payload schemas for tree visualizations. - [treemap operations](https://docs.astrato.io/_llms-txt/treemap-operations.txt): Operation names, descriptions and complete JSON payload schemas for treemap visualizations. - [Treemap Visualization](https://docs.astrato.io/_llms-txt/treemap-visualization.txt): Treemap Visualization: A Powerful Tool for Hierarchical Data - [Troubleshooting](https://docs.astrato.io/_llms-txt/troubleshooting.txt): Each issue below follows the same shape: what it means, likely causes, and how to fix it. - [Understanding Join direction and quality](https://docs.astrato.io/_llms-txt/understanding-join-direction-and-quality.txt): How join direction and join quality work in the Semantic Layer Editor, and how to review and apply join suggestions. - [Use variables](https://docs.astrato.io/_llms-txt/use-variables.txt): Variables let a cell in your sheet drive what a dataset returns — type a region in a cell, and the data underneath re-queries for that region. It's what-if analysis on live, trusted data. - [Using Charts](https://docs.astrato.io/_llms-txt/using-charts.txt): Data object visualizations - types of charts - [Using Filters - Filtering in Astrato](https://docs.astrato.io/_llms-txt/using-filters---filtering-in-astrato.txt): Filtering narrows down the data available in a workbook to aid focused analysis and to help answer specific business questions. - [Using Graphics in the Workbook Editor](https://docs.astrato.io/_llms-txt/using-graphics-in-the-workbook-editor.txt): Learn about using Images in the workbook editor - [Using Layers to design and manage items](https://docs.astrato.io/_llms-txt/using-layers-to-design-and-manage-items.txt): Learn to use Layers to organize the items on your worksheets and to create groups of items for use as Embedded visualizations. - [Using Snowflake Key-pair Authentication with Astrato (Using a Snowflake service account with Astrato)](https://docs.astrato.io/_llms-txt/using-snowflake-key-pair-authentication-with-astrato-using-a-snowflake-service-account-with-astrato.txt): Key pairs are more secure because they use two keys (one public, one private), keep the private key secret, allow you to verify who sent a message, are easie... - [Using Snowflake MFA with Astrato](https://docs.astrato.io/_llms-txt/using-snowflake-mfa-with-astrato.txt): Astrato supports Snowflake accounts utilizing MFA for enhanced secuirty and governance. - [Using Tables](https://docs.astrato.io/_llms-txt/using-tables.txt): Learn about table data objects in Astrato - [Using The Data-Explorer](https://docs.astrato.io/_llms-txt/using-the-data-explorer.txt): The Data-Explorer is a powerful data analytics exploration tool and no-code query builder. - [Using the Gallery to upload images](https://docs.astrato.io/_llms-txt/using-the-gallery-to-upload-images.txt): Save images to reuse in your workbooks. - [Using the Table's writeback/edit capability](https://docs.astrato.io/_llms-txt/using-the-tables-writebackedit-capability.txt): Enables users to update, insert, and manage data directly inside a dashboard — with every change written back to the underlying data source in real time, using Astrato. - [Using the Toolbar in the Workbook Editor](https://docs.astrato.io/_llms-txt/using-the-toolbar-in-the-workbook-editor.txt): Use the toolbar to select the visuals, filters, graphics, and images for your workbook or dashboard. - [Verifying an app](https://docs.astrato.io/_llms-txt/verifying-an-app.txt): Verify saved questions, live results, interactions, dashboard geometry and long-table scrolling. - [Visual essay style](https://docs.astrato.io/_llms-txt/visual-essay-style.txt): A story read by scrolling: full-bleed sections, a playful display face over a readable body face, one highlight colour, charts that change step by step and motion that respects reduced-motion settings. - [Visualization definition reference](https://docs.astrato.io/_llms-txt/visualization-definition-reference.txt): Creation requirements, supported features, constraints and examples for every visualization definition. - [Visualization operations reference](https://docs.astrato.io/_llms-txt/visualization-operations-reference.txt): All standalone visualization operations, with descriptions and complete JSON payload schemas. - [Visualizations reference](https://docs.astrato.io/_llms-txt/visualizations-reference.txt): @astrato-io/visualizations: registry, chart types, definitions (create), operations (modify), and the render contract. - [waterfall operations](https://docs.astrato.io/_llms-txt/waterfall-operations.txt): Operation names, descriptions and complete JSON payload schemas for waterfall visualizations. - [What Business Context is for](https://docs.astrato.io/_llms-txt/what-business-context-is-for.txt): What the Business Context tab is for, and how measures and dimensions differ from the tables and joins in your semantic model. - [What's new in Astrato](https://docs.astrato.io/_llms-txt/whats-new-in-astrato.txt): See what's new in Astrato - [When an imported Snowflake semantic view changes](https://docs.astrato.io/_llms-txt/when-an-imported-snowflake-semantic-view-changes.txt): How Astrato detects changes to a Snowflake semantic view after you import it, and how to take, remove, or add each changed element. - [When your database schema changes](https://docs.astrato.io/_llms-txt/when-your-database-schema-changes.txt): What Astrato checks when a table or column changes in your data connection, and how to repair a semantic layer that points at something missing. - [Why Doesn't My Excel Export Match My Filtered Table Data?](https://docs.astrato.io/_llms-txt/why-doesnt-my-excel-export-match-my-filtered-table-data.txt): This article explains why Excel exports may show different data than filtered tables because of your action event blocks. - [William S. Cleveland](https://docs.astrato.io/_llms-txt/william-s-cleveland.txt): Apply Cleveland to a Data App: encode comparisons as position on a common scale, prefer dot plots, order by value, and choose the aspect ratio. - [Word Cloud](https://docs.astrato.io/_llms-txt/word-cloud.txt): This article looks at Astrato's Word Cloud visualization. - [word-cloud operations](https://docs.astrato.io/_llms-txt/word-cloud-operations.txt): Operation names, descriptions and complete JSON payload schemas for word-cloud visualizations. - [Workbook Chaining: Sharing Filters and Variables between Astrato Workbooks](https://docs.astrato.io/_llms-txt/workbook-chaining-sharing-filters-and-variables-between-astrato-workbooks.txt): Astrato supports passing filters, variables, and more into both embedded and non-embedded URLs for workbooks. - [Workbook Editor - change the Semantic Layer connected of a workbook](https://docs.astrato.io/_llms-txt/workbook-editor---change-the-semantic-layer-connected-of-a-workbook.txt): How to change/swap data views in Astrato workbooks - [Workbook Editor- Getting Started](https://docs.astrato.io/_llms-txt/workbook-editor--getting-started.txt): Learn how to edit an Astrato workbook - [Workbook Life-Cycle: Managing Environments in Astrato](https://docs.astrato.io/_llms-txt/workbook-life-cycle-managing-environments-in-astrato.txt): Simplify data governance with Astrato. Manage versions for databases, schemas & views, manage DEV, UAT and PRDO environments in Astrato. - [Workbook Life-Cycle: Versioning](https://docs.astrato.io/_llms-txt/workbook-life-cycle-versioning.txt): How to manage a workbook life-cycle using versions & environments. - [Workbooks - Enterprise Onboarding – Internal & Customer-Facing Analytics](https://docs.astrato.io/_llms-txt/workbooks---enterprise-onboarding--internal--customer-facing-analytics.txt): This guide explains the recommended enterprise setup for securely delivering internal authoring and external embedded analytics from a single Astrato tenant. - [Workbooks - Frequently Asked Questions (FAQs)](https://docs.astrato.io/_llms-txt/workbooks---frequently-asked-questions-faqs.txt): Got a question about Astrato? Find your answers here. - [Workbooks Terminology](https://docs.astrato.io/_llms-txt/workbooks-terminology.txt): Learn the names and terms used in Astrato Workbooks - [Working in the Semantic Layer Editor](https://docs.astrato.io/_llms-txt/working-in-the-semantic-layer-editor.txt): Find your way around the Semantic Layer Editor: what the tabs do, how edits are saved, and how work reaches your workbooks. - [Working with Large Datasets (query timeout)](https://docs.astrato.io/_llms-txt/working-with-large-datasets-query-timeout.txt): How to utilize Astrato for analyzing large datasets - [Working with Supabase Edge Functions](https://docs.astrato.io/_llms-txt/working-with-supabase-edge-functions.txt): 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 workflows, alerts, and integrations from live analytics. - [Write-back 101: Use cases and data models](https://docs.astrato.io/_llms-txt/write-back-101-use-cases-and-data-models.txt): Write-back lets people edit, input, and submit data directly from an Astrato dashboard back into your warehouse — no separate app, no spreadsheet hand-off, no data-team ticket. - [Writeback and SQL](https://docs.astrato.io/_llms-txt/writeback-and-sql.txt): Insert and update warehouse rows, call stored procedures and read results with SELECT through an authenticated platform transport. - [Writeback Update Action](https://docs.astrato.io/_llms-txt/writeback-update-action.txt): The Writeback Update Action lets users edit existing rows in your warehouse tables directly from a table visualization in Astrato — adjusting targets, running what-if scenarios, correcting values, or marking records as reviewed. - [Your first Data App](https://docs.astrato.io/_llms-txt/your-first-data-app.txt): Go from a data connection to a published Data App in five steps, with a link to the detailed page for each. ## Notes - Each linked page is generated from the official documentation - The content is automatically generated from the same source as the official documentation