New in Datalore: BigQuery Support, SSH tunneling, and More
In today’s newsletter we’ll mostly talk about the recent improvements for data connections in Datalore, but first…
Meet us at BigDataLDN!
You can now connect to Google BigQuery directly from the Datalore interface and use all the benefits of SQL cells to fetch the data into your notebook.
To connect to BigQuery, you can use the following Authentication types:
- Google Service Account
- Access and Refresh tokens
- Application default credentials
Watch this quick video tutorial to learn how to connect to Google BigQuery using the Service Account Authorization:
Community users can try the database integration and SQL cells feature free for 30 days. Professional plan users get unlimited access to this feature.
Enterprise plan users should expect Google BigQuery support in the next Datalore Enterprise release.
💡 Tip: specify the
DefaultDataset parameter in the database connection dialog to get the dataset schema and SQL code completion.
SSH tunneling support
Now you can connect to your remote databases using SSH tunneling in Datalore. This will create an encrypted SSH connection between Datalore and your gateway server. Connecting via SSH tunnels will help avoid whitelisting Datalore IP addresses and makes it possible to connect to databases that are not exposed to the public network.
To connect via SSH tunnel, navigate to the SSH tab inside the database connection window, choose to enable SSH, and specify the required parameters.
5 Tips for Combining Python and SQL in Datalore
On Thursday, 28th July 2022, I gave a webinar about tips for combining Python and SQL in Datalore. Watch the webinar recording and learn how to automate routine SQL+Python tasks!
Is Your Analysis Reproducible? 5 Ways to Make Your Work Bulletproof With Datalore
On Thursday, 23rd June 2022, Jodie gave a webinar about how to build reproducibility into your work using Datalore. Here’s the recording for you to watch if you missed the live stream.
We also published a bunch of helpful blog posts:
- 5 Ways to Collaborate Effectively as a Data Science Team
- How to Get the Best Autocomplete in Jupyter Notebooks, and More
- How To Schedule a Jupyter Notebook
Check them out if any of those topics sound interesting to you!
That’s all for now! Follow us on Twitter to hear about our latest updates!
The Datalore team
Subscribe to Blog updates
Finally Something Fun for Your Inbox – DataLead Season 1
a unique kind of newsletter – like a TV show but about data. Get ready to dive into the lives of our two DataLeaders, Sarita and José, as they navigate the data-related challenges of 2024.
What’s New in Datalore Enterprise 2023.6
Datalore Enterprise 2023.6 offers an improved UI, introduces OAuth authentication for Snowflake and BigQuery, and brings a number of other improvements and bug fixes.
Introducing the Revamped Datalore UI – Built for Focus
Today, we’re introducing a redesign that aims to make Datalore notebooks appear simpler, cleaner, and ultimately more zen.