SQL Block

Professional SQL Editor with Powerful Support in Codatum.

SQL Block is a block within the Notebook that allows for the execution of 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 variety of 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.