tb
Tinybird CLI
Subcommands
| Name | Description | 
|---|---|
check | Check file syntax | 
dependencies | Print all data sources dependencies | 
diff | Diffs local datafiles to the corresponding remote files in the workspace | 
drop-prefix | Drop all the resources inside a project with prefix. This command is dangerous because it removes everything, use with care | 
fmt | Formats a .datasource, .pipe or .incl file This command removes comments starting with # from the file, use DESCRIPTION instead. The format command tries to parse the datafile so syntax errors might rise. .incl files must contain a NODE definition | 
init | Initialize folder layout | 
materialize | [BETA] Given a local Pipe datafile path (FILENAME) and optionally a Materialized View name (TARGET_DATASOURCE), choose one of its nodes to materialize. This command guides you to generate the Materialized View with name TARGET_DATASOURCE, the only requirement is having a valid Pipe datafile locally. Use `tb pull` to download resources from your workspace when needed. Syntax: tb materialize path/to/pipe.pipe | 
prompt | Learn how to include info about the CLI in your shell PROMPT | 
pull | Retrieve latest versions for project files from Tinybird | 
push | Push files to Tinybird | 
sql | Run SQL query over data sources and pipes | 
Options
| Name | Description | 
|---|---|
--debug | Prints internal representation, can be combined with any command to get more information | 
--no-debug | Prints internal representation, can be combined with any command to get more information | 
--token  <text> | Use auth token, defaults to TB_TOKEN envvar, then to the .tinyb file | 
--host  <text> | Use custom host, defaults to TB_HOST envvar, then to https://api.tinybird.co | 
--gcp-project-id  <text> | The Google Cloud project ID | 
--gcs-bucket  <text> | The Google Cloud Storage bucket to write temp files when using the connectors | 
--google-application-credentials  <text> | Set GOOGLE_APPLICATION_CREDENTIALS | 
--sf-account  <text> | The Snowflake Account (e.g. your-domain.west-europe.azure) | 
--sf-warehouse  <text> | The Snowflake warehouse name | 
--sf-database  <text> | The Snowflake database name | 
--sf-schema  <text> | The Snowflake schema name | 
--sf-role  <text> | The Snowflake role name | 
--sf-user  <text> | The Snowflake user name | 
--sf-password  <text> | The Snowflake password | 
--sf-storage-integration  <text> | The Snowflake GCS storage integration name (leave empty to auto-generate one) | 
--sf-stage  <text> | The Snowflake GCS stage name (leave empty to auto-generate one) | 
--with-headers | Flag to enable connector to export with headers | 
--version-warning | Don't print version warning message if there's a new available version. You can use TB_VERSION_WARNING envar | 
--no-version-warning | Don't print version warning message if there's a new available version. You can use TB_VERSION_WARNING envar | 
--hide-tokens | Disable the output of tokens | 
--version | Show the version and exit | 
--help | Show this message and exit |