๐ 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