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 Loading and Handling

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

February 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?

February 22, 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
INSERT and Multi-Table Inserts in Snowflake

INSERT and Multi-Table Inserts in Snowflake

July 22, 2024

Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.

Categories Data Loading and Handling, Snowflake
Creating Snowflake Iceberg tables using AWS Glue as Catalog

Creating Snowflake Iceberg tables using AWS Glue as Catalog

June 17, 2024June 16, 2024

An Externally Managed Iceberg Table is a table where an external system such as AWS Glue manages both the table data and metadata.

Categories Data Loading and Handling, Snowflake
Creating Snowflake Iceberg Tables

HOW TO: Create Snowflake Iceberg Tables?

May 26, 2024

A Snowflake Iceberg table Snowflake employs the Apache Iceberg format for organizing and storing data within the Snowflake data warehouse environment.

Categories Data Loading and Handling, Snowflake
Loading and Querying JSON data

HOW TO: Load and Query JSON data in Snowflake?

November 26, 2023August 8, 2022

Snowflake supports loading JSON data in database tables and allows querying data along with flattening it into a columnar structure.

Categories Concepts, Data Loading and Handling, Snowflake
Snowflake FileFormats

Snowflake File Formats

November 26, 2023July 31, 2022

Snowflake File format simplifies the process of accessing the staged data and streamlines data loading/unloading in database tables.

Categories Concepts, Data Loading and Handling, Snowflake
TYPES OF SNOWFLAKE VIEWS

Types of Views in Snowflake

November 26, 2023June 1, 2022

There are three different types of views in Snowflake – Non-Materialized, Materialized and Secure Views.

Categories Concepts, Data Loading and Handling, Snowflake
Older posts
Page1 Page2 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