Data Resource - Sql Table

Undraw Environment

About

A table is a content resource located in a database.

Data URI

The data URI for SQL table looks like:

  • fully qualified
catalog.schema.table@connection
  • with the default catalog of the connection
schema.table@connection
  • with the default catalog and schema of the connection
table@connection

Note:

  • connection is a connection name
  • schema is a schema name. If not present, it will default to the default connection schema
  • table is a table name



Related HowTo
Undraw Environment
How to copy the data definition of all tables from a star/snowflake schema

This howto will show you how to copy the data definition of all SQL tables from a star/snowflake schema.
Undraw Environment
How to create a table from the definition of another SQL table

This Howto will show you how to copy the data definition of a SQL table from another SQL table
Undraw Environment
How to create a table with a CREATE Sql statement file

This Howto will show you how to create a SQL table with a SQL file that contains a ''CREATE'' SQL statement
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 list SQL Tables

This howto will show you how to list SQL Tables
Undraw Environment
How to load a CSV file into a SQL table

How to upload a CSV file into a SQL table in two steps
Undraw Environment
How to load a JSON documents in a database

This howto will show you how to load json document (files) into your relational database.
Undraw Environment
How to load your database with the TPCDS benchmark

This howto will show you how to load a relational database schema in order to create a benchmark with the data query command
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
How to use a data generator in a data operation

This how-to shows you how to use a data generator as data source

Task Runner