CREATE TABLE table_with_limit AS SELECT * AS target_table LIMIT target_limit;
-- BEWARE! that is a hacky way to use limits, considering that right now (2022/07/22) there is still no support for LIMIT clause in pull queries (there will be soon, a pull request
-- was made back in 2020 solving the issue (https://github.com/confluentinc/ksql/pull/4951).