External Tables in Snowflake | How to create External tables on external and internal stages

Опубликовано: 30 Сентябрь 2024
на канале: Asky Coding

1,086

External Tables in Snowflake | How to create External tables on external and internal stages
#snowflake

Topics covered in this video :

Types of tables in snowflake
external tables in snowflake
external tables on external stages
external tables on internal stages

full practical session

#snowflake #database
#cloud #cloudservices

We'll be doing a complete series of Snowflake from scratch. So watch the full series with practicals.

Complete snowflake tutorial series :

1st episode : What is Snowflake ? Intro video
link :    • 1. Snowflake Data cloud platform Over...

2nd episode : Snowflake Architecture
link :    / o7pwt3b6vg

3rd episode : Create snowflake free account
link :    • 3. How to create snowflake free trial...

4th episode : Enable Old classic UI
link :    • 4. How to change Snowflake Snowsight ...

5th episode : Create warehouse,schema & table
link :    • 5. Snowflake Creating Warehouse, Data...

6th episode : Create a file format
link :    • 6. How to Create a File Format in Sno...

7th episode : Configuring snowsql with snowflake
link :    • 7. How to setup and Configure snowsql...

8.(i) episode : Internal stages concept video
link :    • 8 (i). What is Internal stage ? | Use...

8.(ii) episode : Practical session of data loading
link :    • Snowflake data loading from internal ...

8.(iii) episode : Loading CSV, PSV & TSV Files
link :    • Data loading of CSV, PSV and TSV data...

8.(iv) episode : Loading big data files
link :    • Data loading from Internal stages | L...

8.(v) episode : Loading files with special char
link :    • Data Loading of files with special ch...

9. Create free trial AWS Account
link :    • How to create AWS free trial account ...

10. AWS S3 configuration with Snowflake
link :    • AWS S3 integration with Snowflake for...

11. Data loading from aws s3 external stages
link :    • Data loading from external stages |  ...

12. Zero copy cloning in snowflake.
link :    • What is a Zero Copy Cloning ? | Cloni...

13. What is Time travel ? Retention period?
link :    • What is a Time Travel ? Retention per...

13.1. Time Travel complete practical
link :    • Time Travel in Snowflake full practic...

14.1. What is Caching ? Results cache & local disk cache
link :    • What is Caching in snowflake ? | Resu...

14.2 Caching full practical
link :    • Caching in snowflake full practical s...

15.1 Unloading to External stages
link :    • Data Unloading to external stages fro...

15.2 Unloading to Internal stages
link :    • Data unloading to Internal stages fro...

16.1 Data Sharing full concept
link :    • Data Sharing in snowflake | Full conc...

16.2 Data Sharing to snowflake users
link :    • Data Sharing to Snowflake users by cr...

16.3 Data sharing to non-snowflake users
link :    • Video

17.1 Types of tables | Permanent, Transient & Temporary table
link :    • Types of Tables in Snowflake. | Perma...

17.2 Types of tables practical session
link :    • Types of tables in snowflake | Full W...

Complete snowflake tutorial playlist :    • Snowflake Tutorial

If you guys face any problem then you can comment down or DM on instagram with the following link.

Instagram :-   / ishivam._yadav

Join our whatsApp Community for get in touch with me : https://chat.whatsapp.com/LoFtGConRmB...

For Scripts and files used in the video, checkout my github account :

https://github.com/shivam-sky/Snowfla...

I hope you like the video if u do then hit the like button and if you are new to this channel then please subscribe to my channel and also hit the bell icon so that you can never miss any updates from Asky Coding.

THANKS FOR WATCHING & PLEASE SUBSCRIBE
🙏🙏🙏🙏🙏🙏🙏🙏

how to create external tables in snowflake
Snowflake external tables on external stages
external tables in snowflake
table types in snowflake
working session of permanent table
working session of transient table
working session of temporary table
types of tables in snowflake
Snowflake table types
permanent table types in snowflake
transient table in snowflake
temporary table in snowflake
Snowflake all tables
snowflake types of tables
table types in snowflake
Snowflake types of tables
table types