Create a DAG as a python file like sample.py under DAG_FOLDER - $AIRFLOW_HOME/dags directory.
from datetime import datetime
from airflow import DAG
from airflow.providers.teradata.operators.teradata import TeradataOperator
CONN_ID = "Teradata_TestConn"
with DAG(
dag_id="example_teradata_operator",
max_active_runs=1,
max_active_tasks=3,
catchup=False,
start_date=datetime(2023, 1, 1),
) as dag:
create = TeradataOperator(
task_id="table_create",
teradata_conn_id=CONN_ID,
sql="""
CREATE TABLE my_users,
FALLBACK (
user_id decimal(10,0) NOT NULL GENERATED ALWAYS AS IDENTITY (
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 2147483647
NO CYCLE),
user_name VARCHAR(30)
) PRIMARY INDEX (user_id);
""",
)