How to use identifier() as reference

standup1 — Thu, 25 Jul 2024 02:15:52 GMT

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

Re: How to use identifier() as reference

stil — Wed, 21 Aug 2024 12:32:56 GMT

Is this something you are working to resolve?

We would also like to use IDENTIFIER() with our REFERENCE(s) CONSTRAINT(s)

If not - is it possible to get an explaination why the limitation exists?

topic How to use identifier() as reference in Data Engineering

How to use identifier() as reference

Re: How to use identifier() as reference