DOCSEARCHbyAlgolia
Submit Docs

Enso Documentation

website·Indexed 33 days ago

https://help.enso.org

Technical documentation for the Enso platform, featuring a comprehensive API reference for the Standard library. Includes guides on data preparation, regular expressions, and integration with DuckDB, Azure, and HTTP requests, as well as migration resources for Alteryx users.

Tokens
192K
Snippets
1.1K
Records
2.2K
Agent score
62%

What's inside Enso

  1. Overview of Enso data connection components

    Enso provides several components to import data from files, databases, and web services into workflows:

    • Data.read: Reads data from a file or URI.
    • Data.list_directory: Lists files within a directory.
    • Data.fetch: Fetches data from a web-based resource.
    • Database.connect: Establishes a connection to a database.
    • S3.list_objects: Lists objects stored in an S3 bucket.

  2. Overview of Enso Analytics capabilities

    Enso Analytics is a self-service data preparation and analysis platform for data teams. Its core capabilities include:

    • Data Preparation: Components to clean, transform, and blend structured and unstructured data from various sources.
    • Data Analysis: Tools to derive insights and perform complex analyses without requiring extensive programming knowledge.
    • Workflow and Asset Cataloging: A centralized repository for discovering, reusing, and managing data processes and assets across an organization.
    • Deployment Automation: Ability to schedule executions of data workflows to ensure automatic and consistent processing.

  3. Overview of Enso Analytics capabilities

    Enso Analytics is a self-service data preparation and analysis platform for data teams. Its core capabilities include:

    • Data Preparation: Components for cleaning, transforming, and blending structured and unstructured data.
    • Data Analysis: Tools to derive insights and perform complex analyses without requiring extensive programming knowledge.
    • Workflow and Asset Cataloging: A centralized repository for discovering, reusing, and managing data processes and assets across an organization.
    • Deployment Automation: Ability to schedule executions of data workflows to ensure consistent, automatic processing and reduced manual intervention.

  4. Overview of Enso expression syntax

    Enso's expression syntax is used for data manipulation in components such as set, filter, and aggregate. It is designed to be similar to SQL Server and Excel table functions. Key characteristics include:

    • Whitespace is ignored.
    • Identifiers are case-insensitive, except for column names.
    • Functions are invoked with parentheses, and the first argument is typically the column to operate on.
    • Some functions (e.g., coalesce, is_in) support a variable number of arguments.
    • Comments are not supported in version 1.

  5. Understand Enso Regular Expression standards and options

    Enso's regular expression support is based on the ECMAScript standard. The following options are always enabled by default:

    • u (Unicode): Treats the pattern as a sequence of Unicode code points.
    • g (Global): Matches all occurrences of the pattern in the input string.
    • s (Single Line): The dot (.) matches all characters, including line terminators.

    Additionally, the i (Case Insensitive) option can be enabled if specified. Other options are not supported.

  6. Meet system requirements for Enso on Linux

    To run Enso on Linux, the system must meet the following specifications:

    • Supported Distributions: Ubuntu LTS (Long-Term Support) or Red Hat Enterprise Linux (RHEL)
    • Architecture: x64 (64-bit)
    • Memory: Minimum 16 GB RAM
    • Processor: Intel Core i7 or Ryzen 7 (e.g., Ryzen 7 7745HX or Intel Core i7-13700H released 2023+)
    • Storage: SSD required; minimum 50 GB free space recommended for the application and temporary files.

  7. Meet system requirements for Enso on Windows

    To run Enso on Windows, the system must meet the following specifications:

    • Operating System: Windows 10 (64-bit) or Windows 11 (64-bit)
    • Architecture: x64 (64-bit)
    • Memory: Minimum 16 GB RAM
    • Processor: Intel Core i7 or Ryzen 7 (e.g., Ryzen 7 7745HX or Intel Core i7-13700H released 2023+)
    • Storage: SSD required; minimum 50 GB free space recommended for the application and temporary files.

  8. Integrate with Snowflake using Standard.Snowflake

    The Standard.Snowflake library provides specialized support for the Snowflake cloud data warehouse. It extends general database functionality with tailored methods for Snowflake's architecture, including secure account connections and warehouse management. The key type is Snowflake_Connection, which is optimized for query execution and schema navigation.

  9. Enso Data Pipeline Execution Environments

    Enso allows users to build data pipelines on a desktop and deploy them to the cloud. The platform supports running components either in-memory or directly within a database, using the same set of components regardless of the execution environment.

  10. Extract column metadata and counts

    Functions for calculating statistics and metadata about a column's contents.
    count([Column])           // Count non-null values
count_nothing([Column])   // Count null values
length([Column])           // Total row count
duplicate_count([Column])  // Count duplicates prior to current row

  11. Handle Structured and Unstructured Data in Enso

    Enso provides the capability to work with both tabular (structured) and unstructured data. Users can reshape both data types and perform join operations to combine them within the pipeline.

  12. Understand Enso platform capabilities and constraints

    Enso is a data preparation platform that provides a unified experience across desktop and cloud environments.

    Key Features:

    • Unified Workflows: 100% compatible workflows between desktop and cloud; the same components are used for both in-memory and in-database processing.
    • Code-Based: Workflows are code-based and compatible with GitHub.
    • Documentation: Supports WYSIWYG Markdown for embedded workflow documentation.
    • Data Lineage: The data catalog provides automatic lineage tracing and infers data schemas to simplify switching between data origins and destinations.
    • Execution: Features continuous workflow execution rather than a traditional synchronous 'Run' button.

    Differences from Alteryx:

    • Enso does not use a separate configuration panel or tool-pallet; configuration is displayed directly on the canvas within the Graph Editor.