Snowflake_tutorial

This repo contains all my Snowflake practice queries that I have executed using trial Enterprise edition.

These sql queries are built based on the exercises given in "Snowflake SnowPro Core Certification Study Guide by Hamid Mahmood Qureshi".

Feel free to provide feedback or tips/corrections if any.

Thanks

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Snowflake_tutorial

About

Releases

Packages

Languages

Name		Name	Last commit message	Last commit date
Latest commit History 15 Commits
.vscode		.vscode
0000. Data		0000. Data
0000. Unloaded Data		0000. Unloaded Data
0001. Type of Tables.sql		0001. Type of Tables.sql
0002. Views and Materialized Views.sql		0002. Views and Materialized Views.sql
0003. Access Control.sql		0003. Access Control.sql
0004. Loading data using table stage.sql		0004. Loading data using table stage.sql
0005. Loading data using user stage.sql		0005. Loading data using user stage.sql
0006. Loading data from named stage.sql		0006. Loading data from named stage.sql
0007. Loading Cloud data from external stage.sql		0007. Loading Cloud data from external stage.sql
0008. Loading data from private s3 external storage.sql		0008. Loading data from private s3 external storage.sql
0009. Create an external table on cloud storage.sql		0009. Create an external table on cloud storage.sql
0010. Loading NDJSON data through an external stage.sql		0010. Loading NDJSON data through an external stage.sql
0011. Loading JSON data through external stage.sql		0011. Loading JSON data through external stage.sql
0012. Unloading table data via named internal stage.sql		0012. Unloading table data via named internal stage.sql
0013. Simple task to load data into table.sql		0013. Simple task to load data into table.sql
0014. Creating a simple task tree.sql		0014. Creating a simple task tree.sql
0015. Creating a simple serverless task.sql		0015. Creating a simple serverless task.sql
0016. Creating a stream to track table changes.sql		0016. Creating a stream to track table changes.sql
0017. Time travel.sql		0017. Time travel.sql
0018. Zero copy cloning.sql		0018. Zero copy cloning.sql
0019. Direct data sharing between accounts.sql		0019. Direct data sharing between accounts.sql
0020. Resource monitor.sql		0020. Resource monitor.sql
0021. System usage and billing.sql		0021. System usage and billing.sql
0022. System functions - Clustering Keys.sql		0022. System functions - Clustering Keys.sql
0023. System functions - Query History.sql		0023. System functions - Query History.sql
0024. System functions - Search Optimization.sql		0024. System functions - Search Optimization.sql
0025. Simple python program using snowflake_python_connector.py		0025. Simple python program using snowflake_python_connector.py
0026. UDFs, External Functions, and Stored Procedures.sql		0026. UDFs, External Functions, and Stored Procedures.sql
0027. SnowSQL.sql		0027. SnowSQL.sql
0028. Column and Rowl level security.sql		0028. Column and Rowl level security.sql
0029. Virtual Warehouses.sql		0029. Virtual Warehouses.sql
0030. Query History and Query Profile.sql		0030. Query History and Query Profile.sql
README.md		README.md

dattapadal/Snowflake_tutorial

Folders and files

Latest commit

History

Repository files navigation

Snowflake_tutorial

About

Topics

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages