Move data from AWS S3 to Snowflake Data Warehouse
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-22-2018 02:44 PM
Created by @pkoppishetty
The pipeline pattern moves data from AWS S3 to Snowflake Data Warehouse. The pattern contains a Directory Browser (to retrieve the file list from S3), Snowflake Execute, and Snowflake Bulkload Snaps (to load the corresponding files into Snowflake).
Configuration
File Reader Preview
Snowflake Bulkload Output
Table Data from Snowflake Select Snap
Sources: AWS S3
Targets: Snowflake
Snaps used: Snowflake Execute, Directory Broswer, File Reader, Snowflake Bulk Load, Snowflake Select
Downloads
Integration pattern for moving data from AWS S3 to Snowflake datawarehouse.slp (14.2 KB)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-09-2020 09:55 AM
I am trying to use the same example and getting below mentioned error in loading data into snowflake snap while adding JDBC JARs*
Failed to validate account: Could not load JDBC driver for url: {snowflake-jdbc-3.6.18.jar} Cause: com.snowflake.client.jdbc.SnowflakeDriver (Reason: com.snowflake.client.jdbc.SnowflakeDriver; Resolution: Please verify that the driver exists at the provided location and that read permissions are granted)
Could you please help me to resolve this issue?
Thanks & Regards
Mani
