An introduction to Vantage Native Object Store (NOS) has been covered in a previous post, where the following code sample was used to query csv data in an S3 store (by using the READ_NOS operator). SELECT TOP 5 * FROM READ_NOS ( USING LOCATION ('/s3/my-private-surface-water-data-store.s3.us-west-1.amazonaws.com/CSVDATA/09380000/2018/06/27.csv') …

Native Object Store (NOS) is a Teradata feature which allows for data-in-place operations against a variety of external store types, including S3. By using inbuilt SQL functions and operators, an end user is able to perform read/write operations. …

The WSL Preview Edition (available via the Microsoft Store) introduces an additional argument for directly working with virtual disks. WSL from the Microsoft Store introduces a new argument to directly mount a VHD: wsl — mount — vhd <pathToVHD> This post describes the procedure for adding a VHD to an…

This article primarily focuses on establishing connectivity between Guitar Pro and a Digital Audio Workstation (DAW) by using a virtual MIDI loop device as a conduit for transferring MIDI data between the two programs. …

This article provides an approach to streaming query output from RDS Postgres to an S3 CSV file via a NodeJs Lambda function. The process uses pg-copy-streams and the query results to create a data stream which is piped to S3 using the aws-sdk. Alternatives to removing the function’s dependency on…

Testing of playbooks for AWS deployments can be a challenge for an application developer. Within controlled environments, playbooks are generally executed via workflows/pipelines managed by DevOps teams. The combination of Localstack and Ansible provides an app developer the capability for preliminary local/mock testing of playbooks without incurring AWS billing costs. …

What follows is a walkthrough outlining the steps involved in implementing AWS cross-account access to an encrypted S3 bucket. The following is a summary which describes the scenario used for the walkthrough: An S3 bucket, s3://account-a-bucket, is to be created in account-a and made accessible to an external AWS account…

In a previous post, I documented learnings from setting up a local Devops environment. This article aims to apply a potential use-case for this environment by including support for Terraform. The following overview of the goals to be achieved should help you in deciding whether to read on: Tweak/expand the…

If you’ve worked with Localstack for mock AWS testing, then chances are most of the interactions with the stack have been via the AWS CLI or an SDK. Localstack’s Community Edition does not currently offer an official web-based UI, however, this feature is offered in Pro and Enterprise versions. At…