March update: SQL formatting & Python preview
TL;DR: This month brings SQL formatting customization using sqlfluff - now your whole team can maintain consistent code style with one click. Plus, get ready for full Python support coming soon, featuring seamless SQL-Python integration, cell reactivity, and always-on kernels.
We’ve released some important quality-of-life improvements this month. The bulk of the Fabi team’s efforts are going towards Python support which we know you’re excited about 🙂
🧹 Formatting & SQL best practices
Have strong opinions about how best to format SQL code for readability? You’re not alone…
You can now configure how you and your team should format your queries, and in the click of a button your query will be cleaned up! The best part? The AI respects your formatting preferences as well.
We’re leveraging sqlfluff, so you can customize your preferences to your heart’s content.
🏗 Coming soon: Python
Over the next few weeks you can expect a first version of Python support. What you’ll be getting:
- Python cells: Create Python cells in Fabi.ai notebooks and analyze away!
- SQL and Python chaining: SQL output will automatically be stored as a pandas DataFrame which you can then use in a Python cell.
- Cell reactivity: Updating a variable in a cell which is used in cells lower in the notebook will give you the option to update all dependent cells. Alternatively, running a Python cell which uses variables defined higher up will give you the options to run upstream cells.
- Always-on kernels: We believe that you should focus on the analysis, not on the dev details. When building a notebook or data app, you’ll never have to think about the state of your kernel, it will always be running.
🎁 Other goodies
- Inserting cells: You can now insert a cell anywhere in the notebook
- Improved performance: Our notebooks have gotten a whole lot faster, no matter how many cells you create
