---
title: "Discussion on \"How to Create Prepared Statements with the Airflow PostgresOperator\" | Hashnode"
description: "Discussion on \"How to Create Prepared Statements with the Airflow PostgresOperator\". Airflow's PostgresOperator includes a field called parameters for providing SQL parameters for prepared statements.\nWe wanted to use named parameters since our parameter order would vary, which meant understanding the syntax. In their provided exampl..."
url: "https://hashnode.com/posts/how-to-create-prepared-statements-with-the-airflow-postgresoperator/635db914007b20d93c5870f2"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to Create Prepared Statements with the Airflow PostgresOperator](https://blog.redactics.com/how-to-create-prepared-statements-with-the-airflow-postgresoperator?utm_source=hashnode&utm_medium=feed)

Airflow's PostgresOperator includes a field called parameters for providing SQL parameters for prepared statements. We wanted to use named parameters since our parameter order would vary, which meant understanding the syntax. In their provided exampl...

Oct 29, 2022 · 1 min read · blog.redactics.com  
Read the article

-   [#airflow](https://hashnode.com/tag/airflow)
-   [#postgresql](https://hashnode.com/tag/postgresql)

## Written by

[Joe Auty](https://hashnode.com/@joeauty)

@joeauty

  
[View profile](https://hashnode.com/@joeauty)

DevOps/SRE engineer building Redactics

On multiple occasions in my career I've been tasked with creating production data samples and setting up environments to use this data. Seeing a pattern here, and having spent a lot of time working on perfecting this, I built a business out of this (https://www.redactics.com) and later found my co-founders to take the original concept, generalize it, and extend the original concept into full-fledged data privacy product with its initial focus around bringing safe production data into test, development (local and cloud-based), and demo environments.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.