LogoLogo
codatum.comSign InStart for free
  • Introduction
  • Getting Started
    • Quick Start
    • Concept (Further reading)
      • Why did we a choose Block Editor over Cell-based Editor?
  • Connect and Manage Data
    • Connection
      • Sync Table Metadata
    • Supported Warehouses
      • BigQuery
      • Snowflake
      • Other Warehouses
    • Catalog
    • Search
  • Data Exploration
    • Data Exploration Overview
    • Notebook
      • Doc Page
      • Grid Page
      • SQL Block
      • Version
      • Notebook FAQ
    • Chart
    • Explorer
    • Parameter
    • (Appendix) Cache
  • AI Assist
    • SQL Assistant
  • Sharing
    • Sharing Overview
    • Teamspace
    • Shared Notebook
    • Report
    • Public Link
    • Signed Embed
      • How to Set Up Signed Embed
  • Account Management
    • Account
    • Account Settings
  • Workspace & User Management
    • Workspace
  • User Management
    • Invitation
    • Group
  • Security
    • Security Overview
  • Audit logs
  • IP Access Control
  • Access control
    • Access Control Overview
    • Access Control for Workspace
    • Access Control for Resources
      • Access Control for Group
      • Access Control for Teamspace
      • Access Control for Notebook
      • Access Control for Connection
      • Access Control for Report
  • [Under Construction] Plan and Billing
    • Limit and usage
    • Downgrade and cancel
  • Best Practices
    • Advanced Control Structures in SQL
  • Other considerations
    • System requirements
Powered by GitBook

Reference

  • Privacy policy
  • Terms of service
  • JP Docs Site
On this page
  • Key Features
  • How to Use

Was this helpful?

  1. Data Exploration
  2. Notebook

SQL Block

Professional SQL Editor with Powerful Support in Codatum.

PreviousGrid PageNextVersion

Last updated 7 months ago

Was this helpful?

SQL Block is a block within the Notebook that allows executing SQL.

Within the SQL Block, you can edit and run queries, display the results, view statistical information, and create charts.

Key Features

  • Professional SQL Editor with Powerful Support:

    • Includes features like function and reserved word suggestions, auto-completion, syntax highlighting, and formatting.

  • Instant Result Preview:

    • Execute queries and preview results in real-time using Ctrl + Return.

  • Table Search:

    • Use the / command within SQL blocks to search for tables within datasets and their connections. You can also search by metadata and field names in the catalog.

  • Code Snippets:

    • Create code snippets for personal use or share them across the workspace. Customize settings like triggers and cursor positions after completion.

  • Rich Shortcut Keys:

    • Utilize a various shortcut keys, which can also be customized for personal use.

  • SQL Chain

    • Reference other SQL Blocks within an SQL Block. This helps manage complex SQL by breaking it down into more understandable and reusable components.

  • Field Stats:

    • Easily retrieve statistical information for each field, such as data type, presence of null values, unique count, average value, quantile, frequency, and histogram.

How to Use

  • Creating an SQL Block:

    • While focused on an empty paragraph in a Doc Page, use the slash command (/) to select and create an SQL Block.

  • Creating References:

    • Within the SQL Block, you can use the slash command to create references to other SQL Blocks and tables.

    • You can also create references to Parameters and Saved queries.