tailpipe connect

Return a connection string for a database, with a schema determined by the provided parameters.

Usage

Arguments

Flag	Description
--from string	Specify the start time
--help	Help for connect
--index strings	Specify the index(es) to use
--output	One of: json, text (default text)
--partition strings	Specify the partition(s) to use
--to string	Specify the end time

Global Flags

Flag	Description
--config-path	Sets the search path for configuration files. This argument accepts a colon-separated list of directories. All configuration files (*.tpc) will be loaded from each path, with decreasing precedence. The default is .:$TAILPIPE_INSTALL_DIR/config (.:~/.tailpipe/config). This allows you to manage your workspaces and connections centrally in the ~/.tailpipe/config directory, but override them in the working directory / mod location if desired.
--workspace	Sets the Tailpipe workspace profile. If not specified, the default workspace will be used if it exists. See workspace for details.

Flag

Description

--config-path

Sets the search path for configuration files. This argument accepts a colon-separated list of directories. All configuration files (*.tpc) will be loaded from each path, with decreasing precedence. The default is .:$TAILPIPE_INSTALL_DIR/config (.:~/.tailpipe/config). This allows you to manage your workspaces and connections centrally in the ~/.tailpipe/config directory, but override them in the working directory / mod location if desired.

--workspace

Sets the Tailpipe workspace profile. If not specified, the default workspace will be used if it exists. See workspace for details.

Examples

Connect to the Tailpipe database, filtered to records after the start time:

Note

You could use this connection string with DuckDB:

duckdb /home/jon/.tailpipe/data/default/tailpipe_20241212134120.db

Connect with no filter, show output as json: