PinnedConnecting to Snowflake using Key Pair AuthenticationAdding more security to your interactions with Snowflake in a Production Environment.Aug 1, 20211Aug 1, 20211
The Crucial Debate: Dynamic Task Mapping vs Loops in AirflowAs a developer loops are an obvious choice of action when an array of elements needs to be dealt with. There is then no hesitation in using…May 7, 2024May 7, 2024
Design WORM models with DBTWrite Once & Read Many times model aka WORM are a way of saving a state of data to reuse it multiple times in an environment where the…Nov 6, 2023Nov 6, 2023
Run Adhoc queries in DBT with JinjaDBT Models are great in separating SQL into their own enclosures which can be summoned anytime by Directed A-cyclic Graph code scripted in…Sep 4, 20231Sep 4, 20231
Programming with Credentials like a ProCredential Stores used with pros and consMar 16, 2022Mar 16, 2022
Restful webhook using Lambda + API Gateway — PART 3If you have been following the series (Part 1 and Part 2); so far we have established a Lambda based Flask App that handles GET and POST…Jan 3, 2021Jan 3, 2021
Lambda + API Gateway = awesomeness — PART 2Part 1 of this series dealt with the steps that one must follow to expose a simple GET method on API Gateway that mapped to a handler…Dec 28, 2020Dec 28, 2020
Lambda + API Gateway = awesomeness — PART 1Just last week when I was confident on knowing most of AWS Lambda’s Capabilities; my colleague threw me a new one. API!!!!Dec 27, 2020Dec 27, 2020
Orchestrating flat file consumption with Snowpipe & TasksSnowflake has indeed proven to be a force to reckon with when it comes to SQL based databases, offering much more flexibility minus the…Jun 30, 20201Jun 30, 20201