INTELLIGENCE
Archive
How to Set Up Snowflake Notebooks in Workspaces
Snowflake Notebooks in Workspaces, generally available as of February 2026, replaces the original Legacy Notebooks product. The new version runs on Snowpark Container Services, supports native Git integration, and lets teams collaborate in shared workspace folders. It also introduces Notebook Project Objects, versioned units that Snowflake Tasks can schedule for automated runs. This guide walks through creating a workspace, launching a notebook, connecting to Snowflake data, and writing your first SQL and Python analysis cells.
How to Set Up Snowflake Cortex Analyst
Snowflake Cortex Analyst is a managed natural-language query layer built into the Snowflake Data Cloud that lets analysts and business users ask questions about structured data in plain English and receive SQL-generated answers without writing code. Setting it up requires a semantic model YAML file that describes your tables and business terminology, plus a Streamlit chat interface for end users. A standard setup for one or two tables takes two to three hours.
How to Get Started with Apache Spark 4.1
Apache Spark 4.1, released in December 2025, is the second major update in the 4.x series and resolved over 1,800 issues from more than 230 contributors. It introduces Spark Declarative Pipelines for defining data pipelines without managing execution graphs, a 1.5 MB pyspark-client for lightweight Spark Connect access, sub-second streaming via Real-Time Mode, and SQL Scripting enabled by default. You can install the Python client in under a minute with pip and start running queries against a local or remote Spark Connect server without configuring a JVM.
How to Get Started with Microsoft Fabric
Microsoft Fabric is Microsoft's unified analytics platform that combines data engineering, warehousing, real-time analytics, and Power BI in a single workspace. As of April 2026, Copilot is available on all paid F2-and-above SKUs, removing the previous F64 minimum requirement. Teams can ingest data from files or databases, run SQL queries, build pipelines, and create dashboards without switching tools. A free 60-day trial is available at app.fabric.microsoft.com.
How to Set Up RisingWave for Real-Time Analytics
RisingWave is a PostgreSQL-compatible streaming database that lets analysts define real-time materialized views using standard SQL. It replaces the traditional Kafka-plus-Flink streaming stack with a single system that ingests, transforms, and serves live data through any PostgreSQL client. This guide covers local installation, connecting a data source via PostgreSQL CDC or the built-in datagen connector, writing materialized views, and querying live results with zero new tooling beyond SQL you already know.
How to Get Started with Polars for Data Analysis
Polars is an open-source Python DataFrame library written in Rust that processes data 5-14x faster than pandas on most tasks. It reads CSVs roughly 5x faster and uses 87% less memory, with a multi-threaded engine that handles million-row files in seconds on a standard laptop. For analysts dealing with slow pandas notebooks or memory errors on large files, switching to Polars requires installing one package and learning a new expression-based API.
How to Set Up Ibis for Portable Python Analytics
Ibis is a portable Python analytics library that lets you write dataframe code once and run it against more than 24 backends -- including DuckDB, BigQuery, Snowflake, and Postgres -- without rewriting your analysis. Version 12.0.0, released in 2026, ships with DuckDB as a zero-config default, making it the fastest path from a local CSV file to production-grade analytical queries without touching a SQL string directly.
How to Analyze CSV Files with DuckDB
DuckDB is a free, serverless SQL database that runs on your laptop and queries CSV files directly with standard SQL. Install it in under two minutes, point it at any CSV, and run aggregation, filtering, and join queries on files that would crash Excel. There is no server to configure, no Python required, and no import step before querying. You run SQL against the raw file from the terminal.
How to Use Tableau Agent for Data Analysis
Tableau Agent is a conversational AI feature built into Tableau Desktop, Tableau Cloud, and Tableau Server (2025.3+) that lets you build visualizations, create calculated fields, and explore datasets using plain English. You type a question like "show me monthly revenue by region" and Tableau Agent generates the chart. It supports CSV, Excel, and Hyper file uploads, works with live database connections, and launched a Dashboard Narratives beta in February 2026 that summarizes insights across full dashboards. A free trial with full Tableau Agent access is available at tableau.com/products/trial.