Tech-Discussion

  Different Versions of Stored Procedure I've spent a lot of time developing MS-SQL Server code. After I started working on Snowflake, I experienced a different approach to the same thing. Here I am trying to list various aspects of Snowflake compared to MS-SQL Server. In MS-SQL Server, with same name you can create SP which will return two different results based on the call.  It is not overloading. A. First Version B. Second Version   When you will execute this SP, you will get the output similar like this:  Code inside Stored Procedure will look like this:   If you search under Object Explorer, you will find only one instance. In Snowflake, you can create two instances of Stoerd Procedure with same name A. First Version B. Second Version      When you will execute these SPs, you will get the output similar like this:     If you search under Object Explorer, you will find two instances.   Pl...

  Snowflake is a cloud-based data warehouse that offers scalable and secure storage and processing of structured and semi-structured data. Snowflake uses a shared-nothing architecture for parallel processing and offers native support for SQL as well as other programming languages such as Python, R, and Java   Snowflake’s unique architecture consists of three key layers: -           Database Storage -           Query Processing -           Cloud Services In Snowflake, they have done the decoupling of storage and compute.   Virtual Warehouse: -           A compute resource in Snowflake that processes queries and performs data loading and unloading. -           It can be independently scaled up or down based on demand. -   ...