Snowflake GitHub Integration | Complete Hands-On Snowflake Tutorial

preview_player
Показать описание
This hands-on, end-to-end Snowflake Git/GitHub integration demonstrates how to create a Git repository object within Snowflake for both private and public repositories, allowing seamless access to database script files within Snowflake.

This Snowflake tutorial explains each SQL command that can be used on a Git Repository Stage object and how to share access with other Snowflake roles using the RBAC feature. The video tutorial also covers executing SQL scripts and creating a Python-based stored procedure by referencing a GitHub .py file. It also discusses the current limitations.

🚀🚀 Data Engineering Simplified - Social Links

🚀🚀 Chapters
--------------------------
➥ 00:00 Introduction
➥ 01:43 Welcome Note
➥ 02:16 Token Generation (TAC)
➥ 04:28 Git Repository Object
➥ 11:52 Public Repo Configuration
➥ 15:23 RBAC
➥ 20:28 Repo Stage vs Internal Stage
➥ 21:55 SQL Commands
➥ 29:48 Running SQL Commands
➥ 31:54 Stored Procedure
➥ 36:08 Limitations
➥ 37:53 Thank You Note

#snowflake
#snowflaketutorial
#github
#dataengineeringsimplifed
#dataengineering
#dataengineeringessentials
#clouddatawarehouse

Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.
Рекомендации по теме
Комментарии
Автор

Kindly create end to end course on snowsql . Almost all interviews nowadays ask experience on snowsql pipeline

ApoorvSaxena
Автор

Please create one END to END snowflake tutorial that would be great

kotasuresh
Автор

Why is your website is under maintence since long time? I need some script to practice

shabbiransari
Автор

Quite surprising to see that you can't push your worksheet from snowflake to github

TechCoach
Автор

I created git repo connection and i have a csv file in the repo. I want to create stored procedure with COPY INTO table from @that_repo/.csv but i get error, that this is not supported. Any way to get over it? Or is the only option manually uploading the file to normal internal stage and using it in the procedure instead of repo

mateuszha