1

Data Model - Filter source before Filter

Our Sales data currently consists of roughly 180.000.00 rows. I noticed that when you want to extract sales, for lets say a week, Pyramid waits until all rows on the source have been read.

Is there a way to filter the source without having to write a complete custom query, so only the WHERE clause... like a filter directly on SOURCE ?

Because now it takes a long time :)

2 replies

null
    • Dvir_Buzaglo
    • 6 yrs ago
    • Reported - view

    Hi Ian,

    In the select node, you can select a "SQL Query" element and create the required query you need,


    In addition views are now available to select from the "Select" node table selection. 

      Thanks.

    • Arnold_Slabbekoorn
    • 1 yr ago
    • Reported - view

    Hi, we are testing this out with our Snowflake data warehouse and I am running into the same issue. Above seems to basically answer with two solutions. 1. You either write custom SQL or 2. You go back to the database team to create a View with your WHERE clause static filter. So are you saying there is no option to push a filter WHERE clause into the Table selection column options when you add table to reduce transfer of data for what you need?

Content aside

  • Status Answered
  • 1 Likes
  • 1 yr agoLast active
  • 2Replies
  • 54Views
  • 3 Following