SQL Query in Model
I am trying to set up a SQL Query in a MODEL, but I do not understand which table name I should include into my SQL query.
See both print screens attached.
I also noticed that in my SQL query I do see 3 tables with a small table symbol next to it (see Pic 1). When I click on my SQL Query box, only one of the 3 has such a symbol (see Pic 2). Any idea where that could come from ?
When you write SQL Query on SQL Server, "select * from table1", The SQL engine will look for table1 in the dbo (default) schema.
In you case, your tables are inside "pyramid" schema.
Try to change the query to "select * from pyramid.EBO_ODS_Report_VisitsServiceLoad"