Snowflake execute (select SQL)- Capture results
Hi, We are using Snowflake execute snap to run a metadata query against Snowflake and using the output of it in mapper snap. Snowflake execute snap- preview data shows expected data from sql. In the mapper snap, input schema is not available for snowflake execute-select sql. Is there a way to capture/use the results from snowflake execute-sql(select) and use it in mapper or subsequent snaps.SAP HANA to Snowflake - historical data load
Hi, We are evaluating if Snaplogic can also be used to move historical data from SAP Hana to Snowflake without performance challenges. Any recommendations for historical data movements, best practice or snap configuration from SAP Hana to Snowflake. Snaplogic Fast Data loader does not support SAP Hana as source endpoint.
Snowflake Issues: Throws syntax error randomly for drop statements in snowflake execute snap. Also Bulk Load snap fails stating table does not exist
Snowflake Issues: Throws syntax error randomly for drop statements in snowflake execute snap. Also Bulk Load snap fails saying table does not exist with create table checked in. Also table does exist and there is no mistake in table name.
Snowflake Bulk insert just stuck, do not process any data
I have seen that sometimes my Kafka to snowflake bulk insert is just stuck it does not process anything, neither it fails at the “Snowflake Bulk Insert snap”, like if there is a snowflake outage for 5 min, it gets stuck even after outgate is over, in that case, I manually restart the pipelines. is there a way to stop the pipeline if it just stuck at “Snowflake Bulk Insert snap” for X minutes? or any other better way to solve this.Calling REST APIs with Parameters
I need to be able to call a REST endpoint that takes a UserId as a parameter. I’m curious how I can leverage snaplogic to loop over an undetermined list of userIds from one REST endpoint to call another endpoint passing the user id. Is this even possible in Snaplogic?Snowflake Bulk Upsert Key Column Issue
Hello, I’ve had luck getting the snowflake bulk load to work. But that loads and duplicates records. I have been trying to get the Snowflake Bulk Upsert to work so I can use key ID columns. I can’t get past the error that I have an invalid column name and to check if the column or table exist. Both the table and the column exist. Is there a setting or step I need to do before this?
