I want to create a "load" pipeline that will ingest a json with the pipeline name and the parameters to pass to the pipeline. So for example I'd start with a json like this:{ "targets": [ { "redshift": { "pipeline_name": "redshift...
I have a postgres server that has about 5 different databases I want to consume, is it possible to parameterize the connection to pass the db_name like a table_name? Thanks.
Hi there, need some help transforming the arrayI have a structure that's coming as below[ { "statusLine": { "protoVersion": "HTTP/1.1", "statusCode": 200, "reasonPhrase": "OK" }, "entity": { "links": [ { ...
I have one document structured like this: FirstNameLastNameTitleAnnSmithMsJuneJonesMrsSamJohnsonMrsAnd a second document like this: LabelValueMyEvent8/21/23I'm trying to merge them together to get a final product like this: FirstNameLastNameTitleValu...
Hi Everyone..I have a requirement where we have to split the json which is coming into the json but it is in String. We have to divide into the columns.Let me explain you by the example. The Json is coming in this format.[{"String":"{col_name=CTRY_CO...
Hello, I am trying to connect to the AWS S3 bucket with the Access Key Id and Secret access key using the AWS S3 Account type in Snaplogic. But it fails to validate and throws an error Failed to validate account:Cause: Access Denied (Service: Amazon ...
Hi Team,I have one scenario and want to solve it as soon as possible.I have two files : Initial Load , Incremental LoadWe have loaded the initial load data into the DB which contains the columns like : id, name, age, classBut We have the incremental ...
How can i delay a process according to our needs, is there any snap to perform wait operation?I tried with script snap, mentioned there to delay for 15 seconds,but its taking more time than 15 seconds.CODE # Import the interface required by the Scrip...
