Paul Brabban – Medium

Paul Brabban

Paul Brabban

Preventing data theft with GCP service controls

I recently discovered and responsibly disclosed a vulnerability in the dbt analytics engineering solution. Google Cloud services are my…

Jul 6

Preventing data theft with GCP service controls

Jul 6

Paul Brabban

Are you at risk from this critical dbt vulnerability?

A newly discovered critical security vulnerability in the dbt ecosystem (originally published on equalexperts.com)

Jul 2

Are you at risk from this critical dbt vulnerability?

Jul 2

Paul Brabban

Latest and historical state from change data capture

In previous posts, I disambiguated transactions by filtering out any transient statements and noted that changes in primary key values…

Jun 28

Latest and historical state from change data capture

Jun 28

Paul Brabban

Breaking Change Data Capture with primary keys

My work on dealing with multiple tables was interrupted when I discovered a subtle scenario that leads to DMS CDC output that cannot be…

Jun 12

Breaking Change Data Capture with primary keys

Jun 12

Paul Brabban

Disambiguating Transactions in Change Data Capture

In the CDC output, I get a row for each statement executing in the transaction. Each row reflects the state of the database when that…

Jun 4

Disambiguating Transactions in Change Data Capture

Jun 4

Paul Brabban
in
Dev Genius

Handling CVE-2019–8341 for dbt and mkdocs

Yesterday, Safety told me about CVE-2019–8341, a security issue affecting Jinja2. I’ll walk through how I investigated and assessed the…

Jun 2

Jun 2

Paul Brabban

Exploring Transactions in Change Data Capture

Last time, I set up a CDC system using AWS RDS and DMS services. Now, I’ll run some operations through the source database and show what…

May 28

Exploring Transactions in Change Data Capture

May 28

Paul Brabban

Change Data Capture with AWS DMS

Setting up Change Data Capture from Aurora Serverless PostgreSQL to S3 via the AWS DMS service. I’ll walk through the demo setup, using the…

May 21

Change Data Capture with AWS DMS

May 21

Paul Brabban
in
Dev Genius

Handling CVE-2018–20225

CVE-2018–20225 in all versions of pip tripped my vulnerability alerting this morning. If you're scanning for vulnerabilities using Safety…

May 18

Handling CVE-2018–20225

May 18

Paul Brabban
in
Dev Genius

dbt 1.8 Breaks on Update

On updating dbt-bigquery to latest 1.8.0: No module named ‘dbt.adapters.factory’. TL;DR — pip install --force-reinstall dbt-adapters…

May 12

Error traceback ending with No module named dbt.adapters.factory

May 12

Paul Brabban

Paul Brabban

Consultant/Contractor, Software Development and Data Engineering. Functional Programming Advocate. More at https://tempered.works

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams