Home » command line tools

Database Tables)

Posted on March 30, 2023 by ZappySys

Introduction In this article, you will learn how to create simple or complex JSON file in Informatica just in a few clicks. We will use the Powerful Export JSON Command line Builder from ZappyShell. Using this Portable / xCopy style command line you can build nested/complex JSON / XML or even CSV from single / […]

How to find amazon s3 bucket location (AWS region endpoint)

How to check Amazon S3 Bucket location (Region)

Posted on March 15, 2016 by ZappySys

Problem Sometimes if you loading data to Redshift via COPY command or using SSIS Redshift Data Transfer Task to move data to redshift then you will have to make sure your S3 Bucket is in the same region as Redshift Cluster. Many people don’t know how to verify that because its hidden in the console. This […]