unresolved reference to SqlSchema Azure Data Studio

Question

I am trying to build the database project on Azure Data Studio and receiving errors saying has an unresolved reference to SqlSchema. I have several databases under one project. How can I fix this error. The table create script has [databasenamae].[tablename]

Answer 1

Replace 3-part references to objects (like [database].[dbo].table1) to 2-part names or just the name of the object (like dbo.table1 or table1). Do a find/replace search on the script.

Make sure also that there are not cross database references like reference a table that resides on Database2 from Database1 (SELECT * FROM [database2].[dbo].tablename)). If you want to do this, you may need to create external tables using Elastic Queries.

In addition, make sure you are not making reference to system stored procedures or system functions (like sys.fn_get_audit_file) that are not supported on Azure SQL Database.

Hope this helps.