So, suppose you have a thing you do. Note that everything that you do affects or has an impact on…
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…
Snowflake data cloud
Intro to snowflake company founded in Aug 2012 — while I was at B. Cloud data platform Snowflake region maps…
cloud privilege issues
As per this webinar on BrightTalk: 4 pillars of cloud security are: Least privilege – identity should have only permissions…
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…
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…
DataUntangle 