Redshift Copy Command – Load S3 Data into table
In the previous post, we created few tables in Redshift and in this post we will see how to load data present in S3 into… Read More »Redshift Copy Command – Load S3 Data into table
Raj
Redshift Create Table Example
In this post, we will see a very simple example in which we will create a Redshift table with basic structure and then we will… Read More »Redshift Create Table Example
Moving from Teradata to Hadoop – Read this before
It’s been few years since I have been working on HIVE, Impala, Spark SQL, PySpark, Redshift and in the journey so far I have migrated… Read More »Moving from Teradata to Hadoop – Read this before
Convert number to TIME in Teradata
While calculating measures you may want to convert seconds to TIME. Say you want to know how many HOURS,MINUTES & Seconds constitute this number. Example… Read More »Convert number to TIME in Teradata
Teradata TPT Export script
If writing a typical TPT script is tedious task for you then you may try using existing TPT templates to quickly write a TPT script.… Read More »Teradata TPT Export script
Fetch Metadata of View in Teradata via HELP
Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of… Read More »Fetch Metadata of View in Teradata via HELP