How to Restore AWS redshift table alone using snapshot?

Step  to Restore AWS redshift  table alone using snapshot and you can do it using the AWS console.

if you have  cluster snapshot you can restore the  table from the snapshot.

pre-request:

Source DB:

source schema:

source table name:

Target DB:

Target schema:

Target table name:

If Target DB does not have table , restore will automatically create it.

How to Restore AWS redshift cluster using snapshot?

Step  to Restore AWS redshift cluster using snapshot and you can do it using the AWS console.
if you have  cluster snapshot you can restore the entire cluster:

How to Reboot a AWS Redshift Cluster?

Here is the steps to    Reboot a AWS Redshift Cluster:

cauition:Please do not reboot redshift cluster without business approval,all the running SQL's would  be cancelled

How to copy data from AWS Redshift table to S3 bucket?

Here is the steps to copy data from AWS Redshift table to S3 bucket

pre-request:
1)we  need user created with privilege to access AWS redshift +S3 bucket
2)we need access_key_ID & secret_access_key for the user

we have utility called UNLOAD used to  extract  data from redshift tables to S3 bucket

How To Load data from AWS S3 bucket to Redshift database?

Here is the steps to  Load data from AWS S3 bucket to Redshift database:

pre-request:
1)we  need user created with privilege to access AWS redshift +S3 bucket
2)we need access_key_ID & secret_access_key for the user


COPY utility used to load data from S3 bukcet to AWS redshift database tables ,if the file is CSV  or any delimeter format

How to delete snapshot from AWS Redshift?

Delete snapshot from AWS Redshift

How to create Manual snapshot for AWS Redshift?

create Manual snapshot for AWS Redshift

How to create AWS redshift cluster?

Here is the step by step to create AWS redshift Cluster:

1

How to unlock the admin user in Netezza Database?

Issue:
we had faced issue where we unfortunately locked the admin user on Netezza and unable to conenct to NZSQL,NZADMIN and even aginity work bench.


User wrongly updated the system table .
update _t_user set uselocked=TRUE where usename='ADMIN';

because of the above admin user locked out and its throwing the  error "access denied".

SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
 USELOCKED
-----------
 t
(1 row)

Solution:
we have special command to reset the admin  user and it worked.


nzsql -admin -c "alter user admin reset account" ;

SYSTEM.ADMIN(ADMIN)=> select uselocked from _t_user where USEname='ADMIN1';
 USELOCKED
-----------
 f
(1 row)

what are the features of AWS Redshift database?

Features of AWS Redshift database

• Columnar data storage instead Row
• Data compression
• Cloud based Data-warehouse
• Massive Parallel Processing
• Easily scalable
• Result caching
• Fault tolerant