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.



2 replies

    • Clement
    • 5 yrs ago
    • Reported - view

    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 ? 

    • Shai_Ben_Ami
    • 5 yrs ago
    • Reported - view


    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"

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 2Replies
  • 53Views
  • 2 Following