You can create a configuration of any component in a branch and the following steps are not strictly necessary – you can use branches in a completely empty project. However, the tutorial follows the typical situation when you’re using branches in a non-empty project.
You’ll start with a data pipeline that pulls data about bitcoin prices and creates a list of top 5 days when the price was the highest. Let’s prepare the production configurations, so that you can try working with branches later.
Create new HTTP extractor configuration, fill in Base URL to
https://help.keboola.com. Then add a new table to the extractor, named
bitcoin_price and fill the Path to
/tutorial/branches/bitcoin_price.csv. Table Name should be
Run the extractor and verify that a new table
in.c-keboola-ex-http-682373219.bitcoin_price was created.
Note: The number in your bucket name represents configuration ID and will be different from what you see on the screenshot.
First create a new Snowflake transformation, named
In the Table Input Mapping section fill in the
bitcoin_price table that you created using HTTP extractor.
In Table Output Mapping add
top_prices table that will be created in the transformation.
Finally, add a new code to
Block 1 named
Top prices with following query.
Save the transformation and run it. Then verify that there is a new table
out.c-bitcoin.top_prices containing 5 values from the
source data – dates and amounts when bitcoin had the most value.
Now you have the production set and in the next section you’ll set up a Python transformation using file storage. After that you can give branches a test run.