I just did this on the community cluster

%sql

create or replace table picklist

( picklist_id      BIGINT not null GENERATED ALWAYS AS IDENTITY(start with 1 increment by 1),

 picklist_Name     string 

)

insert into picklist(picklist_Name) values('a');

insert into picklist(picklist_Name) values('b');

insert into picklist(picklist_Name) values('c');

select * from picklist

Also check DESCRIBE to see where the delta table is saved

I have a feeling its the version of the DBR that your using

Could you use the latest and see if that helps you