Posts

Amazon Athena tip: access denied or insufficient permissions to access Athena

Reading data from Athena via the command line - Comparing the options (AWS CLI, Python Boto, Java, AWS SDK)

Handling Big and Little Endian data (image files, binary network responses etc.) in C#

Update a forked git repository from the upstream repository

How to Optimize Code - a General Approach and Principles

Specify location of user folders and files on Unix OS - if $HOME is not set

Automatic graph layout algorithms and libraries

yarn fills up disk - workaround

Manage Builder pattern access requirements (limit the public methods!) via nested Builder class in C#

Automatically setting the default browser on Windows - Use Chocolatey (choco) and Setdefaultbrowser via command line or script

Extracting JSON and nested JSON from an Athena column

Amazon Athena - ANSI SQL - Use inner or nested SELECT statements as alternative to temp tables or variables

Amazon Athena - ANSI SQL - Providing default value if NULL