Rahul TandonHow to Create Java Script Procedure in SnowflakeStored procedures are loosely similar to functions. As with functions, a stored procedure is created once and can be executed many times. A…Sep 11, 2021Sep 11, 2021
Rahul TandonMULTI — INSERT IN SNOWFLAKEUsing , MULTI -INSERT feature in Snowflake , rows can be inserted into multiple table concurrently . Loading tables concurrently if they…Sep 11, 2021Sep 11, 2021
Rahul TandonSecure View in SnowflakeSome of the internal optimizations for views require access to the underlying data in the base tables for the view. This access might allow…Sep 11, 2021Sep 11, 2021
Rahul TandonMaterialized View in SnowflakeA materialized view is a pre-computed data set derived from a query specification (the SELECT in the view definition) and stored for later…Sep 10, 2021Sep 10, 2021
Rahul TandonManaged Schema in SnowflakeApart from creating Schema in Snowflake , there a feature to Created schema with managed access . Managed access schemas centralize…Sep 7, 2021Sep 7, 2021
Rahul TandonTransient Table in SnowflakeSnowflake provides the feature of creating transient tables . The transient table is same as permanent table except the key difference is…Sep 5, 2021Sep 5, 2021
Rahul TandonCluster Key in SnowflakeData in Snowflake is stored in columnar format in micro-partitions . These micro-partitions are automatically created and maintained by…Sep 5, 2021Sep 5, 2021
Rahul TandonSPLIT_TO_TABLE Function in SnowflakeThis table function splits a string (based on a specified delimiter) and flattens the results into rows.Sep 5, 2021Sep 5, 2021
Rahul TandonLoad JSON File To Snowflake from AWS S3Snowflake supports various various file formats (CSV , JSON , XML , PARQUET etc. ) as a source . Lets check how to load data to Snowflake…Sep 5, 2021Sep 5, 2021
Rahul TandonDifference between CAST() and TRY_CAST() in SnowflakeCAST () : Converts a value of one data type into another data type. The semantics of CAST are the same as the semantics of the…Sep 5, 2021Sep 5, 2021