User Profile

Senthilnaga91

New Contributor III

Joined 3 years ago

14 Posts6 Likes2 Solutions

View All Badges

User Widgets

Contributions

Re: Issue with invoking triggered task using Groundplex URL
Thanks for the suggestion acbradley, it worked !
2 years ago Place Application Integration
1.8KViews
1like
0Comments
Issue with invoking triggered task using Groundplex URL
We are experiencing an issue when invoking the triggered task using the Groundplex URL. The problem is that when we trigger the task using the Groundplex URL (load balancer URL), it immediately returns a 200 response code. It does not wait for the job to complete before returning a success status. I am wondering why the 200 response code is returned immediately upon triggering instead of waiting for the job to complete. The triggered task cloud URL behaves as expected; we only encounter this issue with the Groundplex URL. Any help would be much appreciated.
Solved
2 years ago Place Application Integration
1.9KViews
2likes
2Comments
Performance Improvement - Loading large CSV files to Snowflake
I have a use case to load some large CSV files (in GBs) from windows network drive to Snowflake. Used a CSV parser and loading it using Snowflake bulk load. Pipeline is running without any issues. However, it takes a lot of time to load the data. Is there a better way to do it ? Please suggest.
2 years ago Place Designing and Running Pipelines
1.6KViews
0likes
1Comment
Re: Custom Header for a CSV file
The issue is sorted by removing the CSV formatter at the end and change the mapper output view to binary and connected the file writer directly.
3 years ago Place Designing and Running Pipelines
3.5KViews
0likes
0Comments
Custom Header for a CSV file
Hello All, I am looking for an approach to add a custom header before writing into a CSV file. I have referred the below link and developed one, but the issue is double quotes appended at the start and end of the content. So, when I open the CSV file in excel, all the content gets accumulated in a single cell instead of in a different row and columns. Please refer the screen shot below. Please help me to sort out this. Reference Link Adding header and footer - Designing Pipelines / Solutions - SnapLogic Community Double quotes appended at start and end of the document When you open the CSV in Excel Expected CSV output.
Solved
3 years ago Place Designing and Running Pipelines
3.6KViews
0likes
1Comment
Re: Scheduling Tasks Dynamically
I have provided more details in my previous reply. Please refer.
3 years ago Place Designing and Running Pipelines
4.4KViews
0likes
1Comment
Re: Scheduling Tasks Dynamically
No, let me be more precise. Our client has given a schedule to run what pipeline on which day and time (nnot a fixed schedule). It’s maintained in a RDBMS table. So, to trigger a pipeline, the process has to look into the scheduling table and trigger the pipleline on a particular day and time accordingly. Example: There is a record in scheduling table, PipeName,Date,Time LoadSalesTable,06-27-2023,05:00 PM CST LoadEmployeeTable,06-27-2023,04:00 PM CST So, my question is how to automate the process to trigger the pipeline ‘LoadSalesTable’ on 06-27-2023,05:00 PM CST ? (PS: The schedule for ‘LoadSalesTable’ might change in the future and the process should accommodate without manual intervention).
3 years ago Place Designing and Running Pipelines
899Views
0likes
0Comments
Scheduling Tasks Dynamically
Hello All, I have a use case where I have to schedule my pipeline dynamically based on entries from an input table? What’s the best way to implement this? For Example: If I have a pipeline loadSalesTable, I have to look to my input scheduling table to decide what day and time to trigger the pipeline and accordingly I have to schedule it. I don’t think we have any straightforward approach using Scheduled or Triggered task, looking for a work around. Thanks in advance.
Solved
3 years ago Place Designing and Running Pipelines
5.5KViews
0likes
5Comments
Issue in configuring REST OAuth2 Account
Hello All, I am facing an issue in configuring the REST OAuth2 Account in SnapLogic, I am getting the below error while I try to authorize it, {“http_status_code”: 500, “response_map”: {“error_list”: [{“message”: "Request to token endpoint https://login.aaa.com/token (changed the original url) failed. I am getting the response using Postman. I am using the same Client ID , Client Secret and OAuth2 Token as Postman. Not sure what value should I give for OAuth2 Endpoint* as I don’t have the field in Postman for Grant Type ‘Client Credentials’. Please assist.
3 years ago Place Designing and Running Pipelines
1.5KViews
0likes
0Comments
Re: Snowflake bulk load snap is executing COPY INTO for each input document
Can you pls share your pipeline design to have more clarity ?
3 years ago Place Designing and Running Pipelines
2.2KViews
0likes
0Comments

Groups

Partner User Group
This area is for our partners to communicate with each other and with the SnapLogic Alliances team.
0 Posts