Temp Tables row count limit

Get Help
1

Hi,

I need to use a temp table for my analysis, but somehow, when I create temp tables metabase limits the row count to 2000.

(My server is SQL Server)

Can I increase this limit?

2

Hi @kksql
Sounds like you're seeing this issue:
https://github.com/metabase/metabase/issues/9940 - upvote by clicking :+1: on the first post

3

I'm actually the end-user of the Metabase as a Data Analyst. Therefore I saw this thread but did not understand it quite well, my problem is:

When I do:
"""
Select *
FROM [Order]
""
It returns all the rows (lets say 35000 rows).

But when I do
"""
Select *
INTO #TEMPTABLE
FROM [Order]

SELECT *
FROM #TEMPTABLE
""
It returns only 2000 columns no matter what, so my problem only concerns temp tables.

Does this thread (https://github.com/metabase/metabase/issues/9940) only concerns TempTable as well ?

4

@kksql I haven't tested, but I guess so. You would need to contact your database admin, so they can look at the query logs.

All queries should have limits, though there might be workarounds for some database types:
https://github.com/metabase/metabase/issues/12729