How to read VIEW columns from a custom statement that don’t exist as attribute on the resource without throwing a Ash.Error.Query.NoSuchAttribute defmodule MyApp.Members.Member do use Ash.Resource, domain: MyApp.Members, data_layer: AshPostgres.DataLayer postgres do table "members"…

Probably not, TBH. It’s used for a whole bunch of things in Ash proper. You can remove the id from your resource entirely if needed, but not de-select it for a resource that has a primary key.

Hi kamaroly, You can handle columns from a view that aren’t attributes on your resource by either defining virtual attributes marked as read_only: true or creating a custom read action that selects those extra columns. This way, Ash won’t throw a NoSuchAttribute error, but you can still access the …

@kamaroly why would you not just make them attributes?

Attributes will create columns in the DB but views are only for reading. Is there a way to declare attributes without having them created as columns in the DB?

I am looking for a way to create an attribute that won’t generate migrations to create a new table in the DB and add that attribute as a column.

You can set migration_ignore_attributes in the Postgres block to tell it to ignore fields and not generate migrations for them.

Thanks @zachdaniel , It helped but another problem emerged. I realised the query is always selecting ID but the action didn’t specify ID in its selection. This fails the query. The action read :contribution_report do prepare build(select: [:contributed_amount, :period, :membership_no]) …

We always select the primary key. Can that not be added to the view?

It can be added. I am seeing a limitation when there’s a need to offload aggregations to the DB due to complexity or speed optimisation. Something like below that won’t require id selection. CREATE VIEW view_contributions_by_member_category AS SELECT members.category member_category, sum(…

Elixir Programming Language Forum

How to Read Views columns that are not matching Resource attributes?

Questions & Help Questions

kamaroly November 10, 2025, 10:54am 3

Thanks. Please share an example code.