How-To: Handle Compilation Memory Exhausted error in Snowflake
Using SnowSQL
In a Snowflake session, you can issue commands to take specific actions. All commands in SnowSQL start with an exclamation point (!), followed by the command name.
Collation support
Collation allows you to specify alternative rules for comparing text strings, which can be used to compare and sort data according to a particular language or other user - specified rules.
String & binary functions
This family of functions perform operations on a string input value, or binary input value (for certain functions), and return a string or numeric value. The functions are grouped by type of operation performed.
Using the Spark Connector
The Spark Connector applies predicate and query pushdown by capturing and analyzing the Spark logical plans for SQL operations. When the data source is Snowflake, the operations are translated into a SQL query and then executed in…
Error "SQL execution internal error: Processing aborted due to error..."
CAUSE: Incidents are unexpected failures in the code path during compilation and/or execution. At Snowflake, these incidents are reported to us automatically with limited metadata information (table and view DDLs) so that we can attempt to…
How to persist the state of SnowSQL commands on completion of a shell script?
ISSUE: With SnowSQL, it is possible with the use of two properties, stop_on_error and exit_on_error that by default are false but they will exit the script when set to true as demonstrated here: test - script.
All functions (alphabetical)
This topic provides a list of all Snowflake system - defined (i.e. built - in) functions, scalar or table, in alphabetical order. The list includes: The name of each function. A summary of each function. A list of the categories that the…
August 02, 2024 — ML Functions: Improved Error Messages in Classification
We are pleased to announce improved error messages for the Classification ML Function. These new messages more clearly communicate the cause of the error and better suggest how to address the core issue.
SnowConvert Custom UDFs
This function takes the directory name and the file name parameters of the Oracle BFILENAME() as STRING and returns a concatenation of them using \. Since BFILE is translated to VARCHAR, the BFILENAME result is handled as text.