Introduction

This article contains information on Snowflake features supported in Astrato.

Getting Started | Connecting to Snowflake | Snowflake Queries | Snowflake Aggregated Functions

Getting Started

Snowflake data sources can easily connect to Astrato (Figure 1).

Figure 1: Snowflake Connection

If you're new to Snowflake, you can find some useful hints on starting to work with it in the Snowflake user guide.

Back to Top

Connecting to Snowflake

Snowflake data sources require certain connection details to be used with Astrato (Figure 2).

Figure 2: Snowflake Connection

You can find a full list of these details in our article on Connecting to Snowflake.

Back to Top

Snowflake Queries

Astrato will return a Snowflake query ID for each executed SQL statement, and we're working on a UI view for displaying information on query details like credits used, compile time and execution time.

The Snowflake Function Reference contains more information and examples on using query IDs.

Back to Top

Snowflake Aggregated Functions

Aggregated functions are a standard database feature in a database, and Astrato supports all the aggregated functions available for Snowflake.

e.g. SUM returns the sum of non-NULL records.

You can find more details in our reference on Snowflake Functions in Astrato. Snowflake also has an aggregate functions reference which contains information and examples.

Back to Top

Did this answer your question?