Skip to content
ThinkETL

ThinkETL

  • Home
  • Interview Questions
  • Certification
  • Informatica
    • Advanced Concepts
    • Automation
    • Certification
    • Connectors
    • Interview Questions
    • Real-time Scenarios
    • Rest API
    • Secure Agent
    • Slowly Changing Dimensions
    • Taskflows
    • Transformations
  • Snowflake
    • Access Control and Security
    • Data Loading and Handling
    • Data Management and Utilities
    • Query and Performance Optimization
    • Snowflake REST API
    • Snowpark
    • Snowpipe
    • Stored Procedures
  • Catalogue
  • Courses

Data Management and Utilities

Introduction to Snowflake Notebooks

Introduction to Snowflake Notebooks

May 18, 2025December 29, 2024

Snowflake Notebooks provide an interactive environment to write, execute, and document SQL and Python code in one interface.

Categories Data Management and Utilities, Snowflake
DATEADD Function in Snowflake

DATEADD Function in Snowflake: Add or Subtract Time Intervals from Dates

May 18, 2025November 1, 2024

DATEADD Function in Snowflake calculates a date or timestamp value by adding a specified interval to a given date or timestamp.

Categories Data Management and Utilities, Snowflake
Snowflake Alerts Schedule Conditional SQL Statements

Snowflake Alerts: Schedule Conditional SQL Statements

October 24, 2024

A Snowflake Alert allows scheduled execution of conditional SQL statements, enabling users to monitor specific events or thresholds within their environment.

Categories Data Management and Utilities, Snowflake
Sending Email Notifications in Snowflake

HOW TO: Send Email Notification in Snowflake?

September 28, 2024

Snowflake offers built-in stored procedures SYSTEM$SEND_EMAIL and SYSTEM$SEND_SNOWFLAKE_NOTIFICATION for sending email notifications.

Categories Data Management and Utilities, Snowflake
ASOF JOIN in Snowflake

ASOF Join in Snowflake

September 8, 2024

ASOF JOIN in Snowflake matches each row in one table to the closest row in another table based on a specified condition, typically involving time series data.

Categories Data Management and Utilities, Snowflake
MIN_BY and MAX_BY Functions in Snowflake

MIN_BY and MAX_BY Functions in Snowflake

September 8, 2024August 22, 2024

MIN_BY and MAX_BY are aggregate functions in Snowflake that calculate the minimum or maximum value of a column and return the value of another column in that row.

Categories Data Management and Utilities, Snowflake
Common Table Expressions (CTEs) in Snowflake

Common Table Expressions (CTEs) in Snowflake

July 14, 2024

A Common Table Expression (CTE) in Snowflake is a named subquery used within the execution scope of the query in which it is specified.

Categories Data Management and Utilities, Snowflake
DATEDIFF Function in Snowflake

DATEDIFF Function in Snowflake: Calculate the difference between two dates

December 24, 2023

The DATEDIFF function in Snowflake facilitates the calculation of the difference between two date, time, or timestamp values.

Categories Data Management and Utilities, Snowflake
Greatest and Least functions in Snowflake

GREATEST and LEAST Functions in Snowflake

December 16, 2023

The GREATEST function in Snowflake retrieves the largest value whereas the LEAST function returns the smallest value from a list of expressions.

Categories Data Management and Utilities, Snowflake
Snowflake Dynamic Tables

Snowflake Dynamic Tables: Change Data Capture Simplified

November 10, 2024December 8, 2023

Snowflake Dynamic Tables track the changes in the query data specified and refresh the materialized results incrementally through an automated process.

Categories Data Management and Utilities, Snowflake
Older posts
Page1 Page2 Page3 Next →

Take up the Quiz

  • IICS Interview Questions Quiz-1
  • IICS Interview Questions Quiz-2
  • IICS Interview Questions Quiz-3
  • IICS Interview Questions Quiz-4
  • IICS Transformations Quiz-1
  • IICS Transformations Quiz-2
  • IICS Taskflows Quiz
  • IICS Expression Macros Quiz
  • IICS Certification Practice Test
  • SQL Analytic Functions Quiz
Informatica Cloud Professional Certification Practice Tests
Deal extended: Courses Up To 85% Off

Subscribe

Informatica Cloud Data Integration - Automation Project

Recent Posts

  • Data Unloading using COPY INTO Command in Snowflake
    Data Unloading using COPY INTO Command in Snowflake
  • Snowflake Directory Tables
    Snowflake Directory Tables: Query and Manage Staged Files
  • Snowflake File URLs Securely Access & Share Staged Files
    Snowflake File URLs: Securely Access and Share Staged Files
  • Data Load using COPY INTO Command in Snowflake
    Data Load using COPY INTO Command in Snowflake
  • Executing External API calls from Snowflake
    HOW TO: Make External API calls from Snowflake?

About ThinkETL

ThinkETL is your go to resource for learning Informatica Cloud and Snowflake Concepts, Interview preparation and Automation Ideas and strategies that work.

Pages

  • About
  • Catalogue
  • Certification
  • Contact
  • Courses
  • Privacy Policy
  • Subscribe
  • Terms of Use
  • Automation
  • Certification
  • Concepts
  • Informatica
  • Interview Questions
  • Snowflake

Follow Us

Copyright © 2023 ThinkETL