Snowflake beginner course

Snowflake Beginner Course
Snowflake Beginner Course at iExpertify

Snowflake beginner course

Informatica Cloud Services and Snowflake Integration

If you need to connect to Snowflake using any tool or technology, connect through Snowflake’s JDBC or ODBC drivers. These drivers provide general, multi-purpose connection functionality for most tools and technologies. Informatica has specific drivers that can connect with its data integration and governance tools.

Data Integration

Commonly referred to as ETL, data integration encompasses the following three primary operations:

Extract
Exporting data from specified data sources.
Transform
Modifying the source data (as needed), using rules, merges, lookup tables or other conversion methods, to match the target.
Load
Importing the resulting transformed data into a target database.

The more recent usage of the term is ELT, emphasizing that the transformation operation does not necessarily need to be performed before loading, particularly in systems such as Snowflake that support transformation during or after loading.

In addition, the scope of data integration has expanded to include a wider range of operations, including:

  • Data preparation.
  • Data migration, movement, and management.
  • Data warehouse automation.

Security & Governance

Security and governance tools ensure sensitive data maintained by an organization is protected from inappropriate access and tampering,
as well as helping organizations to achieve and maintain regulatory compliance. These tools support a wide range of operations,
including risk assessment, intrusion detection/monitoring/notification, data masking, data cataloging, and more.

The following data integration tools and technologies are known to provide native connectivity to Snowflake:

Informatica Drivers for Snowflake

Informatica Snowflake integration

Solution Version / Installation Requirements
 

Informatica

 

 

Available
in Partner
Connect

 

  • Informatica Cloud:
    • Cloud Connector for Snowflake — available directly in the
      Informatica Cloud interface
    • Secure Agent — download and install from the Informatica Cloud interface
  • Snowflake:
 

Informatica

 

  • Informatica PowerCenter:
    • PowerCenter 10.2 (or higher)
    • PowerExchange for Snowflake
  • Snowflake:
 

Informatica

 

  • Informatica Data Governance and Compliance:
    • Cloud Connector for Snowflake — available directly in the
      Informatica Cloud interface
    • Secure Agent — download and install from the Informatica Cloud interface
  • Snowflake: No requirements

This table lists all known 3rd-party partners and technologies that have been certified to provide native connectivity to Snowflake.