Investigate which ilikes can be replaced with equalities without leading to errors.
Replace ilikes with equalities.
Make equalities the default.
Justification for this enhancement
Replacing the ilike in dremio__list_relations_without_caching with equalities has led to a significant performance enhancement https://github.com/dremio/dbt-dremio/issues/134. Are there any other ilikes that are hampering performance?
Describe the enhancement requested
Investigate which ilikes can be replaced with equalities without leading to errors. Replace ilikes with equalities. Make equalities the default.
Justification for this enhancement
Replacing the ilike in
dremio__list_relations_without_cachingwith equalities has led to a significant performance enhancement https://github.com/dremio/dbt-dremio/issues/134. Are there any other ilikes that are hampering performance?