Yes, you can perform top syntax in the snowflake database.
It can be done by using TOP and this will constrain the maximum number of rows returned by statement or subquery.
Important to Note: When you use TOP make sure that is a non-negative integer constant and also note that LIMIT is equivalent to TOP .
Furthermore, when using TOP the ORDER BY clause does not have to be used. But if you DO NOT use the clause then the results will be non-deterministic as the results within the result set are not in a specific order. So if you want to ensure that the results returned are controlled, be sure to use the ORDER BY clause.