Designing and Running Pipelines

Google Big Query

Is it possible to truncate a table in bigquery and then run Bulk Load(Streaming). I’ve tested using BigQuery Execute with truncate statement and then link a bulk load(streaming) snap. I get an error message saying invalid input. Its not recognizing t...

Is there any way to set variables to before executing snowflake statement

I would like to execute the 2 set variable statements before executing the select * from viewname. This view internally uses VAR1 and VAR2 variables. set VAR1 = ‘ABC’; set VAR2 = ‘XYZ’; Select * from dbname.schemaname.viewname ; Is there anyway to s...

How snaplogic internal database manages the metadata

Hi Team, Could you please let me know how and where snaplogic stores its metadata like the mapping we did or any routing condition etc? Does each data for snap stored separately or its the entire pipeline saved as a metadata in database? Which databa...

How to find the incoming data format (like json or xml) dynamically

Hi everyone, I am passing the data from postman and I need to route the data based on the incoming data whether it is json or xml. Based on this, I have to do the other logics. So my issue was, how to find the incoming data format? For this I have tr...

Rest get snap pagination nexturl issue

Hi, I am trying to Update the below url in rest get snap and want to add filter on date in place of Days. URL I am Using : _JiraHost+“/rest/api/2/search?maxResults=50&startAt=”+(parseInt($entity.startAt)+50)+“&jql=project+in+(”+_project.replaceAll(’ ...

How to log snowflake store procedure execution logs in a log table via snap logic

Hi All, I am new to snaplogic and my first task is to execute multiple Snowflake stored procedures via snap logic and log the execution of those stored procedures in a log table. Below values needs to be captured for each stored procedure. Stored pro...

How to find incoming data format(json,xml) dynamically in pipeline input view?

How to find incoming data format dynamically? Say for example, If the incoming data is JSON then I need to perform certain validation and flow for JSONIf the incoming data is xml then I to perform certain operations. Can any one suggest How to find i...

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove the email ids from first row of first sheet and rest of...

SnapLogic - Integration Nation

Forum Posts

Google Big Query

Is there any way to set variables to before executing snowflake statement

How snaplogic internal database manages the metadata

How to find the incoming data format (like json or xml) dynamically

Rest get snap pagination nexturl issue

How to log snowflake store procedure execution logs in a log table via snap logic

How to find incoming data format(json,xml) dynamically in pipeline input view?

Dynamically parse the excel without having sheet index or sheet name

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings