New in Datalore: BigQuery Support, SSH tunneling, and More

Alena Guzharina

Hi everyone!

In today’s newsletter we’ll mostly talk about the recent improvements for data connections in Datalore, but first…

Meet us at BigDataLDN!

On September 21st, our team will be attending BigDataLDN and it’ll be a great chance to meet in person! If you are going, drop us a line on Twitter and swing by our booth to say “Hi!”.

BigQuery Support

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.

Try it in Datalore

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.

Webinar Recordings

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!

Happy analyzing!

The Datalore team

Subscribe to Datalore News and Updates

Subscribe form

By submitting this form, I agree to the JetBrains Privacy Policy Notification icon

By submitting this form, I agree that JetBrains s.r.o. ("JetBrains") may use my name, email address, and location data to send me newsletters, including commercial communications, and to process my personal data for this purpose. I agree that JetBrains may process said data using third-party services for this purpose in accordance with the JetBrains Privacy Policy. I understand that I can revoke this consent at any time in my profile. In addition, an unsubscribe link is included in each email.

Submit

Thanks, we've got you!