Data Resource - Sql Query (select)

Undraw Environment

Data Resource - Sql Query (select)

About

A Sql Select statement or Sql query is a query performed against a database system.

A Sql Query will return tabular data and is therefore considered as a content data resource.

Attribute

Name Default Possible Values Description
query-metadata-detection temporary view temporary view, runtime, parsing Define the method type to capture the structure if not defined via a data-definition


Related HowTo
Undraw Environment
How to execute and shows the result of a SQL Query

This howto will shows you to execute and shows the result of a SQL Query against the tpcds data
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
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 - How to compare data resources ?

Data Diff is the corner stone 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...
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...

Task Runner