HOW TO: Connect Snowflake from Informatica Cloud (IICS)?
Snowflake Data Cloud Connector allows connecting to Snowflake from IICS using which you can securely read/write data into Snowflake.
Concepts
HOW TO: Find and Kill long running queries in Snowflake?
Learn how to find and kill long running queries in Snowflake using the QUERY_HISTORY table functions available under Information Schema.
HOW TO: Get DDL of database objects in Snowflake?
Snowflake provides GET_DDL Function using which DDL of database objects like tables, views, procedures etc., can be extracted.
HOW TO: Parameterize Taskflows using Parameter Sets in IICS?
A Parameter Set lets you parameterize a taskflow by assigning a parameter file to taskflow which provides values for input parameters.
Snowflake Dynamic Data Masking
Snowflake Dynamic Data Masking is a security feature that allows you to mask sensitive data in database tables, views, and query results in real-time.
HOW TO: Remove Duplicates in Snowflake?
Learn different ways to remove duplicate records from a Snowflake table using SWAP WITH and INSERT OVERWRITE commands.
Partitioning target S3 files in Informatica Cloud (IICS)
IICS supports creating multiple target S3 files by configuring a single target transformation using Distribution Column.
IICS Amazon S3 Connection – Temporary Credentials Duration
Learn how to fix ExpiredToken error while working with IICS Amazon S3 Connection using Temporary Credentials Duration.
IICS Amazon S3 v2 Connector – Authenticate via AssumeRole
Learn how to create Amazon S3 v2 Connection in Informatica Cloud using Temporary security credentials via AssumeRole
IICS Amazon S3 v2 Connector – IAM Authentication
Learn how to create Amazon S3 v2 Connection in Informatica Cloud with IAM Authentication method using IAM Roles.