Tabli - Data Head Command

Undraw Windows

About

The data head command print only the N first records of a data resource.

This command is useful to print content of data resource that have a big size.

To print a data resource, you can also use:

  • the print command to print the whole content of a data resource
  • the tail command to print the last content of a data resource

Syntax

tabli data head -h
Tabli data head
===============

Print the first N rows of content of data resources.

By default, there is a limit of 10 on the number of rows printed



Examples
--------

 1 - Show the first 10 records of the table `sales` from the data store `sqlite`:


        tabli data head sales@sqlite


 2 - Show the first 500 rows of the table `time` from the data store `postgres`:


        tabli data head --limit 500 time@postgres


 3 - Show the first 10 lines from the file `request.log`:


        tabli data head request.log




Syntax
------


    tabli data head [options|flags] <data-selector...>


where:


  Arguments:

    <data-selector...>                                      One or more data or script selectors


  Data Definition Options:

    -a,--attribute <attributeName=value>                    Set specific data resource attributes


  Options:

    --limit <value>                                         Limit the number of rows printed (See footer)


  Selection Options:

    -wd,--with-dependencies                                 If set, the dependencies will be also selected


  Global Options:

    -cf,--conf <path>                                       The path to a configuration file

    -cv,--connection-vault <path>                           The path where the connection vault is located

    -h,--help                                               Print this help

    -l,--log-level <error|warning|tip|info|fine>            Set the log level

    -ns,--not-strict                                        A minor error will not stop the process.

    -odu,--output-data-uri <outputDataUri>                  defines the output data uri for the feedback data (default: console)

    -oo,--output-operation <dataOperation>                  defines the data operations (replace, truncate) on an existing output resource before transfer.

    -oop,--output-transfer-operation <transferOperation>    defines the output transfer operation (insert, update, merge, copy). Default to `copy` for a file system and `insert` for a database.

    -pp,--passphrase <passphrase>                           A passphrase (master password) to decrypt the encrypted values




Footer
------


Important:
We don't recommend to increase the rows limit to a very high number.
This command loads the data into memory to calculate the data layout and
render data aligned properly.
Increasing the limit will then increase the memory footprint and may cause an out-of-memory error.




Related HowTo
Undraw Windows
How to create a CSV File with generated data

This article shows you how to generate a csv file from a generator tabular file.
Undraw Windows
How to create an odometer with a sequence generator

This how-to shows you how to generate a digital Odometer with the column sequence generator.
Undraw Windows
How to generate a date dimension ?

A date dimension is a typical case for data generation and this article shows you how to generate it.
Undraw Windows
How to load a CSV file into a SQL table

How to upload a CSV file into a SQL table in two steps
Undraw Windows
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 Windows
How to use a data generator in a data operation

This how-to shows you how to use a data generator as data source
Undraw Windows
Learning Tabulify - Step 5 - How to print Data Resources

In the previous page, we learned how to select data resources. This page will show you how to discover their content. Tabulify offers three command to explore the data content: print: to print the...
Undraw Windows
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...

Task Runner