create-a-cluster.html 1.2 KB

12345678910111213141516171819202122232425
  1. In Materialize, a [cluster](/concepts/clusters/) is an isolated
  2. environment, similar to a virtual warehouse in Snowflake. When you create a
  3. cluster, you choose the size of its compute resource allocation based on the
  4. work you need the cluster to do, whether ingesting data from a source,
  5. computing always-up-to-date query results, serving results to clients, or a
  6. combination.
  7. In this case, you'll create a dedicated cluster for ingesting source data from
  8. your SQL Server database.
  9. 1. In the [SQL Shell](https://console.materialize.com/), or your preferred SQL
  10. client connected to Materialize, use the [`CREATE CLUSTER`](/sql/create-cluster/)
  11. command to create the new cluster:
  12. ```mzsql
  13. CREATE CLUSTER ingest_sqlserver (SIZE = '200cc');
  14. SET CLUSTER = ingest_sqlserver;
  15. ```
  16. A cluster of [size](/sql/create-cluster/#size) `200cc` should be enough to
  17. process the initial snapshot of the tables in your SQL Server database. For
  18. very large snapshots, consider using a larger size to speed up processing.
  19. Once the snapshot is finished, you can readjust the size of the cluster to fit
  20. the volume of changes being replicated from your upstream SQL Server database.