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

Snowflake

Data Unloading using COPY INTO Command in Snowflake

Data Unloading using COPY INTO Command in Snowflake

May 11, 2025

The COPY INTO command in Snowflake enables unloading data from tables into internal or external stage locations in formats like CSV, JSON, or Parquet.

Categories Data Loading and Handling, Snowflake
Snowflake File URLs Securely Access & Share Staged Files

Snowflake File URLs: Securely Access and Share Staged Files

March 9, 2025

Snowflake File URLs provides controlled and secure data access to the staged files without exposing the entire stage.

Categories Data Loading and Handling, Snowflake
Data Load using COPY INTO Command in Snowflake

Data Load using COPY INTO Command in Snowflake

May 18, 2025February 23, 2025

The COPY INTO command in Snowflake is a powerful tool for efficiently loading data from staged files into tables.

Categories Data Loading and Handling, Snowflake
Executing External API calls from Snowflake

HOW TO: Make External API calls from Snowflake?

May 18, 2025February 6, 2025

Explore how Snowflake offers a secure and efficient way to make external API calls directly within its environment.

Categories Data Loading and Handling, Snowflake
RESULT_SCAN in Snowflake

RESULT_SCAN in Snowflake

January 22, 2025

RESULT_SCAN in Snowflake retrieves the results of a previously executed query and presents them as a virtual table allowing to run subsequent queries

Categories Snowflake, Snowflake Functions
Deleting rows from a Snowflake Snowpark DataFrame

HOW TO: Delete Rows From a DataFrame in Snowflake Snowpark?

January 11, 2025

Discover how to delete rows from a DataFrame in Snowpark using Table.update() and Session.sql() methods.

Categories Snowflake, Snowpark
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
Merging two DataFrames in Snowflake Snowpark

HOW TO: Merge two DataFrames in Snowflake Snowpark?

January 11, 2025November 13, 2024

Table.merge() method in Snowpark allows merging the contents of a Snowpark table object with a DataFrame source based on a specified join condition.

Categories Automation
Executing SQL Statements in Snowflake Snowpark

HOW TO: Execute SQL Statements in Snowflake Snowpark?

November 7, 2024

Snowpark allows direct execution of SQL statements using the session.sql() method in conjunction with collect() method.

Categories Snowflake, Snowpark
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
Older posts
Page1 Page2 … Page10 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