I want to call external query inside stored procedure in BigQuery.
Something along the lines
CREATE OR REPLACE PROCEDURE dataset.my_procedure(param1 STRING)
BEGIN
SELECT * FROM EXTERNAL_QUERY("my-external-connection", """
SELECT * FROM external_table WHERE column1=:param1
""") as external;
END;
Is it possible to pass parameter to external query and how?
The ONLY option I see for you (at least as of today - because ""Connection argument in EXTERNAL_QUERY must be a literal string or query parameter"" and see https://stackoverflow.com/a/61294646/5221944 for little more details on this)
CREATE OR REPLACE PROCEDURE dataset.my_procedure(param1 STRING)
BEGIN
SELECT *
FROM EXTERNAL_QUERY("my-external-connection", """
SELECT * FROM external_table
""")
WHERE column1 = param1;
END;
So, you just simply moving WHERE clause to outside ...
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
コメントを追加