No Percentage Option in the Sample-in-DB

Question

Hi Everyone,

in my current workflow im trying to apply a sort with the in-DB tools. The option to let through 100% of the data is not selectable in tool. See my attachment.

In one other usecase i have been able to have a workaround where i replaced the limit string with an empty string in the final process query.

Sadly im now reliant on the option in the tool. Has anyone encountered this?

Bild.png

alexnajm · Answer

This is just normal behavior of the Sample In-DB tool - if you are trying to apply a sort, you can do so in the Data Stream Out In-DB tool, or in your original query in the Connect In-DB