JSON TO REDSHIFT ARCHIVE
JSON TO REDSHIFT FREE

copy (copy aws s3 files between buckets/folders).get (download s3 files to local machine).

JSON TO REDSHIFT ARCHIVE

Archive files, error reporting, file splitting, many other features….Ĭommands for AWS S3 Storage.

Import compressed data files (*.gz) to redshift.

Load data from any data source (ODBC,ADO.net or OLEDB) using sql query to extract data.

Load local flat files to Redshift in one single command (option to compress data files to *.gz to speed up transfer).

import (imports data to AWS Redshift database from any source).

lsauth (list all saved credential entries)Īws Shell – Command Line Tools (CLI) for Amazon AWS.

loadauth (load storage account credentials).

setauth (set credential for storage account, makes it easy for you to refer it by short later.).

setprop (set properties for specified blob(s) such as content-type, content-encoding, expiration, metadata).

killcopy (terminate server side copy job(s) by file name).

lscopy (list server side copy operation and monitor progress and failures).

copy (copy from any public url to azure storage account, you can copy from AWS S3 to Azure too if you generate shared url for S3 file).

copy (copy between azure storage accounts or same account different containers/folders).

getsas (generate shared access signature url(s) for specified blob(s)).

snap (create new snapshot of specified blob(s)).

setacl (assign/reset permission for azure blob container).

mkfile (create new block/page blob with user defined content.

mkcon (create new container in azure storage account).

Make/Create commands for blobs/containers:

continfo (detailed information about azure blob container(s)).

info (detailed information about azure blob(s)).

Show information commands for blobs/containers (with export to json,xml,csv options):

delcon (delete azure storage container(s) including underlying blobs).

move (move azure blobs between containers/folders or accounts).

copy (copy azure blobs between containers/folders or accounts).

lscopy (List copy status of objects being copied using server side copy feature, filter by specific copy status).

ls (List azure storage blobs, including snapshots).

List commands (with export to json,xml,csv options):

Transfer entire folder structure (including nested folders/files) (–struct option).

Multi threaded operations (–thread option).

Upload/Download only modified files (–sync option).

JSON TO REDSHIFT FREE

Premium support (Phone call, Web meeting)Īdvanced options (not available in FREE version): Screenshots Export multiple tables to JSON / CSV / XML / Excel File (Simple Mode ) – Command line builder UIĬommands for Azure Blob Storage Easily sync files between local machine and Azure Storage. Most of operations are multi-threaded with pattern search support. 25+ commands with 100+ options to adjust your need. Must have command line utility to interact with Azure Blob Storage. Easily sync files between local machine and Amazon S3. 20+ commands with 100+ options to adjust your need.

Must have command line utility to interact with Amazon S3 Storage.

You can import huge amount of data to Redshift from any relational database such as MySQL, Oracle, SQL Server in just one line. You can export data in JSON, XML, CSV, Excel, PDF.Ĭommands to import on-premises data to Amazon Redshift. Commands to export data from relational source.

Json to redshift