remote_query() is not working

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

I am trying to experiment with remote_query() function according to the documentation. The feature is in public preview, so I assume it should be available to everyone now.

select * from remote_query(
  'my_connection',
  database => 'mydb',
  dbtable => 'my_table'
  )

Whenever I query, I am getting one of two errors:

[INVALID_USAGE_OF_STAR_OR_REGEX] Invalid usage of '*' in Project. SQLSTATE: 42000
== SQL (line 2, position 8) ==
select * from remote_query(
       ^

If I change `*` to a column name, say, `id`, I get the following:

[UNRESOLVED_COLUMN.WITHOUT_SUGGESTION] A column, variable, or function parameter with name `id` cannot be resolved.  SQLSTATE: 42703
== SQL (line 2, position 8) ==
select id from remote_query(
       ^^

All prerequisites are satisfied: connection is live, which is confirmed by a Lakehouse Federation catalog built on top of the same connection. Runtime is 17.3 RTS, have USE CONNECTION (I am also the owner).

Can anyone please explain what I am doing wrong?