---json
{
    "page_id": "vlk42fs49615hng914zn8"
}
---
====== Tpcds_query Connection ======


===== About =====
''tpcds_query'' is  a [[docs:system:local|local file system]] [[connection|connection]] that points to the directory where the [[docs:resource:sql_select|queries]] of the [[docs:system:tpcds|TPC-DS]] benchmark.

It's one of the [[howtos|howto's connections]] created at the installation of ''Tabulify''.


===== Location =====

This directory is a subdirectory of the [[docs:tabul:home|installation directory]].

With the [[docs:tabul:connection:info|connection info]] command:
<unit>
<code bash>
tabul connection info tpcds_query
</code>
<console>
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)
</console>
</unit>

===== Directory Structure  =====

With the [[docs:tabul:data:list|data list]] command, we can see that the queries are categorized by [[docs:system:database:database|database]]
<unit>
<code bash>
tabul data list -a count *@tpcds_query
</code>
<console>
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
</console>
</unit>