Data Resource - Sql Table

Undraw Environment

Data Resource - Sql Table

About

A table is a content resource located in a database.

MediaType

The media type for a table is sql/table

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
Database HowTo - How to load JSON documents in a database

This howto will show you how to load json document (files) into your relational database.
Undraw Environment
Database HowTo - 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 create a SQL View with a SELECT query

This howto shows you how to create sql views with select query stored in SQL file We are going to use the tpcds query_11.sql to create this view. With the tabul create command, to create view...
Undraw Environment
How to diff a SQL table ?

This howto show you how to perform diff operation between 2 SQL Tables with the data diff command. In this step, we load the csv resources that we want to compare into sqlite Load the original...
Undraw Environment
How to generate data with a data set?

This howto will show you how to generate data with an data set generator. In these examples, we use a predefined csv entity file but you could any data resource such as : a sql table a sql query...
Undraw Environment
How to load an HTLM table in a database?

This howto shows you how to load an HTML table in a SQL Table. Because the HTML resource is a file resource, it can be used as any source in any type of transfer. Example with the upsert operation...
Undraw Environment
How to load and analyze YAML documents in a database?

This howto will show you how to load and analyze yaml document (files) into a relational database. sqlite howto databaserelational database At its core a YAML file is just a JSON file styled in...
Undraw Environment
HowTo - How to load XML files into a Postgres with Tabulify

This database howto will show you how to load Xml file and document into a database.
Undraw Environment
HowTo - How to load XML files into a database with Tabulify

This database howto will show you how to load Xml file and document into a database.
Undraw Environment
Learning Tabulify - Step 10 - Data Diff, a step by step

Data Diff is the cornerstone of every development because it validates the processing of data. Tabulify ships with a Data diff operation that allows you to compare: the data content and the data...

Task Runner