Hello @Stan Piekarczyk and welcome to Microsoft Q&A.
This is expected behavior. For queries or stored procedures, lineage is not supported. What you see is not an error.
This is called out in supported data stores for copy activity lineage information just below the table, explaining the *
- Microsoft Purview currently doesn't support query or stored procedure for lineage or scanning. Lineage is limited to table and view sources only.