tpcds_query is a local file system connection that points to the directory where the queries of the TPC-DS benchmark.
It's one of the howto's connections created at the installation of Tabulify.
This directory is a subdirectory of the installation directory.
With the connection info command:
tabul connection info tpcds_query
Information about the connection (tpcds_query)
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 Tpc Ds queries 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 tpcds_query 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/tpcds_query/ The uri of the connection
USER The user name
VARCHAR_DEFAULT_PRECISION 0 Default VARCHAR precision
WORKING_PATH /opt/tabulify/resources/tpcds_query The working path (Schema for database, directory for file system)
With the data list command, we can see that the queries are categorized by database
tabul data list -a count *@tpcds_query
path media_type count
--------- --------------- -----
mysql inode/directory 101
oracle inode/directory 101
postgres inode/directory 102
README.md text/plain 32
sqlite inode/directory 101
sqlserver inode/directory 101