The Redshift query hangs indefinitely when executed through DBT, but it completes quickly when run from a SQL Client tool

vuong.l.q.huynh · November 23, 2023, 5:24pm

Hello everyone,

In recent weeks, some queries in dbt on Redshift have been hanging. Even simple queries take nearly 20 hours to complete, and some are still running. However, running the same queries through any SQL Client tool only takes a few minutes.

dbt Core: 1.5.7
dbt Redshift: 1.5.11

Is anyone experiencing the same issue?

Topic		Replies	Views
Redshift view deadlocks? Help redshift , views	4	1890	March 14, 2023
DBT AccessExclusiveLock with more than 1 Thread Help redshift , dbt-core	0	337	April 24, 2024
DBT run with 4 threads causing AccessExclusiveLock in Redshift Archive	0	3123	October 13, 2021
Procedures running for longer times, but same Proc is running for 2 mins in redshift DB Help dbt-cloud	0	667	September 15, 2023
dbt Fundamentals: Unable to connect to Redshift Help	0	74	September 11, 2024

The Redshift query hangs indefinitely when executed through DBT, but it completes quickly when run from a SQL Client tool

Related topics