Assigned
Status Update
Comments
je...@google.com <je...@google.com>
em...@google.com <em...@google.com>
bw...@google.com <bw...@google.com>
is...@google.com <is...@google.com>
cr...@google.com <cr...@google.com>
me...@kieranbenton.com <me...@kieranbenton.com> #2
+1
Description
- When trying to run query like ‘SELECT * FROM EXTERNAL_QUERY("CONNECTION", "SELECT * FROM INFORMATION_SCHEMA.TABLES;" || "")’, BQ UI returns ”Unexpected TVF argument type found, expecting literal string at [1:72]” message and doesn’t allow query to run.
It will be nice if it provides more flexibility when composing a query to be thrown to CloudSQL, so that users can dynamically pass arbitrary values as a part of WHERE clause, etc.
(Expected feature example with BQ UI)
============
SELECT * FROM EXTERNAL_QUERY("CONNECTION", "SELECT * FROM INFORMATION_SCHEMA.TABLES;" || ""),
============
(Expected feature example with BQ CLI)
============
bq query --use_legacy_sql=false --parameter='catalog::"def"' --parameter='extquery::SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG=@catalog' 'SELECT * FROM EXTERNAL_QUERY("CONNECTION", @extquery)'
============