Introduction
This article contains information on Snowflake features supported in Astrato.
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.
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.
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.
As part of Snowflake queries you can leverage
Stored procedures
Time travel
Snowpark UDFs (Python, Java, Scala)
Snowpark External access (access data external to Snowflake: see blog here)
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.