dbt

import subprocess import os # Ensure dbt is in your PATH, or specify the full path to the executable. # This example assumes 'dbt' is accessible via PATH. # For dbt Cloud CLI, you'll typically interact with an existing dbt Cloud project. # This simple debug command checks dbt and its environment. # Real world usage involves `dbt run`, `dbt test`, etc., usually within a dbt project directory. # Example: Run dbt debug try: print("Running 'dbt debug'...") # The check=True argument raises an exception for non-zero exit codes result = subprocess.run(["dbt", "debug"], capture_output=True, text=True, check=True) print("dbt debug output:\n", result.stdout) if result.stderr: print("dbt debug errors/warnings:\n", result.stderr) # Example of a command that would require a dbt project and connection (commented out) # To run this, you'd need to be in a dbt project directory with configured profiles. # print("\nAttempting 'dbt seed' (requires project & connection)...\n") # # Ensure DBT_CLOUD_API_KEY is set in your environment if interacting with dbt Cloud # # os.environ['DBT_CLOUD_API_KEY'] = os.environ.get('DBT_CLOUD_API_KEY', 'your_dbt_cloud_api_key') # seed_result = subprocess.run(["dbt", "seed"], capture_output=True, text=True, check=True) # print("dbt seed output:\n", seed_result.stdout) except subprocess.CalledProcessError as e: print(f"Error running dbt command (exit code {e.returncode}): {e.cmd}") print(f"STDOUT:\n{e.stdout}") print(f"STDERR:\n{e.stderr}") except FileNotFoundError: print("Error: 'dbt' command not found. Make sure dbt Cloud CLI is installed and in your system PATH.") except Exception as e: print(f"An unexpected error occurred: {e}")