> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/guides/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# Guides

## Docs

- [Get Started with the Ocient Hyperscale Data Warehouse](https://ocient.ferndocs.com/guides/get-started-with-the-ocient-hyperscale-data-warehouse.md): Ocient’s comprehensive documentation for setup, integration, and advanced data warehouse features. Perfect for developers and data teams seeking insights into Ocient's high-speed, scalable analytics solutions.
- [Key Concepts](https://ocient.ferndocs.com/guides/get-started-with-the-ocient-hyperscale-data-warehouse/key-concepts.md): Learn the core concepts behind Ocient high-performance data warehouse, including its architecture, scalability, and analytics capabilities designed for large-scale, complex datasets.
- [Work with AI Prompts](https://ocient.ferndocs.com/guides/get-started-with-the-ocient-hyperscale-data-warehouse/work-with-ai-prompts.md): Draft high-quality prompts to help AI tools use the Ocient documentation and Ocient SQL accurately. This guide explains why models need explicit direction, how to anchor them on authoritative sources, and provides copy‑paste templates. Always start from t
- [Ocient Architecture](https://ocient.ferndocs.com/guides/ocient-architecture/ocient-architecture.md): Learn about Ocient architecture, designed to support high-speed analytics on massive datasets.
- [Compute-Adjacent Input and Output on Large Working Sets](https://ocient.ferndocs.com/guides/ocient-architecture/compute-adjacent-input-and-output-on-large-working-sets.md): Leverage compute-adjacent I/O in Ocient for efficient processing of large data sets.
- [Core Elements of an Ocient System](https://ocient.ferndocs.com/guides/ocient-architecture/core-elements-of-an-ocient-system.md): Explore the core components that make up an Ocient system, including storage, computation, and network architecture.
- [Exabyte Scalability Design](https://ocient.ferndocs.com/guides/ocient-architecture/exabyte-scalability-design.md): Learn about Ocient scalability features designed to handle exabyte-scale datasets seamlessly.
- [Loading Characteristics and Concepts](https://ocient.ferndocs.com/guides/ocient-architecture/loading-characteristics-and-concepts.md): Understand data loading concepts in Ocient, optimized for high throughput and efficient resource use.
- [Plan Optimization](https://ocient.ferndocs.com/guides/ocient-architecture/plan-optimization.md): Discover query plan optimization strategies in Ocient, maximizing processing efficiency and minimizing response times.
- [Query Performance Optimizations](https://ocient.ferndocs.com/guides/ocient-architecture/query-performance-optimizations.md): Enhance query performance in Ocient with tips and techniques for faster data retrieval.
- [Connect to Ocient](https://ocient.ferndocs.com/guides/connect-to-ocient/connect-to-ocient.md): Discover how to connect to Ocient’s data warehouse with step-by-step instructions for seamless integration, ensuring fast, reliable data access for large datasets.
- [Connect Using JDBC](https://ocient.ferndocs.com/guides/connect-to-ocient/connect-using-jdbc.md): Learn how to set up and configure a JDBC connection to Ocient, ensuring secure and efficient data access for large-scale analytics.
- [Connect Using pyocient](https://ocient.ferndocs.com/guides/connect-to-ocient/connect-using-pyocient.md): Follow this guide to establish a Pyocient connection to the Ocient data warehouse, enabling Python-based data operations and analysis.
- [Ocient Integrations](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations.md): Explore Ocient integrations with popular analytics tools and platforms to enhance data processing and analysis capabilities across your existing systems.
- [DBeaver Integration](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/d-beaver-integration.md): Learn how to integrate Ocient with DBeaver, enabling a powerful and intuitive interface for managing and analyzing your Ocient data.
- [Looker Connector](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/looker-connector.md)
- [Metabase Integration](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/metabase-integration.md): Set up and integrate Ocient with Metabase to create visual data insights and dashboards, optimizing your data analysis workflow.
- [SQLAlchemy Integration](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/sql-alchemy-integration.md): Connect Ocient with SQLAlchemy for efficient data querying and manipulation, enhancing SQL capabilities in your Ocient database environment.
- [Superset Integration](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/superset-integration.md): Integrate Ocient with Apache Superset for dynamic data visualizations and dashboards, empowering data-driven decision-making at scale.
- [Tableau Integration](https://ocient.ferndocs.com/guides/connect-to-ocient/ocient-integrations/tableau-integration.md): Connect Ocient with Tableau to unlock advanced data visualization and reporting, driving actionable insights from massive datasets.
- [Database Administration](https://ocient.ferndocs.com/guides/database-administration/database-administration.md): Manage and maintain Ocient data warehouse with essential database administration practices for optimized performance.
- [Authentication Methods](https://ocient.ferndocs.com/guides/database-administration/authentication-methods.md): Learn about various authentication methods supported by Ocient, ensuring secure and controlled access to your data warehouse.
- [Manage Distributed Tasks](https://ocient.ferndocs.com/guides/database-administration/manage-distributed-tasks.md): Distributed tasks are processes that run in the background of the Ocient System to keep the system running smoothly and efficiently. These tasks provide persistent storage of task information in the global metadata storage cluster.
- [Manage Users, Groups, and Roles](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles.md): Set up and manage users, groups, and roles within Ocient, ensuring secure and organized access control in the database.
- [Ocient Security Guide](https://ocient.ferndocs.com/guides/database-administration/ocient-security-guide.md): Enhance your Ocient System security with our comprehensive guide. Learn best practices for authentication, network security, data encryption, access control, auditing, and compliance with privacy regulations.
- [Remove Records from an Ocient System](https://ocient.ferndocs.com/guides/database-administration/remove-records-from-an-ocient-system.md): Discover methods for safely and efficiently removing records from an Ocient system, ensuring data integrity.
- [Database Password Security Settings](https://ocient.ferndocs.com/guides/database-administration/authentication-methods/database-password-security-settings.md): Secure your Ocient System with best practices for authentication, access control, encryption, network security, auditing, and compliance. Strengthen data privacy and protect SaaS or customer-deployed systems with our comprehensive security guide.
- [Object-Type Level Privileges Management](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/object-type-level-privileges-management.md)
- [Result Set Caching](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/result-set-caching.md): Optimize performance with result set caching in Ocient, reducing query times and improving efficiency for frequent data requests.
- [Workload Management and Service Classes](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/workload-management-and-service-classes.md): Understand service classes and workload management to allocate resources effectively and maximize Ocient performance.
- [Workload Management Walkthrough](https://ocient.ferndocs.com/guides/database-administration/manage-users-groups-and-roles/workload-management-walkthrough.md): Learn how to manage workloads within Ocient, balancing resources for optimized query performance and efficiency.
- [Set Up Data Encryption](https://ocient.ferndocs.com/guides/database-administration/ocient-security-guide/set-up-data-encryption.md): Optimize data security with Ocient® System data encryption setup for drives supporting TCG Opal Specification. This guide covers configuring encryption secrets using the Thales CipherTrust Manager KMS via KMIP.
- [CREATE TABLE SQL Statement Examples](https://ocient.ferndocs.com/guides/database-administration/schema-design/create-table-sql-statement-examples.md): Access examples of SQL CREATE TABLE statements in Ocient, illustrating best practices for table structure and data types.
- [Secondary Indexes](https://ocient.ferndocs.com/guides/database-administration/schema-design/secondary-indexes.md): Explore the benefits of secondary indexes in Ocient, designed to enhance data retrieval speed and efficiency for large datasets.
- [Table Compression Options](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options.md): Learn about table compression options in Ocient, optimizing data storage and reducing costs for large-scale data warehousing.
- [Table Retention Policies](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-retention-policies.md): Ocient table retention policies automate data lifecycle management by removing aged records based on time-key columns, reducing manual maintenance and optimizing database performance.
- [TimeKeys and Clustering Keys](https://ocient.ferndocs.com/guides/database-administration/schema-design/time-keys-and-clustering-keys.md): Discover how to use time keys, clustering keys, and indexes in Ocient to improve data organization and query performance.
- [Global Dictionary Compression](https://ocient.ferndocs.com/guides/database-administration/schema-design/table-compression-options/global-dictionary-compression.md): Understand global dictionary compression in Ocient, a technique to reduce data redundancy and improve query performance.
- [Load Data](https://ocient.ferndocs.com/guides/load-data.md): Ocient data pipelines enable efficient ETL processes via SQL, supporting real-time transformations and scalable parallel processing. They ensure data deduplication, maintain load positions, and support various sources like S3 and Kafka.
- [Data Formats for Data Pipelines](https://ocient.ferndocs.com/guides/load-data/data-formats-for-data-pipelines.md): Ocient's Data Pipeline functionality optimizes data loading from various formats like JSON and DELIMITED, ensuring strict data interpretation for performance. Learn about transforming data using field selectors and handling NULL values.
- [Data Pipeline Behavior Considerations](https://ocient.ferndocs.com/guides/load-data/data-pipeline-behavior-considerations.md): This pages describes functionality for DDL commands for Ocient Data Pipelines.
- [Data Types for Data Pipelines](https://ocient.ferndocs.com/guides/load-data/data-types-for-data-pipelines.md): This page describes how different data types interact with data pipelines in an Ocient System.
- [Deduplication in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/deduplication-in-data-pipelines.md): Data pipelines ensure that data is loaded exactly once by maintaining a specific load position and enforcing deduplication logic. Pipelines can be stopped, resumed, and updated without duplicating data.
- [Error Tolerance in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/error-tolerance-in-data-pipelines.md): The error limit in SQL statements like `START PIPELINE` dictates how many record-level errors are tolerated before the pipeline fails. If errors exceed this limit, the pipeline enters a `FAILED` status. By default, pipelines allow zero errors.
- [Frequently Asked Questions for Data Pipelines](https://ocient.ferndocs.com/guides/load-data/frequently-asked-questions-for-data-pipelines.md): This page includes various frequently asked questions for the Ocient Data Pipeline functionality.
- [Load Data from External Sources in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/load-data-from-external-sources-in-data-pipelines.md): The Data Pipeline functionality allows you to look up and load data from external sources into the Ocient System. Use the LOOKUP keyword and the LOOKUP function in the CREATE PIPELINE SQL statement to look up data in external source tables.
- [Load Data into Multiple Targets in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/load-data-into-multiple-targets-in-data-pipelines.md): Discover how to efficiently load time-partitioned data into multiple target tables using a data pipeline in the Ocient System from AWS S3 using batch processing.
- [Load Data with a User-Defined Data Pipeline Function](https://ocient.ferndocs.com/guides/load-data/load-data-with-a-user-defined-data-pipeline-function.md): Learn how to load data in the Ocient System using the data pipeline functionality with a user-defined function.
- [Load Geospatial Data in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/load-geospatial-data-in-data-pipelines.md): Data pipeline loading in Ocient supports geospatial data for use with the OcientGeo functionality. It includes functions like `ST_POINT`, `ST_LINESTRING`, and `ST_POLYGON`.
- [Load Metadata and File-Based Partitioned Data in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/load-metadata-and-file-based-partitioned-data-in-data-pipelines.md): The Data Pipeline functionality allows loading metadata values from source records into the Ocient System. Use the `METADATA('<key>')` function in SQL to extract metadata like filenames or creation timestamps.
- [Manage Errors in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/manage-errors-in-data-pipelines.md): This guide illustrates error management during data loading using JSON from Kafka, covering bad data handling, record inspection, pipeline status, and error limit configuration.
- [Monitor Data Pipelines](https://ocient.ferndocs.com/guides/load-data/monitor-data-pipelines.md): Data Pipeline functionality allows for monitoring through system catalog tables, information schema views, and operational metrics endpoints.
- [Transform Data in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/transform-data-in-data-pipelines.md): Data pipeline functionality supports data transformation during loading to efficiently convert and clean source data for your chosen table schema. Use two broad classes of data transformation: source field references or SQL transformation functions.
- [JSON Selectors Examples in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/data-formats-for-data-pipelines/json-selectors-examples-in-data-pipelines.md): Data Pipeline functionality allows loading structured JSON data. It supports scalar and array extraction, handling of NULL values, and complex selectors. Explore loading examples from JSON files, including nested data and arrays.
- [Parquet Selectors Examples in Data Pipelines](https://ocient.ferndocs.com/guides/load-data/data-formats-for-data-pipelines/parquet-selectors-examples-in-data-pipelines.md): Ocient Data Pipelines enable loading data in Parquet format using familiar SQL syntax for selection. Retrieve specific columns based on the Parquet schema. Explore examples and related links for detailed guidance.
- [Data Pipeline Load of CSV Data from S3](https://ocient.ferndocs.com/guides/load-data/load-by-data-source/data-pipeline-load-of-csv-data-from-s-3.md): Ocient data pipelines allow batch loading from AWS S3 using SQL-like syntax for transformations. This guide covers creating a database, table, and pipeline to load CSV data, monitor progress, and manage pipeline execution.
- [Data Pipeline Load of JSON Data from HDFS](https://ocient.ferndocs.com/guides/load-data/load-by-data-source/data-pipeline-load-of-json-data-from-hdfs.md): Unlock seamless data loading from HDFS using a data pipeline into the Ocient System with advanced options. Preview and execute the JSON data load into HDFS, and observe its progress.
- [Data Pipeline Load of JSON Data from Kafka](https://ocient.ferndocs.com/guides/load-data/load-by-data-source/data-pipeline-load-of-json-data-from-kafka.md): Ocient data pipelines enable streaming JSON data from Kafka topics using SQL-like transformations. This guide covers creating a database, table, and pipeline to stream data, monitor progress, and manage pipeline execution with Kafka integration.
- [Data Pipeline Load of Parquet Data from S3](https://ocient.ferndocs.com/guides/load-data/load-by-data-source/data-pipeline-load-of-parquet-data-from-s-3.md): Ocient's Data Pipeline loads time-partitioned Parquet files from AWS S3 into tables using SQL-like transformations. This guide covers database and table creation, pipeline setup, previewing, execution, and monitoring.
- [Data Types for User-Defined Data Pipeline Functions](https://ocient.ferndocs.com/guides/load-data/transform-data-in-data-pipelines/data-types-for-user-defined-data-pipeline-functions.md)
- [Special Data Pipeline Transformation Functions](https://ocient.ferndocs.com/guides/load-data/transform-data-in-data-pipelines/special-data-pipeline-transformation-functions.md): The Data Pipeline functionality allows data transformation during loading using SQL functions like `EXPLODE_OUTER`, which expands arrays into individual rows.
- [Query Ocient](https://ocient.ferndocs.com/guides/query-ocient/query-ocient.md): Master querying techniques in Ocient’s data warehouse, including tips for optimizing performance and handling complex data queries.
- [Functions Overview](https://ocient.ferndocs.com/guides/query-ocient/functions-overview.md): Explore Ocient function library for data analysis, manipulation, and transformations, empowering complex querying and calculations.
- [General SQL Syntax](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax.md): Explore Ocient SQL syntax rules, enabling users to write clear, efficient queries for data retrieval and manipulation at scale.
- [Ocient HTTP Query API](https://ocient.ferndocs.com/guides/query-ocient/ocient-http-query-api.md): The Ocient Hyperscale Data Warehouse™ has the HTTP Query API that enables you to execute SQL statements. The API follows OpenAPI Specification (Swagger®) guidelines.
- [Query Performance Tuning](https://ocient.ferndocs.com/guides/query-ocient/query-performance-tuning.md): The Query Performance Tuning page explains how to optimize query execution in Ocient to achieve low latency and high throughput on large, complex workloads.
- [Quick Start Querying](https://ocient.ferndocs.com/guides/query-ocient/quick-start-querying.md): Get started with querying in Ocient data warehouse, covering the basics of SQL commands and efficient data retrieval practices.
- [Understanding Data Types](https://ocient.ferndocs.com/guides/query-ocient/understanding-data-types.md): Explore the data types supported by Ocient to store and manage diverse data, ensuring efficient storage and retrieval.
- [Generate Tables Using sys.dummy](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/generate-tables-using-sys-dummy.md): Understand how to create sample tables in Ocient with sys.dummy, a helpful tool for testing and learning SQL syntax.
- [Identifiers](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/identifiers.md): Learn about Ocient identifier rules for naming tables, columns, and other SQL elements, ensuring consistency and clarity in database design.
- [Join Operations](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/join-operations.md): Learn how Ocient® optimizes SQL JOIN operations for high-performance queries without manual tuning. Explore join strategies, hash versus product joins, memory considerations, and best practices for efficient query execution.
- [SQL Syntax Conventions](https://ocient.ferndocs.com/guides/query-ocient/general-sql-syntax/sql-syntax-conventions.md): Understand Ocient SQL syntax conventions, helping you structure queries that are both effective and optimized for large datasets.
- [Array, Tuple, and Matrix Overview](https://ocient.ferndocs.com/guides/query-ocient/understanding-data-types/array-tuple-and-matrix-overview.md): Learn how to work with arrays, tuples, and matrices in Ocient, ideal for handling structured and complex data.
- [SQL Reference](https://ocient.ferndocs.com/guides/sql-reference/sql-reference.md): Access Ocient SQL reference guide, covering syntax, commands, and examples for effective querying.
- [Aggregate Functions](https://ocient.ferndocs.com/guides/sql-reference/aggregate-functions.md): Learn about Ocient aggregate functions to perform calculations across sets of data for valuable insights.
- [Alphabetical SQL Functions List](https://ocient.ferndocs.com/guides/sql-reference/alphabetical-sql-functions-list.md): Browse the alphabetical list of SQL functions in Ocient, providing diverse data manipulation and analysis capabilities.
- [Array Functions and Operators](https://ocient.ferndocs.com/guides/sql-reference/array-functions-and-operators.md): Discover functions and operators for handling arrays in Ocient, allowing complex data structuring.
- [Categorized SQL Functions List](https://ocient.ferndocs.com/guides/sql-reference/categorized-sql-functions-list.md): Explore Ocient categorized list of SQL functions for efficient data manipulation and analysis.
- [Character and Binary Functions](https://ocient.ferndocs.com/guides/sql-reference/character-and-binary-functions.md): Utilize character and binary functions in Ocient for advanced text and binary data manipulation.
- [Data Control Language (DCL) Statement Reference](https://ocient.ferndocs.com/guides/sql-reference/data-control-language-dcl-statement-reference.md): Reference DCL commands in Ocient to manage permissions and security within the data warehouse.
- [Data Definition Language (DDL) Statement Reference](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference.md): Access Data Definition Language command reference for creating and managing database structures.
- [Data Types](https://ocient.ferndocs.com/guides/sql-reference/data-types.md): Review the various data types available in Ocient, optimized for efficient storage and retrieval.
- [Date and Time Functions](https://ocient.ferndocs.com/guides/sql-reference/date-and-time-functions.md): Explore date and time functions in Ocient, essential for managing temporal data in analytics.
- [Errors and Warnings](https://ocient.ferndocs.com/guides/sql-reference/errors-and-warnings.md): Learn about handling errors and warnings in Ocient to maintain smooth system operations.
- [Formatting Functions](https://ocient.ferndocs.com/guides/sql-reference/formatting-functions.md): Learn about formatting functions in Ocient to standardize and format data outputs.
- [Geospatial Functions](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions.md): Discover geospatial functions in Ocient with OcientGeo, designed for handling and analyzing geographic data.
- [HyperLogLog Functions](https://ocient.ferndocs.com/guides/sql-reference/hyper-log-log-functions.md): Use HyperLogLog functions in Ocient for fast and approximate distinct counting in large datasets.
- [Machine Learning Model Functions](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions.md): Implement machine learning model functions in Ocient with OcientML for advanced predictive and analytical capabilities.
- [Math Functions and Operators](https://ocient.ferndocs.com/guides/sql-reference/math-functions-and-operators.md): Access math functions and operators in Ocient for comprehensive numerical analysis and calculations.
- [Matrix Functions and Operators](https://ocient.ferndocs.com/guides/sql-reference/matrix-functions-and-operators.md): Use matrix functions in Ocient to handle and analyze multi-dimensional data efficiently.
- [Network Type Functions](https://ocient.ferndocs.com/guides/sql-reference/network-type-functions.md): Manage and analyze network data using network type functions in Ocient.
- [Other Functions and Expressions](https://ocient.ferndocs.com/guides/sql-reference/other-functions-and-expressions.md): Access other functions and expressions for diverse data processing and analysis.
- [Reserved Words](https://ocient.ferndocs.com/guides/sql-reference/reserved-words.md)
- [Scalar Data Conversion Functions](https://ocient.ferndocs.com/guides/sql-reference/scalar-data-conversion-functions.md): Convert scalar data types with Ocient’s conversion functions for seamless data compatibility.
- [Sorted Aggregate Functions](https://ocient.ferndocs.com/guides/sql-reference/sorted-aggregate-functions.md): Learn about sorted aggregate functions in Ocient for ordered data analysis.
- [System Catalog Reference](https://ocient.ferndocs.com/guides/sql-reference/system-catalog-reference.md): Explore Ocient’s system catalog reference for metadata and schema management.
- [Time Zone Functions](https://ocient.ferndocs.com/guides/sql-reference/time-zone-functions.md): Utilize time zone functions in Ocient to handle global data and time zone adjustments accurately.
- [Tuple Functions and Operators](https://ocient.ferndocs.com/guides/sql-reference/tuple-functions-and-operators.md): Explore tuple functions in Ocient, enabling complex data structuring and retrieval.
- [Window Aggregate Functions](https://ocient.ferndocs.com/guides/sql-reference/window-aggregate-functions.md): Use window aggregate functions in Ocient for running calculations across partitions of data.
- [Cluster and Node Management](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/cluster-and-node-management.md): Discover cluster and node management practices in Ocient for system scalability and reliability.
- [Data Integrity and Storage](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/data-integrity-and-storage.md): Maintain data integrity and optimize storage in Ocient, designed for large-scale data environments.
- [Data Pipelines](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/data-pipelines.md): This pages describes functionality for DDL commands for Ocient Data Pipelines.
- [Databases](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/databases.md): Learn about the SQL syntaxes for managing databases in Ocient for efficient data organization.
- [Distributed Tasks](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/distributed-tasks.md): Ensure data integrity and performance with rebuild tasks and data checks in Ocient.
- [Indexes](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/indexes.md): Learn about the SQL syntaxes for managing indexes in Ocient for efficient data organization.
- [Machine Learning Models](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/machine-learning-models.md)
- [Query Analysis](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/query-analysis.md): Perform query analysis in Ocient to optimize performance and understand data patterns.
- [Query Management](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/query-management.md): The Query Management page explains how to monitor, control, and optimize queries running in Ocient.
- [Schemas](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/schemas.md): Learn about the SQL syntaxes for managing schemas in Ocient for efficient data organization.
- [Statistics Cache Management](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/statistics-cache-management.md): Manage cache and statistics in Ocient for improved query performance and system insights.
- [Tables](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/tables.md): Learn about the SQL syntaxes for managing tables in Ocient for efficient data organization.
- [Users, Groups, and Service Classes](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/users-groups-and-service-classes.md): Manage users, groups, and service classes in Ocient for secure access control and resource management.
- [Views](https://ocient.ferndocs.com/guides/sql-reference/data-definition-language-ddl-statement-reference/views.md): Learn about the SQL syntaxes for managing views in Ocient for efficient data organization.
- [Data Pipeline Loading Errors](https://ocient.ferndocs.com/guides/sql-reference/errors-and-warnings/data-pipeline-loading-errors.md): This resource outlines various error codes and their corresponding messages that users may encounter while loading data through data pipelines. It includes detailed descriptions of each error, the parameters involved, and recommended resolutions.
- [Attribute Functions](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/attribute-functions.md): Use attribute functions in OcientGeo to manage and analyze geospatial data entries.
- [Conversion Functions](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/conversion-functions.md): Apply data conversion functions in OcientGeo to transform geospatial data types and formats for analysis compatibility.
- [Linestring Constructors](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/linestring-constructors.md): Create and manage linestrings in OcientGeo, suitable for spatial data representation and analysis.
- [Linestring Functions](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/linestring-functions.md): Access linestring functions in OcientGeo to manipulate and analyze linear spatial data.
- [Point Constructors](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/point-constructors.md): Create points in OcientGeo, fundamental for spatial data analysis and visualization.
- [Polygon Constructors](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/polygon-constructors.md): Construct and manage polygons in OcientGeo, suitable for representing complex spatial regions.
- [Spatial Measurement](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/spatial-measurement.md): Use spatial measurement functions in OcientGeo to calculate distances, areas, and more in spatial datasets.
- [Spatial Operators](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/spatial-operators.md): Learn about spatial operators in OcientGeo, designed to manipulate and analyze geographic data efficiently.
- [Spatial Relationships](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/spatial-relationships.md): Explore spatial relationship functions in OcientGeo to determine interactions between geographic entities.
- [Spatiotemporal Measurement](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/spatiotemporal-measurement.md): Utilize spatiotemporal measurement functions in OcientGeo for comprehensive analysis of space-time data.
- [Spatiotemporal Operators](https://ocient.ferndocs.com/guides/sql-reference/geospatial-functions/spatiotemporal-operators.md): Discover spatiotemporal operators in OcientGeo to analyze data with both spatial and temporal dimensions.
- [Classification Models](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions/classification-models.md): Use classification models in Ocient with OcientML to categorize data, aiding decision-making and pattern recognition.
- [Clustering and Dimension Reduction Models](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions/clustering-and-dimension-reduction-models.md): Discover clustering and dimension reduction models in Ocient with OcientML for data grouping and simplification.
- [Data Preparation](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions/data-preparation.md): Discover Ocient® SQL functions for time series data preparation. Use lag generators and vector assemblers to simplify feature engineering, reduce boilerplate code, and create inputs for regression, VAR, and neural network models.
- [Other Models](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions/other-models.md): Explore various data models in Ocient with OcientML for diverse analysis requirements, from basic to complex.
- [Regression Models](https://ocient.ferndocs.com/guides/sql-reference/machine-learning-model-functions/regression-models.md): Apply regression models in Ocient with OcientML to predict outcomes based on data trends and relationships.
- [Discover Insights From System Catalog Tables](https://ocient.ferndocs.com/guides/sql-reference/system-catalog-reference/discover-insights-from-system-catalog-tables.md): This page describes various useful queries used on the system catalog tables to track important metrics such as storage use, node status, running queries, and segment sizes.
- [Information Schema](https://ocient.ferndocs.com/guides/sql-reference/system-catalog-reference/information-schema.md)
- [System Catalog](https://ocient.ferndocs.com/guides/sql-reference/system-catalog-reference/system-catalog.md)
- [Connection Driver Reference](https://ocient.ferndocs.com/guides/connection-driver-reference/connection-driver-reference.md): Reference Ocient connection drivers for seamless integration and database access.
- [JDBC Manual](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual.md): Access Ocient JDBC manual for guidelines on connecting and managing data through Java-based applications.
- [Ocient Python Module: pyocient](https://ocient.ferndocs.com/guides/connection-driver-reference/ocient-python-module-pyocient.md): Use Ocient Pyocient module to interface with the database using Python for data manipulation and analysis.
- [Commands Supported by the Ocient JDBC CLI Program](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual/commands-supported-by-the-ocient-jdbc-cli-program.md): Explore the commands supported by Ocient JDBC CLI program for streamlined data interaction.
- [Data Extract Tool](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual/data-extract-tool.md): Learn how to efficiently extract data from Ocient using the JDBC driver with this comprehensive manual.
- [JDBC Classes and Methods](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual/jdbc-classes-and-methods.md): Review the list of JDBC classes and methods supported by Ocient for optimal database management.
- [JDBC Spark Connector](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual/jdbc-spark-connector.md): The Spark Connector enables seamless, high‑performance integration between Apache Spark and your data platform, allowing you to run scalable analytics on large datasets with minimal overhead.
- [OCGraph Java Library](https://ocient.ferndocs.com/guides/connection-driver-reference/jdbc-manual/oc-graph-java-library.md): OCGraph Java is a comprehensive, SQL‑native graph analytics toolkit for Ocient that lets you model, transform, and analyze large graphs directly in the database. This guide covers end‑to‑end capabilities including subgraph extraction, edge/vertex filterin
- [OCGraph Python Library](https://ocient.ferndocs.com/guides/connection-driver-reference/ocient-python-module-pyocient/oc-graph-python-library.md): OCGraph Python provides a high‑level, SQL‑native interface to perform graph analytics on Ocient using a familiar Python workflow. This guide documents every function with concise syntax blocks, complete parameter tables, and copy‑ready examples. Build and
- [Machine Learning in Ocient](https://ocient.ferndocs.com/guides/analysis-in-ocient/machine-learning-in-ocient.md): Integrate machine learning models into Ocient queries with OcientML for advanced data analysis, empowering predictive and classification insights.
- [Text Analysis in Database Queries](https://ocient.ferndocs.com/guides/analysis-in-ocient/text-analysis-in-database-queries.md): Utilize Ocient text analysis functions for effective querying and manipulation of textual data, essential for data insights.
- [Classification Analysis](https://ocient.ferndocs.com/guides/analysis-in-ocient/machine-learning-in-ocient/classification-analysis.md): Use classification analysis techniques within Ocient with OcientML to categorize data, helping in decision-making and pattern identification.
- [Clustering Analysis and Dimensionality Reduction](https://ocient.ferndocs.com/guides/analysis-in-ocient/machine-learning-in-ocient/clustering-analysis-and-dimensionality-reduction.md): Discover clustering and dimensionality reduction methods in Ocient with OcientML for grouping data and simplifying analysis.
- [Regression Analysis](https://ocient.ferndocs.com/guides/analysis-in-ocient/machine-learning-in-ocient/regression-analysis.md): Apply regression analysis within Ocient with OcientML to understand relationships in data and make predictions based on historical trends.
- [System Administration](https://ocient.ferndocs.com/guides/system-administration/system-administration.md): This page provides guidance on installing and maintaining the Ocient System, covering hardware/software requirements and ongoing maintenance tasks. It includes tutorials for installation, managing system performance, monitoring, and system configuration.
- [Air-Gapped Environment with an Ocient System](https://ocient.ferndocs.com/guides/system-administration/air-gapped-environment-with-an-ocient-system.md): An air gap is a security measure that physically isolates a computer or network from all external connections to protect sensitive data used by governments and other critical infrastructure operators. Ocient supports this without special configuration.
- [Amazon Web Services Ocient Installation](https://ocient.ferndocs.com/guides/system-administration/amazon-web-services-ocient-installation.md): Set up an Ocient system on AWS, utilizing cloud infrastructure for scalable and efficient data warehousing.
- [Configure Storage Spaces](https://ocient.ferndocs.com/guides/system-administration/configure-storage-spaces.md)
- [Install an Ocient System](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system.md): Follow this guide to install an Ocient system, covering the setup steps needed for deploying high-performance data warehousing.
- [Maintenance Overview](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview.md): Learn about regular maintenance procedures for Ocient, ensuring system stability and longevity.
- [Multiple Storage Clusters for Loading Data](https://ocient.ferndocs.com/guides/system-administration/multiple-storage-clusters-for-loading-data.md): Set up multiple storage clusters for efficient data loading in Ocient, enabling high-speed data handling.
- [Ocient Software Upgrade](https://ocient.ferndocs.com/guides/system-administration/ocient-software-upgrade.md): Follow best practices for upgrading Ocient software, ensuring minimal disruption and maximum performance.
- [Secure Connections Using TLS](https://ocient.ferndocs.com/guides/system-administration/secure-connections-using-tls.md): Implement TLS for secure connections in Ocient, safeguarding data from unauthorized access.
- [Installation Reference](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference.md): Access a detailed reference for installing Ocient, covering all necessary configurations and setup options.
- [Ocient Application Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-application-configuration.md): Configure the Ocient application for optimized performance, with settings tailored to your specific data and operational needs.
- [Ocient Application Installation](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-application-installation.md): Learn about installing the Ocient application, ensuring a smooth deployment for high-speed data processing.
- [Ocient System Bootstrapping](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/ocient-system-bootstrapping.md): Discover the steps required to bootstrap an Ocient system, ensuring it is correctly initialized for large-scale data handling.
- [Checking System After Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/checking-system-after-configuration.md): Verify your system setup post-configuration to confirm that Ocient operates correctly and meets performance benchmarks.
- [Checking System Configuration Before Bootstrapping](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/checking-system-configuration-before-bootstrapping.md): Ensure your system is configured correctly before bootstrapping Ocient, reducing errors and enhancing stability.
- [Node Bootstrapping Reference](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/node-bootstrapping-reference.md): Access reference documentation for bootstrapping individual nodes in an Ocient system, optimizing for scalability and reliability.
- [Ocient System Hardware Specifications](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-hardware-specifications.md): The Ocient System can run on Ocient-branded hardware or suitable generic hardware. It consists of Foundation Nodes, Loader Nodes, and SQL Nodes, each with specific components and performance specs.
- [Ocient System Requirements](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-requirements.md): Review the hardware and software requirements needed to run an Ocient system, ensuring compatibility and performance.
- [Ocient System Sizing](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/ocient-system-sizing.md): To size your Ocient System for data and query needs, gather the uncompressed size of your data and consider its format and compression. Calculate data loading rates, transformation levels, and query types.
- [Operating System Configuration](https://ocient.ferndocs.com/guides/system-administration/install-an-ocient-system/installation-reference/operating-system-configuration.md): Learn about configuring your operating system to optimize performance and compatibility with Ocient.
- [Alter Default Data Pipeline Behavior](https://ocient.ferndocs.com/guides/system-administration/loading-administration/alter-default-data-pipeline-behavior.md): Data Administrators for an Ocient System can configure parameters using the `ALTER SYSTEM ALTER CONFIG` SQL command to adjust pipeline behavior. Key parameters include execution time, partition counts, and type inference.
- [Configuration Settings for Data Pipelines](https://ocient.ferndocs.com/guides/system-administration/loading-administration/configuration-settings-for-data-pipelines.md)
- [Configure Data Pipeline Logging](https://ocient.ferndocs.com/guides/system-administration/loading-administration/configure-data-pipeline-logging.md): To troubleshoot Ocient data pipelines, log levels can be adjusted using SQL commands, impacting performance. Set the log level using `ALTER SYSTEM ALTER LOG LEVEL SET`, then configure specific logging parameters.
- [Backup and Restore](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/backup-and-restore.md): Discover Ocient backup and restore methods to secure your data and facilitate disaster recovery.
- [Expand and Rebalance System](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/expand-and-rebalance-system.md): Discover how to expand and rebalance an Ocient system to accommodate growing data demands while maintaining performance.
- [Guide to Rebuilding Segments](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/guide-to-rebuilding-segments.md): Discover methods for rebuilding segments in Ocient, maintaining data integrity and system performance.
- [Power Safety Recommendations](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/power-safety-recommendations.md): Follow Ocient power safety guidelines to protect your system from data loss and damage due to power fluctuation.
- [Replace Nodes](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/replace-nodes.md): Learn the procedure for replacing nodes in an Ocient system, ensuring minimal disruption and optimal system performance.
- [Startup and Shutdown Procedure](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/startup-and-shutdown-procedure.md): Learn the proper steps for starting and shutting down an Ocient system, safeguarding data and operational integrity.
- [NVMe Drive Firmware Upgrade Process](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/nv-me-drive-maintenance/nv-me-drive-firmware-upgrade-process.md): Upgrade NVMe drive firmware in Ocient, enhancing system stability and performance.
- [Replace an NVMe Node Drive](https://ocient.ferndocs.com/guides/system-administration/maintenance-overview/nv-me-drive-maintenance/replace-an-nv-me-node-drive.md): Learn the procedure for replacing NVMe drives in an Ocient node, ensuring data redundancy and fault tolerance.
- [Log Monitoring](https://ocient.ferndocs.com/guides/system-administration/monitoring/log-monitoring.md): Understand how to monitor errors in Ocient to maintain system health and prevent issues.
- [Monitor Segment Group Transfers](https://ocient.ferndocs.com/guides/system-administration/monitoring/monitor-segment-group-transfers.md): Learn to monitor segment group transfers in Ocient, ensuring data is transferred efficiently and accurately.
- [Set Up System Monitoring with the TIG Stack and Kapacitor](https://ocient.ferndocs.com/guides/system-administration/monitoring/set-up-system-monitoring-with-the-tig-stack-and-kapacitor.md): Set up system monitoring in Ocient using the TIG stack and Kapacitor, providing comprehensive insights into system performance.
- [Statistics Monitoring](https://ocient.ferndocs.com/guides/system-administration/monitoring/statistics-monitoring.md): Track and analyze key performance metrics within Ocient to ensure optimal database operation.
- [System Information REST Endpoints](https://ocient.ferndocs.com/guides/system-administration/monitoring/system-information-rest-endpoints.md): Access system information in Ocient through REST endpoints, ideal for monitoring and automation.
- [Inspect the Current Configuration](https://ocient.ferndocs.com/guides/system-administration/system-configuration/inspect-the-current-configuration.md): Review and verify the configuration of your Ocient system for optimal operation and performance.
- [Manage the Network Configuration of an Ocient System](https://ocient.ferndocs.com/guides/system-administration/system-configuration/manage-the-network-configuration-of-an-ocient-system.md): Configure network settings for your Ocient system, optimizing for connectivity and performance.
- [Node Configuration with the Administrator Role](https://ocient.ferndocs.com/guides/system-administration/system-configuration/node-configuration-with-the-administrator-role.md): Understand the key design considerations for deploying Ocient, ensuring scalability and efficiency.
- [Ingest Data with Legacy LAT Reference](https://ocient.ferndocs.com/guides/lat-reference/ingest-data-with-legacy-lat-reference.md): Explore methods for efficiently loading large datasets into Ocient, optimized for performance and designed for massive-scale data warehousing.
- [LAT Advanced Topics](https://ocient.ferndocs.com/guides/lat-reference/lat-advanced-topics.md): Learn about dynamic schema changes and error management in the Ocient loading and transformation (LAT) system.
- [LAT Client Command Line Interface](https://ocient.ferndocs.com/guides/lat-reference/lat-client-command-line-interface.md): Learn how to easily install and utilize the LAT Client tool for efficient pipeline creation and management.
- [LAT Data Transformation with JMESPath](https://ocient.ferndocs.com/guides/lat-reference/lat-data-transformation-with-jmes-path.md): Utilize JMESPath for powerful data transformation within Ocient, enabling flexible data manipulation.
- [LAT Data Types in Loading](https://ocient.ferndocs.com/guides/lat-reference/lat-data-types-in-loading.md): Discover the supported data types in Ocient for efficient loading and storage optimization.
- [LAT Log4J Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-log-4-j-configuration.md): Configure Log4j in Ocient to manage log output and enhance system debugging capabilities.
- [LAT Metrics](https://ocient.ferndocs.com/guides/lat-reference/lat-metrics.md): Track and analyze performance metrics in Ocient for comprehensive system monitoring.
- [LAT Overview](https://ocient.ferndocs.com/guides/lat-reference/lat-overview.md): Learn about the Loading and Transformation system (LAT) in Ocient, essential for creating pipelines from data sources.
- [LAT Packaging and Installation](https://ocient.ferndocs.com/guides/lat-reference/lat-packaging-and-installation.md): Learn about the different deployment and installation options for Ocient LAT software.
- [LAT Pipeline Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-pipeline-configuration.md): Set up and manage data pipelines in Ocient for seamless data processing and integration.
- [LAT Service Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-service-configuration.md): Configure Ocient services for optimal performance and tailored resource management.
- [LAT Advanced Loading and Transformations](https://ocient.ferndocs.com/guides/lat-reference/ingest-data-with-legacy-lat-reference/lat-advanced-loading-and-transformations.md): Enhance your data loading processes with advanced transformations in Ocient, tailored for complex data requirements and optimized performance.
- [LAT Load CSV Data from S3](https://ocient.ferndocs.com/guides/lat-reference/ingest-data-with-legacy-lat-reference/loading-by-data-source/lat-load-csv-data-from-s-3.md): Learn to load CSV data from Amazon S3 directly into Ocient’s high-performance data warehouse, ensuring smooth and scalable data integration.
- [LAT Load JSON Data from Kafka](https://ocient.ferndocs.com/guides/lat-reference/ingest-data-with-legacy-lat-reference/loading-by-data-source/lat-load-json-data-from-kafka.md): Discover how to ingest JSON data from Kafka into Ocient’s data warehouse, streamlining real-time analytics and data processing.
- [LAT Load JSON Data from S3](https://ocient.ferndocs.com/guides/lat-reference/ingest-data-with-legacy-lat-reference/loading-by-data-source/lat-load-json-data-from-s-3.md): Integrate JSON data from Amazon S3 into Ocient for advanced analytics, designed for high-throughput and efficient processing of large datasets.
- [Install LAT Client in a Disconnected Network](https://ocient.ferndocs.com/guides/lat-reference/lat-client-command-line-interface/install-lat-client-in-a-disconnected-network.md): Set up the LAT client in a network-isolated environment within Ocient.
- [LAT Record Filtering](https://ocient.ferndocs.com/guides/lat-reference/lat-data-transformation-with-jmes-path/lat-record-filtering.md): Implement record filtering in Ocient to manage and streamline data retrieval processes.
- [LAT Transformation Functions](https://ocient.ferndocs.com/guides/lat-reference/lat-data-transformation-with-jmes-path/lat-transformation-functions.md): Explore data transformation functions in Ocient, allowing for extensive data customization.
- [LAT User-Defined Transformations](https://ocient.ferndocs.com/guides/lat-reference/lat-data-transformation-with-jmes-path/lat-user-defined-transformations.md): Create custom transformations in Ocient, tailored to specific data processing needs.
- [LAT Extract Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-pipeline-configuration/lat-extract-configuration.md): Learn about configuring data extraction processes in Ocient for efficient and reliable data retrieval.
- [LAT Sink Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-pipeline-configuration/lat-sink-configuration.md): Set up data sinks in Ocient for effective data storage and processing endpoints.
- [LAT Source Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-pipeline-configuration/lat-source-configuration.md): Configure data sources in Ocient, preparing for high-volume and complex data loading tasks.
- [LAT Transform Configuration](https://ocient.ferndocs.com/guides/lat-reference/lat-pipeline-configuration/lat-transform-configuration.md): Configure data transformation steps in Ocient for customized data processing pipelines.
- [Release Notes](https://ocient.ferndocs.com/guides/release-notes/release-notes.md): Access the latest release notes for Ocient, detailing new features, improvements, and bug fixes.
- [JDBC Release Notes](https://ocient.ferndocs.com/guides/release-notes/jdbc-release-notes.md): View release notes for Ocient JDBC component, including updates and compatibility changes.
- [Ocient Hyperscale Data Warehouse Release Notes](https://ocient.ferndocs.com/guides/release-notes/ocient-hyperscale-data-warehouse-release-notes.md): Review release notes specific to Ocient hyperscale data warehouse, showcasing major updates.
- [pyocient Release Notes](https://ocient.ferndocs.com/guides/release-notes/pyocient-release-notes.md): Access release notes for Pyocient, the Ocient Python module, with details on new features and improvements.
- [Ocient Simulator](https://ocient.ferndocs.com/guides/ocient-simulator.md): Discover how to use the Ocient simulator for testing and validating queries before deploying in production.
- [Version Compatibility](https://ocient.ferndocs.com/guides/version-compatibility.md): Check version compatibility requirements in Ocient for a smooth upgrade and deployment experience.
- [Glossary](https://ocient.ferndocs.com/guides/glossary.md): Glossary of acronyms and terms used in the Ocient System or the Ocient Hyperscale Data Warehouse.
- [Open Source Acknowledgements](https://ocient.ferndocs.com/guides/open-source-acknowledgements.md)