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.
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.
How to convert your input data to UTF- 8 before sending it to Snowflake
Snowflake supports three binary formats or encoding schemes: hex, base64, and UTF - 8. Snowflake requires that incoming data files use this encoding. Attempting to load files into Snowflake tables that do not comply with these can result…
SnowConvert: General Functional Differences
Views that select all columns from a single table without any filtering conditions (WHERE clause) are unnecessary in Snowflake and can negatively impact query performance.