SQL files can contain Jinja, a lightweight templating language. Using Jinja in SQL provides a way to use control structures in your queries. For example, if statements and for loops. It also enables repeated SQL to be shared through macros.SQL files can contain Jinja, a lightweight templating language. Using Jinja in SQL provides a way to use control structures in your queries. For example, if statements and for loops. It also enables repeated SQL to be shared through macros.
Subscribe to:
Post Comments (Atom)
Data Sharing
1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...
-
Upon using the custom query in the source object, the mapping fails with the following error: The select query for read operation failed bec...
-
MD5 (Message Digest Function) is a hash function in Informatica which is used to evaluate data integrity. The MD5 function uses Message-Dig...
-
Data warehouse design is one of the key technique in building the data warehouse. Choosing a right data warehouse design can save the proje...
No comments:
Post a Comment