Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2025 02:24 AM
Hello @saurabh_aher ,
As a workaround maybe you can use SQL procedures, a quick example I created:
CREATE OR REPLACE PROCEDURE workspace.default.get_table_proc(IN p_fqn STRING)
LANGUAGE SQL
SQL SECURITY INVOKER
AS
BEGIN
DECLARE sql_str STRING;
SET sql_str = CONCAT('SELECT * FROM ', p_fqn);
EXECUTE IMMEDIATE sql_str;
END;
And then you can call it like this:
CALL workspace.default.get_table_proc('workspace.default.sample_trips_test');Hope that helps a bit.
Best, Ilir