adhocshare

Knowledge is Power

Monthly Archive: April 2020

0

Linux

Connecting to remote server using a jump server (SSH tunneling)

Problem statement There are 3 hosts, Host-user – one that you are on Host-jump – one that has connectivity to database server Host-database – database server Host-user wants to connect to Host-database using Host-jump. Solution Setup ssh tunnel with local...

0

Bigdata

Fetching Redshift table DDLs

So lately I got stumped by not having the ability to extract DDL/ table definition for a table in Redshift. Quick searches on the internet resulted in… below query, SELECT * FROM pg_table_def WHERE tablename = ‘table_name’ AND schemaname =...