Show the list of all dbt profiles

``` sqleton db ls --use-dbt-profiles ```

Sections

Terminology & Glossary
πŸ“– Documentation
Navigation
35 sectionsv0.1
πŸ“„ Show the list of all dbt profiles β€” glaze help ls-dbt-profiles
ls-dbt-profiles

Show the list of all dbt profiles

``` sqleton db ls --use-dbt-profiles ```

Exampledbtconfigdatabase-sourceslsdbuse-dbt-profiles

You can ask sqleton to list all dbt profiles it is able to find.

Don't forget to enable --use-dbt-profiles. Use --dbt-profiles-path to use another file.


❯ sqleton db ls --use-dbt-profiles --fields name,type,hostname,database
+---------------------+-------+-----------+-------------------+
| name                | type  | hostname  | database          |
+---------------------+-------+-----------+-------------------+
| localhost.localhost | mysql | localhost | ttc_analytics     |
| ttc.prod            | mysql | localhost | ttc_analytics     |
| prod.prod           | mysql | localhost | ttc_analytics     |
| dev.dev             | mysql | localhost | ttc_dev_analytics |
+---------------------+-------+-----------+-------------------+