You don't really have any for a native based approach.
Your only option would be to go with DEQ (data engineering) which would give you a faster processing since you are using the Snowflake Spark API vs the JDBC API.
In PowerCenter, we recommend using Snowflake ODBC drivers with Data direct Manager only to run the session in pushdown mode or if you have Snowflake lookup under mapplet. For non-pushdown use cases, we recommend using PowerExchange for Snowflake connector. In PowerCenter, PowerExchange for Snowflake connector loads data into Snowflake faster than 85 records than minute. I recommend opening a case with Informatica GCS to isolate the issue.
Like Scott explained, you can use DEQ product using Snowflake Spark API (PowerExchange for Snowflake).
Uma Mahesh Chalasani
Uma I would like to use the Power Exchange connector. Can you please let me know where to get the download for that?
You can raise a Shipping case with the Informatica Shipping Team and request for PowerExchange for Snowflake Connector. They will provide you with the installation files.
The below PowerExchange Adapters (PowerCenter platform only)are End-of-Sale as of Nov 2020, and new licenses would no longer be provided. The adapters will be available for the IICS platform as well as the Mercury platform(DQ, BDM, etc.)
• Amazon Redshift
• Amazon S3
• Azure SQL Blob Storage
• Azure SQL Data Warehouse v1, v2, v3
• Google BigQuery
• Google Cloud Storage
If you are looking for PowerExchange for Snowflake connector license for BDM/IDQ, then please contact your Informatica Sales Representative.
For installers, please open Shipping case.