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 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 10 - How to compare data resources ?

Data comparison is the corner stone of every development because it validates the data processing. Tabulify ships with a Data comparison operation that allows you to compare: the data content and...
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...
Undraw Environment
Learning Tabulify - Step 4 - How to select Data Resources

To select a data resources such as a file or a database table, Tabulify uses the concept of: and dependency (Do we select also the dependent data resources) This page goes through this concepts...
Undraw Environment
Learning Tabulify - Step 6 - How to transfer Data Resources

In Tabulify, when you want to manipulate data, it's called a transfer. You want to move data, you transfer You want to copy data, you transfer You want to insert data, you transfer You want to...
Undraw Environment
Learning Tabulify - Step 7 - How to execute a Query

For Tabulify, a query is a script that when executed returns a content resource. In the case of a Sql Query (ie a SELECT statement), the result is a data set in tabular format. The selector of a query...
Undraw Environment
Learning Tabulify - Step 8 - How to modify the content of a table

Tabulify learning guidetransfer step The transfer page should have made you familiar with the transfer concept where we have introduced the copy operation. The copy and move operation does not modify...
Undraw Environment
Learning Tabulify - Step 9 - How to fill a data resource with generated data ?

Tabulify integrates natively a data generator. You can generate realistic production data and start working on your project right away. anonymize production data in your development environment because...

Task Runner