The upcoming release of Jedox in 2023.3 is set to bring exciting advancements to the ETL (Extract, Transform, Load) process by introducing a seamless connection to Snowflake, one of the leading cloud data warehousing solutions. With this integration, users can enjoy efficient data handling with two authentication options, enhanced by considerations for roles, warehouses, and databases.
![Snowflake COnnection](https://i0.wp.com/jedox4beginners.com/wp-content/uploads/2023/09/Connection-to-Snowflake.png?resize=721%2C499&ssl=1)
After choosing the connection there are certain credentials which need to be added.
Authentication Options:
Username and Password: This traditional method allows users to authenticate their access to Snowflake by providing their username and password. This secure authentication process ensures that only authorized individuals can access and manipulate data within Snowflake.
![Snowflake authentication method](https://i0.wp.com/jedox4beginners.com/wp-content/uploads/2023/09/SNowflake-Utohentication-method-1.png?resize=800%2C652&ssl=1)
Private Key Configuration: For those seeking enhanced security, the new connection also supports private key authentication. Users can configure their Snowflake accounts to accept private key authentication, adding an extra layer of protection to their data.
![](https://i0.wp.com/jedox4beginners.com/wp-content/uploads/2023/09/ssh-key.png?resize=800%2C612&ssl=1)
The Jedox-Snowflake integration doesn’t stop at authentication methods. It also provides valuable features to help manage roles, warehouses, and databases seamlessly:
- Role: Users can specify their roles during the connection setup, ensuring that they have the right permissions and access levels within Snowflake. This feature ensures that data is accessed and transformed by individuals with the appropriate privileges.
- Warehouse: The integration allows users to choose from the available warehouses in the Snowflake system. This flexibility ensures optimal performance by allocating resources effectively based on specific ETL tasks and demands.
- Database: Users can easily select the desired database for their ETL operations. This choice empowers users to target their data transformations accurately, promoting efficiency and organization in their ETL processes.
To Extract the data we will go with RelationalTable extract where we can set some filters in the WHERE section.
![](https://i0.wp.com/jedox4beginners.com/wp-content/uploads/2023/09/Snowflake-extract-1024x503.png?resize=800%2C393&ssl=1)
Apart from the Extract from Snowflake tables, we can also load them. There we will go with Relational Load which can look something like this:
![Snowflake load](https://i0.wp.com/jedox4beginners.com/wp-content/uploads/2023/09/Snowflake-Load.png?resize=800%2C602&ssl=1)
Why Choose the Jedox-Snowflake Connection?
With this new ETL connection in Jedox, users gain access to a world-class data warehousing solution while benefiting from enhanced security, role management, warehouse optimization, and database selection. This integration represents a significant leap forward in data integration capabilities, ensuring that organizations can efficiently harness the power of their data in Snowflake.
As data continues to grow in complexity and importance, it’s essential to have reliable and adaptable ETL tools at your disposal.