The Snowflake SnowPro Core Certification (COF-C02) validates an individual’s ability to implement and migrate to Snowflake using specific core expertise. A SnowPro Core Certified individual...
How to load data special characters available in your data file whicch either conflicts with your file delimiter or row delimiter or stops your copy...
How to use standard, secure & materialized views in Snowflake, their SQL construct, their limitations, cost implication with materialized views and best practices around it....
The Snowflake SnowPro Core Certification (COF-C02) validates an individual’s ability to implement and migrate to Snowflake using specific core expertise. A SnowPro Core Certified individual understands the Snowflake Cloud Data...
Before we process and chrunch data, it has to be loaded and it has to be loaded effectively and efficiently. This article talks about all the best practices for loading...
This blogs explain how to handle date and time formats while loading data into snowflake tables from csv files and how to make sure that milli and nano second values...
This blogs explain how to handling null fields in your data file, be it CSV or delimiter separated files and load the data set effectively in your snowflake tables.
This blogs explain how to run validation process while loading small or large CSV files into snowflake. This can be done using a parameter and it has certain limitations and...
Data duplication is a common issue in many data engineering work and when it happens, it becomes a costly matter. So this blog describe how to de-duplicate data when a...
How to load data special characters available in your data file whicch either conflicts with your file delimiter or row delimiter or stops your copy command and eventually stops data...
Type of views (standard, secure & materialized) in Snowflake, their SQL construct, their limitations, cost implication with materialized views and best practices around it.