Data Connections
Workbook Editor - change the Semantic Layer connected of a workbookHow to change/swap data views in Astrato workbooks
AWS Private ConnectionHow to set a private connection between Astrato and sources in AWS.
AWS Privatelink Connection
Connecting Data Sources
Initial setup for connecting to your data warehouse / data lake
Connecting to PostgreSQLConnecting to and using PostgreSQL as a data source
Connecting to SnowflakeConnect Astrato to a Snowflake database in just a few quick steps
Connecting to Google BigQuery (OAuth, JWT)
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
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.
Supabase
Supabase specific guides for Astrato workspaces
Working with Supabase Edge FunctionsCall 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…
Performance & Usage Telemetry: Store Astrato activity in PostgreSQL/SupabaseView Astrato adoption & user activity dashboards, directly using PostgreSQL logs.
Astrato for SupabaseAstrato connects to Supabase for low-cost, scalable analytics in the cloud, using a managed PostgreSQL service.
Snowflake
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.
BigQuery
Astrato is a trusted Google Technology Partner. These articles provide details of BigQuery support features.
Performance & Usage Telemetry: Store Astrato activity in Google BigQueryThis 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…