0

SQL Query in Model

sql_query_2 sql_query_1

Hello,

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.

  
Sincerely

Clément

2 replies

null
    • Clement
    • 6 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
    • 6 yrs ago
    • Reported - view

    Hello,

    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"

Login to reply

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 2Replies
  • 65Views
  • 2 Following