Whenever i run any select query in snowflake the result set is having auto generated row number column (as a first column).. how to ignore this column from the code...

Like : select * from emp ignore row;

CodePudding user response：

If you're referring to the unnamed column just before TABLE_CATALOG in the below picture.

I'm pretty sure that's not something we can not change -> maybe if you wrote some custom JS to fiddle with the page you might be able to hide it by perhaps changing the TEXT color to white or something. But that seems like a lot of work.

If you extract the data to a CSV (or any file format) this number does not appear in the payload.

CodePudding user response：

When you query Snowflake, regardless of which client you use, that column won't be returned.

It is a pure UI thing in the Snowflake Editor for readability.