- 194
- 658 748
VCKLY Tech
India
เข้าร่วมเมื่อ 28 พ.ย. 2020
This channel is all about Snowflake Cloud Data Warehouse Database
วีดีโอ
RAG in Python with txtai and litellm
มุมมอง 1772 หลายเดือนก่อน
Tutorial for an implementation of RAG (Retrieval Augmented Generation) in Python using txtai (Vector Database) and litellm (LLM Proxy). Colab Link: colab.research.google.com/drive/1d5NP7O9bgs0c_V6Q-LHcYHuzsvUS1tiY?usp=sharing
How to create a stream on an External /Internal Named stage and how to consume the data from Stream?
มุมมอง 1935 หลายเดือนก่อน
In this video, I am going to show you how to create a stream on an External /Internal Named stage and how to consume the data from Stream
8. How to resolve the “syntax error: unexpected” error in Snowflake? |Snowflake | DWH | VCKLY Tech
มุมมอง 3225 หลายเดือนก่อน
In this video, I am going to show you how to resolve the “syntax error: unexpected” error in Snowflake? DEMO How to resolve the Syntax error: unexpected Setting context for the current SQL worksheet use role accountadmin; use warehouse compute_wh; use database demo_db; use schema public; /* Tabele Names : group,order,qualify,by,where,connect sample, values, as ,with , into,from insert, update, ...
7. How to resolve the invalid data type specification in Snowflake? Snowflake |DWH | VCKLY Tech
มุมมอง 1485 หลายเดือนก่อน
In this video, I am going to show you how to resolve the invalid data type specification in Snowflake? DEMO How to resolve the invalid data type specification in Snowflake? use role accountadmin; use role compute_wh; create or replace database demo_db; create or replace schema salesforce; create or replace table salesforce.account( AccountNumber string ,AccountSource string ,BillingAddress obje...
Snowflake Interview Questions and Answers Part-21 | VCKLY Tech | Snowflake | Data Cloud | DWH
มุมมอง 5525 หลายเดือนก่อน
In this video, I am going to discuss snowflake interview questions and answers Part -21.
Prompting LLMs: Chain of Thought and Few Shot Prompting
มุมมอง 825 หลายเดือนก่อน
Prompting LLMs: Chain of Thought and Few Shot Prompting
2.How to get/collect the Column Statistics/Density details in Snowflake ?|Snowflake | DWH|VCKLY Tech
มุมมอง 2785 หลายเดือนก่อน
In this video, I am going show you how to get/collect the Column Statistics/Density details in Snowflake? Code: Step 1 :Set context for the current SQL worksheet use role accountadmin; use warehouse compute_wh; use database demo_db; use schema public; Step 2: Create a table public.column_density_details to store the collected column statistics/density details create or replace table public.colu...
Difference between Scratch, Turbo Warp and penguin mod!
มุมมอง 6175 หลายเดือนก่อน
here are the websites 1. Scratch scratch.mit.edu/ 2. Turbo Warp turbowarp.org/ 3. Penguin Mod penguinmod.com/
RAG 101: Understanding and Implementing Retrieval Augmented Generation
มุมมอง 1276 หลายเดือนก่อน
In this video, we will look into the concept of RAG (Retrieval Augmented Generation).
Mindstudio Tutorial - Create Custom Chatbots for Free
มุมมอง 42010 หลายเดือนก่อน
Mindstudio Tutorial - Create Custom Chatbots for Free
don't touch lightining
มุมมอง 3210 หลายเดือนก่อน
to play the game Scratch.mit.edu/projects/989678086/
explanation of tag in scratch
มุมมอง 9810 หลายเดือนก่อน
you will have to load it in turbowarp.org to use because it has 60 FPS
Mastering ChatGPT: Tips and Tricks for LLMs!
มุมมอง 210ปีที่แล้ว
Mastering ChatGPT: Tips and Tricks for LLMs!
Stable Diffusion Ultimate Guide. How to write better prompts, and use Image to Image, Control Net.
มุมมอง 2.4Kปีที่แล้ว
Stable Diffusion Ultimate Guide. How to write better prompts, and use Image to Image, Control Net.
Snowflake SQL API Endpoints. Snowflake SQL API Part - 2
มุมมอง 514ปีที่แล้ว
Snowflake SQL API Endpoints. Snowflake SQL API Part - 2
Top 12 Best Free AI Tools 2023! Research, Writing Assistance, Image Generation and more.
มุมมอง 250ปีที่แล้ว
Top 12 Best Free AI Tools 2023! Research, Writing Assistance, Image Generation and more.
Snowflake Interview Questions and Answers Part-20 | VCKLY Tech | Snowflake | Data Cloud | DWH
มุมมอง 1.4Kปีที่แล้ว
Snowflake Interview Questions and Answers Part-20 | VCKLY Tech | Snowflake | Data Cloud | DWH
1.How to Load CSV File into Snowflake Table from Internal Named Stage using Copy Command? VCKLY Tech
มุมมอง 2.9Kปีที่แล้ว
1.How to Load CSV File into Snowflake Table from Internal Named Stage using Copy Command? VCKLY Tech
Snowflake Interview Questions and Answers Part-19 | VCKLY Tech | Snowflake | Data Cloud | DWH
มุมมอง 1.3Kปีที่แล้ว
Snowflake Interview Questions and Answers Part-19 | VCKLY Tech | Snowflake | Data Cloud | DWH
How to use the 'Execute Immediate From' command in Snowflake | VCKLY Tech | Snowflake
มุมมอง 425ปีที่แล้ว
How to use the 'Execute Immediate From' command in Snowflake | VCKLY Tech | Snowflake
Snowflake interview Questions and Answers Part-17 I Snowflake I VCKLY Tech
มุมมอง 1.3Kปีที่แล้ว
Snowflake interview Questions and Answers Part-17 I Snowflake I VCKLY Tech
add the packages link in the description
This video series is great, helped me understand well
Nice
On which column we apply clustering key particularly
Very good explanation... thank you for providing this...
Venkat, I really appreciate your snowflake interview question and answers videos. please provide more videos and scenario based questions, project related, please cover remaining topics.. Thank you.
Sure. Thanks❤🙏
Good Videos Venkat, Thank you.
Venkat you are cover the best interview questions. Thank you
In Part 17 Question 3, "select max(ename) from demo_db.public.table_name" -- u said warehouse is required. What is the diff in this parts last question and part 17th's Ques 3?
Other than number data types need warehouse to run sql statement
Very nice video! I learned a lot!
Helpful!
Can you give example for append mode nit truncate
Hi , do you have demo with SQL code for stored procedure to use copy command
Very useful.. thanks for sharing
Nicely explained. Can you please make a video about how to promote code to higher environments using ci/cd using best practices followed in enterprise level projects. It would be immensely helpful
Scratch sucks tbh, use peinguinmod or gandi ide or eletramod (most likey spelled wrong) there the king.
turbowarp is still good
@@KabezTheFunniMan Yeah but peinguinmod is better in my opinion
You should have finished eating/chewing before recording this session. Sir, you are doing these video for professionals and we expect some professionalism 🙏
Really sorry for inconvenience, it was issue with recording (had audio issue)
Very Helpful Thanks!!!!
You're welcome!
Why do we need to use the "select * from table(result_scan(last_query_id()))" as "show columns in table <table_name>" is already showing the same?
Show command displays output and we cannot assign that output into any variables. If we want that we can use the "select * from table(result_scan(last_query_id()))".
Please share this slide
Amazing explanation
Thank you so much for your amazing and detailed lesson.
Glad you enjoyed it!
Thank you so much for your efforts 👏👏👏
It's my pleasure
James Simon
James Simon
Good explanation however, what if we receive file like sometext_dept and i just want to load file only staring with dept what pattern we can use ?
Yes
I think you have to use pattern if it is an csv file ='.*_dept.*[.]csv'
Thank you, that was great!
Great
While uploading the csv file getting unknown error
Thanks sir
Very helpful, thanks
thanks, it was useful
How to restore a drop procedure
We can not
kids these days learns fast thanks for teaching
How to migrate history table Oracle to snowflake that having live data
Export into csv file and load into snowflake
All videos are very clear and easy to understand
I encountered error --> Function TRY_CAST cannot be used with arguments of types NUMBER(38,5) and NUMBER(38,0). I use try_to_decimal(columnA). Column A is a decimal (38,5).
Thanks, it was useful 👍🏻
Glad it was helpful!
only the swap table with intermediate tables and usng distinct and creating will works
Thanks for the help.🎉
No problem 👍
Do we need to have any prior knowledge to understand this content? Because i didnt understand anyrhing 😢😢😢
Yes
Super👌
@leehutsuri
Thank you bro
Hello, Can we push the data using snowflake rest api snowflake tables to outside of snowflake?
Yes
Hi Brother, can you share your email ID ? I would like to have small conversation
Do more videos on information schema and account usage
Sure
WISH YOU VERY HAPPY AND PROSPEROUS NEW YEAR🎉🎉
The text in the video is not readable. Fonts are toooo small.
It is made by younger son. Who is a 8 year old
Thank you so much, such a great job 👍🏻.
Glad you liked it!