BigQuery Missing Dataset Error While Creating User-Defined Function

Question

I'm trying to create simple user-defined function in BigQuery using sql query like this:

CREATE OR REPLACE FUNCTION
  distance_traveled_between_time(id STRING,
    starttime TIMESTAMP,
    endtime TIMESTAMP)
RETURNS FLOAT64 AS (
  (
    SELECT SUM(fueltanklevel) FROM `eva-boa-inf2.evaboa.gpsapi`
  )
)

Note: this is not the real function, it's just dummy function that return float value

I think, this is a valid SQL statement, but I have this error:

Routine name "distance_traveled_between_time" missing dataset while no default dataset is set in the request.

And I don't know what to fix at this point. Anyone knows?

Pentium10 · Accepted Answer · 2020-12-11 08:24:51Z

1

Add the dataset to the name of the routine:

CREATE OR REPLACE FUNCTION
   dataset.distance_traveled_between_time

look here-^

answered Dec 11, 2020 at 8:24

Pentium10

209k124 gold badges435 silver badges513 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BigQuery Missing Dataset Error While Creating User-Defined Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related