🚀 New feature: with JupySQL you can now set up a local Spark instance seamlessly to interact with your data.
In this guide, walk you through:
🌟 Setting up a Spark Connect thin client
🌟 Setting up a database with Docker
🌟 Parameterizing your queries
🌟 Perform data profiling, data cleanup and visualization
Link to tutorial: https://jupysql.ploomber.io/en/latest/integrations/spark.html?utm_content=bufferd7b6a&utm_medium=social&utm_source=linkedin.com&utm_campaign=buffer
🎉#JupySQL v0.9.0 is out!🚀
Load config from pyproject.toml, resolve CTEs with new 'with_' feature & enjoy more control over scripts with parameterized queries.
Plus, many more features & bug fixes!
Learn more: https://jupysql.ploomber.io/en/latest/api/configuration.html🌟
Out GitHub: https://github.com/ploomber/jupysql
Using #MarkdownSQLPro Tools 🛠️ with new #SQLBookmarks 🔖, #SQLite & our #DuckDBPro #SQLTools in #VSCode IDE on @ploomber's #JupySQL #JupyText / #MyST #JupyterBook 📓 markdown docs 😎
#SQL #DuckDB #Markdown #ProDataTools 🧙♂️ ...
Same #JupySQL Intro #JupyterBook 📓 markdown document in #VSCode IDE with the added top level Execute All, Select All, Extract All SQL code lenses, and Execute, Select, Copy and Create SQL code lenses in the code cells with %%sql #SQLMagics:
#MarkdownSQLProTools 🧙♂️ ...
Quick demo of the new Extract All SQL and Execute SQL code lenses in the upcoming #MarkdownSQL Pro Tools v1.2.0 with #JupyterBook markdown support and #JupySQL / #SQLMagics SQL code extraction and execution in action:
This example uses VS Code #SQLTools and #DuckDBPro Tools to execute SQL queries directly from the Jupy SQL Jupyter Book markdown document (https://github.com/ploomber/jupysql/blob/master/doc/quick-start.md).
#VSCode #ProDataTools 🧙♂️ ...
Check out this #MyST markdown #VSCode extension with syntax highlighting, hovers and autocomplete of directives, and extended .md preview rendering.
📥 https://marketplace.visualstudio.com/items?itemName=ExecutableBookProject.myst-highlight
Viewing #JupySQL intro markdown:
#MarkdownTools 🛠️ ...
Looking to up your data handling game with with Oracle?
Oracle is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.
Get started today!
Our latest blog post explains how to integrate deepset's #Haystack, an open-source framework for building NLP systems, with #JupySQL and #JupyterNotebooks.
Discover how the JupySQL Agent leverages the power of GPT-4 to convert natural language queries into #SQL queries for seamless database access. The secret ingredient: the JupySQLQuery subclass, enabling SQL queries in Haystack pipelines within your Jupyter notebook environment.
Read more here: https://tinyurl.com/haystack-jupysql
Noticias sobre Python y Datos de la semana, episodio 73 🐍⚙️
En resumen: Versiones nuevas de JupySQL, Modin, Prefect y más, machine learning "doble", detección de comunidades en grafos, ojo a la chi2 de scikit-learn, y noticias del viejo Spyder
https://astrojuanlu.substack.com/p/episodio-73
Apoya el noticiero suscribiéndote por correo 📬
#python #pydata #jupysql #ploomber #modin #prefect #doubleml #networkx #sklearn #spyder
Catherine Devlin
Ploomber
Taras Novak 🇺🇦
Juan Luis