Christopher Lagali – Medium

Christopher Lagali

Pinned

Christopher Lagali

Connecting to Snowflake using Key Pair Authentication

Adding more security to your interactions with Snowflake in a Production Environment.

5 min readAug 1, 2021

--

1

Connecting to Snowflake using Key Pair Authentication

--

1

Christopher Lagali

The Crucial Debate: Dynamic Task Mapping vs Loops in Airflow

As 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…

5 min read4 days ago

--

The Crucial Debate: Dynamic Task Mapping vs Loops in Airflow

--

Christopher Lagali

Design WORM models with DBT

Write 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…

6 min readNov 6, 2023

--

Design WORM models with DBT

--

Christopher Lagali

Run Adhoc queries in DBT with Jinja

DBT Models are great in separating SQL into their own enclosures which can be summoned anytime by Directed A-cyclic Graph code scripted in…

6 min readSep 4, 2023

--

1

Run Adhoc queries in DBT with Jinja

--

1

Christopher Lagali

Orchestrate DBT Core jobs with Airflow

Introduction

6 min readAug 30, 2023

--

Orchestrate DBT Core jobs with Airflow

--

Christopher Lagali

Programming with Credentials like a Pro

Credential Stores used with pros and cons

5 min readMar 16, 2022

--

Programming with Credentials like a Pro

--

Christopher Lagali

Restful webhook using Lambda + API Gateway — PART 3

If 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…

5 min readJan 3, 2021

--

Restful webhook using Lambda + API Gateway — PART 3

--

Christopher Lagali

Lambda + API Gateway = awesomeness — PART 2

Part 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…

7 min readDec 28, 2020

--

Lambda + API Gateway = awesomeness — PART 2

--

Christopher Lagali

Lambda + API Gateway = awesomeness — PART 1

Just last week when I was confident on knowing most of AWS Lambda’s Capabilities; my colleague threw me a new one. API!!!!

8 min readDec 27, 2020

--

Lambda + API Gateway = awesomeness — PART 1

--

Christopher Lagali

Orchestrating flat file consumption with Snowpipe & Tasks

Snowflake has indeed proven to be a force to reckon with when it comes to SQL based databases, offering much more flexibility minus the…

7 min readJun 30, 2020

--

1

Orchestrating flat file consumption with Snowpipe & Tasks

--

1

Christopher Lagali

Christopher Lagali

An Enthusiastic Data Eng. who is on a mission to unravel the possibilities of pipeline building with AWS and who believes in knowledge sharing.

Following

Help
Status
About
Careers
Blog
Privacy
Terms
Text to speech
Teams