- 12
- 25 849
Sebastian Flak
Poland
เข้าร่วมเมื่อ 8 ก.พ. 2024
No idea what I'm doing.
But it's fun.
Ciao!
But it's fun.
Ciao!
6 Simple Functions to improve Your SQL Query
❄In this video, you will learn some great tips and tricks for using Snowflake. I will show you simple ways to work faster and smarter with your data. By the end, you will know how to use Snowflake like a Ninja.
💡KEEP IN MIND:
While a 10-minute video may not cover everything comprehensively, it provides a quick overview that can assist you in navigating through courses, books, and documentation more effectively as you begin your learning journey.
📚 Snowflake Documentation:
- Exclude: docs.snowflake.com/en/sql-reference/sql/select
- Trailing comma: docs.snowflake.com/en/release-notes/2024/8_11#select-supports-trailing-commas
- Qualify: docs.snowflake.com/en/sql-reference/constructs/qualify
- LIKE ANY: docs.snowflake.com/en/sql-reference/functions/like_any
👩💻Find me on:
- Linkedin: www.linkedin.com/in/sebastian-flak/
👀 Check also:
Snowflake Copilot - th-cam.com/video/3MkFW7LHByU/w-d-xo.html
Snowflake Cost Optimization - th-cam.com/video/438n4h5eORk/w-d-xo.html
Snowflake Storage Integration - th-cam.com/video/4xCflSLCDUE/w-d-xo.html&t
⏰Timeline:
00:00 Ciao
00:30 Virtual Warehouse cache
03:47 Query Result cache
05:26 Metadata cache
07:01 Summary
!! Polecana playlista !!
#Snowflake #SnowflakeNinja
💡KEEP IN MIND:
While a 10-minute video may not cover everything comprehensively, it provides a quick overview that can assist you in navigating through courses, books, and documentation more effectively as you begin your learning journey.
📚 Snowflake Documentation:
- Exclude: docs.snowflake.com/en/sql-reference/sql/select
- Trailing comma: docs.snowflake.com/en/release-notes/2024/8_11#select-supports-trailing-commas
- Qualify: docs.snowflake.com/en/sql-reference/constructs/qualify
- LIKE ANY: docs.snowflake.com/en/sql-reference/functions/like_any
👩💻Find me on:
- Linkedin: www.linkedin.com/in/sebastian-flak/
👀 Check also:
Snowflake Copilot - th-cam.com/video/3MkFW7LHByU/w-d-xo.html
Snowflake Cost Optimization - th-cam.com/video/438n4h5eORk/w-d-xo.html
Snowflake Storage Integration - th-cam.com/video/4xCflSLCDUE/w-d-xo.html&t
⏰Timeline:
00:00 Ciao
00:30 Virtual Warehouse cache
03:47 Query Result cache
05:26 Metadata cache
07:01 Summary
!! Polecana playlista !!
#Snowflake #SnowflakeNinja
มุมมอง: 403
วีดีโอ
Snowflake User Interface tutorial | Snowsight
มุมมอง 6942 หลายเดือนก่อน
❄In this video, you will learn how to use Snowflake's user interface, Snowsight. I will show you how to manage your data and run queries easily. By the end, you will know how to use Snowsight to work better and faster in Snowflake. Watch now to become a #SnowflakeNinja! 💡KEEP IN MIND: While a 10-minute video may not cover everything comprehensively, it provides a quick overview that can assist ...
Write SQL queries faster | Snowflake Copilot
มุมมอง 8K2 หลายเดือนก่อน
❄ In this video, you will learn how to use Snowflake Copilot to write SQL queries more easily. I will guide you through the basic features of Copilot and show you how it can help with data analysis. By the end of the video, you will know how to use Copilot to save time and improve your workflow. Watch to understand how Snowflake Copilot can make your data work simpler and faster. 💡KEEP IN MIND:...
Speed up your Snowflake query | Caching
มุมมอง 1K3 หลายเดือนก่อน
❄ In this video, you'll learn how to use caching in Snowflake to speed up your queries and save money. I will explain how caching works with simple examples, making it easy to understand. By the end, you'll know how to optimize your queries for better performance. This video is perfect for those preparing for the SnowPro Core certification or anyone looking to improve their Snowflake skills. 💡K...
STOP wasting money in Snowflake! | Cost optimization
มุมมอง 6K3 หลายเดือนก่อน
❄ In this video, you'll uncover practical tips for optimizing costs in Snowflake, helping you avoid unnecessary expenses and maximize efficiency. Learn effective strategies to manage your Snowflake usage and reduce costs without sacrificing performance. Explore actionable insights and best practices for optimizing your Snowflake environment, ensuring you don't pay for things you don't use. 💡KEE...
5 functions you need to know for data transformation in Snowflake
มุมมอง 7534 หลายเดือนก่อน
❄ In this video, you'll explore Snowflake's essential data transformation functions, unlocking new ways to manipulate and refine your data within Snowflake. Learn how to leverage these functions to transform raw data into valuable insights with ease. Discover practical examples and step-by-step guidance on using each function effectively. 💡KEEP IN MIND: While a 10-minute video may not cover eve...
6 ways to load your data into Snowflake | Data Loading
มุมมอง 2264 หลายเดือนก่อน
❄ In this video, you'll discover six simple methods to load your data into Snowflake, each explained in easy-to-understand terms. From basic CSV uploads to more advanced options like Snowpipe and Snowpipe Streaming, you'll learn practical techniques to seamlessly integrate your data into Snowflake. Gain valuable insights into the strengths and limitations of each approach, empowering you to mak...
Automate your data loading from AWS S3 to Snowflake | Snowpipe
มุมมอง 7K5 หลายเดือนก่อน
❄ In this video, you'll learn how to automate moving data from AWS S3 to Snowflake using Snowpipe. Discover how Snowpipe can make your data loading process simpler and more efficient. Understand the steps involved in setting up Snowpipe and how it can save you time and effort in managing your data. 💡KEEP IN MIND: While a 10-minute video may not cover everything comprehensively, it provides a qu...
AWS S3 data integration with Snowflake | Storage Integration
มุมมอง 1.3K5 หลายเดือนก่อน
❄ Discover how to integrate AWS S3 with Snowflake, enabling efficient data interaction. Learn the setup process, benefits, and practical techniques for integrating AWS S3 data with Snowflake. Whether you're a beginner or looking to enhance your data integration skills, this video will guide you to become a #SnowflakeNinja. 💡KEEP IN MIND: While a 10-minute video may not cover everything comprehe...
Connect to your cloud data using Snowflake | External Stages
มุมมอง 1915 หลายเดือนก่อน
❄In this video, you'll learn how to access and integrate cloud data within Snowflake using External Stages. Discover how to set them up, and leverage their power to efficiently load and query data from cloud storage services. Whether you're new to Snowflake or looking to expand your data integration capabilities, this video is your key to become a #SnowflakeNinja. 💡KEEP IN MIND: While a 10-minu...
Snowflake Data Storage Explained | Internal Stages
มุมมอง 1685 หลายเดือนก่อน
❄In this video, we'll explore the concept of stages, delve into the different types of internal stages available in Snowflake, and guide you on selecting the optimal stage for various scenarios. Whether you're new to Snowflake or seeking to optimize your data storage workflows, this video is your essential guide to become a #SnowflakeNinja. 💡KEEP IN MIND: While a 10-minute video may not cover e...
How to install, configure and use Snowflake CLI | SnowSQL
มุมมอง 3146 หลายเดือนก่อน
❄In this tutorial, you'll learn how to install and configure SnowSQL on your machine, ensuring integration with your Snowflake account. Discover how to execute SQL queries, manage database objects, and efficiently interact with your Snowflake data using SnowSQL. Whether you're a beginner or an experienced user, this video will equip you with the skills needed to navigate SnowSQL like a #Snowfla...
👍
You picked a bad time to start making snowflake videos lol. Everyone is running from that system like the plague.
I couldn't agree less. I see a constant growth in terms of projects, as well as data engineers who are learning Snowflake. No idea where you see it. Just check db-engines.com/en/ranking
@@SebastianFlak-snowflakeninja I get it, you kind of have to say that. but the facts remain at the enterprise level, we're migrating away from it in droves. Still probably good for smaller stuff. Industry shifts happen all the time.
@@thereal-ghost And why are you migrating from Snowflake and where do you go then? I don't really see easier and more scalable solution (except for Databricks and BigQuery which I treat on the same level).
Dear Sebastian, The video is very informative and to point ! Would appreciate it is you could also provide the codes used in a txt or GIT. For ease of access. Thank you.
Thanks! This is such a great idea. I'll setup a GIT repo in the near future.
Thanks for delivering such a great explanations. Any chance on sharing command used in demo ?
Ciao! I don't have them saved anymore, however you can find almost all the commands in Snowflake docs here: docs.snowflake.com/en/user-guide/data-load-local-file-system-stage
thank you
I hope it helped :)
Ciao! To avoid any confusion: SnowSQL is a command line client but it's NOT THE SAME as Snowflake CLI! (at the moment of recording, there was no Snowflake CLI) SnowSQL is about executing SQL queries with use of command line. Snowflake CLI is an alternative and goes beyond SQL operation, including Snowpark Containers, Streamlit apps, and Native apps. You can read more here: SnowSQL: docs.snowflake.com/en/user-guide/snowsql Snowflake CLI: docs.snowflake.com/en/developer-guide/snowflake-cli-v2/index