See why hundreds of industry leaders trust Secoda to unlock their data's full potential.
See why hundreds of industry leaders trust Secoda to unlock their data's full potential.
Get the guideIn order to set up Firebolt with dbt Developer Hub, the first step is to install the adapter. This can be done using pip, which is a package installer for Python. It's a necessary step as the adapter allows dbt to communicate with your Firebolt data warehouse.
pip install dbt-firebolt
The above command installs the dbt-firebolt adapter. This command should be run in your terminal.
After installing the adapter, the next step is to add a profile called "firebolt" to the profiles.yml file. This file is used by dbt to define your connection to the database.
firebolt:
target: dev
outputs:
dev:
type: firebolt
user: <username>
password: <password>
engine_name: <engine-name>
database: <database-name>
The above code is an example of how to add a "firebolt" profile to the profiles.yml file. Replace the placeholders with your actual Firebolt credentials.
Adding credentials for the data warehouse is a crucial step in setting up Firebolt with dbt Developer Hub. These credentials are used to authenticate your connection to the database.
outputs:
dev:
type: firebolt
user: <username>
password: <password>
engine_name: <engine-name>
database: <database-name>
The above code is an example of how to add credentials for the data warehouse in the profiles.yml file. Replace the placeholders with your actual Firebolt credentials.
Creating a seed table is a good practice when using dbt. A seed table is a table that is loaded with static data, like a list of country codes, countries, and country regions.
dbt seed --show
The above command is used to load the seed data into your database. It should be run in your terminal.
To use external tables in dbt, you need to define a table as external in the dbt_project.yml file. An external table is a table that references data stored in an external storage system.
models:
my_project:
my_external_table:
+external:
url: 's3://my-bucket/my-data/*'
type: 'parquet'
object_pattern: '*.parquet'
The above code is an example of how to define a table as external in the dbt_project.yml file. Replace the placeholders with your actual data.
Built for data teams, designed for everyone so you can get more from your data stack.
© 2024 Secoda, Inc. All rights reserved.
By using this website, you accept our Terms of Use and Privacy Policy.
