Filtering out inactive records at the View level

[towens-16505684]

The ask is to find out the best way to pre-filter out inactive records in a view file. Right now we are using a derived table but my team would like to change this for performance considerations.

Here is what the current LookML looks like:

view: viewname {

 derived_table: {

 sql: SELECT * FROM db_table WHERE "IS_ACTIVE" = TRUE ;;

}