Have you ever played “The Whispergame”? You have a group of people and the first person whispers a short story in the next person’s ear. This goes on until the last person of the group has heard the story. Inevitably, the story becomes completely distorted. This is what I hear and see happening in a…
You can change a text value containing a date very easily using the [format] argument of date functions like TO_DATE( ) in Snowflake. See below for an example.
The function SPLIT_TO_TABLE is kind of a niche function in Snowflake, but it can work wonders for some specific use cases. Take a look at the screenshot below to see how it works. Have you ever used this function and if so, what problem were you trying to tackle?
Did you know you can save values in variables in a Snowflake SQL worksheet and use them later in queries?
Ever wanted to extract insights from freeform values in a table? Snowflake AI might be able to assist with that. Snowflake Cortex is a part of the AI features in Snowflake. Snowflake Cortex according to the documentation is… “… a suite of AI features that use large language models (LLMs) to understand unstructured data, answer…
Ever wanted to look for a value in all columns in a Snowflake result set? Snowflake Workspaces make this really easy. The “new” search option is not case-sensitive and results are highlighted in the results pane. In the past you would have to use functions like SEARCH in your where statement. This new method offers…
Sometimes you are stuck with a slow view in Snowflake. Imagine this scenario: You’re trying to create an object with a slowpoke view as the source and development is as slow as taking the highway at 8 AM to work. You cannot edit and improve the view because it is a secure, shared object. The…
Are you looking for a certain column in a table? Using INFORMATION_SCHEMA is one way to do this. Below is another method you can use.
Are you looking for a specific column in all tables in a database? Use the schema INFORMATION_SCHEMA! It contains metadata about all objects in your database, including columns.
For the past few months, Snowflake Workspaces have become available, offering interesting new capabilities. First of all, I like the look and the overview that Workspaces provide; I appreciate seeing the query history on the same screen as the results of my queries. Secondly, I like that it’s possible to create a new Workspace from…