EXECUTE IMMEDIATE in Snowflake Stored Procedures
EXECUTE IMMEDIATE command in Snowflake executes SQL statements present in form a character string and returns the result.
Variables in Snowflake Stored Procedure
A Variable is a named object which holds a value of a specific data type whose value can change during the stored procedure execution.
Introduction to Snowflake Stored Procedures
Stored procedures allow you to write procedural code that executes business logic by combining multiple SQL statements.
Row-Level Security using Row Access Policies in Snowflake
A Row Access Policy is a schema-level object that is assigned to a table or view and determines whether a given row in them can be viewed by a user.
Row-Level Security using Secure Views in Snowflake
Row-Level Security is a security mechanism that limits the records returned from a database table based on the permissions provided to the currently logged-in user.
HOW TO: Create Mapping Task in IICS using REST API?
Learn step-by-step procedure on how to create a mapping task in Informatica Cloud using mttask REST API resource.
HOW TO: Update Mapping Task in IICS using REST API?
Learn how to update mapping task using mttask REST API resource in Informatica Cloud and various use cases of updating mapping tasks using REST API.
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.
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.