Tables, Dynamic Tables, and External Tables

Snowflake gives you three complementary ways to hold data. Database tables live inside Snowflake storage and behave like a classic warehouse. Dynamic Tables keep derived data up to date without hand-built orchestrations. External Tables and Iceberg Tables extend the platform to your lake, so you can query or even own data outside Snowflake while keeping SQL and governance consistent. Choosing among them is less about features and more about where the data should live, who else must use it, and how fresh it needs to be.