← Back to Tutorials
8. Core Objects
| Object | Description |
|---|
| Database | Container for schemas and data objects |
| Schema | Namespace within a database for tables/views/functions |
| Table | Stores relational data with micro-partitions |
| View | Logical table based on a query |
| Stage | Location for files to load/unload (internal or external) |
| File Format | Describes file types (CSV, JSON, Parquet, etc.) |
| Function | UDFs, stored procedures (SQL, JavaScript, Python) |
| Sequence | Generates unique numbers |
CREATE DATABASE my_db;
CREATE SCHEMA my_schema;
CREATE TABLE my_table (id INT, name STRING);
CREATE STAGE my_stage;
CREATE FILE FORMAT my_csv TYPE = CSV;
✏️ Exercise: Create a database, schema, table, stage, and file format in your Snowflake account. Verify each with SHOW commands.