Connect Snowflake cloud from Pega Infinity using JDBC driver
With simple steps, I was able to connect to Snowflake cloud from Pega Infinity community edition using JDBC driver option. We can also use the API service call from Pega to connect Snowflake but I am interested in this option to check the integration. Brief idea on Snowflake: Snowflake is a cloud-based data platform used to store, process, analyze, and share large volumes of data. It runs on cloud infrastructure such as AWS, Microsoft Azure, and Google Cloud. Think of Snowflake as a centralized data warehouse where an organization can bring data from many applications and analyze it using SQL. Snowflake separates storage, compute, and cloud services. Its virtual warehouses provide the compute resources that execute queries. Concept Simple explanation Database Container for related data Schema Organizes tables and views within a database Table Stores structured data in rows and columns Virtual Warehouse Compute engine that runs queries Role Defines what...