Skip to content

Concept List for Mountainash Data

Total concepts: 100

Foundation Concepts (1-10)

  1. SQL Databases
  2. Database Schemas
  3. Database Catalogs
  4. Connection Management
  5. Python Protocols
  6. Runtime Checkable Protocol
  7. Pydantic Models
  8. Decorators
  9. Registry Pattern
  10. Ibis Library

Backend Protocol (11-18)

  1. Backend Protocol Definition
  2. Connect Method
  3. Close Method
  4. List Tables Method
  5. Inspect Table Method
  6. List Namespaces Method
  7. Inspect Namespace Method
  8. Inspect Catalog Method

Ibis Backend (19-34)

  1. IbisBackend Class
  2. Ibis Connection
  3. Fluent Query API
  4. Raw SQL Queries
  5. DDL Operations
  6. Create Table
  7. DML Operations
  8. Insert Data
  9. Upsert Data
  10. Truncate Table
  11. Create View
  12. List Tables Ibis
  13. Table Inspection Ibis
  14. Namespace Inspection Ibis
  15. Catalog Inspection Ibis
  16. Context Manager Ibis

Iceberg Backend (35-48)

  1. IcebergBackend Class
  2. Apache Iceberg Overview
  3. Iceberg Connection Base
  4. REST Catalog Type
  5. Hive Catalog Type
  6. Glue Catalog Type
  7. SQL Catalog Type
  8. Catalog Type Registry
  9. Iceberg Operations
  10. List Tables Iceberg
  11. Table Inspection Iceberg
  12. Namespace Inspection Iceberg
  13. Catalog Inspection Iceberg
  14. PyIceberg Library

Inspection Model (49-56)

  1. CatalogInfo Dataclass
  2. NamespaceInfo Dataclass
  3. TableInfo Dataclass
  4. ColumnInfo Dataclass
  5. Frozen Metadata Model
  6. Backend Agnostic Metadata
  7. Driver Metadata Conversion
  8. Unified Inspection API

Dialect System (57-66)

  1. DialectSpec Overview
  2. Dialect Registry
  3. Dialect Name Key
  4. Connection Builder
  5. Operation Hooks
  6. Per Dialect Configuration
  7. SQLite Dialect
  8. DuckDB Dialect
  9. PostgreSQL Dialect
  10. Snowflake Dialect

Settings & Configuration (67-84)

  1. ConnectionProfile Base
  2. To Driver Kwargs Method
  3. BackendSpec Class
  4. ParameterSpec Class
  5. Parameter Tiers
  6. DATABASES REGISTRY
  7. Register Decorator
  8. Auto Registration
  9. SQLiteAuthSettings
  10. DuckDBAuthSettings
  11. PostgreSQLAuthSettings
  12. BigQueryAuthSettings
  13. SnowflakeAuthSettings
  14. RedshiftAuthSettings
  15. ClickhouseAuthSettings
  16. DatabricksAuthSettings
  17. MSSQLAuthSettings
  18. TrinoAuthSettings

Adapters & Auth (85-94)

  1. Adapter Pipeline
  2. Credential Transformation
  3. OAuth Adapter
  4. JWT Adapter
  5. Cloud Native Auth
  6. SSL Bundle Adapter
  7. NoAuth Settings
  8. PasswordAuth Settings
  9. TokenAuth Settings
  10. IAMAuth Settings

Advanced Features (95-100)

  1. Cross Backend Queries
  2. Backend Capability Matrix
  3. DDL Index Support
  4. Memory Intensive Upsert
  5. REST Catalog Cursors
  6. Unimplemented Operations