Amazon Redshift via CLI

Let’s create a cluster!

aws redshift create-cluster \
--cluster-identifier oliTest2012 \
--node-type dc2.large \
--master-username oli123456 \
--master-user-password **** \
--number-of-nodes 2 \
> log.txt # in Unix bash this line saves Response (see below) to fs
{  "Cluster": {    "ClusterIdentifier": "olitest2012",    "NodeType": "dc2.large",    "ClusterStatus": "creating",    "ClusterAvailabilityStatus": "Modifying",    "MasterUsername": "oli123456",    "DBName": "dev",    "AutomatedSnapshotRetentionPeriod": 1,    "ManualSnapshotRetentionPeriod": -1,    "ClusterSecurityGroups": [],    "VpcSecurityGroups": [      {        "VpcSecurityGroupId": "sg-b8c870de",        "Status": "active"      }    ],    "ClusterParameterGroups": [      {        "ParameterGroupName": "default.redshift-1.0",        "ParameterApplyStatus": "in-sync"      }    ],    "ClusterSubnetGroupName": "default",    "VpcId": "vpc-14007b70",    "PreferredMaintenanceWindow": "wed:04:30-wed:05:00",    "PendingModifiedValues": {    "MasterUserPassword": "****"    },    "ClusterVersion": "1.0",    "AllowVersionUpgrade": true,    "NumberOfNodes": 2,    "PubliclyAccessible": true,    "Encrypted": false,    "Tags": [],    "EnhancedVpcRouting": false,    "IamRoles": [],    "MaintenanceTrackName": "current",    "DeferredMaintenanceWindows": [],    "NextMaintenanceWindowStartTime": "2020-12-23T04:30:00+00:00"  }}

Let’s query the data!

--

--

--

Bass/BV @StornowayBand. DataCat @AstraZeneca. Consulting via StoneStreetProductions.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Our Tech Stack for Yeah! Meshi

Scala #4: Common Sequence Methods

RespiraWorks is Merging with BostonVent!

BostonVent Ventilator and GUI Prototype Images

Schedule a cron job in CoreOS

Provably Fair

Integrating Autonomous Vehicles with rideOS

How to use Arweave to store and access NFT metadata, part 2

Maluva and DRC

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Oli Steadman

Oli Steadman

Bass/BV @StornowayBand. DataCat @AstraZeneca. Consulting via StoneStreetProductions.

More from Medium

AWS ETL: Glue Job — INSERT/UPDATE support

AWS Lake Formation — Transactions, Row Level Security and Acceleration

99.999999999% Durability for SQLite Data

Setting up Spark Clusters with AWS