This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I'm calling a private http Cloud Function using the google-auth-library
in Node.js. This works locally both when authenticated as myself and
when impersonating the Cloud Run service account. However, when I deploy
this to Cloud Run I get 401 response...
I have audit log sinks set up for BigQuery tables, which I use to
monitor access to the tables. I use filter logic similar to the query
below in the sink.protoPayload.metadata."@type" =
"type.googleapis.com/google.cloud.audit.BigQueryAuditMetadata"
p...
I would like to run certain SQLX files during incremental executions,
but skip them during full refresh executions. What would be a clean way
to accomplish this?I was thinking of using the disabled property in the
config block, similar to below, but ...
Is there a way to adjust the default tab size in the Dataform IDE? In
the BigQuery IDE, the default tab size is 2 spaces. This was also
previously the default tab size for the Dataform IDE, but it seems to
have changed to 4 spaces recently.I noticed ...
I'm creating an incremental table in Dataform, but want to change how
duplicate rows are merged. The default behavior is for duplicate rows to
overwrite existing rows in the table (Merge rows in an incremental
table). Instead, I would like to sum val...
Thanks for the response. It turns out the issue was that I was including
the extended route/query parameters for my specific request call when
calling getIdTokenClient. So I was passing getIdTokenClient more
information than required, which was causi...
Hey Artem, thanks for the reply. The table will still exist whether it
be an incremental or non-incremental execution so your solution wouldn't
work out exactly.But your idea of essentially nullifying the operation
in the WHERE clause is a good one. ...
Hello, thanks for the suggestion. Unfortunately, the incremental
function does not work in the configuration block. When I add it as you
describe I get the following error:incremental is not definedI believe
it would need to be included in a JavaScri...
There’s a syntax mistake here. On line 8 of your query you have a
missing closing bracket at the beginning of the line. It should be ) AS
total_orders. Or you could move the ) to the end of line 7 depending on
your styling.This is because you have an...
