title: Error in DBT cloud Server error: Database Error in rpc request (from remote system) syntax error at or near ")"
body: <pre><code>WITH unioned_product_reports AS(
      {% set prod_relations = dbt_utils.get_relations_by_pattern('xyz_shema', 'test_products%') %}
      {{ dbt_utils.union_relations(relations = prod_relations) }}
      ranking_product_report_rows AS(
          SELECT *,
              ROW_NUMBER() OVER(PARTITION BY date, name ORDER BY batch_runtime DESC) rno
          FROM unioned_product_reports
      )
  )
  </code></pre>
  <p>In dbt I am trying to union all tables by above using above dbt-utils packages but it showing error as:</p>
  <blockquote>
  <p>Server error: Database Error in rpc request (from remote system)
  syntax error at or near &quot;)&quot; LINE 13: )</p>
  </blockquote>
  <p>can someone suggest solution.</p>