HowTo Connection

HowTo Connection

About

howto is a local file system connection that points to a directory where all files used in the howto's are stored.

How to know the files location ?

With the tabul connection info command

tabul connection info howto
Information about the connection (howto)
Attribute                    Value                                   Description
--------------------------   -------------------------------------   --------------------------------------------------------------------
BOOLEAN_DATA_TYPE            Native                                  Boolean data type used to store boolean values
CHAR_DEFAULT_PRECISION       1                                       Default CHAR precision
COMMENT                      The location of the how to files        A connection description
DATE_DATA_TYPE               NATIVE                                  Date data type used to store date values
HOST                                                                 Host Server
MAX_CONCURRENT_THREAD                                                The maximum number of threads that can be created against the system
MAX_NAME_IN_PATH                                                     The maximum number of names in a path
NAME                         howto                                   The name of the connection
NATIVES                                                              Native Driver attributes (jdbc properties, ...)
NCHAR_DEFAULT_PRECISION      1                                       Default NCHAR precision
NVARCHAR_DEFAULT_PRECISION   0                                       Default NVARCHAR precision
ORIGIN                                                               The origin of the connection
PASSWORD                                                             The user password
PORT                                                                 Host Port
TABULAR_FILE_TYPE            text/csv                                The default media type when downloading tabular data
TIMESTAMP_DATA_TYPE          NATIVE                                  Timestamp data type used to store timestamp values
TIME_DATA_TYPE               NATIVE                                  Time format data type to store time values
URI                          file:///opt/tabulify/resources/howto/   The uri of the connection
USER                                                                 The user name
VARCHAR_DEFAULT_PRECISION    0                                       Default VARCHAR precision
WORKING_PATH                 /opt/tabulify/resources/howto           The working path (Schema for database, directory for file system)




Related HowTo
Data Generator - 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.
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.
How to add information about the selected resources with the Enrich operation ?

enrich is an intermediate operation that will add virtual columns to its inputs thanks to data supplier. Enrich accepts only one argument data-def where you can define extra columns called virtual columns...
How to create a CSV dynamically with a script?

This howto will show you how you can create any resource dynamically with a script. In this example, we will create a CSV but you can create any type of resource on the fly. You should have followed...
How to create a SQL view with a CREATE statement file

This Howto will show you how to create a SQL View with a SQL file that contains a CREATE SQL statement with the Tabul table create command. You should have Tabulify installed on your computer: ...
How to define an archive entry as data resource?

This howto will show you how to define an entry in an archive as data resource. In the world-db.tar.gz archive of the MySQL...
How to execute a bash script ?

This howto shows you how to execute a bash script against the local file system. The bash script that will be executed is: a simple hello world sample application that accepts optionally 1 argument...
How to execute a procedure in MySQL ?

This howto shows you how to create and execute a SQL Procedure in MySQL. This example has been taken from the official...
How to install the World MySQL Sample Schema

This howto will show you how to install the world sample schema of MySQL. The installation is done with the sql script world.sql This script is idempotent...
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...

Task Runner