https://prefect.io logo
m

Matt Alhonte

09/08/2023, 11:34 PM
Trying to use
prefect-dbt
to interact with Redshift.
Copy code
target_configs = PostgresTargetConfigs.load(<name>, validate=False)
    dbt_cli_profile = DbtCliProfile(
        name=name,
        target=target,
        target_configs=target_configs.dict(),
    )
    result = trigger_dbt_cli_command(
        "dbt docs generate",
        dbt_cli_profile=dbt_cli_profile,
        overwrite_profiles=True,
        return_state=True,
        project_dir=project_dir,
    )
which gave me
Copy code
Database Error
  relation "pg_matviews" does not exist
s

Sean Williams

09/12/2023, 5:35 PM
It looks like the object doesn't exist in redshift. Have you successfully run this outside of
prefect-dbt
with dbt Core?