So, suppose you have a thing you do. Note that everything that you do affects or has an impact on … More
Author: coolford
what are CTAs?
aws redshift: insert multiple rows into a table
Way to insert multiple rows into a redshift table using sql insert command: See: https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-multi-row-inserts.html
Downloading multiple files from aws s3
As this time, the option to download multiple files from aws s3 console is not available. The way to do … More
Snowflake data cloud
Intro to snowflake company founded in Aug 2012 — while I was at B. Cloud data platform Snowflake region maps … More
cloud privilege issues
As per this webinar on BrightTalk: 4 pillars of cloud security are: Least privilege – identity should have only permissions … More
redshift date functions
select getdate(); getdate 2020-05-27 06:44:07 — select getdate() as today, date(dateadd(‘year’,-1,(last_day(dateadd(‘month’,-1,getdate()))))):: DATE as date1, date(last_day(dateadd(‘month’,-1,getdate())))::DATE as date2; today date 1 … More
register a dll
regsvr32 c:/windows/system32 [name].dll In windows 10, dll should also be available in c:/windows/sysWOW64
Project parameters
The 4 most important parameters in a software project: scope, resources, time and quality.
Software and Understanding
1.1. The problem The problem should be completely understood before formulating the solution. If the problem is not understood, the … More
DataUntangle 