Integration with Snowflake and Microsoft SQL Server - Launch Week 2 - Day 4
Welcome to the 4th day of Livebook Launch Week 2! 🎉
Today’s post is about our two new database integrations: Snowflake and SQL Server.
Together with those new ones, Livebook now comes with built-in integrations for seven databases and data warehouses:
- PostgreSQL
- MySQL
- SQL Server
- SQLite
- Google BigQuery
- Amazon Athena
- Snowflake
Let’s see how the new integrations work.
Connecting to Snowflake
The Snowflake integration is available through the Database Connection Smart cell. All you need to do is configure the Smart cell with your connection credentials, and you’ll be ready to start executing queries.
Let’s see how that works.
Under the hood, this is different from the other database integrations we already have. Livebook connects to Snowflake through ADBC (Arrow Database Connectivity), using the ADBC hex package, which contains ADBC bindings for Elixir.
The Arrow format is highly efficient, and it’s also integrated with Explorer, so now you can easily query a database and load the result into an Explorer dataframe.
Good news for those of us doing data analysis with Elixir and Livebook. 🎉
Connecting to Microsoft SQL Server
Connecting to SQL Server is also super simple. All you need to do is add a new Database Connection Smart cell, select SQL Server, and fill in your database credentials.
Here’s how it works.
This was a community contribution from Simon McConnell. Curious fact: the pull request contains less than 250 LOC! Cool, right?! 😎
What now?
To start playing with those new features, install the latest version of Livebook and have fun!