Data Resource - Sql Schema

Undraw Environment

About

A schema is a data resource of a database that contains one or more Sql Object such as tables or view

URI

The Data URI that defines a schema has the following form:

# Fully Qualified
catalog.schema.@connection
# With the catalog of the connection if any
schema.@connection
# The default schema of the connection
@connection

where:

  • connection is the connection name
  • schema is the schema name
  • catalog is the catalog name

It has the same form as a SQL path form where the object name is the empty string.

How to see the default schema of a connection ?

You can see the default schema of your connection with the connection info command.

This is the value set in the working path

tabli connection info sqlite

Sample

See Tabulify - Sample Schema




Related HowTo
Undraw Environment
How to fill a database relational schema with generated data and tabli

This how-to will show you how to use the tabli fill command to fill all the tables of a schema with generated data.
Undraw Environment
How to select data resources with a Glob Pattern

With this howto, you will learn what a glob pattern is and how to use it to select data resources.
Undraw Environment
Learning Tabulify - Step 2 - What's a Data Resource ?

The first job of a data processing platform such as Tabulify is to work with data. Tabulify calls, locates and knows all data uniformly under the term Data Resource. A file is a data resource A directory...

Task Runner