Hello,
i am trying to build some dynamic sql scripts using this identifier() clause. This works fine when it is used with [ select * from identifier (mytable) ]. However, when I try to use this identifier as a reference to a foreign key table, it doesnโt work. For example,
CONSTRAINT s_t_fk FOREIGN KEY(fk1) REFERENCES identifier(mytable).
Any idea how to use an identifier() or a variable when referencing to table? I am using sql warehouse. Not spark sql. Thank you