Is there a limitation on how many schemas and security objects you can have in one Snowflake database and will there be performance degradation with thousands of these objects?
Will splitting the data into multiple snowflake databases help performance?
I think I'll have to know what you mean by objects and data. Rows in the database are what many refer to as data. Schema would be a table. Since most SQL deals with one or a few tables at a time, there is no real impact if a SQL server has hundreds of tables. Finally, thousands of rows is a very small database so any performance issue is either a host issue, improper indexing or other.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.