I need to create a view in logical space with total 5 columns. Two columns are from source 1 and other 2 columns are from source 2 and 1 column is sequence number. This sequence number is assigned to each record to serve as a unique identifier for the record. The view at logical space is pulling values for 4 columns (mentioned above) through live connections to 2 different source systems (source 1 and source 2 as mentioned above)
Can you please help if there is a way to generate sequence number in dremio and assig to each record (a record consists of above 4 fields , 2 from each source). Another challenge is , each time I select the record from view , the sequence number assigned to each record should not change. I mean if the sequence number for record 1 with account name ABC was 101 then if I query the same record at any time later , the sequence number should be 101 only for that record at later time as well.