Find a column in a table in Snowflake without INFORMATION_SCHEMA
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.
Find a column in a database using INFORMATION_SCHEMA
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.
Snowflake workspaces
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…
Create a Snowflake workspace from a Github repository
Would you like to have version control when developing in Snowflake using the browser? You can now create a workspace in Snowflake from a repository. In the example below I am sharing how to do this.
Find out what query Power BI Desktop sent to Snowflake
Are you working with Power BI and Snowflake? Would you like to know what queries Power BI sent to Snowflake? Sometimes you want to know what exactly is happening between Power BI and Snowflake. Perhaps you want to know how costly a certain load from Snowflake to the Power BI Service is. Or maybe you…
Data pijplijn project met data build tool (dbt), Snowflake, Docker, Dagster en Github
Data pijplijn ontwikkeld met behulp van data build tool (dbt), Snowflake, Dagster en Github. Er is een Medallion structuur geïmplementeerd met behulp van transformaties in dbt. Verder is dbt gebruikt om SCD2 te implementeren door middel van snapshots. dbt is ook gebruikt om generic en custom tests uit te voeren zoals het controleren van de…
COMMIT en ROLLBACK in Snowflake SQL
Ever wondered what COMMIT and ROLLBACK do in Snowflake SQL? I know I have. Let me try to explain it using Snowflake SQL.
dbt (Data Build Tool)
Just finished an excellent dbt (Data Build Tool) course on Udemy by Zoltan C. Toth. #dbt is a tool that can be used to develop data models. dbt applies many software engineering best practises to the workflow of transforming your data. What I really liked about dbt: – Version control is easily added to a…
Extract values from unstructured data like invoices using Snowflake Document AI
Do you have employees who spend hours manually copying values from invoices into Excel or a database? Would you like to automate this? Automatically extracting values from unstructured data like JPG or PDF files is really easy. Snowflake has a feature that will help you with just that. You train a model once to extract…
Reduce administrative overhead in Snowflake with Privilege Inheritance in Role Hierarchies
Privilege inheritance in Snowflake’s role hierarchy is a powerful feature that simplifies access management and reduces administrative overhead. In Snowflake, roles can be granted to other roles, creating a hierarchical structure. Privileges associated with a role are inherited by any roles above it in the hierarchy. This means that when you grant a privilege to…