Dataform execution status showing - Pending: Waiting for upstream dependencies to complete

Google Cloud Data Analytics
1

Hi - I am trying to create a table using sqlx. i have two file - 1. to declare a source table in BQ and 2. to create a table. When I execute the code, the 1st one goes through fine, however the 2nd one seems to be held up. Therefore the table is not created in bQ. The status for the 2nd one shows as ‘Pending: Waiting for upstream dependencies to complete’. Here’s the code for both below. i cannot find any errors in any of the logs as well and need to know how i can trouble-shoot the issue.

  1. Declare source with file name as ‘users.sqlx’.

config {

type: “declaration”,

database: “DB-prod”,

schema: “DB_changes_dataset_final”,

name: “users”,

}

  1. Create Table, with file name as ‘new-table.sqlx’

config { type: “table” }

SELECT * FROM ${ref(“users”)}

Any help will be appreciated.

2

Hi, thanks for reporting this, could you confirm what the overall status of the workflow is as well as the specific action? Does the workflow show as running still, or does it show as Succeeded/Failed?

3

Hi Lewish - I managed to resolve the issue after looking at the error logs, where I found that the service account did not have the required access to bigquery access.

Thanks for reverting.

Regards,

Sameer