# Database Limits

**URL:** <https://discuss.google.dev/t/database-limits/115936>\
**Category:** Looker\
**Tags:** lookml\
**Created:** [June 8, 2022, 5:28pm UTC](https://discuss.google.dev/t/database-limits/115936 "2022-06-08T17:28:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [June 8, 2022, 5:28pm UTC](https://discuss.google.dev/t/database-limits/115936/1 "2022-06-08T17:28:31Z")

</div>

Hello,

My client is currently using Amazon Athena for the database connection to Looker. Currently I have created for a couple views some SQL calls to the tables that are standard select statements which each hold 1,000,000 records, for example:

select \* from table\_1

I know that Looker has a 5,000 record limitation for Explores embedded and that this limit is capped at 100,000 when you download information per [https://docs.looker.com/sharing-and-publishing/downloading](https://docs.looker.com/sharing-and-publishing/downloading).

My question is since the SQL in my view has no limit statement in it and has 1,000,000 records, does this mean that when I build build an Explore that is derived from this view and add it to a dashboard and run that dashboard, will Looker pull all 1,000,000 records? Or will it only pull 5,000?