Sitemap

Member-only story

Snowflake & GIT

4 min readNov 1, 2024
Press enter or click to view image in full size
don’t know why this picture showed up on Unsplash, since my search term was Git. The picture shows Groot and Octocat reading a newspaper
Photo by Praveen Thirumurugan on Unsplash

When using Snowflake’s UI Snowsight, code lives in the browser. I really like Snowsight, but the huge amount of tabs you end up with scattered code is not very useful.

How to fix this: you can use VSCode with Git & Snowflake plugin or use 3rd party tools like Dbeaver that also might have Git options. But the most important thing: you want your code in a repository and you want to be able to execute this code in Snowflake.

This article will guide you through the steps to integrate your (public) Github repo in Snowflake/Snowsight.

Go to your Snowflake trial, Create, Git Repository

You need to clone your repository to your Snowflake account. Therefore you need an API Integration:

Press enter or click to view image in full size

If there is no API integration available (which will be the case in your fresh trial account), click the + and you will go to a worksheet with almost-ready code.

You need to put your github account into this code snippet, that’s all:

// A user with the…

--

--

Johan
Johan

Written by Johan

I am a freelance data engineer. My main focus is Snowflake, but I am always eager to learn new things. Python and AWS are my main side interests