Custom Query Problem

hazalbilge Member Posts: 4 Type 0
edited August 2022 in Q&A

Hi, I have a problem with customizing the query. When I write this query 'select date_dim_id,' Last 1 Month' AS date_filter_range FROM public.D_Date ' for the editing, I am facing this problem. What is the reason for the error despite my SQL code being correct?


  • piersbatchelor
    piersbatchelor Member, Administrator, Moderator, Astrato PMs, Employee Posts: 79 admin
    edited August 2022

    Hi @hazalbilge

    Thank you for raising this issue and sorry to hear about the issue faced. We have investigated the issue and have concluded that this is caused by Postgres requiring an alias when inline views are used - which is how we run custom SQL within postgres.

    We aim to have completed testing and release this fix by mid-september.