Snowflake Vs MS-SQL - Part 97 - Identify Data Type - SYSTEM$TYPEOF


Identify Data Type - SYSTEM$TYPEOF

Sometimes, you have to find out the data type or nature of the data in the existing column during data analysis.

MS-SQL Server

We can do as follows:



In Snowflake, we can use SYSTEM$TYPEOF as follows:




For more details, refer to the SYSTEM_TYPEOF section.

  

Location: Pune, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Snowflake Vs MS-SQL - Part 70 - UNION By Name

Image
        UNION By Name Sometimes, we have to combine data from multiple tables. In this case, we can use UNION. However, the catch is that the order of the columns should be the same. MS-SQL Server   We can achieve this by using UNION as below: In  Snowflake,  we can use  the same query as above; however, we have to use the same column order in the select clause. However, we can use  UNION BY Name   as below. The order of the columns in the  select clause does not matter. NOTE: Similarly, you can use  UNION ALL BY NAME . For more details, you can refer to the following:  UNION . Yogesh Shinde LinkedInProfile <<< Back   Next >>>  
Read more

Snowflake Vs MS-SQL - Part 68 - Multi Table Insert

Image
         Multi Table Insert We insert data into a table, and sometimes, we must archive/back it up in another table. MS-SQL Server   We can achieve this by using magic or virtual tables present, like INSERTED,  as below: However, in  Snowflake, the insert statement has an additional clause,  INSERT ALL,  which allows you to insert into multiple tables:  For more details, you can refer to the following:  Multi_Table_Insert . Yogesh Shinde LinkedInProfile <<< Back   Next >>>        
Read more

Snowflake Key Concepts

Image
  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. -   ...
Read more