Designing and Running Pipelines

Snowflake Bulk Load

Hi, I am trying to use Snowflake bulk load snap to read data from external S3 location and load into the snowflake table. here the challenge is that. Under the Snowflake account, I have mentioned the external bucket name and provided keys. but when a...

Resolved! Simple document viewer during testing

I was wondering if there is a simple way of viewing documents made it down a certain path during testing of a pipeline. I know that I can view how many documents flow in and out of a Snap using the statistics viewer, but I’d like to actually see the ...

Resolved! Router snap catch all

I have a section in a pipeline where I need to route documents down one of two paths. I would like to do a single comparison on some fields, if it’s true go down one path, if it’s not, go down another path. Think of it as the ELSE in a SWITCH stateme...

Resolved! Converting Array to Comma Separated String

I have JSON output from a Salesforce SOQL snap, in the format [ { “QualifiedApiName”: “Accelerator_Pack__c” }, { “QualifiedApiName”: “Access_Certifications__c” }, { “QualifiedApiName”: “Access_Requests__c” }, { “QualifiedApiName”: “Account_Cleansed__...

Mapper Expression for PostgreSQL into bit type

I have a target table that is in PostgreSQL. I have a field in that table that is of type bit. I have a mapper before an INSERT PostgreSQL Snap type. I’m trying to use an expression to map to the bit field type but everything I try has a type mismatc...

Resolved! Date Format to yyyy-MM-dd

Hi community, So I have a date that comes from the source system as: 2020-02-23T00:00:00:000 I would like to convert that date to just 2020-02-23 Any thoughts? Thanks.

SCD for PostgreSQL

How would I build a SCD if my target database is PostgreSQL? It doesn’t look like it is an option for PostgreSQL? Is the Diff Snap the way to do it?

Daily API Consumption Count

Hi all, There will be any possible in SnapLogic for Daily API Consumption Count, How we can make Report on the previous API Usage based on day/time params: 30, 60 , 90 day, please help me on this issue, Thanks, Anil

SnapLogic - Integration Nation

Forum Posts

Snowflake Bulk Load

Resolved! Simple document viewer during testing

Resolved! Router snap catch all

Resolved! Converting Array to Comma Separated String

Mapper Expression for PostgreSQL into bit type

Resolved! Date Format to yyyy-MM-dd

SCD for PostgreSQL

Daily API Consumption Count

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error