Skip to the content.

See Redshift queries behind cursor fetch

By default, the Redshift ODBC/JDBC drivers will fetch all result rows from a query. If your result sets are large, you may have ended up using the UseDeclareFetch and Fetch parameters. But if you do this, you won’t see your actual queries in the STL_QUERY table or Redshift console. Instead you will see that the actual long-running query looks like

Read More

MSTR Web development over SOCKS proxy and AWS SSM

The problem: You want to work on MicroStrategy (MSTR) Web customizations in your local Eclipse/Tomcat environment, but you don’t have connectivity to your I-server. Your I-server lives in AWS, your corporate network blocks outbound port 22 access, and you don’t have a VPN or direct connect.

Read More

New AWS SSM feature to tunnel SSH with port forwarding support

AWS SSM already had a “session manager” feature that allowed users to get command prompts through a web browser. The big advantage this had over providing an SSH bastion host is that SSM is covered by the same governance context as other AWS services: authentication and authorization via IAM, with audit via CloudTrail.

Read More

First impressions of AWS Glue

I’ve worked with both old-school ETL tools (Informatica, SSIS), and more recently worked with Spark. My takeaway is that AWS Glue is a mash-up of both concepts in a single tool.

Read More

Five tips for AWS certification exam

I just passed the exam for AWS Solution Architect - Associate level. I wanted to share some observations and tips from my personal experience with the exam. (Disclaimer: this is only my personal experience so YMMV.)

Read More